C# Discussion Boards - CodeProject

28-Jul-09 7:26

You should start by searching this forum for similar requests, as the heading states.

This was asked last week:

http://www.codeproject.com/Messages/3126820/hard-disk-serail-number.aspx[^]

expor database

mht200828-Jul-09 5:51

mht2008

28-Jul-09 5:51

How i can export and import sql server 2005 database by c# code?

Re: expor database

MumbleB28-Jul-09 5:53

MumbleB

28-Jul-09 5:53

Not being funny but maybe buying a book would help?? Confused | :confused:

Excellence is doing ordinary things extraordinarily well.

Re: expor database

Vikram A Punathambekar28-Jul-09 6:34

Vikram A Punathambekar

28-Jul-09 6:34

Any reason you specifically want to do it in C#? SSIS is probably more suited for what you're looking to do.

Cheers,
Vikram. (Proud to have finally cracked a CCC!)

Recent activities:
TV series: Friends, season 10
Books: Fooled by Randomness, by Nassim Nicholas Taleb.

Carpe Diem.

Re: expor database

musefan28-Jul-09 7:56

musefan

28-Jul-09 7:56

How about looping all tables from the database. (export)

Saving them in an xml document. (export file)

And then saving them back to another database. (import)

Life goes very fast. Tomorrow, today is already yesterday.

dynami array

mht200828-Jul-09 5:49

mht2008

28-Jul-09 5:49

How i can define dyamic array in c#?

Nagy Vilmos28-Jul-09 6:00

Nagy Vilmos

28-Jul-09 6:00

Use a List?

Panic, Chaos, Destruction.
My work here is done.

mypicturefaded28-Jul-09 6:05

mypicturefaded

28-Jul-09 6:05

System.Collections.ArrayList al = new ArrayList();

Then for every element you want to add just use the a1.Add method.

harold aptroot28-Jul-09 6:08

harold aptroot

28-Jul-09 6:08

Only if you are forced to use .NET 1.1

DaveyM6928-Jul-09 6:15

DaveyM69

28-Jul-09 6:15

As HArold said, only if forced to use 1.1. The problem with an ArrayList is it requires every object to be converted to and from object (boxing/unboxing). A List<T> gives the same functionality, but without that overhead and inconvenience!

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Using a Custom ScrollBar Within a TreeView C#

mypicturefaded28-Jul-09 6:17

mypicturefaded

28-Jul-09 6:17

Ah, okay, gotcha! I was typing asking why it was bad!
Thanks for the tip!

Zap-Man28-Jul-09 5:42

Zap-Man

28-Jul-09 5:42

I have made a custom Scroll Bar somewhat like the one here How to skin scrollbars for Panels, in C#[^].

My Goal is to insert this control inside of a treeview and get rid of the standard scrollbar. I have been working and looking around for answers for two weeks. Could someone please help me out or at least point me in the correct direction

Mike

Calculate Accounting Period from Date

drodgers28-Jul-09 4:51

drodgers

28-Jul-09 4:51

Hi Guys,

Hope someone can help with this little problem I have because its driving me mad.

I need to calculate the period in which a date falls

so lets say a companies financial years starts on 1st Jan then
Jan = P1, Feb = P2 etc etc

That makes finding the period quite easy, i just take the month of the transaction.

The problem I'm having is when the FY starts on say 1st April 2009 then
Apr = P1, May = P2 etc etc

So .
15/06/2009 returns P3/2009
01/08/2009 returns P5/2009
but
15/01/2009 returns P10/2008

So far I'm using this

'Holds the date which financial year starts
Dim FYstart As Date = = CDate("01/04/2000")

'Move FYStart to current year
FYstart = DateValue(FYstart.Day & "/" & FYstart.Month & "/" & TranDate.Year)

'Months difference between transaction date and FYstart
Dim MonthDiff As Integer = -DateDiff(DateInterval.Month, TranDate, FYstart)
'Years different between the 2 dates
Dim YearDiff As Integer = Math.Truncate(MonthDiff / 12)

'Period number
Dim p As Integer

If MonthDiff <= 0 Then
    p = 12 + (MonthDiff)
Else
    p = MonthDiff

End If


Period = p
Year = TranDate.Year + YearAdj

Anyone have any pointers because everytime I think I've cracked it, I try a different FY Start / Tran Date combination and it gives me wrong answer Frown | :(

thanks in advance,
Daniel

Re: Calculate Accounting Period from Date

DaveyM6928-Jul-09 5:14

DaveyM69

28-Jul-09 5:14

Oops - you posted in the C# forum!

Re: Calculate Accounting Period from Date

Nagy Vilmos28-Jul-09 5:17

Nagy Vilmos

28-Jul-09 5:17

drodgers wrote:
but
15/01/2009 returns P10/2008

This is right. January is the tenth month of the 2008/09 tax year.

Panic, Chaos, Destruction.
My work here is done.

Re: Calculate Accounting Period from Date

DoctorMick28-Jul-09 5:19

