Learn To Control Database Based On VB2010?
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
ADVERTISEMENT
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
Feb 24, 2011
In a vb 2010 project, I have 2 win forms: Form1 and Form2.
In the Form1 class there is a server-based timer: when the "elapsed event" fires, then I update the text of a Label1 on the Form2. A very simple code:
View 13 Replies
Nov 22, 2011
i wanted use some api graphic functions. but how can i use the hdc argumenter, if the picturebox don't have it?
View 11 Replies
Feb 5, 2011
In windows forms, you can easily change the ".left" value of a picturebox to move it. However, I have noticed that in VB2010 WPF, this is not the case..how to change an image control's .left (or equivalent) value in wpf?
View 1 Replies
Nov 26, 2011
I see no options to change. I see the HTML icon but it does not seem to activate. OPtion at the bottom HAS CODE is checked. This code worked in VB2008 but I get the indicated error in VB 2010. I would like to understand what changed.
[Code]....
View 13 Replies
Apr 22, 2012
When I insert a datetime into a datetime field in a SQL Database I only get for example 22/04/2012 06:31:33 instead of 22/04/2012 18:31:33 no matter how I format the field either in Vb or on date time on pc I only get am times
MyArray(MyClientHandles(f), 4) = Format(Now, "yyyy-MM-dd HH:mm:ss")
This is my typical code & have tried many formats the string shows as correct when looked at on breakpoint.
View 2 Replies
Jun 13, 2012
give me the source code to add database connectivity in VB2010 express through ADO.Net. Including all the commands to add, update, delete, retrieve and modify the database fields. It would be really helpful if anyone can provide me with a small prototype working model with the source code.
View 1 Replies
Sep 22, 2011
mostly the data inside the datatable is always typed by ourselves, while in this case, i want the computer itself do caculate or whatever and then input in this table and finally the chart will get the data inside the table and then draw the line automatically.is there any sample codes for me to know....(Above is just a simple idea, actually my project is to record the time spent in 2 status(working and idle) and then do the database table. but the GUI should look similar to the image above)
View 5 Replies
Jul 26, 2011
VB2010 DHTML element event catching using webbrowser control
View 10 Replies
Aug 18, 2010
I am writing an app in VB2010. My code parses a text file, assigns data to variables My??, and then attempts to store this data in an access 2010 (actually access 2007 format) table. Yet, whenever my code gets to MyRow.Item("Artist") = MyArtist I get an error 5 'Artist' does not belong to Table MyTable, but the field/column does exist in the table as do all the others.
01Dim tbl As DataTable = New DataTable(MyTable)
02tbl.Rows.Add()
03Dim lastRow As Integer = tbl.Rows.Count - 1
[Code].....
View 8 Replies
Jan 18, 2012
not all in the listbox items are save in database....only the index 0 is saved in the database...i want all to be save in database.
[Code]...
View 1 Replies
Nov 5, 2011
I finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path "program files" and this path is only read And my application crahed. I know how to installer put database in other path but I don't know how to tell my application to find this database,
View 4 Replies
Nov 3, 2010
I am trying to deploy a VB2010 programme that uses the 2010 Access Database Engine. The programme falls over when starting, with an error trying to access the Database. If I Install the programme on a machine that has Office 2003 installed - still installing the 2010 Database Engine - then it runs OK.Does the Database Engine work?
View 5 Replies
Jul 5, 2009
What is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 Replies
Nov 24, 2011
I am trying to 1) write code in VB2010 that will get a JPG image from a Access Database field and write the image to a PictureBox 2) write code which will write a JPG file to an Access Database field. I have already sucessfully coded this in VB6, without fully understanding what I was doing.
Browsing the various forum's I have come across a few discussions on this subject, but due to my complete amerture status I don't seem to be able to follow the logic.
Below is the VB6 code
Writing JPG file to DataBase:
Dim bytBlob() As Byte
Dim intNum As Integer
[Code]....
View 1 Replies
Aug 10, 2010
I have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
View 1 Replies
Sep 20, 2011
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 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
Sep 2, 2011
I am trying to make a listview custom control based on the standard listview control that will allow me to drag a column header outside the standard listview control and drop it on a panel. I plan to use the drop event to determine which column I should group by view on.
View 2 Replies
Apr 9, 2009
I would like to learn the Microsoft reports in vb.net.Anyone can provide me the links?
View 2 Replies
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
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
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
