I have Sql query consists of multiple tables in ms Access database(has Join Right/inner join) and I would like to insert and Update data on it using ADO.NET. I would be most grateful if someone could provide me with a clear example.
The SQL query is based on two tables (books and authors) that have one-to-many relationship:
SELECT books.title, books.publisher, books.year, book.ISBN FROM authors RIGHT JOIN books ON authors.author_id = books.author_id where authors.name='John'"
As it can be seen from the SQL statement above, I need to insert data only to the books table with the fields: title, publisher, year and ISBN. The authors table has already data.
I am familiar with the old version of ADO and it was easy to run such this sql statament using ADODB Recordset which can be done in one go. But as a vb.net immigrant, I found difficulty to use DataAdobtar, Dataset and DataRow in Ado.Net, because they need the name of table while I have more than one tables and sometimes I need to insert data to particular tables.
Would really appreciate if you could give me a clear answer.
'Fraid I can't help you with data adaptors and such. I'm strictly a hardcore ADO person. I developed all of my software using vbScript (mostly background data mining/massaging) so all my stuff used bare bones ADO, bulk loads and recordsets. I saw your thread title and did a silent "whee" figuring that I could help out. Bummer.
OK, so HostGator for some reason no longer allows gcc/g++ access unless you have a Designated Server account, which is a lot of money to spend just to compile my "Hello World" program. Thus I figured I'd compile at home, then upload. Program is your regular old bare-bones Hello World ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...