How do I: Part 2: Pass a DataTable from a Class to the Main.

Question

Hello:

This question is specific to theLizard:

Here is my ClassDB. In the LoadListBox routine, I had to leave a few lines in. If I took them out, it stopped working. It took me a long time to get it to work because of a bug I created.

The lines that you wanted me to take out. I moved them into the Connection() and now I can remove them. Its cool, I am learning slowly but surely.

//DBDataAdapter = SetupDataAdapter();
//DBDataAdapter.SelectCommand = DBCommand;
//DBDataAdapter.SelectCommand.Connection = DBConnection;

Attachment: ClassDB.zip

theLizard · Answer

Some times taking it slowly gets you there much faster than you think I can see that you are now formulating ideas to solve your needs. //DBDataAdapter = SetupDataAdapter(); this is ok in Connection(); these should be a do as needed only what I mean by this is that you should only use these in functions if you need to otherwise ignore them. //DBDataAdapter.SelectCommand = DBCommand; //DBDataAdapter.SelectCommand.Connection = DBConnection; see attached zip.

Gustavo · Answer

Lizard: In case you need a new copy of ClassDB here it is.

Gustavo · Answer

Lizard: No problem. I just finished testing it and it works now. I will study the code.

theLizard · Answer

Ok I will be gone for about 15 minutes will be back.

Gustavo · Answer

Lizard: OK I will intergrate the changes manually. Give me a few minutes.

theLizard · Answer

Whoops that should not have been done my fault I used the replace command. You can put that back to DBCommand Also this MUST be public. there are things in the class that need to be public. prib=vate string sql --> private string dBConnect public string sql --> public string DBConnect

Gustavo · Answer

Lizard: It does not like the 2 definitions of 'sql' //public string sql; private string sql; public string sql { get { return (dBConnect); } set { dBConnect = value ; } }

theLizard · Answer

Good now lets take the next step what do you want to do next?

Gustavo · Answer

Lizard: Yes... I thought it was those only 2 but that I expanded it and saw the other stuff. I implemented it and tested it and it still works.

theLizard · Answer

Ok have you looked at the other things i have done?

Gustavo · Answer

Lizard: Ok I put that: public SqlDataAdapter SqlAdapter And took out the Close().

theLizard · Answer

No you don't need to put them back look at the changes in the code I made...

Gustavo · Answer

Lizard: OK I see now about the other 2 lines. I should of not put them there becasue they will be execute every time when I do the Connect();. I will put them back where they where.