Hi, Thanks for your reply. I have used the debug mode to check the controls in table cell and using the while loop to get the controls one by one. But I still cannot find the check box in the table cell. Please kindly help. Thanks again

Thanks for your reply. But if I need to add controls after each post back, then I don't know which check boxes have been clicked by the user.

I get a problem on writing a web page using C#.net 2.0. I have added some check boxes to a table cell and a button. When I check on some of the check boxes and the click the button, the table cell's find controls cannot find out the control.... And the web page doesn't know which check boxes have been checked Many Many Thanks for helping~~

Many Many Thanks. You give me a great great hand.

Oh no.....I am SQL Server 2000....But anyway, thank for helping.

I have a table which has Class Name 1A Albert 1A Bill 1A Paul 1B Ricky 1B Kelvin 1B Walala I want to convert it to a table which is Class FULL LIST 1A Albert/Bill/Paul 1B Ricky/Kelvin/Walala I dont know how to write the query. Pls kindly help

Thanks you. It helps.

Hi all, I have a sql statement that occur error when I run in sql server 2005.... "The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes." update TMP_TABLE_1 set CLASS_NO = coalesce(B.CLASS_NO , B.STUDENT_NO) from TMP_TABLE_1 A, TMP_TABLE_2 B where A.CLASS_NO *= B.STUDENT_NO and A.REQUEST_ID = @requestID But How can I change the sql to Right outer join or left outer join. Please kindly help. Thanks

So many thanks for tarunbounthiyal and Apurva Kaushal's kindly help. I successfully create the pop up window la.

I am using visual studio 2005. I have created a web sites. I need to pop up a window with some gridview and text box when a user press a button. But the window only need to pop up when there is another user changing the information in the database. Thus, I need to check the database first, then to pop up if it is needed. However, I dont know how to write the script to pop up a window. I am a javascript idiot.... Many Many thanks for helping

Many Many Thanks

I don't have a method of objpopUp.show. May be it is due to I am creating a web form. I still cannot pop up a new window.... But anyway, thanks for 3ala2. Pls kindly help. Many Many Thanks

I am doing a page for user to editing the information. Before the user click a "SAVE" button, I need to check the time stamp from the database to check whether there is person editing the information before the user. If yes, then I need to pop up a window to show the difference the information. Please kindly assist. Thanks

Oh. I get the answer la. It should be select * from TABLE1 A INNER JOIN TABLE2 B ON A.STUDENT_ID = B.STUDENT_ID INNER JOIN TABLE3 C ON A.CLASS_ID = C.CLASS_ID INNER JOIN TABLE4 E ON A.FORM_ID = E.FORM_ID INNER JOIN TABLE5 D On D.SCHOOL_ID = E.SCHOOL Thanks

select * from TABLE1 A INNER JOIN TABLE2 B ON A.STUDENT_ID = B.STUDENT_ID INNER JOIN TABLE3 C ON A.CLASS_ID = C.CLASS_ID INNER JOIN TABLE4 E ON A.FORM_ID = E.FORM_ID, TABLE5 D INNER JOIN E On D.SCHOOL_ID = E.SCHOOL I want to use TABLE1 A to inner join on TABLE2 B, TABLE3 C, TABLE4 E and the TALBE4 E inner join on TABLE5 D. But I get an error "Invalid object name 'E'." Thanks for helping

It works!!! Thank you very much

I want to change following sql statement to using inner join but I dont know how to join on two column on the two table. Thanks for helping. select * from Persons A, Banks B where B.Student_ID = A.Student_ID AND B.class_NO = A.claa_NO when I change to the following statement, I get an error on the syntax. Incorrect syntax near the keyword 'ON'. select * from Persons A INNER JOIN B ON B.Student_ID = A.Student_ID ON B.class_NO = A.claa_NO Please kindly help. Thanks

I have used this property inside my web service which is build in .net 2.0. I used this by the following code Application.Add("wakaka", 07/28/1979 10:35:05 PM) to post the time inside the item "wakaka". But there is sometime that I cannot get the item "wakaka" and return nothing to me instead of returning the time "07/28/1979 10:35:05 PM". Pls help me...............................