hanis29268
دوشنبه 21 فروردین 1391, 14:20 عصر
با سلام
دوستان من نمیدونم چه طوری مقدار یک query رو برگردونم،توی sql جواب میده ولی توی asp عبارتnull برمیگردونه؟؟
کد:
protected void Page_Load(object sender, EventArgs e)
{
string user, pass;
user = Request.Form["user"].ToString();
pass = Request.Form["password"].ToString();
AvarezDataSetTableAdapters.QueriesTableAdapter adap = new AvarezDataSetTableAdapters.QueriesTableAdapter();
ArrayList ss = new ArrayList();
ss.Add(adap.GetUsers(user , pass )).ToString();
}
و function:
USE [Shahrdari]
GO
/****** Object: UserDefinedFunction [dbo].[BankName] Script Date: 03/03/2011 11:06:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: <Description, ,>
-- =============================================
create FUNCTION [dbo].[GetUsers]
(
@user as nvarchar(500),@Pass as nvarchar(50)
)
RETURNS nvarchar(500)
AS
BEGIN
declare @s as nvarchar(500)
set @s= (select fldUser from Tblusertest where fldUser=@user and fldPass =@pass)
if (@s is null) set @s=''
return @s
END
دوستان من نمیدونم چه طوری مقدار یک query رو برگردونم،توی sql جواب میده ولی توی asp عبارتnull برمیگردونه؟؟
کد:
protected void Page_Load(object sender, EventArgs e)
{
string user, pass;
user = Request.Form["user"].ToString();
pass = Request.Form["password"].ToString();
AvarezDataSetTableAdapters.QueriesTableAdapter adap = new AvarezDataSetTableAdapters.QueriesTableAdapter();
ArrayList ss = new ArrayList();
ss.Add(adap.GetUsers(user , pass )).ToString();
}
و function:
USE [Shahrdari]
GO
/****** Object: UserDefinedFunction [dbo].[BankName] Script Date: 03/03/2011 11:06:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: <Description, ,>
-- =============================================
create FUNCTION [dbo].[GetUsers]
(
@user as nvarchar(500),@Pass as nvarchar(50)
)
RETURNS nvarchar(500)
AS
BEGIN
declare @s as nvarchar(500)
set @s= (select fldUser from Tblusertest where fldUser=@user and fldPass =@pass)
if (@s is null) set @s=''
return @s
END