以下这段代码是输入Id,存入Attending数据库,运行时输入相应的ID,出现如下错误:异常详细信息: System.Data.SqlClient.SqlException: 被准备语句 '(@Id varchar(1),@UCAS varchar(8000))insert into Attending(Id,UCA' 需要参数 @UCAS,但未提供该参数。源错误:
行 82: cmds.Parameters.Add("@UCAS",SqlDbType.VarChar);
行 83: cmds.Parameters["@UCAS"].Value = Session["UCASNumber"];
行 84: cmds.ExecuteReader();
行 85:
行 86:
应该是84行错误,怎样改呢?private void Button1_Click(object sender, System.EventArgs e)
{
String Id = TextBox2.Text;
try
{
VisitConnection.Open();
SqlCommand cmds =
new SqlCommand("insert into Attending(Id,UCAS) values (@Id,@UCAS)",VisitConnection); cmds.Parameters.Add("@Id",SqlDbType.VarChar);
cmds.Parameters["@Id"].Value = Id;
cmds.Parameters.Add("@UCAS",SqlDbType.VarChar);
cmds.Parameters["@UCAS"].Value = Session["UCASNumber"];
cmds.ExecuteReader(); Response.Redirect("UserInterface.aspx");
}
finally{
VisitConnection.Close();
}
}
行 82: cmds.Parameters.Add("@UCAS",SqlDbType.VarChar);
行 83: cmds.Parameters["@UCAS"].Value = Session["UCASNumber"];
行 84: cmds.ExecuteReader();
行 85:
行 86:
应该是84行错误,怎样改呢?private void Button1_Click(object sender, System.EventArgs e)
{
String Id = TextBox2.Text;
try
{
VisitConnection.Open();
SqlCommand cmds =
new SqlCommand("insert into Attending(Id,UCAS) values (@Id,@UCAS)",VisitConnection); cmds.Parameters.Add("@Id",SqlDbType.VarChar);
cmds.Parameters["@Id"].Value = Id;
cmds.Parameters.Add("@UCAS",SqlDbType.VarChar);
cmds.Parameters["@UCAS"].Value = Session["UCASNumber"];
cmds.ExecuteReader(); Response.Redirect("UserInterface.aspx");
}
finally{
VisitConnection.Close();
}
}
解决方案 »
- 数据库添加语句
- 怎么解决在WinForm下拉列表ComboBox显示System.Data.DataRowview的问题啊?
- 在datagridview里面已经根据某个操作后对‘行’进行了颜色分类,但是进行了筛选后已经设定的颜色又变成默认的白底黑字,怎么能保留颜色的设定啊?
- 关于DataGrid(C/S).
- 请问谁有域名查询和域名注册的开发包或相关文档.
- 关于Web中DataSet的使用
- 如何判断文本框输入的是整型数据,在线等!~~~~~~~~~~~~~~
- C# TCP 异步Socket传文件时发现速度太快的时会出现接收的数据出错
- 求x的y次方,用哪个函数?
- 在C#中如何截取一个对话框的图?
- !!!!!!!水晶报表连接带密码的access数据库问题!!!!!!!!!!
- winform下文件(word,excel,ppt,txt)存入数据库后怎样显示
你可以先测试下。
ExecuteReader ??为什么要用这个????
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;namespace CourseWork3
{
/// <summary>
/// </summary>
public class WebForm4 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.DataGrid OpenDayTable;
protected System.Web.UI.WebControls.DataGrid OpenDay; protected System.Data.SqlClient.SqlConnection VisitConnection;
private void Page_Load(object sender, System.EventArgs e)
{
VisitConnection.Open();
SqlCommand command = new SqlCommand("select * from OpenDay", VisitConnection);
SqlDataReader reader = command.ExecuteReader();
OpenDay.DataSource = reader;
OpenDay.DataBind();
reader.Close();
VisitConnection.Close(); } #region
override protected void OnInit(EventArgs e)
{
//
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// </summary>
private void InitializeComponent() {
this.VisitConnection = new System.Data.SqlClient.SqlConnection();
this.Button1.Click += new System.EventHandler(this.Button1_Click);
//
// VisitConnection
//
this.VisitConnection.ConnectionString = "workstation id=erthrc;packet size=4096;integrated security=SSPI;data source=erthr" +
"c;persist security info=False;initial catalog=VisitDays";
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void Button1_Click(object sender, System.EventArgs e)
{
String Id = TextBox2.Text;
try
{
VisitConnection.Open();
SqlCommand cmds =
new SqlCommand("insert into Attending(Id,UCAS) values (@Id,@UCAS)",VisitConnection); cmds.Parameters.Add("@Id",SqlDbType.VarChar);
cmds.Parameters["@Id"].Value = Id;
cmds.Parameters.Add("@UCAS",SqlDbType.VarChar);
cmds.Parameters["@UCAS"].Value = Session["UCASNumber"];
cmds.ExecuteReader(); Response.Redirect("UserInterface.aspx");
}
finally{
VisitConnection.Close();
}
}