christan

Greetings, i'm having a problem on inserting all my items from listview to my database using stored procedure. heres my code. Dim lvItem As ListViewItem For Each lvItem In ListView1.Items With dbComm .AddParameter("@details", lvItem.Text, SqlDbType.VarChar) .ExecuteStoredProcedure("insertRecord") If .Success = False Then MsgBox("Record failed to save.") Else MsgBox("Record Saved.") End If …

Greetings, Can someone please tell me on how to use this class? Public Function GetDataFromStoredProcedure(ByVal spName As String) As DataTable Dim ds As New SqlDataAdapter Dim dt As New DataTable Dim cmd As New SqlCommand Dim con As New SqlConnection(_connectionString) Try _success = True con.Open() cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = …

Greetings, i just want to ask how to insert a data with fk. Like if i insert a data on tblPatient, the patientID will be displayed on the tblRecord. is it just a normal insert into tblpatient or is there another code for it? Thanks.

Greetings, can someone please give me an idea on how to make a stored procedure with foreign key. Here's what i want to happen. 1) I have 1 button for Adding patient. 2) On the add patient button, i want to Add the patient information on the tblPatient and insert …

Greetings. I'm having a rough time solving this problem. this is my global dec Dim btns As Button() = New Button() {Button1, Button2} and this is my eventhandler Dim btnName As Button = DirectCast(sender, Button) Dim i As Integer btns(i) = New Button For i = 0 To btns.Length Step …