How to retrieve and pass data from sql server db to form controls

Peace upon u all
The senario is as following:
1-The user should 1st login(The login part at master page)
2-phone, mobile, country, city from customer table will be displayed at form as initial value.
What I did:
I made stored procedure to retrieve these data and the parameter of stored was session["id"]. when I tested my code I noted that the session id is returned null.
So:
How 2 get session [“id”] to use run stored procedure successfully??
How 2 pass data from db to form controls(textboxes, dropdownmenus)??

plz any one help me as soon as possible.
Thanks,
Rasha

Please take the time to research the problem before you post your question. The experts here are more than willing to help you with a specific problem but you have to do your part to learn the basics. Please take the time to read over the posting guidelines specifically the section on Before you post your question.

A great place to start researching is the MSDN Library. This resource should get you pointed in the right direction. I recommend bookmarking the MSDN Library and using it as your primary resource when developing in .NET.

Some other resources that can help you get started are listed below:

• How to use a database in your program
• Stored Proceedures
• Sessions: How to pass Information Between Web Pages
• The DropDownList Class and it's properties: SelectedItem and SelectedIndex

Also I recommend you watch this video on the topic of Membership, Roles, and Forms-Authentication.

You also may be interested in researching the topic of Windows Authentication.

-Moderator Frinny

I have merged your questions.
Please do not double post your question. It makes it harder for us to answer your question and harder for you to get an answer to your question. Please take the time to look over the posting guidelines especially the section on Do not double post your question.

-Moderator Frinny