存储过程的返回问题 急急急！！！

[jakey188]

public static Admin CheckUserName(string userName)
        {
                SqlParameter[] para = new SqlParameter[]
				{
					new SqlParameter("@UserName",SqlDbType.NVarChar)
					
				};
                para[0].Value = userName;
                using (DataTable dt = DBHelper.P_GetDataSet("CheckAdminName", para))
                {
                    Admin admin = new Admin();
                    if (dt.Rows.Count>0)
                    {
                        DataRow dr = dt.Rows[0];
                        admin.ID = (int)dr["ID"];
                        admin.UserName = (string)dr["UserName"];
                        admin.Password = (string)dr["Password"];       
                    }
                    return admin;
                    
                }
            
           
        }

public static DataTable P_GetDataSet(string pro_name, params SqlParameter[] values)
        {
            using (SqlConnection connection = new SqlConnection(ConnectionString))
            {
                connection.Open();
                DataSet ds = new DataSet();
                SqlCommand cmd = new SqlCommand(connection,pro_name);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddRange(values);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);
                return ds.Tables[0];
            }
        }

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[CheckAdminName]
(
	@UserName nvarchar(50)
)
 AS
SELECT * FROM Admin WHERE UserName=@UserName

小弟第一次用存储过程 不晓得整
当存在userName时 if (dt.Rows.Count>0) 不往下读 返回不了admin 请问哪里出了问题
谢谢啦

[jakey188]

怎么没人来帮我啊 我只有这么点点分了啦

[huming_h]

为什么要用using (DataTable dt = DBHelper.P_GetDataSet("CheckAdminName", para))
{

直接DataTable dt=DBHelper.P_GetDataSet("CheckAdminName", para);
试试。

[ICrazyBoy]

Admin admin = new Admin();
if (dt.Rows.Count>0)
{
DataRow dr = dt.Rows[0];
admin.ID = (int)dr["ID"];
admin.UserName = (string)dr["UserName"];
admin.Password = (string)dr["Password"];
}
return admin;

写错了地方吧！ 应该是这样的！

if (dt.Rows.Count>0)
{
foreach(DataRow row in dt.rows)
{
Admin admin = new Admin();
admin.ID = (int)row ["ID"];
admin.UserName = (string)row ["UserName"];
admin.Password = (string)row ["Password"];
}
}
return admin;

自己调试调试看看！

[SK_Aqi]

SELECT ID,UserName,Password FROM Admin WHERE UserName=@UserName
把存储过程写全了再看看,到底报错是什么,你加上try,catch捕获一下

[jakey188]

上面几位的我都试过了 还是一样的 也没报错

[SK_Aqi]

没有try,catch,试问怎么报错,何来查错?

[jakey188]

[Quote=引用 7 楼 sk_aqi 的回复:]
没有try,catch,试问怎么报错,何来查错?
[/Quote]
呵呵 我加上也是一样的类

原来是个小问题 我没有给存储过程参数UserName指定长度