Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Me.Validate() Me.ItemsBindingSource.EndEdit() Me.TableAdapterManager.UpdateAll(Me.ItemsDataSet) End Sub
Imports System.Data.SqlClient Imports System.Data.Sql Module Module1 Public acscmd As New SqlCommand Public acsconn As New SqlConnection Public acsda As New SqlDataAdapter Public acsds As New DataSet Public strsql As String Public Strreportname As String Sub Connect() acsconn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Items.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;" acsconn.Open() If acsconn.State = ConnectionState.Open Then MsgBox("Connected") End If End Sub End Module
Me.TableAdapterManager.UpdateAll(Me.ItemsDataSet)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)