Comments by Sachin gulati (Top 39 by date)

actually my second trigger is dependent on the first trigger so i need to use it.
as you referred.. i am using this code:

exec sp_settriggerorder @triggername = 'send_all',
@order = 'first',
@stmttype = 'insert',
@namespace = null

exec sp_settriggerorder @triggername = 'inbox',
@order = 'last',
@stmttype = 'insert',
@namespace = null
go

but unfortunately it is not working..
my 2nd trigger "inbox" always get executed before 1st "send_all"
both the triggers fire after an insert command on the database.
am i doing something wrong?

thanx for the extra information......
hey pls tell me do triggers also have some order in which dey implement...
or can we make them implement in some defined order when they all are called at a same time??

hey thanx it worked... you are genius.. :)

can i make cursor permanent in memory?

it worked... thanx alot... :)

thank you... :)

thank you it will really help me alot in my project..

thank you :)

i am making database application so database can store username with space and special character...
but why most of the application and websites don't allow this?

i'm talking about the browser's back button.. i want to disable it as in it may not show the previous page from browser's cache.. but reloads the previous page and show the updated version of it... the browser's button is still enable but i want to reload the previous page if back button is clicked...

actually i want to disable back button so that every time a user click on back button it does not show the previous page from the browser's cache.. but reloads the previous page and show the updated version of the page....

actually i dont want to disable history hence no back is available. i want that whenever user click back button it reloads the previous page inspite of taking it from the browser cache....

how to use it....?? pls give a short example.

i m using the default button field of gridview and there it is not allowed to define commandargument. pls suggest something else...

thanx i studied about the on delete cascade, n it worked as u said.....
now i have no more queries in this context. i m fully satisfied...
thankew :)

there is no suggestion for doing it....
anyways thanx alot.... :)

hey thanx its working...
n what if i want to delete all children rows if parent is going to be deleted?

create trigger manage_mail
on mymail
after delete
as
DECLARE @count_references int,@mail_id varchar(20)
begin
select @mail_id=mail_id from deleted
select @count_references=count(*) from mymail where

mail_id=@mail_id
if(@count_references =0)
begin
delete from mails where mail_id = @mail_id
end
end


in this i m checking the reference for the mails(table) in mymail(table) on deletion in mymail if it is 0 then the original mail from the table mails will also be deleted...

hey but still i need to define a trigger which will work for multiple rows for some other purpose. please guide me...

hey thanx for the brilliant suggestion.... :)

i have already defined its rowcommand event but its e.CommandArgument remains null. so it don't perform any action.

no. actually i have already added link buttons through item template.
and defined rowcommand event for it
but its e.commandArgument doesn't hold any value. it remains "" null
pls suggest some easy example

pls tell me how....

no it doesn't have ispostback....
is it required??

thanx for answering....
it will help me a lot.... :)

thank you :)

no no.... i m talking about the no. of characters it shows....
tell me about rowdatabound... will it work??

okkk..... thanx.. :)

is there any function to append??

thanx alot... it works.... thank u :)

yeah that is true it doesn't work in all situation....
i try to use ajax calender extender as u suggested....
thanx.... :)

how to add control on some particular location??

and is this code appropriate?

private void Page_Load(object sender, System.EventArgs e)
{
RecreatePersistedControls();
}
private void Button_Click(object sender, System.EventArgs e)
{
CreateControl("newControl");
PersistControl("newControl");
}
private void RecreatePersistedControls()
{
// Call CreateControl for each persisted control
}
private void CreateControl(string id)
{
// Create controll with specified id,
// add it to controls collection, attach event handlers
}
private void PersistControl(string id)
{
// Persist specified id (in session for example)
}

hey i checked out d link u gave me..
after reading it.
i turned on my ip/tcp protocol n other service, my firewall is off.
but they said that it will not take effect until this services will b restarted.
so i stop every service and now i m not able to start them againg.
i have restarted my computer. but they r not starting again.
what to do? pls help me....