call delete if not exists condition in c#

Question

0.00/5 (No votes)

See more:

Hi all,
I have a stored procedure which is like this,

SQL

Alter proc usp_DelTechnology
(@TechnologyID int)
 as
Begin
 -- make sure we don't have reference descriptions
if(NOT EXISTS(select TechnologyID from tblTechnologySubTypes where TechnologyID = @TechnologyID) and
   NOT EXISTS(select TechnologyID from tblApplicationVsTechnologies where TechnologyID = @TechnologyID) and
   NOT EXISTS(select TechnologyID from tblEffortHours where TechnologyID = @TechnologyID))
BEGIN
 DELETE from tblTechnologies where TechnologyID = @TechnologyID
END
else
 begin
 Print 'False'
 end
 END

I have called the sp like this,

C#

public int DeleteTechnology()
       {
           SqlParameter[] prms = new SqlParameter[1];
           prms[0] = new SqlParameter("@TechnologyID", TechnologyID);

           Data.ExecuteNonQuery("usp_DelTechnology", prms);
           return 0;
       }

Can anyone help me on how to do this in c#. I want to delete the technology if it doesnt have the reference in another table.. if it has then it should show a msg.. I have to do this in grid view image button.. On click of image button, the delete should happen..
Please help.
Thanku. :)

Posted 21-Apr-13 21:32pm

Anusha Sridhar

Updated 22-Apr-13 0:11am

Deependra Khangarot

v3

Add a Solution

Comments

Naz_Firdouse 22-Apr-13 3:37am

what have you tried???

Anusha Sridhar 22-Apr-13 3:44am

As a newbie to .net , I have no idea on how to give that if not exists condition in c#.. so am hanging in the middle struggling what to do.

Naz_Firdouse 22-Apr-13 3:48am

did you checked whether your SP is working correct... in DB itself by executing the SP

Anusha Sridhar 22-Apr-13 5:51am

sorry for the late reply.. yes. its working fine with the sp/..

2 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)

Naz_Firdouse · Answer 1 · 2013-04-21T21:47:00

you can have your image button inside the gridview like this ...

ASP.NET

asp:ImageButton runat="server" ID="ibtnDelete"
        Text="delete"
        CommandName="delete"
        CommandArgument='<%#Eval("technologyID")%>
'

and you can add a RowCommand

C#

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "delete")
    {
        DeleteTechnology(convert.toInt32(e.CommandArgument));
    }
}

C#

public int DeleteTechnology(int TechnologyID)
       {
           SqlParameter[] prms = new SqlParameter[1];
           prms[0] = new SqlParameter("@TechnologyID", TechnologyID);
 
           Data.ExecuteNonQuery("usp_DelTechnology", prms);
           return 0;
       }

Vani Kulkarni · Answer 2 · 2013-04-21T21:51:00

Alter your stored procedure as below, so that it returns some value like below:

SQL

Alter proc usp_DelTechnology
(
   @TechnologyID int
)

AS

BEGIN
 -- make sure we don't have reference descriptions
if(NOT EXISTS(select TechnologyID from tblTechnologySubTypes where TechnologyID = @TechnologyID) and
   NOT EXISTS(select TechnologyID from tblApplicationVsTechnologies where TechnologyID = @TechnologyID) and
   NOT EXISTS(select TechnologyID from tblEffortHours where TechnologyID = @TechnologyID))
BEGIN
 DELETE from tblTechnologies where TechnologyID = @TechnologyID
 RETURN 1
END
   ELSE
     BEGIN
       Return 0
     END
END

Now in c# code, create onClick event for image button

C#

private void ImageButton_Click(object sender, EventArgs e)
{
    using (SqlConnection con = new SqlConnection("Your database connection string here."))
    {
        using (SqlCommand cmd = new SqlCommand("usp_DelTechnology", con))
        {
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.Parameters.Add("@TechnologyID", SqlDbType.int).Value = GridView1.Cells[0].Text; //access technology Id from Gridview
           con.Open();
           int returnValue = cmd.ExecuteNonQuery();
           if (returnvalue == 0)
           {
               //Display message - There are references
           }
           else
           {
               //Deleted Successfully message.
           }

        }
    }
}

call delete if not exists condition in c#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0