I think you can just substract the week number u got, with the last month week number. This is a simple example (mm/dd/yy is the date format): select convert(numeric(3,0), datename(ww, '02/24/2004')) - convert(numeric(3,0), datename(ww, '01/31/2004')) The query will give u the week number relate to the month for 24th Feb 2004. Hope this can help u, :)

Because your problem is not very clear to me, I assume that your datagrid's data source is from a dataset. You can try set an event handler for one of these dataset events. 1. RowChanged 2. RowChanging 3. ColumnChanged 4. ColumnChanging For the changing event, it occurs when data is changing. You can cancel or accept the changes in this event. For the changed event, it occurs when data has been changed successfully.

Hi, :) Can C# export a report (created using Crystal Reports 9) to multiple excel files automatically (in background)? Because the report is to big for only one excel file, so i need to split it into more than 1 excel files. Thank you for the help.

Hi, :) I want to export a report created with Crystal Reports 9 to Excel format with this condition : I want to split the exported file into 5 files. First file for page 1 - 10, second for page 11 - 20, and so on. What i want to know is, how can i set the number of pages exported without user interaction (by clicking export button in crystalreportviewer)? Thanks for the help.

Thx for your reply. Sorry for the lack of information. I'm using C# to build windows application to execute a dts package and i set an event handler for the OnError Event. So, when the error occurs i want to take the value of source field that failed to be transformed.

Hi, :) Can i get the value of current source column that failed to transform to the destination column in an OnError Event of a DTS package? I want to insert this failed value to a table for data maintenance. Thanks for the help.

Hi, :) Can i use activexscript in transform data task to determine whether the transformation of current table field failed or succeed? This is because i need to insert the failed field to another table. I don't want to validate the dtssource to do this because the transformation still can be failed. This is the program logic : Function Main DTSDestination("Destination") = DTSSource("Source") Main = DTSTransformStat_OK (Validate current transformation here) IF (TRANSFORMATION FAILED) THEN (INSERT FAILED FIELD VALUE TO A TABLE) END IF END FUNCTION Can i do this in the script? Or i need to use other task like data driven task, activex task, etc. Thanks for the help.

Hi, :) I need to know how to insert all the records to a table which are fail to be inserted when executes a DTS package. The table is different with the destination or source table. I realize there are many scenarios. One of them is using the text file - as the source in DTS package - that is generated when exception occured in execution process. But i think that this is a complicated and not the best way. I also need to insert the current date to the table along with the failed records. So, please help to solve this problem :confused: Thanks.

Hi, Can anyone tell me how can i create database query for an excel workbook with c#? Thanks.

This is the example text of richtextbox that i want to save to a txt file : 1. xxx...(the new line) xxx...(the new line) 2. xxx... (the new line) xxx...(the new line) . . . (and so on) The text in the txt file: 1. xxx...xxx...2. xxx...xxx... So, this is the problem. Great thx for helping.:)

Hi, I have a problem with saving a long text with newline characters in richtextbox control to a txt file. I'm using streamwriter to save the text. But the text in the file don't recognize the new line character. Can anyone help solving this problem?

How do I bind two table columns in a combo box with a '-' character separate the column without using concatenation method in my select SQL statement.