sql-server - Perform SUM query in ADO.NET

Question

I am getting following error

;expected

I am trying to find sum of column values in my webform.

protected void Page_Load(object sender, EventArgs e)
{
    con.Open();
    SqlCommand cmd = con.CreateCommand();
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "Select SUM("AMOUNT DEPOSITED ") From MAIN_TABLE6";
    Double amount = cmd.ExecuteScalar();
    Label3.Text = amount.ToString();
} 

标签： sql-serverado.net

Answer 1

Use brackets to enclose your columns in SQL Server.

protected void Page_Load(object sender, EventArgs e)
{
    con.Open();
    SqlCommand cmd = con.CreateCommand();
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "Select SUM([AMOUNT DEPOSITED]) From MAIN_TABLE6";
    Double amount = cmd.ExecuteScalar();
    Label3.Text = amount.ToString();    
}