Suppose in the table, username already exits means how to show the alert/ message in code behind file...

Question

2.00/5 (1 vote)

See more:

C#

CREATE proc [dbo].[sp_user] 
(
@userid int,
@username varchar(20)
)
as 
begin
 
 
IF exists(select * from tbl_ins where username=@username)  
BEGIN
print 'Username Already exits'
Return 1
END
Else
insert into tbl_ins(userid, username) values(@userid,@username)
return -1
end

The above sp checks the username already exits in the table....

By using the above stored procedure, how to show the alert/ message , suppose the username already exits means in the below code behind file...

C#

protected void Btn_Save_Click(object sender, EventArgs e)
        {

            con.Open();
            cmd = new SqlCommand("sp_user", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@userid", txt_uid.Text);
            cmd.Parameters.AddWithValue("@username", txt_uname.Text);
            cmd.ExecuteNonQuery();
            con.Close();


        }

Kindly help me friends...
Thanks advance...

Posted 28-Nov-13 18:07pm

M.Thiyagaraja

Updated 28-Nov-13 18:15pm

Tom Marvolo Riddle

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Harshil_Raval · Answer 1 · 2013-11-28T18:49:00

Hi,
Try this.
//Change your Stored Procedure

SQL

CREATE proc [dbo].[sp_user] 
    @userid int,
    @username varchar(20),
    @flag int OUTPUT
AS
BEGIN 
    IF EXISTS(SELECT * FROM tbl_ins WHERE username=@username)  
    BEGIN
        SET @flag = -1
    END
    Else
    BEGIN
        INSERT INTO tbl_ins(userid, username) VALUES (@userid,@username)
        SET @flag = 1
    END
END

//Now change your code

C#

protected void Btn_Save_Click(object sender, EventArgs e)
{
    con.Open();
    cmd = new SqlCommand("sp_user", con);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@userid", txt_uid.Text);
    cmd.Parameters.AddWithValue("@username", txt_uname.Text);
    SqlParameter text = new SqlParameter("@flag", SqlDbType.Int);
    text.Direction = ParameterDirection.Output;
    cmd.Parameters.Add(text);
    cmd.ExecuteNonQuery();
    con.Close();
    int flagvalue = Convert.ToInt32(text.Value);  //return value
    if(flagvalue == 1)
    {
        // success
    }
    else
    {
        // username already exists. either show in lable or give alert message
    }
}

Hope it helps you.
Thanks.

Tom Marvolo Riddle · Answer 2 · 2013-11-28T18:24:00

Try something like This:

C#

            SqlDataReader dr;
            cmd = new SqlCommand("select * from tbl_ins where username=@username", con);
            dr = cmd.ExecuteReader();
            dr.Read();
            if (dr.HasRows)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Already exist');", true);
dr.Close();
            }
else
{
//insert  query here
dr.Close();
}

C For Code!!! · Answer 3 · 2013-11-28T18:50:00

You can do it by using DataAdapter also

SQL

CREATE proc [dbo].[sp_user] 
(
@userid int,
@username varchar(20)
)
as 
begin
select * from tbl_ins where username=@username  
end

C#

DataSet ds=new DataSet();

cmd = new SqlCommand("sp_user", con);
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.Parameters.AddWithValue("@userid", txt_uid.Text);
           cmd.Parameters.AddWithValue("@username", txt_uname.Text);
 DataAdpater da=new DataAdapter(cmd);
 da.Fill(ds);
int len=ds.Tables[0].Rows.Count;
if(len>0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('UserName Already Exits');", true);
}

Hope This Helps!!!

*Suvabrata Roy* · Answer 4 · 2013-11-28T18:38:00

Hi,
I will change it slightly.

SQL

CREATE proc [dbo].[sp_user] 
(
@userid int,
@username varchar(20)
)
as 
begin
 
 
IF exists(select * from tbl_ins where username=@username)  
BEGIN
RAISERROR (16,-1,-1, 'Username Already exits');
Return 1
END
Else
insert into tbl_ins(userid, username) values(@userid,@username)
return -1
end

Now in Code behind:

C#

try {
con.Open();
            cmd = new SqlCommand("sp_user", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@userid", txt_uid.Text);
            cmd.Parameters.AddWithValue("@username", txt_uname.Text);
            cmd.ExecuteNonQuery();
            con.Close();
}
catch(Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('"+ex.Message+"');", true);
}
finally
{
if(con!=null)
{
con.Close();
}
}

Suppose in the table, username already exits means how to show the alert/ message in code behind file...

4 solutions

Solution 3

Solution 1

Solution 4

Solution 2

Add your solution here

Preview 0