Expand|Select|Wrap|Line Numbers
- dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\KarthI\sample\db1\WindowsApplication1\WindowsApplication1\bin\Debug\phm_pharmacy.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
- con.Open()
- Dim cmd As New SqlCommand
- cmd.CommandText = "insert into quotation_t11 values('" & TextBox1.Text & "','" & ComboBox1.SelectedItem & "','" & TextBox2.Text & "','" & TextBox3.Text & "')"
- cmd.Connection = con
- cmd.ExecuteNonQuery()
- MsgBox("Insertion process is success")
- con.Close()
created table using microsoft sql database file