Am I on the right path I programmatically create, fill, modify, essentially communicate with a set of Datatables, etc within my app while never having an actual database (i.e. Access.mdb file) all residing in memory but never really existing in an '.mdb' file, for example?
View 3 Replies
I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
[Code]...
I'm using a OleDB connection to a access database. I'm entering a row into the database to set some user preferences. What i need to get is get back the row ID of the row I just entered. I'm more familiar with PHP and with PHP I use use this entry
[Code]...
What is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 RepliesHow can I display column contents of a MS SQL Database on Text Box using VB 2008
View 2 RepliesUsing VS2008 as frontend and MS SOL Server2008 as backend... a database is created in MS SQL Server2008(SQLEXPRESS). Now the problem is i am not being able to to load the database created in MS SQL Server2008(SQLEXPRESS) onto VS.Net 2008...
View 32 RepliesHaving problem in updating an existing record. An error occurs "Data Type Mismatch in Criteria Expression"
Private Sub ToolStripButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton1.Click
Dim myBuilder As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(dataAdapter)
[code].....
I am using VB 2008 express and SQL Server 2008 express on a test basis and I used to connect VB express to a SQL database (created in SQL Server 2008 Express management studio) file and it work perfectly until my hard drive packed up and I had to get a new one, so I had to reinstall both of these again and copied my old databases from a backup I had. Now when I try to connect to the database file it cannot connect. Network related error or the instance name is incorrect. When I look at the advanced options in the connect dialog it shows my instance as .SQLExpress and my correct instance name is .SQL2008Express. I clicked OK on the connect dialog and manually changed my connection string to the correct instance and that worked but whenever I run the application in debug mode it give me the same error as above.
View 1 RepliesI have spent several hours trying to delete a row and insert a row into an Access database using the OLEDBDataadapter and dataSets without any success. I don't get any errors it just doesn't update the datatable. Here is the last version of the code I have been trying to get to work. I have done a lot of searching and have
Data save
Private Sub SaveNumDte(ByVal ltoNum As String, ByVal ltoDate As Date)
Dim numTotal, x, MaxRows As Integer
[code].....
Im using VB 2008 and SQL Server 2008 as its database. But i have encountered this error in connecting to my database. An Expected error has occurred. Error Message: Count not load type [Code] What's seems to be the problem? or what this error message means.
View 10 RepliesI'm working on a medium-ish project that requires a database. The problem, is that I can't use an actual database. Well, I at least can't have any installable dependencies with the exception of the framework.
Anyone have any ideas on what I could use?I was thinking I might be able to create an XML file and store the information, though I think that would be extremely time consuming. I might be able to convince my boss to let me use a SQL CE database because it has smaller footprint, but I'm not sure if he'll go for it.
VS 2008 how to add data in database 2008
[URL]
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
i wanna know is there away of working with a database inside one of my VB apps ? what i wanna do is make a login system (which i can do fine) but i can only have the username and password stored in the code like.
[Code]...
Im have used vb2008 now for a while but i have no ideer how to use database now i have Microsoft Access but i dont know if thats easy to use or if there is somthing thats is more easy to use!.. now any one have an ideer for a program i could start to make with database in it so i cut start learning to use the whole database properly!i should say that i have no experience using Microsoft Access i only have messed aroud with it a littel!
View 21 RepliesI'm trying to learn more and find out if a type of database would be beneficial to use in my application.
My application consists of saving a few thousand file names, folder each one is located in, multiple tags per file, and other misc info.The concept I have in my head of how this might work is like a table. With the first column being the file name, second column is the location, etc, etc. Is this how databases work?
Is there any type of databases VB can use that don't need anything extra installed? I would like to not have to install something on my computer to just use a database. don't refer me to google or link to complex/advanced documentation that a beginner wouldn't understand. (I asked here cause I can't find the info I want easily)
I have made program who use sql database 2008 and when i want to give to someone who dont have microsoft sql server is the program will work or he need to instal sql server.
View 7 RepliesI have a large project that was originally written in VB6 using an ACCESS database. I want to rewrite it in vs2008 and change the database to SQL 2008. Someone on this site suggested that I look into NHibernate, which I am trying to do. Most of the samples are written in C#. My question is, does anyone know where I can find a sample of a project that is using NHibernate and VB.net? Or is there a better way to go?
View 1 RepliesI was maked a application in visual studio 2008 using language vb & now i want to connect with database so plz mail the steps required for database connectivity using ms access or sql server.
View 1 Replieshow can i make database on vb 2008
View 1 RepliesI wish to store all changes that were made to one database into another with datetime and the name of the user that made that changes. I'm using SQLExpress 2008 and Visual Studio 20008 (Visual basic).
View 10 RepliesI am trying to get information into a database from VB 2008. I have an established connection and have pulled fields onto my form. I am able to see data already in the database on the form. Originally, I tried to use an Update button to send the data from the dataset to the database. This did not work. I then added a Save button to the Navigator on my form in hopes this would do it. This too, failed.
View 10 RepliesI'm a newbie in programming and visual basic 2008 language.I'm learning to use sqlite database in visual basic 2008, and I got the following tutorial code. The code is working correctly and my question is: what is the meaning of that ! mark in the code. Please point to me where to get more information as I wish to learn more about that. I have Windows Sdk v6.1 installed.
[Code]...
Im learning how to work with databases. So far I've created the database (FirstDB.sdf) (without a dataset - because I'm not exactly sure what this is and why it would be needed?)
[Code]...
My Question is. What code do i need to put under the AddDataButton to get the Values of FirstNameTB, LastNameTB and YearTB into the relevant columns in my Pupil Table?
I just want to simply be able to edit a database directly using a Datagridview. That includes adding new rows, editing existing ones, and deleting rows. So far if I have been able to get one of those actions to work, the others do not. I found the codebank entry by JMC and I am trying to use it to connect to my database. I have a bindingsource, a dataset, and tableadapter created via the designer. Now I need to figure out how to combine all these components.
VB.NET
Imports System.Data.SqlClient
Public Class Form1
Private connection As New SqlConnection(My.Settings.Database1ConnectionString)
Private adapter As New SqlDataAdapter("SELECT ID, Name, Quantity, Unit FROM StockItem", connection)
Private table As New DataTable
[Code] .....
how to do a database a network? in a library system, when the student searches a book in a datagridview then, when they borrow books, they click the borrow then it borrows. Then it would reflect the students name and the book that the student borrowed in the librarian form. how is that?
View 1 RepliesI`m developing an appication which works with a mssql server database.At this stage I don`t have a problem connectiong to a database, because it`s on my computer.But the release version will be installed on few computers, when after installation user will have to choose the correct database to use with the application. I know how to find a working instances of MS SQL server in LAN, but after choosing an instance how to choose the correct database?
1. How to show databases availabale in th instance?
2. How to separate database designed for my application from all other databases in chosen instance?
When you are working with a database, is it then possible to make the program save stuff, so when you close and open the program, it could etc. save a text in a textbox?
View 5 RepliesI'm trying to add a new record to my database, below is the code i have but it doesnt seem to be working. I dont even get the message box saying new record added.
''BEGIN DATABASE CONNECTION
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = W:Textvertisingdatabase.mdb"
[Code]....
The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it does save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program.[code]I'm only trying to get the ID column populated, the rest should be fine as they're all from textboxes.
View 8 Repliesi want to connect to a database i have in my site and once the user connects it goes to form2
View 2 Replies
