update your Inser Function like..
private void InsertInfo()
{
string connectionString = null;
SqlConnection connection;
SqlDataAdapter adapter = new SqlDataAdapter();
connectionString = @"Data Source=HP\SQLEXPRESS;database=MK;Integrated Security=true";
connection = new SqlConnection(connectionString);
foreach (int rowIndex in lstNewRows)
{
string insrtQry = "insert into " + comboBox1.SelectedText + " values(";
int cols = yourGridView.Rows[0].Cells.Count;
foreach (GridViewRow gr in yourGridView.Rows)
{
for (int i = 0; i < cols; i++)
{
insrtQry += "'" + gr.Cell[i].Text.ToString() + "',";
}
}
insrtQry = insrtQry.TrimEnd(",".ToCharArray());
insrtQry += ")";
try
{
connection.Open();
adapter.InsertCommand = new SqlCommand(insrtQry, connection);
adapter.InsertCommand.ExecuteNonQuery();
MessageBox.Show("Row inserted !! ");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
if it is helpful to you then rate the solution