data on labels

Visit this link


http://stackoverflow.com/questions/14233640/retrieve-data-from-database-and-count-second-row-and-show-it-in-label

In my humble opinion you need to go with he basics on Data Binding.

Refer to these links below, they will help you learn and achieve that:

http://hightechnology.in/how-to-bind-data-to-textbox-and-label-in-asp-net/

http://forums.asp.net/post/3412565.aspx


In order to use Stored Procedure instead of command text, specify your command type as StoredProcedure and put it's name in place of the command text, like:

 SqlCommand sqlCmd = new SqlCommand("myProcedure", connection);
 sqlCmd.CommandType = CommandType.StoredProcedure;

Happy Learning :)

i m using asp.net and sql server 2008 (using visual studio database tool) and i have just made the tables

This is very same like you do with getting the values in a textbox or elsewhere. Share what technology you're using and what have you tried so far.