ASP.NET - read data

protected void Button1_Click(object sender, EventArgs e)

{

string strcon = @"Data Source=RAJA;Initial Catalog=frame;User Id=;Password=;Trusted_Connection=True; ";

//string strcon = "Server=RAJA\SQLEXPRESS;Database=ram;Trusted_Connection=True;";

SqlCommand cmdinserted = new SqlCommand();

SqlConnection con = new SqlConnection(strcon);

cmdinserted.CommandText =

"select*from jms";

cmdinserted.CommandTimeout = 0;

cmdinserted.CommandType =

CommandType.Text;

cmdinserted.Connection = con;

try

catch (Exception ex)

{

Label1.Text = ex.Message.ToString();

}

try

string strcon = @"Data Source=RAJA;Initial Catalog=frame;User Id=;Password=;Trusted_Connection=True; "; 
//string strcon = "Server=RAJA\SQLEXPRESS;Database=ram;Trusted_Connection=True;"; 
SqlCommand cmdinserted = new SqlCommand(); 
SqlConnection con = new SqlConnection(strcon); 

cmdinserted.CommandText = "select * from jms"; //Keep space between select and *  
//cmdinserted.CommandTimeout = 0; //No need to specify timeout...........
cmdinserted.CommandType = CommandType.Text; 
cmdinserted.Connection = con;
try 
{
    con.Open();
    //cmdinserted.ExecuteNonQuery(); //No need to ExecuteNonQuery...
    //Normally we use ExecuteNonQuery when you do the operations like Insert or Update.... For select you can either use;
    //DataAdpter, Dataset OR DataReader... like;
    SqlDataAdapter da = new SqlDataAdapter(cmdinserted);
    DataSet ds = new DataSet();
    da.Fill(ds); 
    //Here you can use DS then you display data like
    Label1.Text=ds.Tables[0].Rows[0][0].ToString();
    con.Close();
}
catch (Exception ex) 
{
    Label1.Text = ex.Message.ToString();
}

protected void Button1_Click(object sender, EventArgs e)

 {

 string strcon = @"Data Source=RAJA;Initial Catalog=frame;User Id=;Password=;Trusted_Connection=True; ";

 SqlCommand cmdinserted = new SqlCommand();

 SqlConnection con = new SqlConnection(strcon);

 cmdinserted.CommandText = "select*from jms";

 cmdinserted.CommandTimeout = 0;

cmdinserted.CommandType = CommandType.Text;

 cmdinserted.Connection = con;

 try

 {

con.Open();

SqlDataReader dr = cmdinserted.ExecuteReader();

//here u get data fon datareader and u need to show data on label control as follows

if(dr.Read())
 {
    lblName.Text = dr["columnname"].ToString();
// this will show vlaue of that columnname u specify here and make sure that columname must be selected in your query than u will be see value on that label control
}

con.Close();

}

catch (Exception ex)

{

Label1.Text = ex.Message.ToString();

}