creating insert form n connecting it to database using asp.net

[mandrekar salim]

hi guys , i'm using visual studio 2005. now i've to create a insert form which shud be connected to database(mssql). can any one tell me how to do dat. as i'm new to visual studio i dnt knw it.

[vanc]

G'day mate,

This is a big question, I think we have to break it down a little bit.

1. You should have the MSSQL database setup already.
2. You should have known the way to connect to that database from your project.
3. Then you will decide how to put data from forms into that database.

Get back to me when you're at step 3, we will go from then.

Cheers.

[mandrekar salim]

its done.. now tel me how. i completed the design of te form.

[vanc]

This is quick :D.

The simplest way and quickest way to do this is to create connection to the database, command with SQL queries and execute the command to insert data into database.

The idea is quite simple, you will have a form with some input text boxes, and an input button where you wire it to the event that will get data from those boxes and put them into the command text and execute it.

It may not get your question or this is what you're after. Please let me know.

Cheers.

[mandrekar salim]

i completed with design of the form .. it has few txtbooxes n combo boxes. i hve sqldata source. hw to connect the form to d database. wat code is required tobe written in save button?

[mandrekar salim]

@vanc: i want the codes to connect to db...

[mandrekar salim]

d form is designed using visual studio 2005, using asp.net . frm this form i want to insert data into database. i wnt the code example so that i can do it.

[Frinavale]

Please check out the quick articles on How to use a Database in your Program (part 1) and How to use a Database in your Program (part 2)

[vanc]

Sweet Frinavale. This should help heaps with example codes.

Cheers.