存储过程的调用不是这么写的,给个例子与你
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["Connectionstring"]);
SqlDataAdapter myCommand = new SqlDataAdapter("GetLimits",myConnection);
myCommand.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parameterUserID = new SqlParameter("@UserID",SqlDbType.Int);
parameterUserID.Value = userID;
myCommand.SelectCommand.Parameters.Add(parameterUserID); DataSet ds = new DataSet();
myCommand.Fill(ds,"Limit");
return ds;
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["Connectionstring"]);
SqlDataAdapter myCommand = new SqlDataAdapter("GetLimits",myConnection);
myCommand.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parameterUserID = new SqlParameter("@UserID",SqlDbType.Int);
parameterUserID.Value = userID;
myCommand.SelectCommand.Parameters.Add(parameterUserID); DataSet ds = new DataSet();
myCommand.Fill(ds,"Limit");
return ds;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货