i started on an apllication that reads from a access data base and displays them on the accordinf textboxes.i have always used text files to save and retrive data but i heared somthing about sql and that its much easier, i have looked through the net and read through many forums and thread but i can not find and example of hwo to use sql
I'm working on a tool that allows the user to connect to his SQL database and edit some of the database values.First here's a screenshot of the GUI (you can see my problem as well):
I am using VB code behind in Visual Studio 2008 to process data but can't figure out SQLConnection problems. I copied and pasted the connectionstring for my database from the explorer properties window but when I paste it inside the parenthesis of SqlConnection() it gives me an error. Also if I name a variable " dim myconnect As New SqlConnection" in does not give me all of the methods or attributes that are associated with it. Is this a Express Edition limitation or do I need to make some specific declarations to get it to work. this is what I have so far
Dim connectString As String Dim myconnect As New SqlConnection()
[code]....
myconnect. If I try to put open() at the end of this it says its not a member of SqlConnection. I have a dataset but no way to insert into the database
I am trying to connect to a database in VB 2008 express the book I am using is for an older model of VB. The book says to go to view and click on server explorer, and then a database wizard should open. VB 2008 express doesn't have a server explorer under the view section. I know what code I need to enter into to the two buttons I have I just do not know how to open the wizard.
I'm a little new to Visual Studio, and want to learn how to connect VB 2008 or VB 2010 to a SQL database. Are there any books or online lessons that teach how to connect Visual Studio to a database?
I have a database setup on my localhost hosting [C:xampp] and I want the mysql server from that to connect to the my one on Visual Basic 08, wait no - the other way round. I want Visual Basic 08 to connect to my database which is hosted locally via my computer.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed...
someone gave me a link to changing the database connection using an instance. When I tried to type what the instance of my SQL server 2008 I must have put the wrong information into the database connection instance.
What is the database connection instance called for SQL server 2008?
i allmost completed my vb project with an access database..Now I put a password on the database, but i can't connect anymore.[code]How can i set a password to my NavsitDataSet..so i can connect ??
I have created a login screen but I need to connect a database that hold all of the login information to the form on visual basic. My question is how do I connect the two together so that it works like a e-mail address acount like on google's gmail?
I am not sure what I am doing wrong I can connect to my database on my personal computer yet I am unable to have someone else use it without getting an error. system.IO.FileNotFoundException: Could not load file or assembly 'MySql.Data, This works on my PC so I am not sure what I am not including in the project when I compile or what?
i used this code (below) but it have error on this line "dAdapter2.Fill(dSet2, "BPC_EMPLOYEE")"
Dim ConnectionString As String = "Server=bpc-k2;Database=FIXED ASSET DISPOSAL;Integrated Security=SSPI" Dim mySQLConn As New SqlConnection(ConnectionString) mySQLConn.Open()
I am a new member here and i would like some help with my problem, i am working on my graduation project and it is about mobile learning, i'm using visual basic.net and using the sql database i want to connect my data base with the form in visual basic, how can i do that.
I developed 1 new project i.e workstation project.I have one sqlserverce database i.e workstationProject.sdf.In this database i have 2 tables i.e demolist,userinformation.In demolist i have 2 columns i.e domainid,domainname.
In vb.net form i found Currentuser information.information coming like this kenu387901.ken is the domain in the domain list table.i want the following code.1)how to find out ken is domain list table or not.2how to use demolist table in vb.net code.
is it possible to connect the database which in different form. For example which form1 make the connection to database and while form2 make the data update and retrieve from the database.Or another example, is i login as manager and i open up the manager form, in manager form we will establish a connection. and in the manager form there is 3 different buttons and each button will open up a new form. in the new open form we will be able to add or edit or view the account data and exit. but using the connection that make at manager form. Can it be done?