I've been able to create a datasource to a db that I have on the machine. However I can't find any place to be able to add an sql query to my connection.
I'm beginning to suspect the express version does not have this functionality. do sql queries from within the vb program.
When it comes to database connections what is the difference between closing a connection & disposing a connection? I'm hoping to gain a more technical understanding of what happens when each is called & the effect on the database.
View 5 Repliesi am doin project using vb.net 2005 and using this sql query for connection
sql = "select username from login order by username"
con.ConnectionString = "Data Source=" & hostname & "; Initial Catalog=college;integrated security=sspi"
but m getting the following error:
Cannot open database "college" requested by the login. The login failed.Login failed for user 'CI4Admin'.
I'm building application that will heavily use database (about 25k query's in few hours) , what is the best way to go:
A) use datareader and open new connection to the database on every client query.
B) load all the needed tables into dataset once the program loaded and use that dataset for the query's?
[Code]...
Im clearly opening it there and its valid as i use the same connection to login with, anyone know the problem?
I have a project in Visual Studio 2008 and there is a working data connection to a MySQL database. In other words, I can query the db directly from Visual Studio and it will display the results.
I've tried a couple of approaches that I found online for writing a connection string and accessing the db, but no luck yet.
All I'm trying to do is code a button to query the db and then reset the text property of a label/textbox to display the results based upon another label/textbox value.
The pseudo-code I am imagining is something like this:
Private Sub query_submit_button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles query_submit_button.Click
result_textbox.Text = SELECT field FROM table WHERE otherfield = key_textbox.Text
End Sub
I didn't see any related questions posted on SO - forgive me if I missed one that already exists and this is a dupe.
What is the correct way to accomplish this?
EDIT
Using MySQL 5.1
i connect the Datagridview by using command connection not coding. now i have "table3tableadabter", "table3bindingsource" and "database3dataset" below the form ? the search string " "Select * from tabel3 Where test2 like '" & Me.TextBox1.Text & "%';"" how i can do serch and the result will be shown in datagridview.
View 4 RepliesI'm new to VB.NET and am trying to do some basic Forms development and am unable to set up a database connection to a SQL Server DB. Here's the particulars:
I'm using VB 2010 Pro The database is on a server (not local). I have administrator rights. The DB version is SQL Server 2000 Enterprise.When I try to add a Project Data Source or try to add a Data Connection in Server Explorer, I can navigate to the test DB I have on the server, but when I try to test the connection, I get an error stating "The file <path and file name> is on a network path that is not supported for database files. An attempt to attach an auto-named database for <path and file name> failed. A database with the same name name exists, or specified file cannot be opened, or it is located on a UNC share."I tried using a mapped drive on the local machine to the server, and a UNC path.I tried Windows Authentication and user name/password. (Same error message in all attempts and combinations.)
Almost all the development work I've done previously has been primarily w/ VBA (Excel, Access, Word, AutoCAD). I connect to the test DB in the VBA environment either thru DAO (ODBC), or ADO.
I guess I'm wondering whether the DB has to be local? Or is there some setup I'm missing? Is it an issue with trying to connect to a SQL 2000 DB? As I said, I'm new to VB.NET development, so I hate to ask a dumb question, but I've gone thru some threads and articles but haven't found a working hook yet.
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
basically, i want to make windows app with visual basic 2010 with network database but i have no idea how to connect database like im using vb6 with sql server 2000 where i can code sql connection freely with IP address, set database, set username, set password using form that i create and save setting at windows registry for examle:
sqlString = GetSetting("xxxxx", "setting", "connection", "")
Set rsAirline = New Recordset
If rsAirline.State = 1 Then rsAirline.Close
[code]....
I have written an application that is currently in use at my work. I am wanting to clean up the code and start preparing the application to make it available to other business of the same type. I want the user to be able to set the location of the access database at install. Is there a way to make the connection string a variable that is set by user at setup? Also what is the best installer to use I am currently using one-click.This is my next step as soon as I get the limit number of logins and some sort of licensing scheme.
View 11 RepliesI reproduced the following code to update a database and I get the error" Operation must use a updateable query"
[Code]...
I have used this codes
Imports
System.Data.OleDb
Public
[Code].....
'it's not warking it gave me message {Invalid authorization specification}
can you correct me cn.ConnectionString line ?
Is there one out there? I try to include this and it says something about the Oracle connection not being compatible with the target framework. Any ideas? Or how can I change the target framework of the project without breaking the visual studio power packs?
View 1 RepliesI have a problem connecting to an access database. I'm currently trying to build a login/register program that reads the username and password from a database and allows login if the specified username and password are found. I have code that will work properly for that so that's not an issue. However, when I make an attempt to register a new username along with a bunch of other things such as email, password, etc. I am unable to because the database connection is closed. The code I'm currently using to open the database connection is :
[code]...
However, when I try to use this code to open the connection to the database, it leaves the connectionstate closed. I decided to then build in as a test, a block of code that would check on load to see if the connectionstate is open or closed. Each time I've run it so far by making a few changes it always tells me that the connectionstate is closed no matter what I do.
I have come to the conclusion that it isn't a simple 2 line code, to send a picture via a TCP/IP connection. It has to be converted to bytes, sent and received properly on the other side. In short, I've tried this, and (as you can imagine, now that I've made this thread) I failed. Here's my
Client Private Sub ConnectBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ConnectBtn.Click
If IPTxtbox.Text = "" Then
[CODE]...........
In short, I've made it possible to send strings, but... Sending Bytes and receiving them properly, I can't seem to manage.
is there a function that will allow coders to connect to multiple database? by just changing the connection string and not the variable declaration ...example:connecting to access is something like this
Dim Con As New System.Data.OleDb.OleDbConnection(ConString)
for sql is something like this
Dim Con As New System.Data.SqlClient.SqlConnection(ConString)
is it possible? acctually in vb 6.0 it is possible ...
how do i check for sql connection status constantly. Timer?
View 4 Repliesif i go to sql server configuration manager and shutdown the SQL server, the server will be down.
How do i detect for those changes using vb.
Public Sub CheckConnection()
Dim con As New SqlConnection
Dim objCmd As New SqlCommand
[Code]....
I cant make those work because the connection opens and close. WHat i want is to check if the server is alive or dead.
I have an existing system that uses an ODBC connection to connect datasets to a SQL Server database. I want to conevrt these to use an OLEdb connection.
View 4 RepliesI want to add a new Data Source (so I can use it with Crystal Reports) but using mysql, I did this before.
In the left side under: 'Data Sources' and then choosed 'Add New DataSource'Then I choose: Database > Dataset I clicked in 'New Connection' and I changed the first box (with 'change' button (as you can see in the image attached)) to what is showed in the image (MySQL Database..)The problem is, as I type the first letter of any of the textbox's that are below (server, user, or pwd) it closes that form showing the previous form (where I clicked 'New Connection')
Have someone had this problem ?I had a connection there, but since I changed the project from 'Framwork 4 Client Profile' to 'Framework 4' (so I could have the Crystal Report Viewer) the connection has gone and don't leaves me create it again.PD: I'm using dotNetConnector (already Added as a Reference)
How to use Connection string with VS 2010 during form design? Actually i added database through Data -> Add new Data Sources.And When i publish the project How to publish database too? [code]
View 3 RepliesMy program needs to connect to a mysql db, but if the users has no internet or fails to connect i don't want my app to crash
View 4 RepliesI have been using VB Express (and SQL Express) for 8 days now, and this morning for the first time I got a message that I have 22 days left and need to register. When I click to obtain Microsoft registration key I get the untrusted connection warning.Is it ok to take the add exception option?
View 1 RepliesIm currently doing a small programme of a register system. I need to add a new group box filed with a few textboxes and a couple comboboxes for each entry in a access 2010 database. for example if i had someone called bob in my database with his details i would like the GUI of the VB app to add in a new textbox for the name, a textbox for the address ect in a set order, this needs to work for multiple entry's so the textboxes ect don't overlap but be placed neatly below the added textbox.
View 1 RepliesI have codes which is written with python. I am not good with python and i want to convert this python codes to VB 2010.This python function searching local network and finding my LG TV's local IP adress. I want to find my TV's local IP with VB 2010.
[Code]...
I'm making an program to searsh trou a access db with a combobox it neet after selecting to show the wricht value in a textbox and a numberupdown
i have tried to load al data in combobox but when i select it nothing happen
I'm wondering if I create a program that connects to a mysql database, will they be able to decompile it and do anything with the mysql connection information?
View 18 RepliesI have a number of FTP routines all based on the code below. Why does this take 15 seconds to run the first time? [Code] If I use an FTP program like FileZilla or CuteFTP to connect to the same FTP server they make a very much quicker connection. Any ideas?
View 10 RepliesI'm creating a database management program and I just got started. I will be using a login form and a form that is the management part. The MySQL connection will be created on the login form and I was wondering how to get it to the other form. What I thought I should do is create a public mysqlconnection property on the login form and just use it from there. I don't think I have ever known the correct way of transferring a mysqlconnection over 2 forms.
View 2 Replies