How can I save multiple textBoxes and dataGridView at once

The question make sense:) . Like before my problem is to save 3 textboxes and one dataGridView that can contain several rows. I made 2 tables in the database called tableHead(InvoiceID, Date and Total) and tableBody (ProductID, InvoiceID, ProductName, Quantity and Price) the tables are in relationship => tableHead.InvoiceID = tableBody.InvoiceID. I am using sql database and language c# for the application.

I try to program some code but I still can not save the form. The code is:


private void SaveButton_Click(object sender, EventArgs e)
{

SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = @"Data Source=IVAN-PC;Initial Catalog=model;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();

//Head textbox without InvoiceID because is increment...
string head = "INSERT INTO tableHead (Date) values('" + dateTextBox.Text +"'";

//InvoiceID select...
string Invoice = "SELECT InvoiceID FROM tableHead";

//Populate datagridview without ProductID...
//Maybe I have to create for or something else to correctly populate row by row...
string InvoiceID = this.DataGridView.CurrentRow.Cells[imeIndex].Value.ToString().Trim();
string ProductName = this.DataGridView.CurrentRow.Cells[imeIndex].Value.ToString().Trim();
string Quantity = this.DataGridView.CurrentRow.Cells[imeIndex].Value.ToString().Trim();
string Price = this.DataGridView.CurrentRow.Cells[imeIndex].Value.ToString().Trim();

string body = "INSERT INTO tableBody(InvoiceID, ProductName, Quantity, Price) values ('" + InvoiceID + "','" + ProductName + "','" + Quantity + "','" + Proce + "')";

cmd.CommandText = head;
cmd2.CommandText = Body;
cmd.Connection = cnn;
cnn.Open();
cmd = new SqlCommand(head, cnn);
cmd = new SqlCommand(Body, cnn);
cmd.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
cnn.Close();

if (MessageBox.Show("Successfully saved! ", "Saving", MessageBoxButtons.OK) == DialogResult.OK)
{
this.Close();
}
}

Can someone Help?

Thanks in advance,
zabamkd

Hi Zabamkd,
If you have a screen with three textboxes and also a grid with multiple rows you are probably saving multiple records to multiple tables in your database. You probably want to look at using a Data Adapter object to do multiple records at a time. You could try googling [^]or searching CP for articles to help you. Here are some that I found that you may find helpful:
Inserting relational data using DataSet and DataAdapter[^]
Building database application with ADO.NET for a beginner.[^]

Also, about the code you posted. You said that it didn't work. Please let us know what error message you get or what is happening that is incorrect and we can try to help you more from there.

Hope this helps.