I do not understand why the error ! :S - C# Discussion Boards

gavindon1-Jun-11 10:31

gavindon

1-Jun-11 10:31

CP ! ! ! ! gimme codez. urgentz and life or deathz

Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.

Re: Sharpening the Saw [modified]

SledgeHammer011-Jun-11 9:53

SledgeHammer01

1-Jun-11 9:53

Perhaps an example of what kind of "moderately tricky programming task" you would assign would be helpful? Smile | :)

AspDotNetDev1-Jun-11 10:37

AspDotNetDev

1-Jun-11 10:37

Towers of Hanoi... with only 2 towers.

EDIT: Whoops, changed from a rant icon to a joke icon.

[Managing Your JavaScript Library in ASP.NET]

modified on Wednesday, June 1, 2011 4:57 PM

SledgeHammer011-Jun-11 11:21

SledgeHammer01

1-Jun-11 11:21

Well, since you have your joke icon, I'll assume its a joke (especially with 2 towers)... but IMHO a "towers of hanoi" question sucks on an interview. The guy would waste too much time figuring out the "puzzle" aspect of it and not the programming aspect of it. Granted, you might like that the guy could solve puzzles, but...

I was once asked to write a shortest path algorithm during an interview... I knew that there was a well known & proven algorithm and I said to the interviewer "I would use the well known and proven one since not only is it mathematically proven to work, but its also the fastest" or something like that. He didn't like that I didn't have it memorized. You can't really memorize every common algorithm out there...

Re: Sharpening the Saw [modified]

Pete O'Hanlon1-Jun-11 21:47

Pete O'Hanlon

1-Jun-11 21:47

Sorry, tried to post last night but CP kept timing out on me. Anyway, I won't be posting my sample task otherwise I'd have to come up with a new one - there's no point giving potential candidates too much of a head start.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

RobCroll1-Jun-11 14:11

RobCroll

1-Jun-11 14:11

How old are you? I'm 50 and been contracting a bit lately. Never once got a job when interviewed by someone in there 30's. Never once Not got the job when interviewed by someone over 40.

Age is definitely an issue, you won’t get around that.

As far as the sharpening goes, just get up to speed with the new technologies. Working for in-house development teams can leave your skillset stale due to the fact they tend to be conservative places and not early adopters of technology.

At a .NET level I’d say focus on Xaml(WPF/Silverlight/WP7/MVVM) WCF, Entity Framework and Unit testing if you don’t already have these skills. If you are a web developer MVC is a no brainer.

"You get that on the big jobs."

modified on Wednesday, June 1, 2011 8:23 PM

I do not understand why the error ! :S

ismail201-Jun-11 2:31

1-Jun-11 2:31

private void Action(int ust_id) 
{ 
     MySqlCommand cmd = new MySqlCommand("Select * From kategoriler_tablo Where UstKategoriId=" + ust_id.ToString(), c); 
     c.Open(); 
     MySqlDataReader r = cmd.ExecuteReader(); 
     while (r.Read()) { 

          if (ust_id != 0) { 
               treeView1.Nodes.Find(ust_id.ToString(), true)(0).Nodes.Add(r("id").ToString(), r("KategoriAdi").ToString()); 

          } else { 
               treeView1.Nodes.Add(r("id").ToString(), r("KategoriAdi").ToString()); 
          } 
          Action(Convert.ToInt32(r("id"))); 
     } 
     r.Close(); 
     c.Close() 
} 

private void Button1_Click(System.Object sender, System.EventArgs e) 
{ 
    if (c.State != ConnectionState.Open) { 
     } 
     TreeView1.Nodes.Clear(); 
     TreeView1.Update(); 
     c.close(); 
     Action(0); 
}

This code does not work. I could not understand where the fault is
http://www.imageupload.org/?d=2E926FEF1[^]

PIEBALDconsult1-Jun-11 2:50

PIEBALDconsult

1-Jun-11 2:50

I guess an earlier operation didn't close the connection. Find out where, and also check the state before opening and closing.

You may want to put the close in a finally.

Eddy Vluggen1-Jun-11 2:59

Eddy Vluggen

1-Jun-11 2:59

It'd be easier to create a new connection in the Action method and wrapping it in a using directive; that way it'll always use it's own connection and it'll always close it when done.

Bastard Programmer from Hell Suspicious | :suss:

Not Active1-Jun-11 2:59

1-Jun-11 2:59

Well as the error indicates the connection is still opened from a previous attempt or some other method.

Since you are not using any try/catch blocks the code could have failed at any point between the Open and Close calls thus leaving the connection open.

Make use of the using statement

using(SqlConnection conn = new SqlConnection("..."))
{
  using(SqlCommand cmd = new SqlCommand("...", conn))
  {
    // Do actions here
  }
}

With this the connection and command will be disposed of regardless of whether a failure has occurred.

You should learn to program defensively also.

if(conn.State != ConnectionState.Open)
  conn.Open();

And lastly, use parameterized queries rather than concatenate a string for the command.

I know the language. I've read a book. - _Madmatt

modified on Wednesday, June 1, 2011 9:34 AM

ismail201-Jun-11 3:05

1-Jun-11 3:05

which should help me get the line?

Not Active1-Jun-11 3:21

1-Jun-11 3:21

What?????

I know the language. I've read a book. - _Madmatt

ismail201-Jun-11 3:29

1-Jun-11 3:29

which line is wrong in my code?

Not Active1-Jun-11 3:32

1-Jun-11 3:32

All of it. Please read the suggestions you have been given

I know the language. I've read a book. - _Madmatt

ismail201-Jun-11 3:34

1-Jun-11 3:34

I can not see the error.

Not Active1-Jun-11 3:38

1-Jun-11 3:38

Then we can't help you further

I know the language. I've read a book. - _Madmatt

BobJanova1-Jun-11 4:12

BobJanova

1-Jun-11 4:12

good one

Pete O'Hanlon1-Jun-11 3:25

Pete O'Hanlon

1-Jun-11 3:25

As others have said, your connection is open already. You could wrap the line c.Open() with

if (c.ConnectionState != ConnectionState.Open)
  c.Open();

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

ismail201-Jun-11 3:33

1-Jun-11 3:33

error http://www.imageupload.org/?d=FA9F79481[^]

Not Active1-Jun-11 3:37

1-Jun-11 3:37

We are here to help but you must also put forth some effort. Copy & Paste is not a valid coding technique. You need to understand the objects you are working with. This error is very easily corrected by simply using the Intellisence built in to Visual Studio.

I know the language. I've read a book. - _Madmatt

ismail201-Jun-11 3:44

1-Jun-11 3:44

if (c.State != ConnectionState.Open)
c.Open(); ---- accept that this code ***** but "c.ConnectionState" wrong