i wanted to get SUM of total column in " textbox11 ", from DateBase table name: bs Column name: total

Hi Karthik,


using System.Data.SqlClient;


SqlConnection con=new SqlConnection("connectionstring");
SqlCommand com;
String str;

private void btnsum_marks_Click(object sender, System.EventArgs e)
{
       
con.Open();
str = "select SUM(smarks)from student";
com = new SqlCommand(str, con);
txtsum_marks.Text =com.ExecuteScalar().ToString ();
con.Close();
}




Thanks

It will be something like this, assuming it's a decimal column:

string sql = "SELECT SUM(total) FROM bs";

using (SqlConnection conn = new SqlConnection(connString))
{
    SqlCommand cmd = new SqlCommand(sql, conn);
    conn.Open();
    textBox11.Text = ((decimal)cmd.ExecuteScalar()).ToString();
}