C# Discussion Boards - CodeProject

Russell Jones17-Apr-09 3:25

17-Apr-09 3:25

I spent a lot of time researching this when I was trying to build an application to plot juggling state graphs.

In the end I decided that laying out the nodes was one of those jobs that's almost trivial for a human but an absolute nightmare for a computer. There are some OK algorithms for laying out the graphs ( a lot come from electronic circuit board design) but they will never work 100% for the task you are trying to achieve. I made the Nodes draggable and then let the user arrange them where they were wanted, it was far less coding effort than trying to auto sort anything more than a trivial graph.

Russ

NUnit test

devvvy16-Apr-09 23:00

devvvy

16-Apr-09 23:00

here's what i do every now and then

<br />
STEP 1. switch.to.oracle.bat<br />
STEP 2. run unit test against Oracle db<br />
         [visual inspection on NUnit user interface after to make sure things are okay]<br />
STEP 3. switch.to.mysql.bat<br />
STEP 4. run unit test against MySQL<br />
         [visual inspection on NUnit user interface after to make sure things are okay]<br />
STEP 5. switch.to.mssql.bat<br />
STEP 6. run unit test against M$SQL<br />
         [visual inspection on NUnit user interface after to make sure things are okay]<br />

question is, how can i automate this?

dev

Re: NUnit test

SeMartens17-Apr-09 0:46

SeMartens

17-Apr-09 0:46

Well write a unit test for each database...

public void TestOracleDB() {
 ...
}

public void TestMySqlDB() {
 ...
}

public void TestMSSQLDB() {
 ...
}

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: NUnit test

Luc Pattyn17-Apr-09 1:27

Luc Pattyn

17-Apr-09 1:27

Hi again,

You could incorporate NUnit's logic in a test app and forgo the NUnit app itself.

I once did a small subset of NUnit; just supporting [TestFixture], [Test] and Assert.AreEqual takes some 100 lines of code, heavily using reflection.

BTW: You would still need a "using NUnit.Framework;" to reuse the types they have defined.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

ODBC Excel ConnectionString Problem - Urgent

mishigun16-Apr-09 22:52

mishigun

16-Apr-09 22:52

Hi to all ,
I am using ODBC connection to read from a excel sheet, but i am unable to read the first line of the excel sheet bcoz driver taking it as Header, i have some data in the first row how can i read it. And another problem is that i can not read the numbers from the excel sheet. These two problems i have solved with the OLEDB connection using HDR=No and IMEX=1 but how to solve this problem in ODBC... please Help me.

connectionString i am using :

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=E:\newFile.xls;

Thank You

How to change these codes to CHAR to String

john231316-Apr-09 22:36

john2313

16-Apr-09 22:36

Hi again..

Im not very familiar with C# but i am wondering if its possible to change these codes to CHAR or String or even Boolean.

