数据源参数和数据源值 [英] DataSource Parameters and Datasource Value

问题描述

我正在尝试使用数据源并检索其值，它应该能够为我提供正确的ID，但代码始终返回null.

数据源的存储过程为...

Im trying to use a datasource and retrieve the value of it.It shopuld be able to give me the correct ID but the code always returns a null.

the stored procedure for the datasource is ...

CREATE PROCEDURE [dbo].[RecordManagement_getcollegeid]
(
   @College nvarchar(100)
)
AS
Select College_ID
From College
WHERE College_Name = @College

后面的代码是

THE BEHIND CODE IS

SqlDataSource SqlDS_GetCollegeID = new SqlDataSource();   
              SqlDS_GetCollegeID.SelectParameters.Add("College", ddlistschool.SelectedValue);
        int test2 = SqlDS_GetCollegeID;//i want to get the value datasource(SqlDS_GetCollegeID)

推荐答案

由于您的问题不清楚，因此此 LINK 将对您有用.

Since your question is not in a clear view.This LINK will be useful for you.

这篇关于数据源参数和数据源值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！