如何把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(" <script language=javascript>alert('OK！');</script>");
        }
        catch (Exception exc)
        {
            conn.Close();           
            string s = exc.ToString();
        }