Books for asp.net

Thursday, August 30, 2007

Database connection with MSSQL for data reader

VB

'using mssql express edition

Dim strConn As String = " \SQLEXPRESS;database=;Integrated Security=SSPI"
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()

C#

string strConn = "
\\SQLEXPRESS;database=;Integrated Security=SSPI";
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();