I am working on a database application for my Class Reunion in VB.et and VS 2008, My problem is when i build the program it will only work with 1 Database For my Class year, I would like the ability to be able to create a new database for a different classyear than the 1 i build and pre-Populate, so the person using it can do more than 1 year and keep the databases seperate.
View 3 RepliesI would like to make a copy of an existing database in microsoft SQL Server 2005 in code, if that is possible. I'll need to make a copy of the original one, and change the name to some other name choice. All tables, stored procedures and such will be exactly the same.
View 4 RepliesIm working on a prog for my work. however, im stuck. I come to a spot where i need the prog to copy a sample table to an existing database. we can either simply copy the sample table, or as a last resort, create a new one from scratch.
View 6 RepliesI have the following problem. I try to create a Database based on SQL. But i have problems to get the connection open! I have following code:[code...]
View 5 RepliesWhen ever I try to add Service-based Database in Visual Basic 2010 Express Edition it just prompts me a message.
And if it means anything this error started showing right after I installed
Visual Studio 201 Professional test.
I am creating an Add-In that I want to create classes and forms based on a database structure. I can't find any information anywhere on how to programatically add code to classes. I know I can write out the files and add them to a project, but that would limit what I can do in the future. I would like the possibility to update a function in the future which would be impossible writing out a file and loading the whole thing back in. It would destroy any modifications made to the class, and since this Add-In will only be creating a framework, there will usually be modifications.
I got this line from the macro recorder:DTE.ActiveDocument.Selection.text = strDACode
But I like to keep Option Strict on, and this is late bound according to the IDE. There seems to be very little help on the IDE and how to use it creating Add-Ins. If I overlooked something please point me there, but I can find nothing. I don't know if it can be done, but I was able to do it in an Add-In for VB6.I would also like to add controls to a form, so if anyone can point me somewhere where it explains
I have made an Access database complete with a report/form UI, however I am now looking to take this further to Visual Basic. In my Access database I have a log-in form to access some secure reports. I am now trying to do the same thing in Visual Basic, with no luck. I have created the UI elements i.e. buttons and text boxes, but am now stuck at how to implement the code.What I want to do is make the login button check what's in the username/password boxes with a table in my Access database.
View 1 RepliesI have pictures of each employee stored in SQL database with Image database.
Select pic from empimages where emp_ID=10
give the picture of that employee in binary format.
How do I create a physical jpeg in C:images folder based on the above query in vb.net.
I have to create buttons at rum time based on database records and implement their events.
View 5 Replieshow to write the code for my project.I am to base my new project on an existing one(existing one has code that works 100%)and create an Array of a structure that bascially holds the information from a summary form AND the totals from an AddToOrder_Click event. If you are still with me)... I cant figure out what the code is for my structure and Array so that I STILL have a Summary Form but I have an array that shows when I click my PrintPreview. So an Array is basically a "space" that holds information, like my summary form except it doesnt show until I click PrintPreview right?
If I just wanted to show the table then my code belongs in the PrintDocument1_PrintPage to show the array but the actual structure code belongs in the Click_Event of my AddToOrder? Please Please understand I AM NOT asking for anyone to write my code, basically I am asking for some clarification on what exactly creating an array from a structure is and therefore determing where the structure is to be placed in my code..
I've decided to make an new archiver based on existing dlls. Im aiming at a simple 7zip style archiver thats quadcore optimized and 8 core compatible (the 8 core part can wait cause amd's bulldozer aint out yet). I'd like to include [code]Where do I start? And where can I get the dll's? (multiupload.com links are nice).
View 3 RepliesI want to use automated testing using autoit for my existing windows form based application. Currently looking at the autoit documentation I couldnt figure out how to start a existing windows application in vb.net and then use it for further automation.
View 3 RepliesI am wanting to create a menu based on items in my MS SQL database i have 3 tables
FormTbl
FormID - Int Eg (1)
FormName - nvarchar(50) Eg (Form1)
[CODE]...................
I can get the form names to be populated in to the menu and can open it my question is how do i set where the menu items will be placed. Eg File with FormHierarch 0 will be the very first one. Exit with FormHierarch 0.1 will be the very first one under File
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim menu As New MenuStrip()
Dim dst As DataTable = User.MenuItems(Me.ToolStripStatusLabel1.Text)
[CODE].....................................
I seem to be having a problem with controls that I am creating as new classes (not UserControls) inheriting from an existing system control. Everything seems ok while I create the control code, through to the compile (which is successful and adds the control to the toolbox) and dragging the control from the toolbox to the GUI surface. However, when I then debug or compile the project, I get a message such
[Code]...
I am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 RepliesI have a table in database which I need to add a new column to. Normally I would load the access database and create the column but in this instance I have to many databases to amend. Is there a way in code to first detect if the column exists and if it doesn't create it in code?
View 1 RepliesI have recently released a free application for some game and now I have added a few features 'the public' requested.
I used Inno Setup to create the installer, which works just fine.
Now however, instead of having the ask the user to uninstall the current version, and then reinstall my new version, I want to be able to give the user an Update install exe which they can simply run and it will update the existing application.
One thing I would like is that the users Settings are not changed. So hence the following questions: 1. Where are the Settings stored? I thought it was in the user's Local Settings <Application Name> directory, but I cannot find my application there... I cannot find it in the All Users or Administrator 'accounts' directories either...
2. Are the Settings stored depending on the Version of your application? (Assembly Version / File Version)?
If 2. is true, then obviously changing the Application Version (which is logical in an Updated executable, no?) would also change the Settings back to default..? Can I avoid that?
Finally, is it enough to simply overwrite the executable? What registry 'work' do I need to do, or can Inno Setup do that for me? I am only using one other file which is the SharpZipLib DLL file.
I am currently writing a program in VB 2008. Here is what the program is intended to do: I need it to have two forms of input, so I want it to open existing text files and create new ones. Once the user has selected what input to be taken (either a file is opened or a new one is made, guessing multiple forms need to be used here) the user will then take the text file either created or opened and then be able to click a button which will sort all the text in the text file into alphabetical order and then display the results to the screen. While this happens, I need the words in the file to be counted by a counter (so a loop i guess) that then displays on which line each word appears on. I then need this information to be displayed in a text box on screen.
View 2 RepliesWhat is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 RepliesI'm creating another database searcher, only this one is a little better user friendly than the one I made with a datagridview. I'm using the "details" of my dataset(CustomersDataSet) and trying to add a record into an existing database. I'm using this code
Me.TableAdapterManager.UpdateAll(Me.DatabaseDataSet)
which worked for me when using the datagridview, but for some reason it won't work now. Even when I check for my test "add a customer" in the access database itself, it isn't added.
I am using SQL server managment express. I have 4 databases in it and got a bug on my computer which I could not get rid of. I saved these to disk and reinstalled windows, I reinstalled SQL server and I am now trying to add my 4 databases. Can any one help me with this, I can add a new database but not an existing.
View 2 RepliesI 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 RepliesRecently 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 RepliesHow can I add a new form to my project that is based on an existing form in the same project?
I want to add a new form to my project with the same control layout as an existing form in my project, and then just change the label text and so on.
I tried to just copy and paste, then rename the pasted .vb file, but get an error when I try to open it for modification.
I need to add a column to an existing table in my database. I am having trouble adding a column to my database. I physically go into Microsoft Access and add the column, my problem comes up when Visual Studio does not recognize the table. Basically, I think I'm doing something wrong.
View 5 Repliesi am using vb.net2010 and mssql as my database. what i want to do is when i open the form, the database will auto increment the student id and show it on the text box.
View 13 RepliesI have this Add User Form and a Function Class, I need to know if the username typed in the Add User Form already exist in the database, so that I can warn to change the username but I have problems doing that.
Here's the code for the function class:
Public Function addUser(ByVal arole As String, ByVal ausername As String, ByVal apass As String, ByVal aname As String, ByVal aaddress As String, ByVal aregion As String, ByVal aprovince As String, ByVal atown As String, ByVal adate As Date, ByVal acreator As String) As Boolean
[Code].....
How to get the value of table in sql database and adding in existing table?
View 1 RepliesI'd followed Beth's video which nicely explains how to setup a "connector" to an existing database. Also, I've updated a method to retrieve information from one of the tables.Now, I need to retrieve information from the table, but I don't succeed to find the "method" to do so (I don't get to the situation that "Fill" or "GetData" are recognized methods). Could anyone send me references through which I could easily understand. how this needs to be done?
View 1 RepliesI have a series of .DAT files I need to read into vb.net and then parse the data into a format that can be easily read into an SQL database that already exists. Would I be using a StreamReader object? Or is there a different way to go about this?
View 11 Replies