if Exists(select SandS_Tadmin_UserName,SandS_Tadmin_Password from SandS_TAdmin where SandS_Tadmin_UserName=@UserName
and SandS_Tadmin_Password=@password)
Begin
SET @Message='Success'
Return 1
End
else
Begin
SET @Message='Error'
Return 0
End
End
______________________
my asp program is...
_______________________________________
protected void Button1_Click(object sender, EventArgs e)
{
cmd = new SqlCommand("sp_TAdminLogin", con);
cmd.CommandType = CommandType.StoredProcedure;
p1 = new SqlParameter("@UserName", SqlDbType.VarChar);
cmd.Parameters.Add(p1);
p1 = new SqlParameter("@password", SqlDbType.VarChar);
cmd.Parameters.Add(p1);
p1 = new SqlParameter("@Message", SqlDbType.VarChar);
p1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(p1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string x;
x = cmd.Parameters[1].Value.ToString();
if (x == "Success")
{
Response.Redirect("Default.aspx");
}
_______________________________________
i am getting an error
__________________________________________
cmd.ExecuteNonQuery();---->String[2]: the Size property has an invalid size of 0.
Jagadeesh.M
Member
23 Points
62 Posts
i am getting error in this ???
Oct 01, 2010 06:53 AM|LINK
help me in this......
this is my s.p
_________________________
create procedure sp_TAdminLogin
@UserName varchar(50),@password varchar(50),
@Message varchar(100) output
as
Begin
if Exists(select SandS_Tadmin_UserName,SandS_Tadmin_Password from SandS_TAdmin where SandS_Tadmin_UserName=@UserName
and SandS_Tadmin_Password=@password)
Begin
SET @Message='Success'
Return 1
End
else
Begin
SET @Message='Error'
Return 0
End
End
______________________
my asp program is...
_______________________________________
protected void Button1_Click(object sender, EventArgs e)
{
cmd = new SqlCommand("sp_TAdminLogin", con);
cmd.CommandType = CommandType.StoredProcedure;
p1 = new SqlParameter("@UserName", SqlDbType.VarChar);
cmd.Parameters.Add(p1);
p1 = new SqlParameter("@password", SqlDbType.VarChar);
cmd.Parameters.Add(p1);
p1 = new SqlParameter("@Message", SqlDbType.VarChar);
p1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(p1);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string x;
x = cmd.Parameters[1].Value.ToString();
if (x == "Success")
{
Response.Redirect("Default.aspx");
}
_______________________________________
i am getting an error
__________________________________________
cmd.ExecuteNonQuery();---->String[2]: the Size property has an invalid size of 0.
_______________________________________________________________________
help in thissss plzzzzzz
Rajneesh Ver...
All-Star
36815 Points
6757 Posts
Re: i am getting error in this ???
Oct 01, 2010 08:00 AM|LINK
Edited***
Input Output directions
http://weblogs.asp.net/andrewrea/archive/2008/02/19/examples-of-using-system-data-parameterdirection-with-sql-server.aspx
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.
suresh dasar...
Contributor
3606 Points
743 Posts
Re: i am getting error in this ???
Oct 01, 2010 08:13 AM|LINK
hi jagadeesh
Here i have explained clearly how to write query to return output parameters and how to get output parameters in codebehind in asp.net
http://aspdotnet-suresh.blogspot.com/2010/10/how-to-get-output-parameters-return-by.html
Please "Mark as Answer" If post helps you
KumarHarsh
All-Star
15133 Points
3647 Posts
Re: i am getting error in this ???
Oct 01, 2010 09:15 AM|LINK
There is fault in sp also.
replace Return 1 and Return 0 with Return @Message
also in code.what is p1,how u hv declare ?Check it index?It should be 2.
also mention @Message while retrieving as mention by Suresh.
Kumar Harsh
Hong-Gang Ch...
All-Star
74696 Points
6768 Posts
Re: i am getting error in this ???
Oct 07, 2010 12:42 PM|LINK
Please refer this, I am sure this can help you to solve this issue,
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx
If you have any feedback about my replies,please contactmsdnmg@microsoft.com.
Microsoft One Code Framework