Way To Create A Database
Sep 9, 2009How to create a database for medical shop database. m also getting the error unable to fit in memory.
View 3 RepliesHow to create a database for medical shop database. m also getting the error unable to fit in memory.
View 3 Repliesdoes VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesI have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 RepliesWhen I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesMy question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 RepliesI create my database with SQL server management 2005 Express and i must connect my application elaborated with VB.NET2008 express when i go Tools-connect to database a window appeeas;it demands to set database name But the problem is: i create my database with windows authentification and i don't know the path of the database
View 1 RepliesI created a SQL database using the migration tool.I am converting my access forms to VB.net (VS2008).I am wondering if I create a single dataset in studio to the database or do I create a dataset for each form (query)? I am trying to determine what the best solution is. Many of my forms have drop downs that are populated using queries from tables.
View 3 RepliesWith VB.net, I'm coding a simple application to get more used to the new .Net format.
I'd like to save all the information to a 'new' database file. how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work/find out.
Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?
Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' (rather than just running from the .exe of the program) and proceed to load the data?
EDIT1 - Extra InfoThe windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file
how to create a database programmatically in VBtajinder
View 3 Repliescreate a SQL database from .net?
View 11 RepliesI have an FTP website that I created using Visual Web Developer 2008 Standard and I'm just now needing to store some data on it that would be accessed and modified by my winforms app. I added an SQL database to the website but found that an addon is necessary from the hosting service that I use that costs $ 10 a month. I was considering creating my own non SQL database.
For those of you that know about this subject do you think that it wouldn't at all be worth it to try. Should I just pay the extra $ 10 a month and use my SQL database or should I attempt to create my own non SQL database. If I did create my own non SQL database what are your suggestions. Could I make it secure and what would be the best way to communicate between my winforms app and my website database. The data I would be storing wouldn't be that much: User email addresses, some 12 character codes and a few other things perhaps.
I have been reading all about filling controls with information from the database but I can't find anything that really covers the simple question.I want to create a database with 4 different table names. Each table will be holding information from information the end user submits on my form.All I need in the database is tablenames so I can have the corresponding datatable control column on my form display data that is populated through my application.
View 1 RepliesI'm new to this VBexpress and programming but I would like to learn it.I have tried to follow avideo from Beth Massi on how to create database
at some point she right kliks and choos relationship.I dont have that at all...I cant even rightklik nad have something to choose..I can se that in the video there is an older version of VB and SQL.
I wrote a small application in witch I create a connection to a database. I'm new to this, so I followed the steps in MSDN help. I first created a link to the database with the "Datasource" of the Visual Studio environement. Then, in the code, I create instances of the dataset in the datasource and use a tableAdapter to register my changes in the database.
Now I want to allow the user of the application to specify the path of the DB file he wants to use. How can I do so? Do I still can use the datasource in the VS environment? I don't know where to start.
I am trying to create a database in access, and interact with it using a VB form and listboxes in particular. I am stuck on one small section which should open the rest up for me if fixed!The database has 5 columns, ID, Book Title, Author, No. Sold and Year Sold. I have managed to get my program to put all the data from 'years' into a listbox using this coding:[code]This nearly works, but the problem is that it copies ALL the Number Sold from every year, not just the one highlighted.
View 3 RepliesHow to create a ms-access database with table in run time .i mean i want to create a database when user run the application
View 6 Replieswhat is the code to put in when you want to create a procedure for a sql database
View 1 RepliesI'm looking to create a program that needs to use a database I have (MySQL is the format it is in right now). The program doesn't need to change/update this database, only read from it. How would I go about making the data available to the program, without the end user having to install an SQL server?
View 9 RepliesI just want to be able to click on a commandbutton, menu_item, or maybe even a wizard at program install time, to make the database from scratch.
1) I do not care what type of database it is it is as long as it will run on any pc machine without having other programs installed except the one im creating.
2) I do not want to use access or the designers to create the database either
[code]...
I am trying to create an application that needs to have a database. I would like to know which one you recommend using. I have programmed in php using mysql but I do not think that is feasible for a windows application. I want something that does not have to install something else with my application.
View 32 RepliesI have a really big problem in my application and I don't know how will I resolve it, so please help me. And here is my problem:
I want to create a SQL database from my application. So to do this, simply storing SQL statements in the My.Resources (as text file) and then execute it as SqlCommand.
It successfully creates the database, everything is good. But after the creating database, I want to re-connect it with my application. But it gives me that error:
Unable to open the physical file "C:Users[UserName]DesktopDB_01022010.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)".[code]...
im sure that there are plenty of people here that have the same problem as me, but i cant seem to find a forum that explains this to me. well basically i have a program i am creating to use as a phone list, but to save data to a database on a mapped hard drive. I want to give the user the option to set the path of the database just by typing it into a textbox. The database will be supplied with the program, with all appropriate tables, i just really would like to know how to set up a connection to a database using code, and to be able to display it into a datagrid veiw. I know this seems simple to you guys,and i am really sorry, i am just new at this.
and also if u could, could u describe to me how to make it search through the database for like certain names/numbers?
o if i want to add,edit and delete information in daatgridview,look like Microsoft excel
View 15 RepliesI have a list view which is populated with an MSACCESS database using ADO. I know how to import data from the database, and I know how to create new rows in the database. However, is it possible to save the contents of the listview to the databaes? Here's my code so far:
Adding A Row:
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim dsNewRow As DataRow
dsNewRow = ds.Tables("Accounts").NewRow()
dsNewRow.Item("UserID") = txtUserReg.Text
[code]....
I want to create ODBC DSN for a database (which will be included in my application folder whenever a user setups the application). I want to know how to create ODBC with all the required parameters so that the first thing that is done when the setup is being run is connecting the database to the application. I have tried using default VB.NET setup wizard and Installshield.
View 1 Replies"Employee Monitoring Program"
Source: Visual Studio 2008 Pro
Language: Visual Basic
I already Installed the components came with the VS2008 Installer (Sql etc)
The idea of the program:
The program will create a personal information of every employee including the userid and password that will be use to log in (user validation) .The application will monitor the login / logout and save the task of every employee.he application will save/store the daily activity task done by the employee (login/logout time,notes, and other task assign). the information will be saved in a database which can be access by the application in every PC within the network (LAN).The application will be installed in different PC within a network(LAN). The number of PC is not yet confirmed (5-10 PCs)
The application will be used concurrently within the network.The database will be updated after the employee save his/her task.
I plan to have ONE application only, to make it simple no server type installation and client type installation needed. Just one installation type only, the functionality/privilege will depend on the login information validation.
There will be 3 account types, Manager Account (Administrator),Regular Account (Normal Employee) and Guest account.
1. How to create an application which the database will be on the other PC within the network (LAN) ?
2. How to do it during run time/design time ( the database will be on the other pc)?
3. Can I have a guide or walk through on how to do this project?
I have this code of sending sms but i dunno know how to make the connection for the below code to run my program.
[Code]...
I 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 RepliesI created a small program that reads an access database 2007 I added the database from the data sources window, the fields I created were ID, Name, Transaction, email and Number. where number has a YES index(no duplicates) option. And they all are TEXT types. I created a new form and added the datagrid of the database and want to create a search by number. so I click on the add query, then on the number filter I added LIKE @Number + '%' BUT IT CHANGES TO: LIKE '@Number' + '%' so the query wont work, and VB.net wont create the text field or anything. what is it that I have to do?
View 1 Repliesi'm searching for information on how to programmatically create a database. i want to manage some data and the windows forms application i wish to built will provide users to create, open, manage & delete databases with small amount of data presented into a datagridview.as an example, if, in VS, you click Project and Add new item, it's possible to choose Local database and cancel the wizard, than manually create and edit a table.is there a way to do something similar with some code?i've checked msdn but cannot find anything on this.
View 3 Replies