insert into table values(datagridview1.column1 + "," + datagridview1.column2 + "," + datagridview1.column2 +");
for(int i=0; i< dataGridView1.Rows.Count-1;i++) { Strquery= @"Insert into yourTableName(date,column1,....) values (" + System.DateTime.Now +", " + dataGridView1.Rows[i].Cells[1].Value +".......);"; cmd.CommandText = Strquery; cmd.ExecuteNonQuery(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)