“Vigilancia del cumplimiento de la normatividad en seguridad y salud en el
ESTANDAR DE COMPETENCIA Código: Título:
III.- Elementos que conforman el Estándar de Competencia Referencia Código Título
Imports System.Web.Configuration.WebConfigurationManager
PublicClass AddNewUser
Dim cp AsString = ConnectionStrings("Hotel").ToString
Dim cn AsNew SqlConnection(cp)
PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If txtPass.Text = ""Then
MsgBox("username/password cannot be empty")
ExitSub EndIf Try
cn.Open()
Dim cmdText AsString = "select * from Login where password='"& txtPass.Text &"'"
Dim cmd As SqlCommand
cmd = New SqlCommand(cmdText, cn)
Dim rea As SqlDataReader
rea = cmd.ExecuteReader Dim a AsString = "" While rea.Read a = rea("username") EndWhile cn.Close() cn.Open() If a = ""Then
cmdText = "Insert into Login values('"& txtPass.Text &"','"& txtFirst.Text _
&"','"& txtLast.Text &"','"& txtAdd.Text &"','"& txtPhone.Text &"','"& cbxDept.SelectedItem & _ "','Staff')" cmd = New SqlCommand(cmdText, cn) cmd.ExecuteScalar() MsgBox("Inserted") clear() Else
MsgBox("This username exists!")
EndIf Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub Sub clear() txtAdd.Text = "" txtFirst.Text = "" txtLast.Text = "" txtPass.Text = "" txtPhone.Text = "" cbxDept.SelectedItem = Nothing EndSub
32
EndClass
PublicClass AdminMeni
PrivateSub AdminMeni_FormClosing(ByVal sender AsObject, ByVal e As
System.Windows.Forms.FormClosingEventArgs) HandlesMe.FormClosing Form1.Show()
EndSub
PrivateSub AddNewUserToolStripMenuItem_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles AddNewUserToolStripMenuItem.Click AddNewUser.Show()
EndSub
PrivateSub ViewUserToolStripMenuItem_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles ViewUserToolStripMenuItem.Click
Dim allusers AsNew ViewAllUsers allusers.Show()
EndSub
PrivateSub DailyReportToolStripMenuItem_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles DailyReportToolStripMenuItem.Click
Dim dReport AsNew DailyReport dReport.Show()
EndSub
PrivateSub ExitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles ExitToolStripMenuItem.Click Form1.Show() Me.Hide() EndSub EndClass Imports System.Data.SqlClient Imports System.Web.Configuration.WebConfigurationManager PublicClass CheckInCheckOut
Dim cp AsString = ConnectionStrings("Hotel").ToString
Dim cn AsNew SqlConnection(cp)
PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If txtCust.Text = ""Then
MsgBox("You must enter customer ID")
ExitSub EndIf Try
33
Dim cmdText AsString = "select * from [check] where cust_id='"& txtCust.Text &"'"
Dim cmd AsNew SqlCommand(cmdText, cn) cn.Open()
Dim reader As SqlDataReader
reader = cmd.ExecuteReader
While reader.Read
txtChkD.Text = reader("chkInDate") txtChkT.Text = reader("chkInTime") txtRoomNo.Text = reader("room_no") txtNoD.Text = reader("noOfDays") txtChkOutD.Text = reader("chkOutDt") txtChkOutT.Text = reader("chkOutTime")
EndWhile
If txtChkOutD.Text = ""Then
MsgBox("No record found")
EndIf Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
Try
If txtRoomNo.Text = ""Then
MsgBox("Room Number can't be null")
ExitSub EndIf
Dim cmdT AsString = "select * from [check] where cust_id='"& txtCust.Text &"' "
Dim comand AsNew SqlCommand(cmdT, cn) cn.Open()
Dim rea As SqlDataReader
Dim status AsString = ""
rea = comand.ExecuteReader
While rea.Read
status = rea("status").ToString
EndWhile
cn.Close() cn.Open()
If status = "check out"Then
MsgBox("This user with id: "& txtCust.Text &" has already
checked out")
clear()
Else
Dim cmdText AsString = "update Room_Master Set
Status='Available',checkOutDate='Not Set' where Room_No='"& txtRoomNo.Text
&"'"
Dim cmd AsNew SqlCommand(cmdText, cn) cmd.ExecuteScalar()
34
cmdText = "update [check] set status='check out' where
cust_id='"& txtCust.Text &"'"
cmd = New SqlCommand(cmdText, cn) cmd.ExecuteScalar()
MsgBox("Customer succcessfully checked out") clear() EndIf Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub Sub clear() txtChkD.Text = "" txtChkOutD.Text = "" txtChkOutT.Text = "" txtChkT.Text = "" txtCust.Text = "" txtNoD.Text = "" txtRoomNo.Text = "" EndSub EndClass Imports System.Data.SqlClient Imports System.Web.Configuration.WebConfigurationManager PublicClass CustomerDetails
Dim cp AsString = ConnectionStrings("Hotel").ToString
Dim cn AsNew SqlConnection(cp)
PrivateSub CustomerDetails_Load(ByVal sender AsObject, ByVal e As
System.EventArgs) HandlesMe.Load
Dim RanNum AsNew Random
txtCust.Text = RanNum.Next(9999, 999999)
EndSub
Sub Customers()
Try
cn.Open()
Dim cmdText AsString = "Insert Into customers VALUES('"& txtCust.Text &"','"& txtCustName.Text &"','"& txtAddress.Text &"','"& txtPhone.Text &"')"
Dim cmd AsNew SqlCommand(cmdText, cn) cmd.ExecuteNonQuery() Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry
35
EndSub
Sub checkIN()
Try
Dim ccc AsString = "Insert into [check] VALUES('"& txtCust.Text &"','"& dtChkIn.Text &"','"& _
txtChkTime.Text &"','"& txtRoomS.Text &"','"& txtNoD.Text &"','"& dtChkOutDate.Text &"','"& dtChkOutTime.Text &"','check in')"
Dim cmd AsNew SqlCommand(ccc, cn) cn.Open() cmd.ExecuteScalar() Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub Sub UpdateRoomNo() Try
Dim cmdText AsString = "UPDATE Room_Master Set
Status='unavailable',CheckOutDate='"& dtChkOutDate.Text &"' where Room_No='"&
txtRoomS.Text &"'"
Dim cmd AsNew SqlCommand(cmdText, cn) cn.Open() cmd.ExecuteScalar() Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PublicSub LoadDataSet(ByRef cmdText AsString)
Dim da AsNew SqlDataAdapter(cmdText, cn)
Dim ds AsNew DataSet da.Fill(ds)
EndSub
Sub InsertTax(ByRef cust_id AsString, ByRef servTax AsInteger, ByRef Total
AsInteger)
Try
Dim cmdText AsString = "Insert INTO
Bill(CustomerID,theDate,ServiceTax,Total_Charge) Values('"& cust_id &"','"&
dtChkIn.Text &"','"& servTax &"','"& Total &"')"
Dim cmd AsNew SqlCommand(cmdText, cn) cn.Open() cmd.ExecuteScalar() Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub Sub Print() Try
36
Dim cmdText AsString = "Delete from cust_Report INSERT INTO cust_Report
Values('"& txtCust.Text &"','"& txtCustName.Text &"','"& txtPhone.Text &"','"
_
& txtAddress.Text &"','"& txtChkTime.Text &"','"& dtChkIn.Text &"','"& dtChkOutTime.Text &"','"& dtChkOutDate.Text &"','"& txtNoD.Text &"','"& txtRoomS.Text &"')"
Dim cmd AsNew SqlCommand(cmdText, cn) cn.Open()
cmd.ExecuteNonQuery()
Dim tText AsString = "Delete from BillTemp Insert INTO
BillTemp(cust_id,servT,Tot_Charge) select CustomerID,ServiceTax,Total_Charge
from Bill where CustomerID='"& txtCust.Text &"'"
cmd = New SqlCommand(tText, cn) cmd.ExecuteNonQuery() cn.Close() Catch ex As Exception MsgBox(ex.Message) EndTry EndSub
PrivateSub cbxRType_SelectedIndexChanged(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles cbxRType.SelectedIndexChanged
Try
Dim cmdText AsString = "select Room_No from Room_Master where Room_Type='"& cbxRType.SelectedItem &"'"
Dim cmd AsNew SqlCommand(cmdText, cn) cn.Open()
Dim rea As SqlDataReader
rea = cmd.ExecuteReader lstRoom.Items.Clear() While rea.Read lstRoom.Items.Add(rea(0).ToString) EndWhile Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub lstRoom_SelectedIndexChanged_1(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles lstRoom.SelectedIndexChanged
Try
Dim cmdText AsString = "select * from Reservation where Res_Date='"& dtChkIn.Text &"' and Room_No='"& lstRoom.SelectedItem &"'"
Dim da AsNew SqlDataAdapter(cmdText, cn)
Dim ds AsNew DataSet
da.Fill(ds, "Reservation")
Dim RoomNo AsString = ""
Dim theDate AsString = ""
ForEach s As DataRow In ds.Tables(0).Rows RoomNo = s("room_no") theDate = s("Res_date")
Next
cmdText = "select * from Room_Master where room_no='"& lstRoom.SelectedItem &"'"
37
da = New SqlDataAdapter(cmdText, cn) ds = New DataSet
da.Fill(ds, "Room_Master")
Dim RoomNo2 AsString = ""
ForEach t As DataRow In ds.Tables(0).Rows RoomNo2 = t("status")
Next
cn.Open()
Dim myText AsString = "select * from Room_Master where Room_No='"& lstRoom.SelectedItem &"'"
Dim cmd AsNew SqlCommand(myText, cn)
Dim rr As SqlDataReader = cmd.ExecuteReader
While rr.Read
txtTariff.Text = rr("Tariff")
txtRoomS.Text = lstRoom.SelectedItem
If dtChkIn.Text = theDate And lstRoom.SelectedItem = RoomNo Then
txtRStatus.Text = "Reserved"
ElseIf RoomNo2 = "unavailable"Then
txtRStatus.Text = "unavailable" Else txtRStatus.Text = "Available" EndIf EndWhile Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub btnSubmit_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnSubmit.Click
'Const SerChar As Single = 0.02
Dim tarriff AsInteger
tarriff = txtTariff.Text
Dim NoD AsInteger
NoD = txtNoD.Text Dim TM AsInteger TM = tarriff * NoD Customers() checkIN() UpdateRoomNo() InsertTax(txtCust.Text, 0.02, TM) Print() PrintCustomerReport.Show() Me.Hide() EndSub EndClass
38
PublicClass MainMenu
PrivateSub ReserveRoomToolStripMenuItem_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles ReserveRoomToolStripMenuItem.Click RoomsReservation.Show()
EndSub
PrivateSub ViewReservationsToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ViewReservationsToolStripMenuItem.Click viewReservation.Show()
EndSub
PrivateSub AddCustomerDetailsToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
AddCustomerDetailsToolStripMenuItem.Click CustomerDetails.Show()
EndSub
PrivateSub CheckINcheckOUTDetailsToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
CheckINcheckOUTDetailsToolStripMenuItem.Click CheckInCheckOut.Show()
EndSub
PrivateSub RoomStatusToolStripMenuItem_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles RoomStatusToolStripMenuItem.Click viewRoomStatus.Show()
EndSub
PrivateSub MainMenu_FormClosing(ByVal sender AsObject, ByVal e As
System.Windows.Forms.FormClosingEventArgs) HandlesMe.FormClosing Form1.Show()
EndSub
PrivateSub MainMenu_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) HandlesMyBase.Load lblTime.Text = DateTime.Now lblDept.Text = userInfo.dept
lblUName.Text = userInfo.name1 &" "& userInfo.name2
EndSub
PrivateSub NewRestaurantDetailsToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
NewRestaurantDetailsToolStripMenuItem.Click
Dim rd AsNew Restaurant rd.Show()
EndSub
PrivateSub ExitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles ExitToolStripMenuItem.Click Form1.Show()
Me.Hide()
EndSub EndClass
39
Imports System.Data.SqlClient
Imports System.Web.Configuration.WebConfigurationManager
PublicClass Restaurant
Dim cp AsString = ConnectionStrings("Hotel").ToString
Dim cn AsNew SqlConnection(cp)
PrivateSub cbxCategory_SelectionChangeCommitted(ByVal sender AsObject, ByVal
e As System.EventArgs) Handles cbxCategory.SelectionChangeCommitted
Dim cmdTet AsString = "select * from variety where category='"& cbxCategory.SelectedItem &"' "
Dim cmd AsNew SqlCommand(cmdTet, cn)
Try
cn.Open()
Dim reader As SqlDataReader
reader = cmd.ExecuteReader lstVarName.Items.Clear()
While reader.Read
lstVarName.Items.Add(reader("varName").ToString)
EndWhile Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub lstVarName_SelectedIndexChanged(ByVal sender AsObject, ByVal e As
System.EventArgs) Handles lstVarName.SelectedIndexChanged
Dim water AsString = "select * from variety where varName='"& lstVarName.SelectedItem &"' "
Dim cmd AsNew SqlCommand(water, cn)
Try cn.Open() Dim rr As SqlDataReader rr = cmd.ExecuteReader While rr.Read txtAmount.Text = rr("cost") EndWhile Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub Button3_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button3.Click
Try
If txtQuan.Text = ""Or txtAmount.Text = ""Then
MsgBox("supply quantity")
ExitSub EndIf
Dim quantity AsInteger Dim amount AsInteger Dim Total AsDouble
40
amount = txtAmount.Text Total = quantity * amount
txtOverallAm.Text += Total
Dim cmdText AsString = "INSERT INTO Restaurant VALUES('"& txtResID.Text &"','"& txtCustName.Text &"','"& _
lstVarName.SelectedItem &"','"& txtQuan.Text &"','"& txtAmount.Text &"','"& DateTimePicker1.Text &"')"
cn.Open()
Dim cmd AsNew SqlCommand(cmdText, cn) cmd.ExecuteScalar() MsgBox("saved") Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub Restaurant_Load(ByVal sender AsObject, ByVal e As
System.EventArgs) HandlesMe.Load
Dim RanNum AsNew Random
txtResID.Text = RanNum.Next(10000000, 30000000) &"eA"
EndSub
PrivateSub btnPrint_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnPrint.Click
If txtCustName.Text = ""Or txtAmount.Text = ""Or txtQuan.Text = ""Or
txtOverallAm.Text < 0 Then
MsgBox("You can't print with an incomplete information")
ExitSub EndIf Try
Dim cmdText AsString = "delete from RestaurantTemp Insert INTO RestaurantTemp Select Rest_ID,Cust_Name,FoodOrdered,quantity,amount from Restaurant where
Rest_ID='"& txtResID.Text &"'"
Dim cmd AsNew SqlCommand(cmdText, cn) cn.Open()
cmd.ExecuteNonQuery()
cmdText = "delete from header INSERT INTO header VALUES('"& txtResID.Text &"','"& txtOverallAm.Text &"')"
cmd = New SqlCommand(cmdText, cn) cmd.ExecuteNonQuery() RestReportForm.Show() Me.Hide() Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub EndClass
41
Imports System.Data.SqlClient
Imports System.Web.Configuration.WebConfigurationManager
PublicClass RoomsReservation
Dim cp AsString = ConnectionStrings("Hotel").ToString
Dim cn AsNew SqlConnection(cp)
PrivateSub RoomsReservation_Load(ByVal sender AsObject, ByVal e As
System.EventArgs) HandlesMe.Load
Dim ranNum AsNew Random
txtResID.Text = ranNum.Next(2000000, 3000000)
EndSub
PrivateSub cbxRoomT_SelectedIndexChanged(ByVal sender AsObject, ByVal e As
System.EventArgs) Handles cbxRoomT.SelectedIndexChanged
Try
cn.Open()
Dim cmdText AsString = "select * from Room_Master where Room_Type='"& cbxRoomT.SelectedItem &"'"
Dim cmd AsNew SqlCommand(cmdText, cn)
Dim rea As SqlDataReader
rea = cmd.ExecuteReader lstRooms.Items.Clear() While rea.Read lstRooms.Items.Add(rea(0).ToString) EndWhile Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub lstRooms_SelectedIndexChanged(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles lstRooms.SelectedIndexChanged
Try
Dim cmdText AsString = "select * from Reservation where Res_Date='"& dtDate.Text &"' and Room_No='"& lstRooms.SelectedItem &"'"
Dim da AsNew SqlDataAdapter(cmdText, cn)
Dim ds AsNew DataSet
da.Fill(ds, "Reservation")
Dim RoomNo AsString = ""
Dim theDate AsString = ""
ForEach s As DataRow In ds.Tables(0).Rows RoomNo = s("room_no") theDate = s("Res_date")
Next
cn.Open()
Dim myText AsString = "select * from Room_Master where Room_No='"& lstRooms.SelectedItem &"'"
Dim cmd AsNew SqlCommand(myText, cn)
Dim rr As SqlDataReader = cmd.ExecuteReader
While rr.Read
txtTariff.Text = rr("Tariff")
txtRoomN.Text = lstRooms.SelectedItem
42 txtStatus.Text = "Reserved" Else txtStatus.Text = "Free" EndIf EndWhile Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
Try
If txtCustName.Text = ""Or txtDays.Text = ""Or txtPhone.Text = ""Or
txtAdd.Text = ""Then
MsgBox("No field can be empty")
ExitSub EndIf
cn.Open()
Dim ccc AsString = "Insert into Reservation Values('"& txtResID.Text &"','"& txtCustName.Text & _
"','"& txtAdd.Text &"','"& txtPhone.Text &"','"& dtDate.Text &"','"&
txtDays.Text &"','"& txtRoomN.Text &"','"& txtTariff.Text &"')"
Dim cmd AsNew SqlCommand(ccc, cn) cmd.ExecuteScalar()
ccc = "Delete FROM ReservationTemp INSERT INTO ReservationTemp
SELECT * from Reservation where Res_Id='"& txtResID.Text &"'"
cmd = New SqlCommand(ccc, cn) cmd.ExecuteScalar()
MsgBox("Room Reserved successfully") ReservationReportForm.Show() Me.Hide() Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub EndClass Imports System.Data.SqlClient Imports System.Web.Configuration.WebConfigurationManager PublicClass ViewAllUsers
Dim cn AsString = ConnectionStrings("Hotel").ToString
PrivateSub ViewAllUsers_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) HandlesMyBase.Load
43
PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim cp AsNew SqlConnection(cn)
Dim cmdText AsString = "select * from Login where designation='Staff'"
Dim da AsNew SqlDataAdapter(cmdText, cn)
Dim ds AsNew DataSet
da.Fill(ds, "Login")
DataGridView1.DataSource = ds DataGridView1.DataMember = "Login"
EndSub
PrivateSub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
If txtPassword.Text = ""Then
MsgBox("You must enter password")
ExitSub EndIf
Dim cmdText AsString = "select * from Login where password='"& txtPassword.Text &"'"
Dim cp AsNew SqlConnection(cn)
Dim cmd AsNew SqlCommand(cmdText, cp) cp.Open()
Dim reader As SqlDataReader
reader = cmd.ExecuteReader Dim a AsString = "" While reader.Read a = reader("password") EndWhile cp.Close() cp.Open() If a = ""Then
MsgBox("No record to delete")
Else
Dim ccc AsString = "DELETE FROM Login where password='"& txtPassword.Text &"'"
cmd = New SqlCommand(ccc, cp) cmd.ExecuteNonQuery()
MsgBox("record deleted") txtPassword.Text = "" EndIf cp.Close() EndSub EndClass Imports System.Data.SqlClient Imports System.Web.Configuration.WebConfigurationManager PublicClass viewReservation
Dim cp AsString = ConnectionStrings("Hotel").ToString
Dim cn AsNew SqlConnection(cp)
PrivateSub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
If txtCust.Text = ""Then
MsgBox("You must enter customer ID")
44
EndIf
Dim cmdText AsString = "select * from Reservation where Res_Id='"& txtCust.Text &"'"
Dim cmd As SqlCommand
Try
cmd = New SqlCommand(cmdText, cn)
Dim rea As SqlDataReader cn.Open() rea = cmd.ExecuteReader While rea.Read txtCustName.Text = rea(1) txtAdd.Text = rea(2) txtPhone.Text = rea(3) txtResDate.Text = rea(4) txtDays.Text = rea(5) txtRoom.Text = rea(6) Button1.Enabled = True EndWhile If txtCustName.Text = ""Then
MsgBox("NO record found")
EndIf Catch ex As Exception MsgBox(ex.Message) Finally cn.Close() EndTry EndSub
PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
ReserveItems.Res_Name = txtCustName.Text ReserveItems.Address = txtAdd.Text ReserveItems.Phone = txtPhone.Text ReserveItems.Res_Date = txtResDate.Text ReserveItems.noOfDays = txtDays.Text ReserveItems.room_no = txtRoom.Text ReserveItems.tariff = txtTariff.Text CustomerDetails.Show() Me.Hide() EndSub EndClass Imports System.Data.SqlClient Imports System.Web.Configuration.WebConfigurationManager PublicClass viewRoomStatus
Dim cp AsString = ConnectionStrings("Hotel").ToString
Dim cn AsNew SqlConnection(cp)
PrivateSub Button1_Click(ByVal sender AsObject, ByVal e As System.EventArgs)
Handles Button1.Click
Dim cmdText AsString = "select * from Room_Master"
Dim da AsNew SqlDataAdapter(cmdText, cn)
45 da.Fill(ds, "Room_Master") DataGridView1.DataSource = ds DataGridView1.DataMember = "Room_Master" EndSub EndClass