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