从Mysql中读取数据绑定Grid，然后在全部绑定sql
///获取Mysql里面的数据
protected void Button1_Click(object sender, EventArgs e)
{
///实例化强类型的数据集
macs_20140707TableAdapter data = new macs_20140707TableAdapter();
DataTable ds= data.GetDataBySelect();
GridView1.DataSource = ds;
GridView1.DataBind();
}
#region 插入sql
///
/// 获取Grid的全部数据插入sql数据库
///
///
///
protected void Button2_Click(object sender, EventArgs e)
{
string connectionString = "server=.;database=gz.sunnywifi.com;uid=sa;pwd=123456";
SqlConnection conn = new SqlConnection(connectionString);
try
{
conn.Open();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string sqlStr = "";
SqlCommand comm = new SqlCommand();
string ROUTER_MAC = GridView1.Rows[i].Cells[0].Text.Trim().ToString();
string DEVICE_MAC = GridView1.Rows[i].Cells[1].Text.Trim().ToString();
string CREATE_TIME = GridView1.Rows[i].Cells[2].Text.Trim().ToString();
int ID = Convert.ToInt32((GridView1.Rows[i].Cells[3].Text.Trim().ToString()));
string AP_MAC = GridView1.Rows[i].Cells[4].Text.Trim().ToString();
int SINGAL = Convert.ToInt32((GridView1.Rows[i].Cells[5].Text.Trim().ToString()));
sqlStr += "INSERT GreenvPn_CM(ADDRE_MAC,DEV_MAV,GREATE_TIME,AP_MAC,SUNNY_SINQH,YS_ID) VALUES ('" + ROUTER_MAC + "','" + DEVICE_MAC + "','" + CREATE_TIME + "','" + AP_MAC + "','" + SINGAL + "','" + ID + "');";
comm.CommandText = sqlStr;
comm.Connection = conn;
comm.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Response.Write("更新失败,失败原因:" + ex.Message);
}
finally
{
conn.Close();
}
}
#endregion
