Insert dat to datagrid view from twxt boxes

[shweta134]

if there are 3-4 textboxes diplaying some calcuted value,then how can we add these values to datagrid view and database

[maddyromeo]

you can add textbox values to a datagridview by just

1)create a "DataTable"
2)create a DataColumn
3)Add DataColumn to DataTable
4)create a new DataRow
5)Append textBox value to DataRow
6)Add DataRow to DataTable
7)set datasource of datagridview to DataTable


sample code.....

1)DataTable dt = new DataTable();
2)DataColumn values = new DataColumn("values",typeof(System.String));
3)dt.Columns.Add(values);
4)DataRow dr = dt.NewRow();
5)dr["values"] = textBox1.Text;
6)dt.Rows.Add(dr);
7)dataGridView1.DataSource = dt;

[shweta134]

Sir thanx above code is working fine but i want to save 5 to 10 values to the same datagrid view ,each value until i close the window

[maddyromeo]

if you understand the above code you can figure out the answer yourself.............

if you want to add the next value to a new row of dagaGridView , just create a new datarow as shown before

/*
dr = dt.NewRow();
dt["columnName"] = "the string you want to insert";
dt.Rows.Add(dr);
*/ this code will add a new row to your dataGridView
with the given string.


in order to add new values to your dataGridView you have to code in such a way that the above code executes each time you want to insert a string.....

[maddyromeo]

... in case if you want to add your values to new columns the just create new columns

values = new DataColumn("values1",typeof(System.String));
dt.Columns.Add(values);

values = new DataColumn("values2",typeof(System.String));
dt.Columns.Add(values);

and now create row like

string[] row = {""+textBox1.Text,""+textBox2.Text}
dt.Rows.Add(row);

for more values add more columns and then add values in

string[] row = {""+textBox1.Text,""+textBox2.Text+,.....}

[sdmunoz]

Given two textboxs (textbox1 and textbox2), you can add it content to datagridview:

dt.Rows.Add(textbox1.Text, textbox2.Text);

Obviously you had to have the two columns added in the datagridview control. Then to save it to database (I'll omit connections and queries):

SqlCommand command = new SqlCommand();
if (dt.Rows.Count > 0)
{
   for (int i = 0; i < dt.Rows.Count; i++)
   {
      command.CommandText = "INSERT INTO table(val1,val2) VALUES(@val1,@val2)";
      command.Parameters.AddWithValue("@val1", dt.Rows[i].Cells[0].Value.ToString());
      command.Parameters.AddWithValue("@val2", dt.Rows[i].Cells[1].Value.ToString());
      command.ExecuteNonQuery();
   }
}