You're welcome. Luc Pattyn try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] } catch { [Google] }

Ok thanks but I even just tried compiling this in a new solution and it didn't work: #include using namespace std; int main() { cout<<"This should work..."; return 0; } Any ideas?

Can you please say what the errors are?

Thankyou for your help, it works now :)

**string strConnect = @"server = (local)\SQLEXPRESS; integrated security = sspi; database = C:\SQL\NORTHWND.MDF"; string strQuery1 = @"SELECT * FROM employees"; string strQuery2 = @"SELECT * FROM orders"; string strQuery = strQuery1 + strQuery2; SqlConnection conn = new SqlConnection(strConnect); SqlDataAdapter da = new SqlDataAdapter(strQuery, conn); **When you add the strings : strQuery = strQuery1 + strQuery2; here the strQuery becomes: "SELECT * FROM employeesSELECT * FROM orders" and you can see this is an invalid query , so it results in error. Regards, Sushant Duggal.****

thanks for the help, But I found out how to do it another way before your post: dataGridView.DataBindings.Add("datasource",dataSet1,"customers");

Blekk wrote: What am I doing wrong? It would appear you did not look at the MANY database articles here on CodeProject. Give it a shot, I imagine it will help. led mike

Well, it would help if you mentioned which database you are working with. I can help you with oracle: for all tables: 'select table_name from dba_tables;' for tables for a specific owner: 'select table_name from dba_tables where owner = 'XYZ';' for all the tables you have access to: 'select table_name from all_tables'; based on the result you may fill the listbox ! hope this helps regards, Noman Nadeem :zzz:

Just FYI, there is also a method called Convert.ToInt32(). Either method will work fine. Jon Sagara When I grow up, I'm changing my name to Joe Kickass! My Site | My Blog | My Articles

Yes, I could be interested, but obviously it depends on price ;P What country are you from? P.S. Feel free to email me: gingermigit@hotmail.com, if you would rather not give details in public. Thanks tgrt.

I know there are products which allow you to create a free standing exe, but pointing that out just muddies the waters.  None of the solutions I know of are cheap, and really, I think they are a bad idea in any case.

Thanks Pradeep C and Greeeg, I now understand why you don't have to create an instance and you have both also made the whole concept of the C# language a little more clear. There are still many things I don't really know at this stage, but probably should know, meh, I would rather find it out this way than reading through endless chapters of a book and then forgetting what it was at the end of the book. :laugh: Thanks.

Not atall, Form1 just contains a textbox and a menustrip so far with a File>New that creates a new instance of a class called File in Text.cs

Ok, I don't know what to do now. I am creating a TextEditor (because I saw it in another post ;P). Anyway, I have created the main form, but when the program starts it displays another form called newDlg.cs It has buttons on, with labels saying "Create a Text File:" or "Create a CSV File:" etc. When the button is clicked, it opens the main form and assigns a variable called fileFormat to 1 or 2 (for Text File and CSV respectively). The fileFormat variable is then used to determine whether the file can be saved as a .txt or a .csv when the user clicks Save. I need to somehow make fileFormat global because it is used in newDlg.cs and Main.cs I tried the method of creating a globalVars.cs class but that didn't work. Anyone got any idea? Thanks.