Learn How To Work With Databases
Apr 1, 2011
I am wanting to learn more about databases and how to code them into my VB application. I've been searching the forums and I see a lot of examples of code with OleDB.OleDBConnection, OleDBCommand and same with SQL. How did you learn how to work with databases? What resources would you recommend? Any online tutorials that you found helpful?
One of the particular issues that I am having is that I've set up a table with approximately six columns. I have this shown on the main form as a datagridview with only two of the columns shown. To edit / add a new record, I have set up a button to load a new form with the details of the datagridview showing in textboxes (for all six columns). So, if the user were to select an entry on the main form page and then click on the edit/add button it would bring up the row's information in their respected textboxes. From there the user would be able to edit and then save the changes. I'm having difficulty bringing up the form with the selected row's information.
View 3 Replies
ADVERTISEMENT
Mar 14, 2010
I recently moved over to a Windows 7 computer and I can't get databases to work with VB.net.Before I moved I used to do an Access database and connect it to VB through the ODBC thing. However, I don't have Access on this computer (open office) so I'm not sure how to create a database and connect it.I have tried to use the SQL Compact Edition that comes with Visual Studio but I not sure how to get it to work. Also would something like mySQL work with VB? I have looked at the mySQL workbench and like it, what else would I need to download to be able to use the databases created with it in Visual Studio?
View 2 Replies
Apr 21, 2012
I am fairly new to programming, and even more new to using database objects. I am creating a program that will calculate a user's BMI, and that will let the user know how many calories are in a food that they choose. I found a database that has a bunch of foods, and each of their calories, so I am using that. I have the program set up so that the user selects each food from a drop down list. The user then adds each of the food to a list box after pressing a button. The program is then suppose to calculate all of the calories after the user presses another button to come up with the total calories. I got all the foods on the drop down list no problem, but now, I'm stuck on figuring out how to get the program to add all the calories for each cooresponding food. I have no idea where to start with it. I know that I'm going to have to create a variable to hold the total calories, but I just don't know how to get the calories from each food.
View 8 Replies
Feb 22, 2011
Possible Duplicate: Which language should I pick up: VB.Net or C# I'm trying to make a descision on learning VB.NET or C# as my first .NET language. I'm aware that bith languages can achieve the same things since both ultimately use the .NET framework. I'm also aware that C# has a similar syntax to both Java and C/C++, so I definitely see the benefits with this.
But how about the future of VB.NET? Will it be maintained in the years to come?I do know a bit of python, so would that make C# easier to learn?
View 11 Replies
Jan 13, 2010
I am looking to switch to C#. I come from a C / C++ background but C# is a little different for me. I am switching mainly because of Silverlight and MVVM; all examples are in C#. Any information is in C# and I am confused when I read through it all.
What is a good place to start learning C# when starting with existing C / C++ knowledge?
View 6 Replies
Mar 16, 2012
I'm a high school teacher and I have started a course in how to program with Visual Basic. Start with the 1st entry at url...
View 3 Replies
Mar 26, 2009
I'm a C# programmer who needs to pick up some VB. The syntax differences are easy enough to figure out, but there are other things I'll need more of a tutorial on. For example, VB's "strict" mode in Visual Studio is something essential to me, but something I wouldn't have learned just by comparing language syntax. Any recommendations on how to pick up VB quickly, yet thoroughly? I can't stand to work through a 1000 page book introducing VB to novices.
View 10 Replies
Apr 9, 2009
I would like to learn the Microsoft reports in vb.net.Anyone can provide me the links?
View 2 Replies
Sep 5, 2010
where is the best place to learn InvokeRequired and BeginInvoke.
View 4 Replies
Jan 27, 2010
as part of my alevel course i had to learn Pascal and now moved on to VB.NET.in Pascal there was a data type called 'real' where a number could have floating point values) my question is this; what in VB.NET is the equivalent to the Pascal real??
View 3 Replies
Jul 28, 2011
I've been an ASP.NET VB.NET Web Developer for the past 4 years, but its been mainly self-taught so I think theres a fair few basics I have probably not learnt along the way.I'm interested in switching to C#, and was wondering what book would be best to buy to learn this.Is Jon Skeet's 'C# in depth' book a good place to start learning, or would this be too difficult for me to start with?
View 4 Replies
Jul 6, 2009
please can anyone tell me where do i start to learn database???please help me because is a lot and confused information in google.
View 1 Replies
Jan 26, 2012
is there any series to learn Server and Client in VB.NET?
View 1 Replies
Feb 12, 2010
Can i get any best tutorial/Book/site to learn ADO.Net
View 1 Replies
Sep 30, 2009
I am not sure if this is the correct forum to post. I sometimes train Excel VBA. I would like to learn the language to a developers level. What relevant qualifications do Microsoft offer since I cannot find anything on their site?
View 1 Replies
Aug 27, 2009
I am taking a training course in Visual Basic.NET.
1) I downloaded the trial version of Visual Studio Professional and I am having troubles getting the Visual Studio trial version to recognize some of the coding.I know the coding is correct.I have heard of a Visual Studio.NET that the course recommends.Is it Available?If not is there a way to correct Visual Studio allow Recognition of this code?
2) What is the best Visual Studio package to learn the Visual Basic.NET Language?
View 10 Replies
Mar 20, 2012
learn and understand datetime picker and timer that would allow me to create application that is like reminder which would be like an appointment when this certain date and time is now at my computer then this form with listbox would show the appointment for the day that is stored in my database in sql server management studio express and vb.net 2008 as my programming language?
View 3 Replies
Nov 6, 2011
Recently, I've changed my job to a biological company, they have huge data but managed by Excel, only by Excel. For example, they have hundreds of orders every month, but they just simply record them by Excel. No database concept is used in this company. Excel to manage this is nightmare, only one person can write the file, others can only read the file by ReadOnly. And these data is very easy to be mistakenly modified.
So, since I come to the above Excel-managed company about one month ago, I cannot stop myself thinking apply database.But I have no programming background at all, only used VB6.0 to create some tiny program in High School. Now I started to think whether I can use VB2010 to do this.First of all, I turn this problem to Access, and I learned a lot database design theory from getting to know Access. However, I finally find out that Access can hardly freely create Form like VB (maybe I didn't find out how)
Anyway, I started to study VB2010, to add DataSet to my Form1, and use DataGridView to display data, and to use TableAdapter to modify data. However, it is quite hard to learn, without any systematic books. For example, I am confused about TableAdapter and TableManger, and I don't know how to simply display a modified DataTable by DataGridView control. And SQL search language is new to me as well.
So, I'm wondering if anyone could recommend me any books based on what I would like to learn? Or any tips and reviews?
View 5 Replies
Sep 22, 2011
I always wanted to make some websites. Is VB 2010 a good tool to make websites?
Where is a good place to start. Tutorials, examples and all of that.
View 1 Replies
Sep 8, 2009
I'm beginner programmer in the amazing world named ".Net".I've a lot of questions
well, what I should learn C# or Vb.net What's the best blogs which talk about .Net technology and Open source projects Where can I find good tutorials, free books and ideas of projects how can I progress in ".Net" please, share your knowledge , your OPML of your favorite blogs or web sites about ".Net "
View 12 Replies
Nov 5, 2011
I want to learn visual basic 2010 for software development
View 3 Replies
May 1, 2009
I'm trying to read and learn the save file dialog coding.[url]....
View 5 Replies
Jan 13, 2011
I'm new to VB but completly new. I've dabbled with it a bit before but mostly from copying and pasting code from online. Is there a good book that I can purchase that will show me the ropes of the basics?
View 5 Replies
Jan 22, 2011
Associating an Event with an Event Handler, in the VB 2008 Express Edition Learn VB tutorial, but the link to "Events and Event Handlers"does not work.
View 1 Replies
Apr 4, 2009
Where should I go to leanr to program stuff like getting keystrokes, locking keyvoards, changing desktop backgrounds, opening CD trays, changing IE homepage, etc.... Basically everything windows... I'm using VB.NET right now. Is there an api or something to learn for this kind of stuff?
View 10 Replies
Apr 15, 2012
I'm about to graduate and I've been applying for jobs. I know some basic programming languages and I asked the guy that I'm going to interview with on Tuesday if there is any specific language or program I should review. He said .Net
I know nothing about this particular language. When I look up info and tutorials I see that there is VB.net, ASP.net, DotNetNuke.
Is there just a regular .Net? Which do you think he is referring to? What is the difference between all of these? Also, can you recommend a good website or video tutorial series to learn the basics as quick as I can?
View 2 Replies
May 29, 2012
I found that when group by multiple values does not work well with VB.NET, but it works well with C# ,here are my code, is there something wrong with my VB.NET Code? Here is my VB.NET code:
[Code]...
View 1 Replies
Apr 2, 2012
i've been doing ADO.NET for a while but I would like to know if its posssible to use dao recordsets in VB.Net 2010 and where I can get tutorials and code samples to do database stuff like insert etc. I've tried to google but most of the code available is for vb6 I was going through some stuff on this link [URL]../bb243801%28v=office.12%29.aspx and i'd like to know if it works for vb.net 2010 or maybe theres something i'm missing. because the moment I put "Dim dbmyDB As dao.database" its been giving me the wavy blue line and i am now doubting if it works or maybe i'm missing some other code
View 1 Replies
Sep 9, 2009
If you are using an sql database with a vb.net application, does the user need to have anything extra other than the .net framework installed for the program to run? Meaning, if I simply compile the application, are there any extra steps I need to take to make this work?
View 1 Replies
Feb 2, 2011
I have an application that requires data be entered, and after entering, a button is clicked to process that data. Clicking the button works just as it should--the data is processed properly. In constructing a test module, I provide a set of data values, followed by:
btnWhatever.PerformClick()
Nothing happens. I have used this syntax for years, and it has always worked flawlessly. I have triple checked everything else and isolated the problem to the failure of the PerformClick(). The PerformClick() is in a test subroutine that does nothing but fill textboxes and labels with default data, then calls the PerformClick() on the button to begin processing. Again, the button works fine, the data is entered as it should be, but the PerformClick() does not fire the click event.
View 21 Replies