DoctorMick

28-Jul-09 5:19

Would something this simple not work....

DateTime startDate = new DateTime(2009, 04, 01);
            DateTime transactionDate = new DateTime(2009, 4, 01);
            //DateTime thisFYStart = new DateTime(DateTime.Now.Year, startDate.Month, 1);
            int monthDiff = transactionDate.Month - startDate.Month + 1;
            if (monthDiff <= 0)
                monthDiff = 12 + monthDiff;

            MessageBox.Show(monthDiff.ToString());

For Loop Pattern to use in Parsing - C# code

gamer112728-Jul-09 4:18

gamer1127

28-Jul-09 4:18

Hello, I'm creating a program that will parse a for loop statement. I'm already done with some of the things that a parser does. Now my problem is about the pattern i created to check if the user's for loop syntax is correct.

First i ask the user to enter an example of a for loop statement syntax.

ex. for(int x=0; x<5; x++) Console.WriteLine("Hello World");

After that I'll just check if the example follows the syntax of a for loop statement.
To check if the syntax is correct i created a for loop statement pattern to compare it with the user's for loop statement.

Here is the pattern:

public static string forLoopPattern =
          @"([for])" +
          @"([(])" +
          @"([int]\ \\)" +
          @"([a-z])" +
          @"([=])" +
          @"([0-9])" +
          @"([;])" +
          @"([a-z])" +
          @"([>,<,=,<=,>=,=<,=>])" +
          @"([0-9])" +
          @"([;])" +
          @"([a-z])" +
          @"([++,--])" +
          @"([)])";

Is that pattern correct? If not what should i change or do to make it correct? Also, i don't know yet if that pattern really works or not. How will i be able to check if that pattern works?

Please Help..thanks..

musefan28-Jul-09 4:33

musefan

28-Jul-09 4:33

You really should test it yourself and see if it works.

Some points thou...

- for loops don't rely on using an int data type
- someone may want two spaces between type and instance name
- instance names can be alot more than just a-z
- instance name can be any number (within limits of data type) and potentially negative too
- you can also apply more than just increment and decrements to the instance
etc...

Life goes very fast. Tomorrow, today is already yesterday.

Chris Trelawny-Ross28-Jul-09 4:58

Chris Trelawny-Ross

28-Jul-09 4:58

Further to what musefan said, broadly speaking, each of the three parts of the for loop control can contain an expression, with the first also being allowed to contain a variable declaration and the second being required to result in a boolean value.

Thus it would be legal to have the following:

...
for (MyObj = new MyObj(); MyObj; MyObj.MoveNext())
    {
    ...
    }
...

provided that MyObj implements an implicit bool conversion operator.

You can check out the C# language specification for the exact rules for the formation of a for loop; see section 8.8.3 of the C# Language Specification 1.2.doc, which you can find in your VS folder, in VC#\Specifications\1033.

PIEBALDconsult28-Jul-09 5:41

28-Jul-09 5:41

And can also include the little-known , (COMMA) operator.

Vikram A Punathambekar28-Jul-09 6:35

Vikram A Punathambekar

28-Jul-09 6:35

I thought that was only in C++? I don't know for sure though... I am at home now.

Cheers,
Vikram. (Proud to have finally cracked a CCC!)

Recent activities:
TV series: Friends, season 10
Books: Fooled by Randomness, by Nassim Nicholas Taleb.

Carpe Diem.

PIEBALDconsult28-Jul-09 7:04

28-Jul-09 7:04

It seems C# limits it somehow, and I'm reading the spec now to see why.

"
8.8.3 The for statement
The for statement evaluates a sequence of initialization expressions and then, while a condition is true, repeatedly executes an embedded statement and evaluates a sequence of iteration expressions.
for-statement:
for ( for-initializer ; for-condition ; for-iterator ) embedded-statement
"

for ( int i = 0 ; i < 10 ; i++ , i++ )
{
    System.Console.WriteLine ( i ) ;
}
 
or
 
int i ;
for ( i = 0 , i++ ; i < 10 ; i++ , i++ )
{
    System.Console.WriteLine ( i ) ;
}

The comma operator is valid in the for-iterator, but not in the ~~for-initializer and~~ for-condition (they are allowed there in C), this may be an oversight.

I may ask on an MSDN forum later.

Vikram A Punathambekar28-Jul-09 7:19

Vikram A Punathambekar

28-Jul-09 7:19

Yeah, you're right. Turns out you can even do multiple declarations:

for ( int i = 0, j = 4 ; i < 10; i++ , i++, j++ )
{
	System.Console.WriteLine ( i + " " + j) ;
}

Another arcane fact about C# that I'll probably never use in my life Smile | :)

Cheers,
Vikram. (Proud to have finally cracked a CCC!)

Recent activities:
TV series: Friends, season 10
Books: Fooled by Randomness, by Nassim Nicholas Taleb.

Carpe Diem.

PIEBALDconsult28-Jul-09 7:31