读书人

command插入数据总是出有关问题

发布时间: 2012-03-28 15:40:03 作者: rapoo

command插入数据总是出问题
想用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();  } 

读书人网 >asp.net

热点推荐