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.
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
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 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?
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.
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.
What 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.
how 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.
My 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?
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:
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?
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 want to create a table (called "Customers") in a Microsoft Access database and then insert/delete records into the table and update the table. The table shall have 3 columns:
ID Customer Name Customer Address
I know i need to make the "ID" column as an autonumber and a primary key, as i need to insert and delete records and update the table. I am using the Visual basic 2008 Express edition and quite familar with the OledBcommand.
I've just downloaded SQL server express and have created a database in there. Now back in my VB.NET application from Visual Studio how do i find/connect to it?
I 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?
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
When 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?
I 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
I 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.
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
I 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.
