给你一个参考SqlConnection con = personOperate.createCon(); con.Open(); SqlCommand cmd = new SqlCommand("insert into personInfo values(@personId,@personName,@personGender)",con); SqlParameter para = new SqlParameter("@personId",SqlDbType.Int); para.Value = p.personId; cmd.Parameters.Add(para); para = new SqlParameter("@personName",SqlDbType.VarChar,20); para.Value = p.personName; cmd.Parameters.Add(para); para = new SqlParameter("@personGender",SqlDbType.VarChar,10); para.Value = p.personGender; cmd.Parameters.Add(para); cmd.ExecuteNonQuery(); con.Close();
myComm.CommandText="insert into SMSOUT (Time1,Context,IP,Phonenumber,Port,Content,Purpose) values ('[@"+Time1+"]','[@"+Context+"]','[@"+IP+"]','[@"+Phonenumber+"]','[@"+Port+"]','[@"+Content+"]','[@"+Purpose+"]')";对吗?
myComm.CommandText="insert into SMSOUT (Time1,Context,IP,Phonenumber,Port,Content,Purpose) values ('[@"+Time1+"]','[@"+Context+"]','[@"+IP+"]','[@"+Phonenumber+"]','[@"+Port+"]','[@"+Content+"]','[@"+Purpose+"]')";这个写法是错的建议先看文档 http://chs.gotdotnet.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/data/datagrid2.src&file=CS\datagrid2.aspx&font=3
myComm.CommandText="insert into SMSOUT (Time1,Context,IP,Phonenumber,Port,Content,Purpose) values (@Time1,@ContextIP,@Phonenumber,@Port,@Content,@Purpose)";
INSERT INTO tb ( fld1, fld2 )
VALUES ([@1], [@2]);程序中参数的传递和SQL数据库的存储过程一样
con.Open();
SqlCommand cmd = new SqlCommand("insert into personInfo values(@personId,@personName,@personGender)",con);
SqlParameter para = new SqlParameter("@personId",SqlDbType.Int);
para.Value = p.personId;
cmd.Parameters.Add(para);
para = new SqlParameter("@personName",SqlDbType.VarChar,20);
para.Value = p.personName;
cmd.Parameters.Add(para);
para = new SqlParameter("@personGender",SqlDbType.VarChar,10);
para.Value = p.personGender;
cmd.Parameters.Add(para);
cmd.ExecuteNonQuery();
con.Close();
http://chs.gotdotnet.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/data/datagrid2.src&file=CS\datagrid2.aspx&font=3