C# (CSharp) DAL DBHelper.ExecuteIUD Beispiele

Beispiel #1

        //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);
        }