while (true)
{
// Divide by 80, get remainder
Random xRandom = new Random((int)(Cosmos.Hardware.Global.TickCount
+ Cosmos.Hardware.RTC.GetSeconds()));
int xMagicNo = xRandom.Next() % 80;
Debugger.Send("Magic Number is " + xMagicNo);
Console.WriteLine("I am thinking of a number between 0 and 80. What is it?\n");
while (true)
{

thanks.

Re: How to change these codes to CHAR to String

OriginalGriff17-Apr-09 1:38

OriginalGriff

17-Apr-09 1:38

I do not understand the question!

Which codes are you trying to change?
Is there more to read?
Why comment the unnecessary bit? (use xRandom.Next(80) and it will return a number between 0 and 79, just like your modulus)
Why use "% 80" and then expect 80 as a possible result?

BTW: If you use the "code block" button below, it will preserve your formatting, and make fragments easier to read, thus:

while (true)
   {
   // Divide by 80, get remainder
   Random xRandom = new Random((int)(Cosmos.Hardware.Global.TickCount
                    + Cosmos.Hardware.RTC.GetSeconds()));
   int xMagicNo = xRandom.Next() % 80;
   Debugger.Send("Magic Number is " + xMagicNo);
   Console.WriteLine("I am thinking of a number between 0 and 80. What is it?\n");
   while (true)
      {

Convert

Agweet16-Apr-09 21:39

Agweet

16-Apr-09 21:39

Hi All,

i am busy trying to convert an int to a ReportWS.MonthlyDOWRecurrence, this is what i got

MonthlyDOWRecurrence pattern = new MonthlyDOWRecurrence();
pattern.WhichWeekSpecified = true;
pattern.WhichWeek = Convert.ToInt16(Combobox1.SelectedItem.Value);

but i always get the following error:

Cannot implicitly convert type 'int' to 'ReportWS.WeekNumberEnum'. An explicit conversion exists (are you missing a cast?)

In VB.Net it works if you say:

pattern.WhichWeek = CInt(Combobox1.SelectedItem.Value);

can someone please tell me how to correct this?

living life on the flip side

Re: Convert

musefan16-Apr-09 21:47

musefan

16-Apr-09 21:47

well i not familiar with the classes you are using but as the error is suggesting 'WhichWeek' is an enum value then you might want to try an enum parse. There should be an enum collection for the 'WhichWeek' type which will have a static Parse function.

Something like...

(WhichWeeks)WhichWeeks.Parse(typeof(WhichWeeks), Combobox1.SelectedItem.Value);

...I highly doubt that will work but hopefully you will get the idea of what you need to do

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

Re: Convert

OriginalGriff16-Apr-09 21:49

OriginalGriff

16-Apr-09 21:49

The answer is in the error message, just cast it:

pattern.WhichWeek = (ReportWS.WeekNumberEnum) ...

I assume this is C# (correctly) trying to ensure you are setting the enum to valid values only. (Your combo box can only return valid enum members, right?)

Re: Convert

PauloCastilho17-Apr-09 12:43

PauloCastilho

17-Apr-09 12:43

Try this:

pattern.WhichWeek = (ReportWS.WeekNumberEnum)System.Enum.Parse(typeof(ReportWS.WeekNumberEnum), Combobox1.SelectedItem.Value);

How to Insert textfile to be table in sql by c# [modified]

Rakurai16-Apr-09 21:08

Rakurai

16-Apr-09 21:08

I don't know how to insert textfile to be table in database sql .
Right now,I can do only open and load here is my code

http://upic.me/i/3w/zcode.jpg[^]

http://upic.me/i/fn/design.jpg[^]

modified on Friday, April 17, 2009 3:15 AM

Re: How to Insert textfile to be table in sql by c#

SeMartens16-Apr-09 21:16

SeMartens

16-Apr-09 21:16

Do you want to insert the whole file into a field in the table? Or is your file a table (like a csv-file)?

First you have to write database access code to get a connection to the db...

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: How to Insert textfile to be table in sql by c#

Rakurai17-Apr-09 22:41

Rakurai

17-Apr-09 22:41

Yep Right now I can create database
Then I dont' know how to import or insert this(textfile) to my database
http://upic.me/i/98/textfile.jpg[^]

Re: How to Insert textfile to be table in sql by c#

Rajesh Anuhya16-Apr-09 21:40

Rajesh Anuhya

16-Apr-09 21:40

For sql server
BLUK INSERT
For Oracle
SQLLDR
For MYSQL
INFILE

Use This Keywords to Search in Google.

Thanks

Rajesh B --> A Poor Workman Blames His Tools <--

Do you compile the C# project using VS.net IDE

Fired.Fish.Gmail16-Apr-09 20:15

Fired.Fish.Gmail

16-Apr-09 20:15

I find that some C# project is compiled with the makefile, so i want to know why use the makefile to compile it. Is it a best way to improve the programming skills?

What compiler do you use?

Re: Do you compile the C# project using VS.net IDE

Ashfield16-Apr-09 20:53

Ashfield

16-Apr-09 20:53

It makes no difference as far as I know, its generally down to the site standards and source control methods.

Fired.Fish.Gmail wrote:
Is it a best way to improve the programming skills?

No, its not really that relevant any more than say using IE or FF for a browser.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: Do you compile the C# project using VS.net IDE

Pete O'Hanlon16-Apr-09 22:42

Pete O'Hanlon

16-Apr-09 22:42

Fired.Fish.Gmail wrote:
What compiler do you use?

The compiler doesn't change whether you use a MakeFile, the IDE or an MSBuild project. It's always going to be csc.exe (for C#).

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Do you compile the C# project using VS.net IDE

Fired.Fish.Gmail20-Apr-09 20:54

Fired.Fish.Gmail

20-Apr-09 20:54

I Have seen the csc.exe file.

Thanks.

Open form from another form

piticcotoc16-Apr-09 20:10

piticcotoc

16-Apr-09 20:10

Hy,
I'm designing an application that accesses SQL Server from C#. I have a form that runs first where i select the sql server and database. When i click a button it's should assign the hostname and database for the connection string, close and open another form (the main application). The problem is when the select form closes, the main form appears for 1 sec and then the whole application closes. I've ran the app step by step, everything is ok, the variables are assigned but it automaticly calls the dispose method for the second form.

This is the code from the first form that runs at app start (selectserver form)

private void btnSelectServer_Click(object sender, EventArgs e)
{
   <<assign values from control boxes>>
   frmMain main = new frmMain();
   main.Show();
   this.Close();
}

Re: Open form from another form

Mbah Dhaim16-Apr-09 21:00

Mbah Dhaim

16-Apr-09 21:00

1. In main entry point use your MainForm in Application.Run(new YourMainForm)
2. In your main form load event call your Sql Server Form Setting with showdialog and verify the settings
3. Close your Sql Server Form Setting.

hope it helps

dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support

Re: Open form from another form

piticcotoc16-Apr-09 22:21

piticcotoc

16-Apr-09 22:21

But this way the main form would be loaded first. And I want to load the server form only, and if selected the appropriate server+database, close it and open the main form.

Re: Open form from another form

Mbah Dhaim17-Apr-09 1:18

Mbah Dhaim

17-Apr-09 1:18

in main entry of your application use this

using (SqlServerForm sqlServerForm = new SqlServerForm())
{
  if (sqlServerForm.ShowDialog() == DialogResult.OK)
  {
    Application.Run(new frmMain());
  }
}

piticcotoc wrote:
and if selected the appropriate server+database

set the dialog result of sqlserverform to OK to close the form

hope it helps

Re: Open form from another form

daiduongbk17-Apr-09 2:34

daiduongbk

17-Apr-09 2:34

Change:

private void btnSelectServer_Click(object sender, EventArgs e)
{
<<assign values from control boxes>>
frmMain main = new frmMain();
main.Show();
this.Hide();
}

-------
Nguyen Dai Duong
Ha Noi University of Technology
daiduongbk@gmail.com

how to implement inventory control if using ORM?

calendarw16-Apr-09 19:39

calendarw

16-Apr-09 19:39

Hi,

I am needed to implement an inventory control module but should I apply ORM for it? For the case, if I create a change (e.g. transfer from one warehouse to another warehouse), then the loaded stock value may be change by other, so how to use ORM for this case? or should not use ORM for this case?

Thanks

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