is it possible....
-
Hi guys.. ok, here is my situation. I am doing SQL database programming ith VS 2003. I did a sql database called 'test.adp'. In this DB there is two tables.. ONe is 'Customer', the other is 'Temp'. In both this tables is the field 'Name'. Okay, let's say the field 'Name' under the table 'Customer' have only one data in text form called 'David' . In the 'Temp' table, there is no data in it. Is it possible for me to create a button and put a command in it where it will open up the 'customer' table, extract that 'David' data and insert it into the 'Temp' table under the 'Name' Field? Can anyone give me a brief command example that can accomplish this? Thanz for your time..
-
Hi guys.. ok, here is my situation. I am doing SQL database programming ith VS 2003. I did a sql database called 'test.adp'. In this DB there is two tables.. ONe is 'Customer', the other is 'Temp'. In both this tables is the field 'Name'. Okay, let's say the field 'Name' under the table 'Customer' have only one data in text form called 'David' . In the 'Temp' table, there is no data in it. Is it possible for me to create a button and put a command in it where it will open up the 'customer' table, extract that 'David' data and insert it into the 'Temp' table under the 'Name' Field? Can anyone give me a brief command example that can accomplish this? Thanz for your time..
OK I'm not trying to be a jerk, just being honest. No one is going to answer this question because probably no one on this forum has the time or interest in teaching basic SQL and data access in VB.NET. If we did have the inclination, we would not have the time because we'd be busy with either teaching or writing a book. That's just the basic truth. Yes this is possible - you can use a SELECT query to get data from one table and an INSERT query to put it in the other. Or use about half a dozen other ways. All of which require some basic understanding of SQL and data access. You have to learn that on your own. Again I don't want to seem like a jerk, it's just reality. You can do it - nobody here will do it for you. We all have to start somewhere, and I understand that the MSDN is not the place - it's just not useful until you reach a certain level. But the same is true of this forum. What you need at this point is a good reference book. A beginning book of any kind. If you feel like you are good with picking things up quickly, a beginner book may seem overly simple - in which case certification books often give more technical but useful overviews. To learn NET initially I used the MCSD 70-360 Exam book published by Que, authored by Mike Gunderloy. It is a great quick start. Costs you $50 new, but how much is your time worth? If you don't have the money, or just want to look at something right now, here is freebie on the web - I don't think it is that great, but it is better than nothing: http://www.interplat.com/VBNet.pdf[^] Godd Luck .... seriously
-
OK I'm not trying to be a jerk, just being honest. No one is going to answer this question because probably no one on this forum has the time or interest in teaching basic SQL and data access in VB.NET. If we did have the inclination, we would not have the time because we'd be busy with either teaching or writing a book. That's just the basic truth. Yes this is possible - you can use a SELECT query to get data from one table and an INSERT query to put it in the other. Or use about half a dozen other ways. All of which require some basic understanding of SQL and data access. You have to learn that on your own. Again I don't want to seem like a jerk, it's just reality. You can do it - nobody here will do it for you. We all have to start somewhere, and I understand that the MSDN is not the place - it's just not useful until you reach a certain level. But the same is true of this forum. What you need at this point is a good reference book. A beginning book of any kind. If you feel like you are good with picking things up quickly, a beginner book may seem overly simple - in which case certification books often give more technical but useful overviews. To learn NET initially I used the MCSD 70-360 Exam book published by Que, authored by Mike Gunderloy. It is a great quick start. Costs you $50 new, but how much is your time worth? If you don't have the money, or just want to look at something right now, here is freebie on the web - I don't think it is that great, but it is better than nothing: http://www.interplat.com/VBNet.pdf[^] Godd Luck .... seriously
Been through that book, it doesn't go through SQL database programming. Select and Insert Command.. We are getting somewhere eventually.. Beasically, I am not asking anyone to write the whole code down for me. as Mentioned on the starting thread, I gave a small example of what I am trying to do and hopefully, someone out there who is helpful enough and have some spare time in his hands can help out.. This is what this thread is for, after all.. So anyone else with some knowledge on this and is willing to help... Will appreciate your time...