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

Gustavo

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;

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

theLizard16y ago
Accepted 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.
Gustavo16y ago
Lizard:

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

No problem. I just finished testing it and it works now. I will study the code.
theLizard16y ago
Ok, I will be gone for about 15 minutes, will be back.
Gustavo16y ago
Lizard:

OK, I will intergrate the changes manually. Give me a few minutes.
theLizard16y ago
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
Gustavo16y ago
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; }
}
theLizard16y ago
Good, now lets take the next step, what do you want to do next?
Gustavo16y ago
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.
theLizard16y ago
Ok, have you looked at the other things i have done?
Gustavo16y ago
Lizard:

Ok, I put that: public SqlDataAdapter SqlAdapter
And took out the Close().
theLizard16y ago
No you don't need to put them back, look at the changes in the code I made...
Gustavo16y ago
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.