问题描述
usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclass_Default:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){SqlConnectionconn=newSqlConnection("userid=test;password=aaa;database=pay;server=aaa-5ffb53b4342");SqlCommandcmd=newSqlCommand("Pay_SitePoint_GetPoint",conn);cmd.CommandType=CommandType.StoredProcedure;SqlParameterpara=newSqlParameter();para.ParameterName="@username";para.SqlDbType=SqlDbType.VarChar;para.Direction=ParameterDirection.Input;para.Value=TextBox1.Text.Trim();cmd.Parameters.Add(para);para.ParameterName="@FreePoint";para.SqlDbType=SqlDbType.Decimal;para.Direction=ParameterDirection.Output;para.ParameterName="@BuyPoint";para.SqlDbType=SqlDbType.Decimal;para.Direction=ParameterDirection.Output;conn.Open();SqlDataReadermyDataReader=cmd.ExecuteReader();while(myDataReader.Read()){Response.Write(myDataReader.GetDecimal(0)+","+myDataReader.GetDecimal(0));}myDataReader.Close();conn.Close();}}编译提示:过程或函数'Pay_SitePoint_GetPoint'需要参数'@UserName',但未提供该参数。请帮忙找出错误.功能就是调一个存储过程,输入一个参数.输出二个参数.
解决方案
解决方案二:
protectedvoidButton1_Click(objectsender,EventArgse){SqlConnectionconn=newSqlConnection("userid=test;password=aaa;database=pay;server=aaa-5ffb53b4342");SqlCommandcmd=newSqlCommand("Pay_SitePoint_GetPoint",conn);cmd.CommandType=CommandType.StoredProcedure;cmd.Parameters.AddWithValue("@UserName",TextBox1.Text.Trim());cmd.Parameters.Add("@FreePoint",SqlDbType.Decimal).Direction=ParameterDirection.Output;cmd.Parameters.Add("@BuyPoint",SqlDbType.Decimal).Direction=ParameterDirection.Output;conn.Open();SqlDataReadermyDataReader=cmd.ExecuteReader();while(myDataReader.Read()){//下面有点问题,怎么下标都是0?Response.Write(myDataReader.GetDecimal(0)+","+myDataReader.GetDecimal(0));}myDataReader.Close();conn.Close();}