您好，



尝试更改以下代码。

Hi,

Try changing your code like the following.

private DataSet GetData(string SPname, SqlParameter SPParameter)
      {
          	string CS = ConfigurationManager.ConnectionStrings["SampleDemoConnectionString"].ConnectionString;
          	SqlConnection conn = new SqlConnection(CS);


                SqlCommand cmd = new SqlCommand("SPname", conn);
		if (SPParameter!=null)
          	{
              		cmd.Parameters.Add(SPParameter);
          	}
                
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cmd;
                
 
          	DataSet DS = new DataSet();
          	da.Fill(DS);
          	return DS;
      }

在此之前，请确保您的sp存在于数据库中。



谢谢，

Sisir Patro

Prior to this make sure that your sp exists in the database.

Thanks,
Sisir Patro