日期:2014-05-18 浏览次数:20499 次
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();
}