Hi Priyanka,
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("SELECT [Bay_Name],[Bay_Status] FROM [Bays_Info]", con))
{
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
string bays_Info = string.Empty;
while (dr.Read())
{
bays_Info += dr["Bay_Name"].ToString() + " ";
}
lbl_BaysInfo.Text = bays_Info;
}
con.Close();
}
}
}
NameSpaces Used
using System.Data.SqlClient;
using System.Configuration;