如何把datagrid中数据-dataset中数据导入SQL数据库

1、 如何把datagrid中数据导入SQL数据库?　

if (this.DataGrid1.Items.Count > 0)
{
foreach (DataGridItem oDataGridItem in DataGrid1.Items)
{
string strTheHour = oDataGridItem.Cells[0].Text.ToString();
string sql = "Insert into Temp(TheHour) values(" + strTheHour + ")";
Connect.ExecuteSql(sql);

}
}




2、如何在dataset中数据插入SQL数据库

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["SQLConnectionString"]);
try
{
SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
DataSet myds = new DataSet();
conn.Close();
conn.Open();
myda.Fill(myds, "" +strTable+ "");

foreach (System.Data.DataRow row in myds.Tables[0].Rows)
{
string strTheHour = row["TheHour"].ToString().Trim();
string sql = "Insert into Temp(TheHour) values(" + strTheHour + ")";
Connect.ExecuteSql(sql);
}
this.DataGrid1.DataSource = myds.Tables["" + strTable + ""].DefaultView;
this.DataGrid1.DataBind();
conn.Close();
this.Response.Write(" ");
}
catch (Exception exc)
{
conn.Close();
string s = exc.ToString();
}