Well, first you have to decide what you want to search. Searching a database is different from searching a dataset which is different from searching a data row. What do you want to do?

What are you trying to accomplish and what language do you want to use?

In what way doesn't it work? Do you also have a button or someother way to invoke Me.BindingContext(DsCourse1, "Course").EndCurrentEdit() after you have entered all your information to save the changes and end the edit?

You need to bind the SelectedValue property to the id field also. Then you get the value by: memId = ComboBox1.SelectedValue

what programming language are you using?

Here's instruction for including the control in your project: [^] Are you familiar with the MaskedEdit control in VB6? It's just about the same. If you aren't familiar, then you can Google it or look further on vbcity.com, just remember you are looking for VB6 instructions, not VB.NET.

Can you read the whole text file into a string and then write the string to the database?

I will assume that you do not have Access and/or can not use it. When you use the Data Adapter Configuration Wizard, it will show the tables available and after you have choosen the one(s) you want, it will show you the fields in the table.

http://www.support.microsoft.com/ph/6349

Can you open VB.NET IDE first and open the file from there? If so, then look under "file association" in XP Help and it will tell you how to associate the file with the IDE.

I am new to writing programs that access database files myself. I have found the books from Murach publishing to be very useful, although I am learning VB.NET. They do have a C# book that covers databases ADO.NET. Their examples usually use SQL, just replace sql with oledb and it should work. I have also just begun to learn how to deploy an applications, so I don't know all the ins and outs, but I have my database in its own folder on the C drive and I install this folder on the C drive on the computers I want to run the program, so the reference in the connection remains the same. There is probably a way of doing this automatically through the setup program, but I haven't learned that yet.

The first thing that comes to mind is to ask if they still exist. Are you able to run the program in the debugger? or do the dataAdaptor and dataSet names in your code have squiggles under them? Either of those two things would show that they don't exist anymore and somehow were deleted. If the program runs and/or the names don't have squiggles, then did the little window the icons appear in get shrunk? Look at the bottom of the design view window. Is there little shadded area with scroll arrows on the right right side? If so, place the cursor on the edge and drag it up till you see the icons.

So you will be keeping the trees in the database and based on which characteristics are checked, the matching tree will show in the listbox? And you are using a listbox for the trees because you also want the user to be able to choose a tree and see the characteristics in the checkboxes? You will need to establish the database first. You can use Access to set up your database. Once it's setup you just need to copy the database file to wherever you want it to go, you won't need Access after it's setup, except to make changes to the database. Your program will be able to run on computers without Access. If you can't use Access, you can try to set it up using another database program and copy the database file to where you want to work with it. I don't see why that wouldn't work.

Have you tried using the SQLDataAdapter and just substitute "SQL" for everywhere you have "OleDb"?

What information are you trying to store/retrieve? From your description, it sounds like you may be able to handle what you want in code.

Could you explain your questions in a different way? Do you want to transfer data between an SQL database(SQL Server or MySQL) and an Access database?

Sorry, I don't know that much about datagrids but I assume that when the datagrid first appears it is populated with the info from database as it is at that moment. You didn't say whether you are using VB or VB.NET. For VB.NET if you want the updated information, you have to clear and fill the dataSet again in order for the new information to show up in the datagrid. Whether it would work from another form, you'll have to try it and see. For VB I assume you would do whatever you did to populate the datagrid originally.

I don't think your problem is SQL, I think it is with how .NET handles DateTime. You might try reading up on DataTime and see how it handles milliseconds. I did a quick search on www.support.microsoft.com and there seem to be a problem with what you want to do.

You can add a "Reload" button or menu option and then write the code to query the database and reload your datagrid.

Can you add a table to your database with the values you want and then join it to your current table(s)in the dataAdapter? If you can't add the table to the current database, you make a separate database with the new table. I have seen instructions on joining tables from different databases