Click here to Skip to main content
15,922,015 members
Home / Discussions / C#
   

C#

 
AnswerRe: Reflection, Invoking Methods Pin
J4amieC8-Aug-07 3:32
J4amieC8-Aug-07 3:32 
GeneralRe: Reflection, Invoking Methods Pin
glFrustum8-Aug-07 4:00
glFrustum8-Aug-07 4:00 
GeneralRe: Reflection, Invoking Methods Pin
J4amieC8-Aug-07 4:43
J4amieC8-Aug-07 4:43 
GeneralRe: Reflection, Invoking Methods [modified] Pin
glFrustum8-Aug-07 4:47
glFrustum8-Aug-07 4:47 
QuestionHow to Split one big excel file in to smaller files? Pin
Guru_yogi8-Aug-07 1:37
Guru_yogi8-Aug-07 1:37 
AnswerRe: How to Split one big excel file in to smaller files? Pin
Justin Perez8-Aug-07 2:32
Justin Perez8-Aug-07 2:32 
GeneralRe: How to Split one big excel file in to smaller files? Pin
Guru_yogi8-Aug-07 2:59
Guru_yogi8-Aug-07 2:59 
GeneralRe: How to Split one big excel file in to smaller files? Pin
Justin Perez8-Aug-07 4:04
Justin Perez8-Aug-07 4:04 
I don't have any code to give you, as I have never done that.
What I would do is:

1)get the total number of rows from your main table(the table you load all of your data into)

2)then create a worktable for storing rows to be written to a file.

3)create an integer(lets call this IHAVETOPEE), and divide the number of total rows by 10, and drop the remainder.

4)do a for loop to the number of total rows.

5)create a counter(iCounter) to record how many rows have been copied to the worktable, and written to file.

6)loop through, adding the current row to the worktable, and when the loop becomes == to IHAVETOPEE, write the worktable to file, and clear the worktable.

7)create an if statement for when the for loop is on it's last round

8)subtract the counter from totalRows

9) Inside the if statement, have another for loop, that will loop from the current row, to the total rows, and when the loop reaches the # from step 8, write to file

All of that will write to 10 files, evenly over all, plus a couple on the last file, because surely you will end up with a number of rows like 1983 some time Smile | :)

Hope that was clear Smile | :)



I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

QuestionDatagridview Pin
lesoftrons8-Aug-07 1:25
lesoftrons8-Aug-07 1:25 
AnswerRe: Datagridview [modified] Pin
Blue_Boy8-Aug-07 1:48
Blue_Boy8-Aug-07 1:48 
QuestionMessage Queue Error Pin
M. J. Jaya Chitra8-Aug-07 1:24
M. J. Jaya Chitra8-Aug-07 1:24 
AnswerRe: Message Queue Error Pin
Pete O'Hanlon8-Aug-07 1:35
mvePete O'Hanlon8-Aug-07 1:35 
GeneralRe: Message Queue Error Pin
M. J. Jaya Chitra8-Aug-07 1:50
M. J. Jaya Chitra8-Aug-07 1:50 
AnswerRe: Message Queue Error Pin
kubben8-Aug-07 2:32
kubben8-Aug-07 2:32 
GeneralRe: Message Queue Error Pin
M. J. Jaya Chitra8-Aug-07 2:51
M. J. Jaya Chitra8-Aug-07 2:51 
GeneralRe: Message Queue Error Pin
kubben8-Aug-07 2:59
kubben8-Aug-07 2:59 
GeneralRe: Message Queue Error Pin
M. J. Jaya Chitra8-Aug-07 3:13
M. J. Jaya Chitra8-Aug-07 3:13 
GeneralRe: Message Queue Error Pin
kubben8-Aug-07 3:21
kubben8-Aug-07 3:21 
GeneralRe: Message Queue Error Pin
M. J. Jaya Chitra8-Aug-07 18:11
M. J. Jaya Chitra8-Aug-07 18:11 
GeneralRe: Message Queue Error Pin
kubben9-Aug-07 1:40
kubben9-Aug-07 1:40 
GeneralRe: Message Queue Error Pin
kubben9-Aug-07 1:59
kubben9-Aug-07 1:59 
GeneralThank you Pin
M. J. Jaya Chitra12-Aug-07 20:22
M. J. Jaya Chitra12-Aug-07 20:22 
GeneralRe: Thank you Pin
kubben13-Aug-07 1:35
kubben13-Aug-07 1:35 
Questionserial port in c# Pin
suprapto8-Aug-07 1:04
suprapto8-Aug-07 1:04 
AnswerRe: serial port in c# Pin
Blue_Boy8-Aug-07 1:11
Blue_Boy8-Aug-07 1:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.