(Link)Ado.Net functions ,c-sharpcorner
ExecuteScalar method is used to execute SQL Commands or storeprocedure, after executing return a single value from the database. It returns the first column of the first row in the result set from a database.
SqlDataAdadpter