Question

c#.net插入sql数据库语句

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { string mc = TextBox1.Text.Trim(); string nl = TextBox2.Text.Trim(); SqlConnection conn = new SqlConnection("server=weng;database=db;uid=sa;pwd=123"); conn.Open(); insert into tcr (mc1,nl2) values ('" + mc + "','" + nl + "',); } } 求解这样写插入语句运行有错误，怎么修改？谢谢！

Answer 1

你写的对数据库操作的代码都不完整，你可以这样写： string mc = TextBox1.Text.Trim(); string nl = TextBox2.Text.Trim(); string sql=string.Format("insert into tcr(mc1,mc2) values('{0}','{1}')",mc,nl);//sql插入语句 SqlConnection conn = new SqlConnection("server=weng;database=db;uid=sa;pwd=123"); conn.Open(); SqlCommand comm=new SqlCommand (sql,conn); comm.ExecuteNonQuery(); conn.Close(); 上面的sql字符串变量就是你要的sql语句。 以上信息希望对你有帮助。。^^

Answer 2

.net是认识sql语句的，要操作sql，语句只能用嵌入式，也就需要一个操作对象，所以insert into tcr (mc1,nl2) values ('" + mc + "','" + nl + "',); 需要改为： SqlCommand cmd = new SqlCommand("insert into tcr (mc1,nl2) values ('" + mc + "','" + nl + "')", conn); //定义一个sql操作命令对象 cmd.ExecuteNonQuery(); //执行语句 conn.Close(); //关闭连接 cmd = null; conn.Dispose(); //释放对象