How to use a datagridview to insert multiple item to an sql db using c# winform

Question

1.00/5 (1 vote)

See more:

Hi friends
i have a form with two textboxes and a datagridview that has two columns. Now i want users to be able to fill in as many data as they want into the datagridview, and also enter information such as name and age into the textboxes and when they click on save buton the information along with the datagridview informations should be saved to a table in the sql server db. I.e the name of the person to one column, the age to another column and the datagrid to one column on the same row. Dont know if is possible. But if there is a better way please suggest.thanks

Posted 11-Mar-13 12:16pm

Ese ochuko

Add a Solution

Comments

Andreas Gieriet 11-Mar-13 19:16pm

What did you try? What says Google?
How about a little bit effort from your side? You are asking now more than 30 quite basic questions in the last 6 months - one question a week... I strongly suggest to consult some of the many tutorials and answers that are around on these topic.
Andi

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mostafa Metwally · Answer 1 · 2013-03-11T16:01:00

Make an insert statement function with two parameters name and age
and make statement with select name and age from table

1st statement take data from textbox

C#

insertintotable(textbox1.text,textbox2.text);

and the 2nd statement take data from datatable of select statement

C#

datatable dt=selectnameandage();

then use this ...

C#

datagridview.datasource=dt;

all of that under the save button