问使用带有存储过程和参数的SqlDataAdapter更新和检索值

EN

...

        SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlQuery, sqlConnection);

        foreach (SqlParameter sqlParameter in sqlParameterCollection)
        {
            sqlCommand.Parameters.Add(new SqlParameter(sqlParameter.ParameterName, sqlParameter.Value));
        }
        sqlDataAdapter.SelectCommand = sqlCommand;
        DataSet dataSet = new DataSet();
        sqlDataAdapter.Fill(dataSet);