protected void Button1_Click(object sender, EventArgs e)
{
string name = Session["Vipname"].ToString();
string userid = Session["Vipcard"].ToString();
string zhuti = txt_zhutiadd.Text.ToString();
string neirong = txt_neirongadd.Text.ToString();
//string time = DateTime.Now.ToString();
string sConn = ConfigurationManager.ConnectionStrings["ConnStr"].ToString();
using (SqlConnection Conn = new SqlConnection(sConn))
{
Conn.Open();
using (SqlCommand cmd = new SqlCommand("Insert INTO [Liuyan] ([lytitle], [lycontent] ,[username] , [userid]) VALUES (@zhuti,@neirong,@name,@userid)", Conn))
{
cmd.Parameters.AddWithValue("@zhuti", zhuti);
cmd.Parameters.AddWithValue("@neirong", neirong);
//cmd.Parameters.AddWithValue("@time", time);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@userid", userid);
cmd.ExecuteNonQuery();
}
}
总是报错,看了半天实在是看不出哪里错了,求大神解答编译不报错 运行出错行 40: cmd.Parameters.AddWithValue("@name", name);
行 41: cmd.Parameters.AddWithValue("@userid", userid);
行 42: cmd.ExecuteNonQuery();
行 43:
行 44: }
在线等大神解答
{
string name = Session["Vipname"].ToString();
string userid = Session["Vipcard"].ToString();
string zhuti = txt_zhutiadd.Text.ToString();
string neirong = txt_neirongadd.Text.ToString();
//string time = DateTime.Now.ToString();
string sConn = ConfigurationManager.ConnectionStrings["ConnStr"].ToString();
using (SqlConnection Conn = new SqlConnection(sConn))
{
Conn.Open();
using (SqlCommand cmd = new SqlCommand("Insert INTO [Liuyan] ([lytitle], [lycontent] ,[username] , [userid]) VALUES (@zhuti,@neirong,@name,@userid)", Conn))
{
cmd.Parameters.AddWithValue("@zhuti", zhuti);
cmd.Parameters.AddWithValue("@neirong", neirong);
//cmd.Parameters.AddWithValue("@time", time);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@userid", userid);
cmd.ExecuteNonQuery();
}
}
总是报错,看了半天实在是看不出哪里错了,求大神解答编译不报错 运行出错行 40: cmd.Parameters.AddWithValue("@name", name);
行 41: cmd.Parameters.AddWithValue("@userid", userid);
行 42: cmd.ExecuteNonQuery();
行 43:
行 44: }
在线等大神解答
string userid = Session["Vipcard"].ToString();
session是空的?