Adding from textbox in form to datagridview in another form C#

Question

1.00/5 (1 vote)

See more:

I Have form 1 with 4 textboxes and 1 button, and I have form 2 which contains dataGridView, I want to add new row to the datagridview from the other form.

but it give me this error:

SQL

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

This is my code on the Button Click.

C#

Main frm = new Main();

frm.dataGridView1.Rows[0].Cells[0].Value = textBox1.Text;
frm.dataGridView1.Rows[0].Cells[1].Value = textBox2.Text;
frm.dataGridView1.Rows[0].Cells[2].Value = textBox4.Text;
frm.dataGridView1.Rows[0].Cells[3].Value = dateTimePicker1.Value;
frm.dataGridView1.Rows.Add();
this.Hide();
frm.Show();

Posted 30-Oct-15 12:54pm

R.M49

Updated 30-Oct-15 12:55pm

v2

Add a Solution

Comments

George Jonsson 30-Oct-15 19:35pm

Do you have any rows in the DataGridView?
How many columns do you have in the DataGridView.

R.M49 31-Oct-15 3:57am

Yes I have rows because the DataGridView is filled by DataSet.
there are 4 columns

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)

VR Karthikeyan · Answer 1 · 2015-10-30T18:32:00

Solution 1

Hi, Add Columns in your datagridview, because without defining columns you can't assign data to datagridview, so create columns in datagridview, and use the following line to add rows to datagridview.

C#

frm.dataGridView1.Rows.Add(textBox1.Text, textBox2.Text, textBox4.Text, dateTimePicker1.Value);

Posted 30-Oct-15 18:32pm

VR Karthikeyan

Comments

R.M49 31-Oct-15 4:01am

There are 4 columns, the DataGridView is filled by DataSet.
How can I define them.

VR Karthikeyan 31-Oct-15 4:52am

In case you are using DataSet to fill datagridview, its very simple to add a new row to it. Refer the below code.

DataRow objNewRow = YourDataSet.Tables[YourTableIndex].NewRow();
objNewRow[0] = textBox1.Text;
objNewRow[1] = textBox2.Text;
objNewRow[2] = textBox4.Text;
objNewRow[3] = dateTimePicker1.Value;
YourDataSet.Tables[YourTableIndex].Rows.Add(objNewRow);
YourDataSet.Tables[YourTableIndex].AcceptChanges();

R.M49 31-Oct-15 5:01am

DataRow obj = ds.Tables[0].NewRow();
obj[0] = textBox1.Text;
obj[1] = textBox2.Text;
obj[2] = textBox4.Text;
obj[3] = dateTimePicker1.Value;
ds.Tables[0].Rows.Add(obj);
ds.Tables[0].AcceptChanges();

I use this code, now it doesn't give me any error, the form of datagridview is shown but the row doesn't be added and nothing changed in the DGV

VR Karthikeyan 31-Oct-15 5:12am

After adding new row to the table,
Reassign datasource of datagridview with new table with new row, like,
dataGridView.DataSource = null;
dataGridView.DataSource = ds.Tables[0];

R.M49 31-Oct-15 5:35am

thaaaaaaaanks alooot, that is work, but the problem now when I add the new row it open a form that contain only this row, how can make this row be added under the all rows ??

R.M49 31-Oct-15 12:02pm

any suggestion for the new problem ??? when I add the new row it open a form that contain only this row, how can make this row be added under the all rows ??

VR Karthikeyan 1-Nov-15 22:47pm

this is simple, show your code for both forms...