how to binding stored procedure in a text box

[ali.alipanahi]

hi i have a problem in binding sum of my sql table column's in sp format into a text box
could you help me i want to know how can i bind stored procedure out put result in c# sharp i want to sum a column of my table and show the result in a text box pleasssssssssssssss heellllllppppppppppppp meeeeeeeeeeeee pleasssssssss :icon_question:

[Mitja Bonca]

You can use SqlDataReader and set value to it:

SqlConnection conn = new SqlConnection("connString");
string query = @"SELECT SUM(columnName) FROM MyTable";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
if(reader.Read())
    textBox1.Text = reader[0].ToString();
reader.Dispose();
cmd.Dispose();
conn.Dispose();