 |  |  |  |  |  |  |  |
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.
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
.net 2.0 ajax alltypeofvideos appliances application asp asp.net bc30451 beginner box browser button c# cac checkbox class commonfunctions control countryselector dataaccesslayer database datagridview datagridviewcheckbox datalist deployment development dgv dialog dropdownlist dynamic dynamically edit embeddingactivexcontrol expose feedback fileuploader fill findcontrol flash form formatdecimal formview gridview gudi iis image javascript listbox login microsoft mouse mssql news novell numerical opera panelmasterpagebuttoncontrols parent problem radio redirect registration relationaldatabases reportemail save schoolproject search security select sessionvariables silverlight smoobjects software sql sql-server sqlserver2005 ssl suse textbox tracking treeview unauthorized validatedate validation vb.net video videos vista visualstudio vs2008 web webapplications webdevelopemnt webdevelopment webprogramming webservice wizard xsl youareanotmemberofthedebuggerusers
