caterpillar

Hi, I have to insert fields in a table. I am using VB.net & SQL Server database. The code is: Dim userid As Int32 = Me.classname.UserID Dim strSQLD As String = "Insert into table1 (userid) values (Me.classname.UserID)" userid is of type int While debugging, i can see that variable userid …

Hi I am using 2 dropdownlists such that corresponding to the item selected in the 1st dropdownlist only the related items will appear in the 2nd dropdownlist. The problem is that the 2nd dropdownlist is never populated. My code is: Sub popdropdownlist1() Dim myConnection1 As New SqlConnection(ConfigurationSettings.AppSettings("connectionString1")) Const strSQLC As …

Hi All, I have a stored procedure which displays list of ADMITTED,QUEUED and DISCHARGED patients. The patient status is stored in a table. A represents ADMITTED patient, Q represents QUEUED patient and D represents DISCHARGED patient. I am using a dropdown to display the ADMITTED,QUEUED and DISCHARGED patients respectively. I …