>using following c# code, I am trying to get sum of a field "LNOD" type varchar in a variable "mysum"
>
>protected void Button7_Click(object sender, EventArgs e)
>{
>SqlConnection con = new SqlConnection("Server=SDCHO\\SQLEXPRESS;Database=LoginPage;Trusted_Connection=true");
>con.Open();
>SqlCommand myCommand2 = new SqlCommand("select sum(lnod) as mysum from LeaveDataTable where ID='212' ", con);
>myCommand2.ExecuteNonQuery();
>Response.Write('The Sum of LNOD is :' + mysum);
>con.Close();
>}
>
>please help it is not working
First of all, if it's a varchar column, why do you try to sum it?
Secondly, you need to use ExecuteScalar and not ExecuteNonQuery if you want to get a result.
If it's not broken, fix it until it is.
My Blog