想用command插入数据,但是总是出问题,数据根本就没进入数据库啊,不知道什么问题,在page_load 中加入了if(!ispostback) 了,插入的按钮代码如下,不知哪里出了问题啊
protected void sendmsg_Click(object sender, EventArgs e)
{
string strconn = WebConfigurationManager.ConnectionStrings["istudyconn"].ConnectionString;
SqlConnection conn = new SqlConnection(strconn);
string sqlcomm = "insert into msginfo (senduser,recuser,msgcontent,readflag) values (@senduser,@recuser,@msgcontent,0)";
SqlCommand comm = new SqlCommand(sqlcomm,conn);
comm.Parameters.Add("@senduser", SqlDbType.NVarChar, 50);
comm.Parameters.Add("@recuser", SqlDbType.NVarChar, 50);
comm.Parameters.Add("@msgcontent", SqlDbType.Text);
comm.Parameters["@senduser"].Value = Session["user"].ToString();
comm.Parameters["@recuser"].Value = Request.QueryString["jieshou"];
comm.Parameters["@msgcontent"].Value = msgbox.Text;
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
}
------解决方案--------------------------------------------------------
- C# code
protected void sendmsg_Click(object sender, EventArgs e) { string strconn = WebConfigurationManager.ConnectionStrings["istudyconn"].ConnectionString; SqlConnection conn = new SqlConnection(strconn); conn.Open(); string sqlcomm = "insert into msginfo (senduser,recuser,msgcontent,readflag) values (@senduser,@recuser,@msgcontent,0)"; SqlCommand comm = new SqlCommand(sqlcomm,conn); SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@senduser",SqlDbType.NVarChar,50), new SqlParameter("@recuser",SqlDbType.NVarChar,50), new SqlParameter("@msgcontent",SqlDbType.Text), }; sp[0].Value = Session["user"].ToString(); sp[1].Value = Request.QueryString["jieshou"]; sp[2].Value = msgbox.Text; com.Parameters.AddRange(sp); comm.ExecuteNonQuery(); comm.Dispose(); conn.Dispose(); conn.Close(); }