Hi Frnds,

          I am very new in ASP.NET application. Can you please tell how to make a connection between ASP.NET and MS SQL SERVER 2000? Also I want to display all the data in ASP.NET form. Please help me to learn ASP.NET.

Thanks in Advance

write,
using System.Data.SqlClient at top of the .cs page

on any event where you want to make connection write

string strConn="Data Source=<Server name>;Initial Catalog=<database name>;uid=<user id>;pwd=<password>";

SqlConnection con = new SqlConnection(strConn);

to open connection write
con.open();

do next what u like....

Hi NITINP,

            Thanks for ur help and reply. Now I have another question. I want to show one data from database in a textbox. I think I need to databind. But how to do this??

Waiting for ur reply.

Do you want to do a simple process of getting data into a text box or want to populate a text box in GridView or other at run time? Pls tell me specifically.

http://www.asp.net/getstarted/default.aspx?tabid=61 could be helpful.

Thanks Nitin for ur help..