string ConnectString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(ConnectString);
try
{
conn.Open();
Label1.Text = "<b>Server Version:</b>" + conn.ServerVersion;
Label1.Text += "<br/><b>Connection is:</b>" + conn.State.ToString();
string sql = "SELECT * FROM UserLogin";
SqlCommand cmd = new SqlCommand(sql,conn);
SqlDataReader reader = cmd.ExecuteReader ();
string strResult=" " ;
while(reader.Read ())
{
strResult += reader.GetInt32(0).ToString() + reader.GetString(1) +reader.GetString(2) + "<br/>" ;
}
Response.Write(strResult);
reader.Close();
}
catch (Exception err)
{
Response.Write("Error reading the database:" + err.Message);
}
finally {
conn.Close();
}