public bool Insert(object obj) { Type type = obj.GetType(); PropertyInfo[] properties = type.GetProperties(); string[] col = new string[properties.Length ]; string[] par = new string[properties.Length ]; string[] value = new string[properties.Length ]; int count = 0; foreach (var item in properties) { if (item.Name!=null) { col[count] = item.Name; par[count] = "@"+item.Name; if (item.GetValue(obj) != null) { value[count] = item.GetValue(obj).ToString(); } else { value[count] = "-"; } count++; } } string cols= string.Join(",", col); string parm = string.Join(",", par); string insert = "insert into wbgzd (" + cols + ") values ("+ parm +")"; SqlParameter[] sqls = new SqlParameter[par.Count()]; for (int i = 0; i < par.Count(); i++) { sqls[i] = new SqlParameter(par[i], value[i]); }; Console.WriteLine(insert); return true; } private void button1_Click(object sender, EventArgs e) { wbgzd wbgzd = new wbgzd(); Type type = wbgzd.GetType(); PropertyInfo[] properties = type.GetProperties(); foreach (var item in this.panel1.Controls) { if (item as TextBox!=null) { foreach (var item2 in properties) { if (item2.Name.ToString()== (item as TextBox).Tag.ToString()) { if ((item as TextBox).Text=="") { MessageBox.Show((item as TextBox).Name.ToString() + "不能为空!"); return; } else { item2.SetValue(wbgzd, (item as TextBox).Text.ToString()); } } } } } Console.WriteLine(wbgzd.gzID); Insert(wbgzd); }View Code
标签:par,wbgzd,C#,properties,item,Sql,new,多字段,string From: https://www.cnblogs.com/jjyy2008cn/p/16715330.html