Trigger

Whenever I run the form and complete the procedure then I need to go back to sql database and click on execute. I want to avoid everytime going back and executing each entry because if I don't execute everytime then the further other [b]form data [/b]will not be[b] retrieved[/b] properly as the [b]previous form[/b] will [b]not be updated[/b]. I hope ur understanding ...
I have written the query in the [b]form code[/b] itself.
I have used [b]trigger[/b] once but that was on the Database side itself.
so,this time I am not understanding what to do!!
So what is the solution to make the database execute automatically once the code is being executed i.e. the details are sent to database?

Re: Trigger

You can create a Stored Procedure and put in whatever logic you need to perform on your Data, now you can call this stored procedure from asp.net code.

Re: Trigger

nijhawan.saurabh

I don't know how to do this...So I asked here.

Re: Trigger

nijhawan.saurabh

did u mean to remove the query command code of form side and put it in stored procedure and then call this stored procedure from form side?

Re: Trigger

IAmateur

nijhawan.saurabh

did u mean to remove the query command code of form side and put it in stored procedure and then call this stored procedure from form side?

Correct!

Re: Trigger

What is the syntax to cal stored procedure from code side?

Re: Trigger

Hello,

Follow the thread below. It will help you

http://support.microsoft.com/kb/306574

Re: Trigger

IAmateur

What is the syntax to cal stored procedure from code side?

Hi,

You could write like this:

SqlConnection conn = new SqlConnection("your_sql_server_connection_string");
        SqlCommand cmd = new SqlCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "your sp's name";
        //add values to paramters.
        cmd.Parameters.AddWithValue("@name1", "name1");
        conn.Open();
        cmd.Connection = conn;
        cmd.ExecuteNonQuery();
        conn.Close();

Thanks.