[lieweffect]

it say the dbcom is undefined value.

[shabbir]

Sqlstring is passed as variable to FillListBox function and so the value of Sqlstring can be determined before hand only and you dont need to be going through the OleDb code.

[lieweffect]

If I don't going through the OleDb code. The data will not list at the list box there.

[shabbir]

But to get that all you need is call that function with a string and the error is in the string.

[coderzone]

lieweffect probably you need to concentrate on basics first and get the grasp and then go for database programming in C#.

[lieweffect]

Thank Q for your advise coderzone
Actually the original program is in vb code.
It can run properly.
After I convert it into c# follow the c# syntax it cannot run.
So,may I know which is the mistake from the code
Thank Q

[shabbir]

Quote:

Originally Posted by lieweffect

So,may I know which is the mistake from the code

The error is in creation of the sql string.

[lieweffect]

Thank Q
I try to create again