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?
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?
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.
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
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.
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)
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
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,
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?
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
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.
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?
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?
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?
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.
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.
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.
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??
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?
