Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
 |
•
•
Join Date: Nov 2007
Posts: 28
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
exec command in stored procedure depends on condition Hi
i want to insert the email into a table,
i pass the parameter to the stored procedure
if this email_id doesnt exists in the table
only then it should be inserted into the table...
how to do this using a stored procedure
please help
its urgent!!!
i want to insert the email into a table,
i pass the parameter to the stored procedure
if this email_id doesnt exists in the table
only then it should be inserted into the table...
how to do this using a stored procedure
please help
its urgent!!!
Thanks & Regards
Umang
Umang
•
•
Join Date: Jan 2008
Location: Largo Florida
Posts: 448
Reputation:
Rep Power: 1
Solved Threads: 32
Posting Pro in Training
this t-sql below does what you want :
declare @email nvarchar(50)
set @email = 'test'
if not exists (select * from yourtable where email=@email )
insert into yourtable(email) values(@email )
declare @email nvarchar(50)
set @email = 'test'
if not exists (select * from yourtable where email=@email )
insert into yourtable(email) values(@email )
Serkan Şendur
MCAD.NET
MCAD.NET
•
•
Join Date: Nov 2007
Posts: 28
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
thanks
but i want to display the message also if email exists
then wht can i do for that???
but i want to display the message also if email exists
then wht can i do for that???
Thanks & Regards
Umang
Umang
•
•
Join Date: Nov 2007
Posts: 28
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
how can i show that message at my .aspx page???
Thanks & Regards
Umang
Umang
•
•
Join Date: Jan 2008
Location: Largo Florida
Posts: 448
Reputation:
Rep Power: 1
Solved Threads: 32
Posting Pro in Training
execute the following query in ExecuteScalar mode, and display the return value to the user.
declare @email nvarchar(50)
set @email = 'test'
if not exists (select * from yourtable where email=@email )
begin
insert into yourtable(email) values(@email )
select 'inserted successfully'
end
else
begin
select 'the provided email already exists in our records'
end
declare @email nvarchar(50)
set @email = 'test'
if not exists (select * from yourtable where email=@email )
begin
insert into yourtable(email) values(@email )
select 'inserted successfully'
end
else
begin
select 'the provided email already exists in our records'
end
Serkan Şendur
MCAD.NET
MCAD.NET
•
•
Join Date: Nov 2007
Posts: 28
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
no
its not working...
its not working...
Thanks & Regards
Umang
Umang
•
•
Join Date: Jan 2008
Location: Largo Florida
Posts: 448
Reputation:
Rep Power: 1
Solved Threads: 32
Posting Pro in Training
ok i will go step by step :
first create your stored procedure in sql server with the following :
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE myInsertProcedure
@email nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;
if not exists (select * from yourtable where email=@email )
begin
insert into yourtable(email) values(@email )
select 'inserted successfully'
end
else
begin
select 'the provided email already exists in our records'
end
END
GO
then go to your aspx page and create the markup below :
<asp: TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp: Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
lastly double click your button and type the following :
i tried this creating a sample application, it works, just modify your connection string and adjust everything according to your webpage
first create your stored procedure in sql server with the following :
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE myInsertProcedure
@email nvarchar(50)
AS
BEGIN
SET NOCOUNT ON;
if not exists (select * from yourtable where email=@email )
begin
insert into yourtable(email) values(@email )
select 'inserted successfully'
end
else
begin
select 'the provided email already exists in our records'
end
END
GO
then go to your aspx page and create the markup below :
<asp: TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp: Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
lastly double click your button and type the following :
SqlConnection sqlCon = new SqlConnection("Data Source=ALPC28\\SERKANS2005;Initial Catalog=denemeler;Integrated Security=True;Pooling=False");
SqlCommand sqlCom = new SqlCommand();
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.CommandText = "myInsertProcedure";
sqlCom.Connection = sqlCon;
SqlParameter sqlPar = new SqlParameter("@email", SqlDbType.VarChar);
sqlPar.Value = TextBox1.Text;
sqlCom.Parameters.Add(sqlPar);
string notification;
sqlCon.Open();
notification = sqlCom.ExecuteScalar().ToString();
sqlCon.Close();
Response.Write(notification);i tried this creating a sample application, it works, just modify your connection string and adjust everything according to your webpage
Serkan Şendur
MCAD.NET
MCAD.NET
|
Other Threads in the ASP.NET Forum
- Previous Thread: ASP.Net Development India
- Next Thread: Socket programming on Web Server
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
