I am making a window based application in vb.net. Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?
View 1 RepliesI'd like to get some feedback what you think is the best way of designing a VB 2005 application that can be set up ("scaled"?) to work with different database backends (say MS-Access vs. SQL Server vs. Oracle). For example, where would you store the connection info, where should the repository of SQL statements (which will vary slightly from DBMS to DBMS) reside, etc.
View 9 RepliesI have a rather complicated application (for me anyway). I have a word template setup with text controls. A web app with ASP controls and vb backend code binds data to the text controls using an xml file.
[Code]...
i have 3 user roles "ALGEMEEN,OZIS,VERPLEEGKUNDIGE".And I want them added to the database.But when I use the code below it only adds the userrole "ALGEMEEN" and not the other 2.
Dim cmdCheckLidVan As New SqlCommand("SELECT COUNT(*) FROM [Lid van] WHERE [Gebruikers-ID] = @ID AND [Rol-ID] = @RolID", connection)
Dim strRolArrCount As Integer
Dim strRolArr() As String
[code].....
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesI have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 RepliesI am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2003.
The code seems to stop executing at the statement cmdJetDB.ExecuteNonQuery()
I am using the following code:
Dim conn1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:Sample.mdb")
Dim conn2 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:db2.mdb")
conn1.Open()
conn2.Open()
[Code]...
Question: What is it that I am not doing. I opened both connections, stated my two SQL statements, yet it is still not working. I really need to get this application working. Please Help.........
I'm trying to select all the work's accidents between two dates, but my datatype in sql server 2000 is varchar instead datetime.
For example when i want the fields from 01/01/2010 to 01/10/2010 it shows me all the values from 01 to 10 but from other year and month. I know the easy way to do it is changing my datatype into the database but when i do it the value saved into the table is 01/01/1900.
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
I did the following
Imports System.Data
Imports System.data.OleDb
Public Class Form1
Dim con As OleDb[code].....
By this i can fetch only one row(the last row) of the access....how to modify the above code to fetch all the rows starting from the begining from the database..........
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
I have 2 Database in my VB.net application. I am using 1st database for daily operations. I would like to send one of the table records to online database. How Can I do that? First database is MSSQL Online database is MYSQL. I have created connections already using MYSQL .net connector.
View 2 RepliesOk, the basic situation: Due to a few mixed up starts, a project ends up with not one, but three separate databases, each containing a portion of the overall project data. All three databases are the same, it's just that, say 10% of the project was run into the first, then a new DB was made due to a code update and 15% of the project was run into the new one, then another code change required another new database for the rest of the project. Again, the pertinent tables are all exactly the same across all three databases.
Now, assume I wanted to take all three of those databases - bearing in mind that they can't just be compiled into a single databases due to Primary Key issues and so on - and run a single query that would look through all three of them, select a given set of data from each, then compile those three sets into one single result and return it to the reporting page I'm working on.
I have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 Replieshave a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
I have no problems getting VB to work with a database. IT:SQL or an access db file I need to get VB to read from an XML file.Ive read several different tutorials and I cant ever get past the first few steps, I don't know what i am missing
[Code]...
every single time, how ever many tutorials ive tried i always get "type xmltextreader is not defined.I have tried just segments or all of the code they list in these tutorials, same results.
I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
I am using Combobox, when i select the value in combobox, the date value should display in datetimepicker where date = combobox id
vb6 code
cmd.CommandText = "select distinct Name from T_Person where personid = '" & txtno & "'"
Set rs = cmd.Execute
[code].....
I opened vs 2008 and used the server explorer for the first time to create a connection to my SQL 2005 db. The solution explorer pulled in all the tables, the database diagram etc. My question is how do I access that database connection and work with it using ADO objects? Do I need a reference to ADO?
View 4 Repliesadd user to access database but it's doesn't work the problem here
SavInto.ExecuteNonQuery()
say a user buys a 6 month subscription to my online app. Using c# or vb.net, How would I work out what the expiry date should be to be inserted into the database.
View 2 RepliesI am trying to pull the data by date in vb.net. It is not throwing the error nor giving any result. Whereas It shows the results in table adapter configuration wizard when I try through query builder. I am using date time picker in the form. But I have formatted the date in the database as date.
[code....]
Why would database drivers work in the development environment of VB.Net and not once the project is built and installed on the same pc? I've tried the MS ODBC Oracle driver. I've tried various ODBC datasources. All work when I am in the development environment but none once I build and install. No matter whether the configuration is Debug or Release. This is the only project having this problem. I have other apps (VB.Net) that access the same database (Oracle 9.2) with no problem.The environment variables are the same during both types of runs. The error messages vary depending upon the driver being used.
View 1 RepliesI know how to make a setup wizard but when I install my program on other computers, I get an error (SQL Error).
What do I need to install on other computers other than .NET Framework and my program ?
I made a program that i want to run on computers at school and it utalizes a MySQL database. When i try to run it the program does not work as it cannot access the database. I open the code up on my computer at school and it has errors saying ti does nto recognize the MySQL code as it does not have it in its .Net library. So i try to download it into the library but that does not work. So my question is, will programs using any kind of database not work unless the user installs the needed add on, weather it be a .Net library add on or a java add on for MySQL? That cant be right it.
View 4 Replieshow to get this login to work if i add a field in to my database called UserTypes "Admin" "Normal" if they are admin if will display cmdAdmin and if they are Normal if will hide cmdAdmin this is the code i have currently?.[code]
View 12 Repliesmy problem is want to use WHERE clause to extract only year that fulfill a specified criterion. My coding as below, the coding below is extract all the month,day and year. But i only want year only. I am using MS Access. My textbox(cbYear) can select January To December. Can anyone give me a guideline to correct the coding.
sql = "SELECT * FROM sumPercent WHERE plants = '" & yieldsummary.cbPlant.Text & "' AND [b]dates = #" & cbYear.Text & " #[/b] AND line = '" & ds.Tables("sumPercent").Rows(a).Item("line") & "'"
This update command works in updating my mysql database. Another database I have doesn't have a idnum field. I'm looking for a command to select a row number in the database. For example, update row #5. How would I modify this command?
SQL = "UPDATE " & table_name & " SET " & _
"title='" & TextBox3.Text & _
"' WHERE idnum =" & TextBox2.Text