my visual basic create a .sdf file for every database but then when i try to access it it says that its an unknown database file extension. i used a tutorial which used a .mdb file which i had to download and it worked fine with it. how do i create a .mdb file
View 1 Replies
I need some expert help in achieving this task. I have an xml file which will be emailed to me everyday. I need to loop through the xml and create tables in a database based on the xml nodes and their attributes. looking at the following xml fragment for example: Code:
So based on the above xml, I would have to create a Shipment table as a Parent with fields like ShipmentIdentifier. Then I would have to create an Event table with the ShipmentID as a foreign key and fields like Source, Code. Basically a field for each node. Then if there are columns in the table that are new, I would have to modify the table and add the column. I only have to create tables where there are child nodes or where the nodes have attributes.
I'm using the Access Database format .accdb?
1. Can I just create a database by creating the file: "<db name here>.accdb"?
2. Once that is done, is it simply as easy as executing the "CREATE TABLE" command to populate the database with tables and columns?
3. These queries return an error:
vb
Dim query As New OleDbCommand("CREATE TABLE xp (Name Text, Author Text, Version Text, Data Memo, Engine Text, Website Text, Call Text, SDK Text, Type Text, Demo Text);", cn) Dim query2 As New OleDbCommand("CREATE TABLE vx (Name Text, Author Text, Version Text, Data Memo, Engine Text, Website Text, Call Text, SDK Text, Type Text, Demo Text);", cn)
Error:Format of the initialization string does not conform to specification starting at index 0
With 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 can i create a File/Registry/Database, to Save the time and playernames?
View 5 Repliesany one to make a complete exe file of my vb project its urgent need for me.
View 2 RepliesIs is possible that you can create database programmatically in SQL CE?
View 2 Repliesi not sure can it be done.
Using VB.net by typing the name and hit the button to Show the person record from the database access.
the log file will pop out and show the person record in VB.Net
Anyone here knows a batch file to create a duplicate database!
View 6 RepliesI would like to generate an Excel file using a database query in VB.Net. How can I do it? To be more precise: I would like to "bind" a query (much like binding a query to a GridView) to an Excel file such that the rows in the table occupy corresponding cells in a new Excel file, and save the file to my computer. And then, mail that file to someone. While I can handle the mailing part, it's the creation of such a file that I need help with. Anyone know how to achieve what I want to achieve? PS: I need to do this in VB.Net and I'm using SQL Server 2008.
View 3 RepliesSuppose you have three file of a database with information for three years (imported information of one year to database and has saved as a new file). How we can merge this three file and create one database for all years with visual basic 2010?
Note:
1-Each database has three tables and there is relationship between them
2- The ID number in tables is Auto number
3- Fields in all tables for all files are completely the same
I am in process of developing a student database for my husbands institute. I am completely done with the design of screens. Now I want to create database using sql plus ( as i am trained in it). I would like to know the process of connecting the database with the application.I would also like to know the process for the following :
1. When i create a student registration form, it should get updated in the database.
2. When i try to delete a student's record it should get deleted.
3. When filling the registration form , if any mistakes, i shall refresh and fill again.( i have designed buttons already).
4.On completion of the present academic year, the details i mean the class of the student shall be updated automatically.
The above are few requirements i need for my application.
with MySQL + vb.net 2008 exp to create back up of MySQL database script file through vb.net
View 2 RepliesI'm wanting to create a database programmatically from the edmx or edmx.sqlce file in my project. I read the best practice when sending the data out to users this is the best way.But I haven't found anything on it. Or is it best to create it and send it out with the program? How would I do updates to the database if I did this? How do I tell which version the database is?
View 1 RepliesI need to export data to a text file either in VB or SQL and it has to be formmatted like this. The data is in a SQL Databse[code]...
View 7 RepliesI have a problem with attaching sql server database to an installer file.
View 1 RepliesI have completed the coding for this assignment but have a few errors that I cannot figure out. I did create the new stored procedure 'getEmployees'
Error1Type 'PubsDataSetTableAdapters.getEmployeesTableAdapter' is not defined
Error2Type 'PubsDataSetTableAdapters.getEmployeesTableAdapter' is not defined.
Error3'getEmployees' is not a member of 'CIT263Lab5.PubsDataSet'.
How to create a database using sql in vb 2008. Creating a database as in make it a valid one. I'm actually trying to develop a program. I've got everything in mind it's just that the database that i'm lacking and i am wondering if there's any idea to create it inside vb.net.
p.s. I know how to link. I just need the information to create the database from the scratch using SQL.
I want my program to be able to create a '.txt' file when it is run for the first time, with the date and time the program was accessed, and to be able to add new 'logs' of program history every time it is accessed. What i mean is that i want my program to be able to create a '.txt' file, and then fill in the dates and times when the program is opened.
View 7 RepliesI have tried to create a bar to search the form
View 1 RepliesI want to do a task with a function controlling database with vb scripting. My form will include textbox, button and datagridview to view the database table manually without add from the microsoft access or other..how i want to make the table appear when i put a number into the textbox that refer to the number of row and column and then click the button to create the database table? Besides, how to rename it using textbox?
View 3 Replieshow can i tarnslate this code blokcs ,from vb6.0 to vb 2008 express successful work how can i do this in vb 2008 express
If Dir(App.Path & "MUHASEBECIM.mdb") = "" Then
' muhasebem is database name
Dim MUHASEBEM As Database
' tables define
Dim GENELAYARLAR As New TableDef
[code].....
I am new with VB. I got now the Visual Studio 2008. I newer used it before.I need the following:I need a login form, which is using an MS Access 2003 database, in which I stored usernames and passwords.
The DB name is users.mdb and is stored on the C drive. It contains just 1 table, the name of the table is UserList. In the table I have 3 colums, first is ID, second is Username, the third is Password. It contains
just 4 datas, in the username the first entry is John, the second is Mary, in the password column the passwords are john and mary.
[Code]...
I'm a college student and starting to use Visua Basic 2008.Unfortunately couldn't find the right algo for adding a database in vb 08. T_TMy problem is that how to add a database access 2007 in visual basic 2008.
View 3 RepliesWhat I need to create Microsoft Access database using VB.NET? I was looking for microsoft ado ext. 2.7 for ddl and security but I could not find anywhere.
View 2 Replieshow i can create a connection to a database when i open my program and then close that connection when the program closes, so that the user has a permanent connection while the program is running that can be used for multiple things depending on what the user decides to do.
View 5 RepliesIs it possible to create a graph by using data from a database?
View 2 RepliesMy connection that I am using is via connection string, so there's no dataset that will be created for the datasource. How can i create one for this type of connection?
View 3 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 sql 2005 and i want to develop a small program that can access the database and amend a few rows of data. in sql database, i have 1 table and it consist of 3 columns = datetime, type & price. below is example:
[Code]....
