Sql & Vb.net

[darya]

it's the first time i'm working with Asp.net and Sql server.

I have a SqlServer 2000 database and i want to use it as my Project's database.

i don't know what to do next.:(

i have just install vb.net 2003 and sqlserver 2000,i don't no what codes i should use to connect to My Db.

special thanks and best regards

:)

[Nate Bross]

The Microsoft.SqlServer namespace may be worth looking into.

[amir100]

Wouldn't the Internet be a sufficient place to look around for references? By the way, I believe you can take a look inside the .Net Framework SDK Documentation. It should be installed along when you install .Net 2003. Look in the "Content" tab and find a node about accessing data using ADO.Net.

 

A word of advice. No offense. You should read first then ask. It looks like you're relying to much on others. There's plenty of good resources out there. At least I know my way around .Net was also thanks to those resources.

 

I'll be glad to help you in the dark. But if you it's dark then you should bring a flashlight or such. Don't just rely on others for the light.

 

Geez. What am I talking about. :D

 

Anyway good luck kick-starting in .Net.

[darya]

hello

thanks alot for your attentions,

i have searched alot about my problem but i didn't find any usefull solution.each research was diffrent from the other and made me confused.

i ask others cause i'm in a hurry.about a week for a beginner!!

[amir100]

I'll try to help. What you need to understand is the way to connect to the database right? So let's start with something automatic and simple.

 

Create a new project. Choose project type "Windows Application". In that project, add a new item. You should add a "Data Form Wizard". You will then follow a wizard to create a form which connect to the database. You will be prompted to setup the DataSet, the Connection, the DataAdapter, and so on that is required to manipulate objects (tables, views) in the database. The last step of the wizard lets you decide how to display your data in the form. That is either using a datagrid or individual controls.

 

Once you're done, you can view the code to understand better how to connect to your database. Debugging should help you figure out the flow of the program.

 

That's all I can say for now. Good luck.

[darya]

hello

tnx alot for your attention dear amir,this project is going to be finished,i use a gridview to show the resuls,and now i want to active the property (edit,delet,select) in Vb.net 2005.(asp.net 02)

i need a good refrence for help.

best wishes