 |  |  |  |  |  |  |  |
exec command in stored procedure depends on condition
Please support our ASP.NET advertiser: Intel Parallel Studio Home
 |
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
Posts: 2,052
Reputation: 
Solved Threads: 118
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 )
Due to lack of freedom of speech, i no longer post on this website.
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: Jan 2008
Posts: 2,052
Reputation:
Solved Threads: 118
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
Due to lack of freedom of speech, i no longer post on this website.
•
•
Join Date: Jan 2008
Posts: 2,052
Reputation:
Solved Threads: 118
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
Due to lack of freedom of speech, i no longer post on this website.
|
Other Threads in the ASP.NET Forum
- Previous Thread: ASP.Net Development India
- Next Thread: Socket programming on Web Server
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
.net 2.0 3.5 activexcontrol advice ajax appliances asp asp.net bc30451 beginner bottomasp.net box browser businesslogiclayer button c# c#gridviewcolumn cac checkbox class click compatible confirmationcodegeneration content contenttype control countryselector courier css database datagrid datagridview datagridviewcheckbox datalist deadlock deployment development dgv dialog dropdownmenu dynamic edit embeddingactivexcontrol fileuploader findcontrol flash flv forms gridview gudi homeedition iframe iis javascript jquery list menu mono mssql multistepregistration nameisnotdeclared novell objects order problem ratings redirect registration relationaldatabases rotatepage save search security serializesmo.table sessionvariables silverlight smartcard sql ssl suse textbox tracking treeview unauthorized validatedate validation vb.net video virtualdirectory vista visual-studio visualstudio vs2008 web webarchitecture webdevelopemnt webdevelopment wizard xml
