I'm trying to connect to a .MDF database (created via VS2010), but I'm having some issues.
My code is simple:
Imports System.Data.SqlClient
Partial Class MasterPage
Inherits System.Web.UI.MasterPage
[code]....
I get error on line connection.Open().
The path of my DB is App_DataVisitas.mdf
It may be my connection string.
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 RepliesTrying to connect to my SQL database.Receiving this error:[code]No idea how to fix this, any ideas?
View 22 Replieshow to connect vb.net 2010 to ms access database to get the data and display it in vb.net application that I am doing right now. My project is that I am doing dictionary application with vb.net so every time i put new word in search box, I want the vb.net to get the definition from ms access and display it in the application.
View 1 RepliesI have connected the database itself without much issue but i want to be able to edit, add and eventually delete from the database using Visual basic interface. This is for an A Level computing course that i teach, i remember a long time ago when i did the course this was fairly simple to do however i cannot for the life of me figure out how to do it at the moment. This is further confused by office 2007 and VB 2010 both of which didnt exsist the first time i did this.Connect 2010 to an access database?
View 4 RepliesI'm using the latest version of the MYSQL DotNet Connector (currently 6.3.7) and I am unable to connect to my database at all with it. It keeps giving me an error. I can connect the the database using SQLyog with the exact same information but not with this.
This is the error:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Here is the code I'm using:
Dim conn As New MySql.Data.MySqlClient.MySqlConnection("" _
& "server=mydomain;" _
& "user=myusername;" _
[Code]....
I want to connect to a mdb file but i have never did that before. i don't know where to start. heard something about ado.net and some other things.
the file is a 2003 access file if i am not mistaken. and it is shared on network. so multiple users (not too many, max 50) will use it at same time. what is the best connection to use? i have to mention that i don't want to use data controls. i want to use sql commands to fetch data and manipulate data on the form controls myself. i know there are various connection ways like strings and adapters. not sure which one is better.
I want to use a connetction string for connect a databse in sql server express by vb.net? My code is : Cn1.ConnectionString ="Data Source=.SQLEXPRESS;Integrated Security=True;Connect Timeout=30;User Instance=True" but i when open then connection i see this error Cannot open user default database. Login failed. Login failed for user 'Shahab-PCShahab'.
View 6 RepliesSubj.There is no knowledge that is not power.
View 3 RepliesI am using VB 2010 Utimate on a Win7 64bit machine. I have an accdb database created through MS Access 2010 (database has a password). How do I go about connecting to it using codes without having to drag a database control on the form, also is it possible to code my form so that it will automatically detect the path of the accdb database? Also I want to view the whole table using datagrid view as well as perform database actions such as add, edit, del, save, search and etc.
View 7 RepliesClient form need an access to the ms access database located at the Server. I've just created a database in MS Access in the format .mdb, 2000 version. Forms created in the platform Visual Basic 2010. Kindly post procedure or source code to do it. I preferred to use OleDB connection since i used it on a stand-alone access to database.
View 4 Repliesany one here can help me to make access database and connect it to a visual basic 2010 program and update and retrive information from it
View 2 RepliesFirst off, my apologies for being a complete Newb! I have a SQL Express database that I use quite successfully to track my investments in several accounts. I built it myself, it's quite functional, and Im happy with it. The problem is that there are multiple account tables and updating them can be tedious in SQL Server, if multiple purchases and sales in multiple accounts have occurred in a month. Tedium can lead to errors¦
[Code]...
I just purchased VS 2010 Professional. I was using 2010 Express and i used to use Crystal Reports 9 to create my reports. My problem is that CR9 does not allow me to connect to the new MS Access database (accdb). It only lets me connect to .mdb. I used to use .mdb but i have upgraded to MS Office 2010.
[Code]...
provide me a simple code to connect .net and MSAccess? also provide me the details of where to find ADODB control.
View 6 RepliesI'm using OLEDB to connect to an MSAccess database and would like to know which is the correct syntax to get a value from the database and store it into a variable. I'm using the following syntax but it is not working: getStock = "SELECT Stock INTO " & stkActual & " FROM PECAS WHERE PECA_ID = " & Val(Me.PECA_IDTextBox.Text)
View 4 Replieshow to create a program that can access information held in an excel database and show it in a simple form.
View 2 RepliesI'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):
[Code]...
I want to create program in vb2008 express with ms access database. Can somebody help me so i can learn how to program using classes hard coded. I have learned vb6 before but it has a big difference on vb2008.
I have a database named "DATABASE" in ms access 2003 and the details are: Table :
EMPLOYEE(EmpNo, EmpName), DEPARTMENT(DeptID, DeptName), CATEGORY(CategoryID, CategoryName), SUPPLIER(SupplierID, SupplierName), ITEM(ItemID, Itemname), ITEMLIST(ItemListID, ItemID, ItemDescription), INVENTORY
[CODE]...
All the CAPITALIZED name are Table and all items inside the parenthesis are fieldnames. I don't know where to start on working on this RECORDS. I was able to understand visual basic 6 a bit, and i am trying to apply the coding to VB 2008 but all i get is errors. I am hopeless now and i need help to be able to start my programs. If someone can give me a sample code, i think i would be able to trace the line of code to be able to understand it. I am currently an inventory manager on the small company i was working with and i like to organize my record by using database.
I have loaded my database with one table under "Data Connections" in the "Server Explorer" pane.What is the standard / best-practices way to handle a simple query in a VB ASPX page?
My left <div> would be a set of form elements to filter rows, and when the button is clicked, the main <div> would show the columns I want for the rows returned.
Note: Answers in C# are okay too, I'll just translate.
I just want to be able to click on a commandbutton, menu_item, or maybe even a wizard at program install time, to make the database from scratch.
1) I do not care what type of database it is it is as long as it will run on any pc machine without having other programs installed except the one im creating.
2) I do not want to use access or the designers to create the database either
[code]...
How To Manage A Simple Database
View 1 RepliesI try to keep it short - so far I got an app. which receive, compare and send STRINGs back and forth. Due to the fact that I am not too fit in VB, I realized it via a SELECT/CASE method. But now, I would like to allow user to add new STRINGs from the user plane as well (before it was done by myself). I can imagine, I need a database for it. Which one would do the job best? I need only two columns, where my app. can send a coulmn B string back, after it recognized a column A.
View 7 RepliesNeed to create a form and connect the form the database on the click of a button. I have created the forms and data tables (Attached).Also want to know how can i open a form on double clicking an entry in the list box.
View 4 RepliesHow to do a simple log in program in netbeans using java database ?
View 1 RepliesRecently, someone asked me to code a program for them in Visual Stuido. What they need is a program that allows them to enter names, and each name has to pick a option (i was thinking that the user would select a radio button) and each option could only be selected a limited number of times.
View 8 RepliesI am here to write a small database application that will be running in desktop (offline mode).I am using MSAccess 2007 as my database file and trying to write code in vb.net.I used to write the code vb6 an usually had global variables for storing database connection and executing every query from that.I am trying to upgrade myself from vb6 to vb.net.do i need to read some more simple starter books also?
View 3 RepliesI'm looking for a front-end that's very simple, to access a to-be-built MySQL Database. I actually need it for only one table. I was thinking that the user could search in a way that would ask for values for each field of that table, and give the option of leaving it blank. Then, it would return all the entries that match up with the query.
View 3 RepliesI know this sounds simple to the majority of the database gurus out there but I am finding it difficult to find anything related.I am using Visual Studio 2008 VB.net winforms application.I have a form which contains a datagridview. what I want to do by push of a button is set the field "OnHand" either to default or 0. The 'either or' is really for you guys. Which ever one works the best in terms of reducing code or functionality is obviouls prefered.Once the 'OnHand' Fields in every record has changed then I would like to save all the data back to the database'This is more than likely very simple I just cannot find anything that discusses this kind of thing.
View 1 RepliesIm just doing some tests to connect to a mysql database.I do not know how to call these values once I have made the sql query. How do I go about this, i.e. to show the values on the labels on a form?
Code:
Imports MySql.Data.MySqlClient
Public Class Form1
Dim ServerString As String = "Server = localhost; User Id = root; database = CALIBRA"
Dim SQLConnection As MySqlConnection = New MySqlConnection
[code]....
What do I put in the "SOMETHING MISSING HERE"?