Creating Database From Scratch
May 18, 2012
I am trying to create an empty table from scratch using Microsoft SQL Server Compact 3.5 and I am running into this problem.Please take a look at the screenshot below.[code]How come I do not have the same screenshot as the web site link below as Frank Smith showed in his example? What Do I have to do/install to have the same screenshot as in the web site below? I have Visual Studio 2008, Microsoft SQL Server 2005 and Microsoft SQL Server Compact 3.5 installed on my computer..url...
View 1 Replies
ADVERTISEMENT
Apr 21, 2009
We are migrating our applications to VB.Net 2008 from Classic VB and I need to create a base namespace and business layer. My method of approach is going to be to visit our top BA and identify the common areas of our (Fixed Income) company and try to form a decent inheritence model with as much of the code in generics as possible. What's everyone's experience of doing this and also as a second part of the question, we are looking at incorporating Web Focus into the OLAP side, how would this affect the design of the corporate namespace and it's derivatives?
View 3 Replies
Mar 19, 2010
The Vb.Net application creates a bitmap from scratch and either converts to a tiff or sends it to a printer. In both cases, the quality of the image (in this case the font) is not good at all. The sample code listed below creates the graphics object that I use to write to the image.
Dim gr2 As Graphics = Graphics.FromImage(New Bitmap(800, 1000), Imaging.PixelFormat.Format32bppPArgb))
[code]......
View 2 Replies
Feb 2, 2010
I'm following the sops from msdn on how to create a database from scratch. I would now like to programmatically add a single record via a command button?
View 3 Replies
Nov 14, 2010
I was wondering is it would be possible to create a web browser from scrach(meaning not the webbrowser object) in Visual basic(or any other visual studio languages).
View 3 Replies
Jun 13, 2009
This is purely academic-- I'm looking for an example of a custom control, created from scratch as in not built out of existing controls, you're actually handling drawing it, ect entirely yourself.
View 4 Replies
Jun 22, 2011
I want to build a simple chat app where people can go a url, type in a name and a message and click submit and it will basically show that message to everyone that is current connected.Firstly i would like to state i've had zero experience in sockets programming and the like. I'm simply a web 2.0 person building websites with css/html/js/ajax and backend i have asp.net on vb and sql server for database.So basically coming from an ajax background, i was wondering why do we even need to download any additional stuff to do web sockets? I mean in ajax i can simply create a asd.aspx file and use Response.Write(text) (text based on the input which are available through dissecting the url) and voila, the server side is done, all that's left is just to create new XMLHttpRequest and stuff in the client side.
So ok I'm not worried about the client side part of Web Sockets. but the server side part of web sockets is just difficult. so in the client side i have this: ws://localhost:8080/websocket. Is it true that it will work if is also an .aspx file as such: ws://localhost:8080/websocket.aspx ?I'm wondering so how do i continue from here? in Ajax i will supply parameters from client in the url as such: page.aspx?a=1&b=2 and do output in the server using Response.Write it's all clear but how do we do it in web sockets?
View 1 Replies
Jul 15, 2010
Rather than create a Form and use Graphics generated via the CreateGraphics Method, how does a System.Drawing.Graphics Object get built?
View 16 Replies
Dec 25, 2009
I want to know how I could create a bitmap from scratch with no images to start with.(I would say need. but than you would think this was for some sort of school project and it's not.)Basically, what I have is an image which is perfectly square in shape and has a black border with a black x going through it, what is not black is white. What I'm looking to know is how to take that small image (50x50 pixels) and make an image based upon those by placing them in X Rows of X amount. I'll make a couple example to show what I mean.(X's represent the 50x50 image.
[Code]...
View 7 Replies
Oct 12, 2010
i would like for my first project to be a CPU stress testing program (kind of like Core Damage or Intel Burn Test).I have no problem designing the form, but how and where should I start? I've done some searching, but haven't really found much. I think the reason for that is because nobody is really going to just give out source code for anything (which is completely understandable).
The main thing I would like to understand is what exactly makes the CPU work at 100%? And how could I design it to where it automatically determines the amount of cores/threads the CPU has, and utilize them 100% without having to open up one instance for each? Or is that jumping too far ahead?
EDIT > I know that I'll need to create some kind of loop for the CPU to process over and over until closed. I was thinking something along the lines of calculating Pi to 32 million digits or something like that.
> Another goal is to have some sort of error checking capability. I am an overclocker, and I would like to have this ability with this program. For example, it I make it to calculate Pi, then I would like for it to tell me if there were any errors in the digits it produced.
View 8 Replies
May 13, 2012
I'm currently starting a new job in which I will be working on some coding in the future and need some advice on some good places to start so I can learn this correctly. Essentially we need to bring VB4 code over to the new VB.net language and I will be tasked with this. The project consists of a large battery of tests for psychiatric patients consisting of mostly multiple choice questions presented one at a time - since VB4 isn't very compatible, I think I will create a new battery from scratch while using the old code as a reference point.
I started creating the code this weekend for fun and am really enjoying it. However, a huge problem has been the abandonment of control arrays in the new language... by the time I got to creating my first questionnaire I'm stumped and can't follow the old code. Clearly I'm not ready to tackle such a large project with no experience and need to start from scratch; who would have thought .
The reason why I'm here is not to ask you to help me with my work. What I'm wondering is if any of you have any cool advice of great places to start learning the language (books, websites, etc). The amount of literature is very overwhelming so I thought I would ask some people with experience for tips. If any of you have stumbled across learning material with emphasis on coding that would be useful in the design of questionnaires or multiple choice exams, it would be particularly useful.
So far my starting place is Visual Basic 2010 Step by Step with Michael Halvorson, it seems good at a glance in the sense that it couples theory with practice but I'm already sure I'll need a little more.
View 12 Replies
May 4, 2012
Without using MVVMLight, I need to implement drag and drop for photos onto a listbox using mvvm using Icommands preferably and interaction triggers, however if i use commands then I don't know what to pass in for a command parameter? Any ideas? Thanks.
Heres some ideas I tried:
Public Property ImageList As New ObservableCollection(Of ListBoxItem)
Public Property AddImageCommand As ICommand = New Adjuster.DelegateCommand(AddressOf addImage)
Public Property DropCommand As ICommand = New Adjuster.DelegateCommand(AddressOf dropImage)
[code]....
View 1 Replies
Apr 25, 2011
I'm trying to develop 2 companion applications. One application will be a FileSystemWatcher service application that will create/maintain a database containing file metadata (file properties) from a specific folder structure on the user's C drive. The other application is executed by the user which contains edit boxes pertaining to the metadata. As the user enters data in the edit boxes, the code will execute an SQL statement which in turn will display a list of file matching the entered criteria.
I'm thinking about using Microsoft Access as the database since all users have it but I'm willing to use another database format as long as it something intrinsic to the Windows XP 64 bit system (i.e. I don't want to install another database application in order to utilize its database format). So, do you have a suggestion on a database format? Do you have some pointers or links, on how to create database file and tables on the fly? Should I use DAO or ADO or something else? I'd prefer to work in VB.NET.
View 1 Replies
Dec 5, 2011
In Beth Massi's Video How do I Create a simple Data Entry Form in Wpf? Video you use a Oms Data Base but it does not tell you how. Can someone please tell me how. Iam using Visual Studio 2010 In Vb code.
View 2 Replies
Feb 1, 2012
I am trying to set up a database with Students, Courses and grades. This is the main bulk of my code, I am stuck with the error below,
[Code]...
View 5 Replies
May 4, 2011
I am creating a VB.NET application that will use a FoxPro database as it's main datasource.The problem I've got is that I can browse existing databases and pull out data with no problems at all but as soon as I try and create my own database I get an error message saying "One or more errors occurred during processing of command." (which is helpfully vague).[code]
View 1 Replies
Sep 27, 2011
I have written some software for a company I want to start, basically I want to supply automotive parts. The software I have created uses a database to hold information for users, parts, suppliers and so on.I want to write in a search bar so I can search for a part by name.The code I have written so far for this form is basically what is created when the new dataset wizard is used.[code]I have a datagridview that loads the data for my partslist table, underneath there is a textbox control for my search bar and a button to perform the search, underneath that I have placed another datagridview control to receive the results from the search.Can anyone help me write code to perform a search and place the results in the second datagrid control.
View 2 Replies
Jan 30, 2010
i want to know how to create a log in form using a database..i've watched some videos but its failed.im using visual basic 2008 and access database 2003...i have created a table for password..
View 9 Replies
Jul 17, 2009
Below is my code for creating a database and then, from there i hope to be able to create more than one tables in the same database that i just created. But for some reason, Visual studio 2005 keeps reminding me that the SqlCeException was not handled or mishandled. Error lies in the "sqlCreateTable.ExecuteNonQuery()"[code]Actually i heard from someone that you can actually create all the tables that you need such as "Login", "Order" and so on in a single windows form(in form_load) , which will load up all your table and create them for you if that window form is the first object to start running in the order.
View 3 Replies
Feb 22, 2009
Im would like to create relationships between my tables from different database. im using VB 2008 and SQL 2008 as my database. Is the relationships should be made on my database itself or tru coding in my VB? If either which how can i do that.
View 2 Replies
Jun 19, 2012
I've been having some trouble wrapping my head around how to link the 4 tables I have together. I'm creating a database to store all of our equipment in. The four tables are Equipment, Service (Stores dates that a piece of equipment has been worked on), Invoice (Stores invoice and warranty dates) and Peripheral table (Stores a unique ID for each type of peripheral we have in the database. Monitor (1), mouse (2), keyboard (3) etc)
View 4 Replies
Nov 15, 2011
I want to create a relational database in VB2010 and I am attempting to accomplish this goal by creating a structure of records to be stored in a Random Access File.For each record, I want to organize each fixed-length record so that 4-integer sets of data are stored into a a multi-dimensional array.But when I try to write the code below at the module level, I get an error.
Structure PictureDat
'len= needed for Open
of Random Access File [code].....
Since I want to read/write/save the data in this structure to a Random Access File with a fixed record length size, I need to exactly specify the size of the record...which is, of course, determined by the array's dimensions.If I could accomplish this strategy, then I could search this random access file for a match of search criteria consisting of 4-integers with any of the 4-integer sets of data in each record and thus find, edit, delete and search records...therby retrieve information from my database.
Is my program design inefficient? Is there a better way to handle perhaps hundreds of thousands of records? The IDE keeps telling me that I am using a deprecated method of file I/O when I use FileOpen(), FileGet(),FilePut() and should be using MyFile.I am entirely comfortable with my time-tested method of data storage that ensures the security of disk storage while exposing only one record at a time to the PC's volatile RAM, thereby not allowing all my data exposed to possible memory corruption on a PC left on for hours, which would be the case if I loaded the whole file as a monster- sized string or stream. Also, these older file access methods allows my code to run on PC's with modest amounts of memory.
View 9 Replies
Nov 30, 2011
I am currently creating a windows form app with a database.The database hosts links that the user can customize.When I go to publish the file, if user A changes the Link to their liking user B also see's the changes and will cause a clash if user B does not need the link that user A has put it.
I wish to be able to have a unique database for each individual and for the life of me cannot figure out how.Currently I am having the person upload to an access DB. This is not required but I am lost for ideas
[Code]...
View 4 Replies
Jan 19, 2011
I've been viewing the tutorial at [URL]...08-088541.html but I'm still having issues creating my connection to our Oracle database. Here's my code, which uses the same connection string as one of my VB6 programs (no password required for database--Oracle picks up windows name) :
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Create connection object
Dim OraDB As String = "Data Source=databaseneme;Persist Security Info=False"
Dim conn As New OracleConnection(OraDB)
conn.ConnectionString = OraDB
conn.Open()
Me.Show()
End Sub
I've been using .NET for all of 10 mins so the error may be painfully obvious!
View 18 Replies
Jun 9, 2011
I have decided I would start small and make a program that would create a "receipt" list in a listbox and a total. Now, I would like the user to be able to add their own "menu" items. I'm assuming the best way to go about this would be to have them actually add it to a database and then a function in the program will refresh the dataset with the new list. However, this is where my problem lies. How can I tell VB .net 2010 that I want to create a new button (or buttons) on the fly, in an orderly pattern on the form, based on the input from a DB?
View 10 Replies
Nov 15, 2011
Iam using firebird v 2.5 database with vb.net . how to create a new user in fb database programmatic ally in vb.net .
View 2 Replies
May 26, 2012
I have seen a few .NET apps use .db files. I am not new to Visual Basic, however I have never created a VB app that uses databases. I do know PHP pretty well, and working with databases in PHP I am familiar with.
[Code]...
View 1 Replies
Aug 2, 2009
I'm trying to create a database driven application using VS 2008. I want my database to be generic, i.e it shouldn't rely on the existence of MS Access or similar application. So how do I create such a database, add tables , values..etc?
View 7 Replies
Jun 12, 2009
When i'm trying to create a new SQL Server Database in VB.NET 2005 through Server Explorer i'm getting following error (no matter what authentication i select):An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider:Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)i have properly selected my Server and entered a different name to the new database.
View 3 Replies
Mar 15, 2012
I have this in creating table but did not work. Having invalid table name error.
Imports Oracle.DataAccess.Client
Imports Oracle.DataAccess.Types
Public Class dump
[code]......
View 3 Replies
