If you are using SQL Server you can write a FOR DELETE trigger on the table 'contact'. Try this: - -------------------------------------------------------------------------------------------------- CREATE PROCEDURE DeleteContact @consultantid int AS DELETE FROM contact WHERE consultantid=@consultantid -------------------------------------------------------------------------------------------------- Now create a trigger on the table 'contact': - -------------------------------------------------------------------------------------------------- CREATE TRIGGER DeleteAddress ON contact FOR DELETE AS CREATE TABLE #DeletedContacts ( consultantid int ) INSERT INTO #DeletedContacts SELECT consultantid FROM deleted DELETE FROM address WHERE consultantid IN (SELECT consultantid FROM deleted) -------------------------------------------------------------------------------------------------- Now, you execute the stored procedure: EXEC DeleteContact After it deletes from the table 'contact' the trigger will be excuted and it will delete corresponsing rows from the table 'address'.

I am a Software Developer using C# on ASP.NET.

Can you please clarify what is your criteria of retriving the TOP 30 records? Is it that, you want top 30 records as they appear in the table in the order of you primary key column? Is A>ID_no your primary key column? Can you please try the following and let me know: - SELECT A.ID_no , .......etc From A , ......etc Where 30>=(SELECT COUNT(*) FROM A a WHERE A.ID_no>=a.ID_no) Order by ID_no,........etc

Just collect the columns being included in the select list in come variables. See below: - DECLARE @v1 int,@v2 int SELECT @v1=number1,@v2=number2 FROM tblA

It seems that columns having NULL values in B.aktiv is getting eliminated. You can try the following: - WHERE ISNULL(B.aktiv,1)!='-1' Let me know if its working for you.

Can you kindly examplify your input and output?

The situation/requirement is something like this... There will be a print button on the page and whenever that button is pressed content of that page will be printed. After that a confirmation box will appear asking for confirmation whether the document has been sucessfully printed, if click "yes" then a row will be inserted in a table. Now the problem is... If I use the "onAfterPrint" javascript event procedure and put a confirmation box there then that confirmation box is appearing even before the "WINDOWS PRINT DIALOG BOX" is appearing and this doesn't solve the purpose. The requirement is...that confirmation box will appear after the print command is issued from the "WINDOWS PRINT DIALOG BOX". Is there any way out? Any help will be appreciated. Thanks in advance... -- modified at 6:59 Monday 28th November, 2005

Hi, <%# DataBinder.Eval(Container.DataItem, "Name") %> I want to know what is the use of # inside this server side script tag. I am sorry if I am sounding silly. Thanks in advance.

Hi, I have a datagrid where I have added a client side mouseover attribute to each items in the Item Created Event so that when ever mouse hovers on the rows of the datagrid the respected rows get selected. Its working fine, but if I want to access the index of the row which gets selected on the click of the mouse I am fighting. I am not using Select Button column of the datagrid. Please help. Thanks in advance

Hi all, I have a button called download which will open the file download dialog box and save the content of a datagrid in a file. I can do it with server side scripting, but is there any way to do it in the client side with javascript or vbscript? Please help. Thanks in advance.

hi all, I am inserting some records from my sql server database to an existing previously designed excel file. Now the problem is I want to insert a new row between to existing rows from my code behind file. Can any body help me on this? Thanks in advance. I am a Software Developer using C# on ASP.NET.

Hi Marcie Your reply helps. Thanks for the reply. But can you help me on some thing!! The code which is there is working fine with c sharp, but when using vb.net I am not finding the proper way of writing the the following c sharp code in vb.net format. The code is for assigning event handler to the databind event of the literal control. In C sharp it is as following:- literal1.databinding+=new eventhandler(). But how can I write the same line in vb.net. Please help.

Hi I am opening an aspx page in a modal window using vbscript command window.showmodaldialog(). It is working fine but when ever I am clicking on any button on the modal window to perform any action a new window is being opened which is having the same .aspx file. eg: I am opening b.aspx from a.aspx on button click of a button on a.aspx in a modal window using the vbscript command. So, b.aspx is being opened in a new modal window. Now this b.aspx has a button which will say populate a datagrid on b.aspx itself. But whenever I am clicking on the button a new window is being opened containing b.aspx and having the datagrid being populated in the new window, the modal window is remained open as well. Can any body please help me on this? Thanks in advance

Please be a little more ellaborate with the problem. I am a Software Developer using C# on ASP.NET.

Hi all! Is it possible to generate different types of columns in datagrid in runtime? I mean to say , I have a datagrid on my page and if I want to add a asp:templatecolumn on a fly is it possible? If so then how? Please help. Thanks in advance.

I am creating report using datagrid. There is a button for download outside the grid. Now when ever this download button will be clicked all the records in the datagrid will be saved in an excel file. How can I do that? Please help. Thanks in advance

Hello All! In almost all the job sites we can see an intersting mechanism - when ever a suitable job for a candidate is found it is automatically emailed to the candidate, that is it automatically checks the jobs that have been arrived, match the profile of the job with the profile of the candidate and if the profile matches it is automatically emailed to the candidate. How is it possible to execute a particular code automatically at a certain interval of time in ASP.NET? Please help. Thanks in advance.

Actually I want to write an Auto Responder. I have searched the net and every where I have found that it requires an mailbox first. Please help me.

How can I create a mailbox using ASP.NET. Thanks in advance.

Hi all, How to process credit card transactions using PaymentExpress? I mean to say , I am sending the values to their site, but how can I process the response from there. For example when we use paypal we trap the value of responseText property of the Microsoft.XMLHTTP object. And if the value is "VERIFIED" then furthur processings are done. But with payment express I cannot find a suitable way to trap the response after the transaction has been processed. I have visited their site but I could not find the solution. Any suggestion/hint to this will be of great help and highly appreciable. Please Help. Thanks in advance.

How can I draw shapes like line, rectangle, circle in ASP.NET. Please Help. Thanks in advance.