SqlConnection myconn = DB.CreateConnection();
myconn.Open();
SqlCommand CMD = new SqlCommand("insert into news(title,auther,content) Values(@Title,@Auther,@Content)", myconn);
CMD.CommandType = CommandType.StoredProcedure;
CMD.Parameters.Add(new SqlParameter("@Title", SqlDbType.Char, 20));
CMD.Parameters["@Title"].Value = Title;
CMD.Parameters.Add(new SqlParameter("@Auther", SqlDbType.Char, 10));
CMD.Parameters["@Auther"].Value = Auther;
CMD.Parameters.Add(new SqlParameter("@Content", SqlDbType.Char, 255));
CMD.Parameters["@Content"].Value = Content;
CMD.ExecuteNonQuery();(提示:将参数值从 TextBox 转换到 String 失败。)
myconn.Close();
myconn.Open();
SqlCommand CMD = new SqlCommand("insert into news(title,auther,content) Values(@Title,@Auther,@Content)", myconn);
CMD.CommandType = CommandType.StoredProcedure;
CMD.Parameters.Add(new SqlParameter("@Title", SqlDbType.Char, 20));
CMD.Parameters["@Title"].Value = Title;
CMD.Parameters.Add(new SqlParameter("@Auther", SqlDbType.Char, 10));
CMD.Parameters["@Auther"].Value = Auther;
CMD.Parameters.Add(new SqlParameter("@Content", SqlDbType.Char, 255));
CMD.Parameters["@Content"].Value = Content;
CMD.ExecuteNonQuery();(提示:将参数值从 TextBox 转换到 String 失败。)
myconn.Close();
Auther 是什么?
Content 是什么?
是字符串还是TextBox变量?
这种问题和数据库没有关系!