常用方法
常用方法
常用方法
常用方法
//SqlCommand cmd; public void SaveControl(List <MyControl> controls) { DBHelper.ExecuteIUD("delete controlInfo"); string sql = "insert controlInfo "; foreach (MyControl item in controls) { sql += " select '" + item.Name + "' , '" + item.CLocation + "' , '" + item.CFont + "' , '" + item.CColor + "' union "; } sql = sql.Substring(0, sql.LastIndexOf("union") - 1); DBHelper.ExecuteIUD(sql); }