| VB 'using mssql express edition Dim strConn As String = " Dim conn As New SqlConnection(strConn) Dim cmd As SqlCommand = conn.CreateCommand Dim reader As SqlDataReader cmd.CommandText = "Select * from clients where client_id = '" + iid.ToString() + "'" conn.Open() reader = cmd.ExecuteReader If reader.Read = True Then TextBox1.Text = reader.GetString(1) TextBox2.Text =reader.GetDatetime(2) TextBox3.Text = reader.GetString(3) TextBox4.Text = reader.GetString(4) End If conn.Close() string strConn = " SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = conn.CreateCommand; SqlDataReader reader; cmd.CommandText = "Select * from clients where client_id = '" + iid.ToString() + "'"; conn.Open(); reader = cmd.ExecuteReader; if (reader.Read == true) { TextBox1.Text = reader.GetString(1); TextBox2.Text = reader.GetDatetime(2); TextBox3.Text = reader.GetString(3); TextBox4.Text = reader.GetString(4); } conn.Close(); |
Thursday, August 30, 2007
Database connection with MSSQL for data reader
Posted by
Khairul
at
Thursday, August 30, 2007
