how to connect SQL Server database? [modified]

Golden Jing

Dear All, I'm just learn ASP.Net. I make a website by using Visual Studio.Net 2005. I want to take data from table in SQL Server into my website. But i do not know how to connect SQL Server with ASP.Net and take data from table to my website. Thank before hand for your help. Best Regard, Sovann.

VB.Net

modified on Wednesday, January 09, 2008 3:34:56 AM

N a v a n e e t h · modified on Wednesday, January 09, 2008 3:34:56 AM

You will get many articles if you search for this. You need to use the following classes for doing this. 1 - SQLConnection 2 - SQLCommand 3 - SQLDataAdapter 4 - DataSet/DataTable/SQLDataReader

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

Golden Jing

Thank you for your help. But i'm a new asp.net so i don't know much about that. I would like you to show me detail about that. If used ODBC connection. what sourse for writing ?

VB.Net

N a v a n e e t h

Sovann wrote:

But i'm a new asp.net so i don't know much about that.

Explaining the whole stuff through forums is too tough. Consider reading the books online or buying an ASP.NET book

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

Golden Jing

If i readed the books or bought asp.net, I don't ask you and CodeProject. I have less time for doing my website so that i ask in CodeProject. I think that there are kind people have to share some knowledge to me. Ok it's nothing if you don't want to help me. Thank you for your spend valuable time to me. I will try more or wait someone's help else. :sigh:

VB.Net

janet2008

Or use MSDN

Golden Jing

Thank you so much Janet. But like what i post before i don't know much asp.net. I'm a new one and i just get first project which less time of deadline. So I try to get some knowledge in this site from you and other. If posible i would like you to show method about that. Thank you in advance.

VB.Net

janet2008

How many time you will wait Sovann? If no one helps you, will you wait for years? Why don't you try to learn yourself? That is the best method eventhough it is time consuming. don't look for spoon feeding like a baby.

N a v a n e e t h

Sovann wrote:

If i readed the books or bought asp.net, I don't ask you and CodeProject. I have less time for doing my website so that i ask in CodeProject.

The reason why I have not answered your question here is, it's too vague to answer through a forum. Internet got tons of articles for this. I have given you all the possible classes used for this. Why don't search for some articles which explains how to use them instead of wasting time for asking this here and waiting for reply ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions