Role of ExecuteScalar ASP.NET

Question

what is role of ExecuteScalar()?

Satyapriya Nayak · Answer

Hi Sanjoli Executes the query and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored Use the ExecuteScalar method to retrieve a single value (for example an aggregate value) from a database Ex:- Count the total votes and display it in a textbox SqlConnection con = new SqlConnection(ConnectionString); con.Open(); string str = select sum(votes)from vote_table; SqlCommand com = new SqlCommand(str con); txt_totalvotes.Text = com.ExecuteScalar().ToString(); con.Close(); Thanks

Chetan koralli · Answer

ExecuteScalar executes your query and returns the 1st row's 1st column as a result set