我用下面的代码将数据提交到数据库,怎么提交到数据库里的是两条重复的纪录阿
怎么解决阿?
string connstr="Server=127.0.0.1;User ID=sa; Password=sa; Initial Catalog=fld001";
string insert = "INSERT INTO WorkPlan (Context1, Context2,Time,UserID) Values('"+TextBox3.Text+"', '"+TextBox4.Text+"','"+today.ToShortDateString()+"',"+fbr+")";
conn=new SqlConnection(connstr);
SqlCommand comm=new SqlCommand(insert,conn);
conn.Open();
SqlDataReader myReader = comm.ExecuteReader();
myReader.Close();
怎么解决阿?
string connstr="Server=127.0.0.1;User ID=sa; Password=sa; Initial Catalog=fld001";
string insert = "INSERT INTO WorkPlan (Context1, Context2,Time,UserID) Values('"+TextBox3.Text+"', '"+TextBox4.Text+"','"+today.ToShortDateString()+"',"+fbr+")";
conn=new SqlConnection(connstr);
SqlCommand comm=new SqlCommand(insert,conn);
conn.Open();
SqlDataReader myReader = comm.ExecuteReader();
myReader.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货