Dim cnConnect As New SqlConnection cnConnect.ConnectionString = conn.ConnectionString cnConnect.Open() Dim cm As New SqlCommand cm.CommandText = "SELECT * FROM user " Dim connection As New SqlConnection(conn.ConnectionString) Dim dataadapter As New SqlDataAdapter(cm.CommandText, connection) Dim ds As New DataSet connection.Open() dataadapter.Fill(ds, "user") connection.Close() DataGrid1.DataSource = ds DataGrid1.DataMember = "user" cnConnect.Close()
Dim cnConnect As New SqlConnection cnConnect.ConnectionString = conn.ConnectionString cnConnect.Open() Dim cm As New SqlCommand cm.CommandText = "SELECT * FROM user"; Dim dataadapter As New SqlDataAdapter(cm.CommandText, cnConnect) Dim ds As New DataSet dataadapter.Fill(ds, "user") DataGrid1.DataSource = ds DataGrid1.DataMember = "user"; cnConnect.Close()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)