I want to create a global connection class from Sql server database to vb.net to make it easy in later editing the connection. Could anyone guide me the way to code both creating and calling to individual form?
View 1 RepliesI've inherited an application that uses a global database sqlconnection object in order to access the database from every form in the application. The connection is established when the application starts.I think to have the connection open all the time it's not good practice and I would prefer to change it so I would open the database connection and close it every time I need to access the database.
Public Sub UpdateDatabase(ByVal command As SqlCommand, ByRef NumError As Double, ByRef DescError As String)
Using connection As New SqlConnection(connectionString)
Try
command.ExecuteNonQuery()
[code].....
I send the SqlCommand object to the method instead of a query string because I can add parameters to an SqlCommand object.
I am using Microsoft Visual Basic 2010 Express. I have a WPF-based project. I have a successful connection to a database in Database Explorer, and a working existing Data Source in Data Sources.
I created a datatable from the datasource using this code:
Dim roster_table As New DataTable("AGENT_ROSTER")
I can manipulate this datatable just fine, but I cannot figure out how to save its data to my database (agentroster.sdf) since the connection is on a global level, and isn't declared in this particular window.
How do I update this database from the datatable on this window?By the way, I tried creating a connection on this window's code, using the exact same connection string as the successful globally-connected database, yet it said that it couldn't connect.
After running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
[Code]...
I am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[Code]...
I am trying to connection to MS SQL SERVER 2008 database (students), i want to make sure:
1) If connection string that i made is OK
Dim connectionString As New SqlConnection("server=X86ONX64; database=students; Integrated Security=True")
2) How can i check if dataset is producing any results?
Code:
Public Class Form1
'Connection String + DataAdaptor + DataSet
'Declared Outside Any Subroutines/Functions
[Code].....
I've just started ASP.NET for real, and I was wondering if it is possible to use connection strings from Data Sources instead of hard-coding them. I've added my connection in Data Sources and it works, and I can also drag a table to a page in design mode, but I can't figure out how to access it in code. Here's what I get when I drag it in:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display.">[code].....
I have Visual Basic 2010 Express and SQL Server 2008 R2 (not Express) installed on my Windows 7 machine. In Visual Studio, I am attempting to create a Data Connection to a database in SQL server. Server Mgmt Studio is not running. When I attempt to add a connection in Database Explorer, to the AdventureWorks _Data database, I get the message "This file is in use. Enter an new name or close the file that's open in another program." There are no programs running except VB, except maybe for the SQL Server engine running the background.Please note that I can open and access tables within a database in code
within Visual Studio, I just can't add a connection in Database Explorer.Am I doing something wrong? I've been very frustrated on this issue for a long time
how to connect wampserver or phpmyadmin localhost to vb.net. I mean adding, searching, deleting, updating, listing of data from the localhost database via vb.net?
View 2 RepliesI want to know how to connect sql server 2005 to vb.net windows application
1)is there any connection string ?
2)if so i am using windows authendication in sql server 2005 management studio so am not entering any user id and
password to enter in sql server
3)so what should be the userid and password for the connection string can any one send me a sample code that i can refar
I am trying to connect a VB.NET 2003 Oledbdataadapter through the wizard to a SQL Server 2005 Database, but i get an error message during the wizard.These are my steps:New Connection, Select provider (Microsoft OLE DB Provider for SQL Server), Select Connection:server name, log on: use windows NT integrated security, select database. I do all these steps then click "test connection" and it is fine, but when I click "ok" and error message pops up."Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access Databases with this version of visual studio."
View 3 RepliesI am doing a project on window application but the problem is that I want to connect the connection of database to the SQL Server database. Does anyone knows the connection strings of the connection.
View 10 RepliesHow to change read_only to read_write in vb.net SQL Server database connection? Error message:
Failed to update databse because the database is read_only
i make a connection with SQL server 2005 database using Wizard in Express Edition 2008,I have got data in my text field using dataset , but now I want to execute query for insert, select and update but I don't know my connection vaiable and how to execute query and get data .what kind of connection is this Adodb or oledb etc
View 5 Replies[i][b]I have always developed apps for desktops with an access database on one server for one company or sql server. I had one connection string. Now I am in a situation with multiple clients using my software on their own server. This means different connection strings can anyone suggest an efficient way to do this without changing connection strings for each server throughout the application?[/b][/i]
View 1 RepliesI am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file. It should allow user to select server type, server name, authentication, user name and password. It should also automatically load available servers and domain login by default.
View 11 RepliesThis will happen at random, and I can always just catch the error and re-establish connection to the server, but I am confused as to why. When doing lots of inserting into the sql server, I only establish one connection that is public, instead of many little connections. I had my doubts on a public sql connection, but it's been running great, and I've seen no problems until this morning. Again, this random moment I hit an error that stated, sql connection state is broken. Is it bad practice to just accept this error, and when it happens, re-establish the connection?
View 7 RepliesThis emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
I have simple code that connects to Sql database... (well it doesn't)
VB
Dim objConn As New SqlConnection("Server=localhost;uid=***;pwd=***;database=***")
objConn.Open()
ERROR MESSAGE:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)But looks like something is wrong with "localhost" thing. Any help? Where can I get name of (my) server?
Is there a way to display the connection properties dialog for connection string browsing(for database) in run time?
As I want the user to be able to connect to various database using the GUI.
I am using VS2010 and have been watching and learning from Beth Massi's great videos. I have built some test apps using her example of (under Server Explorer) - right clicking on "Data Connections" and selecting "Create New SQL Server Database, and in the server name just like she does, I type ".SQLEXPRESS", fill in the "New Database Name" and fill in my fields, build my tables, build a simple little windows form app. add new data source, etc. and everything works great. Then I try the "Add Connection" option again under Server Explorer and use the default (for me) of "Microsoft SQL Server Database file(Sql Client)", fill in a database file name (it creates a new one for me), "Test Connection" works, build my tables etc, and then build a simple little windows form app. add new data source and everything is great once again. Except I am not sure what is actually happening between these two options. Under the "Create New SQL Server Database option I see (in Server Explorer) a "myapp.dbo". Where is the actual database file? Under the "Add Connection" I see a "myapp.mdf" file in the Server Explorer. Also what happens when I "Publish" (deploy) my app? When I look under application files under Publish, I see the .mdf file listed as "Required" under the "Add Connection" option, but with the "Create New SQL Server Database" I don't see any database files listed? What is the difference between these two ways of creating a database for a VB Windows Forms Application?
View 3 Repliesevrytime i add new controls to a form in vb.net the designer regenerates code and asks me to make corrections, so i have to keep on changing the object declarations to global using the 'global' keyword evertime it regenarates code,especialy dataset objects.how can i prevent this?
View 1 Repliesi could use Global x as string in vb6 in a module to declare it with global privelages, how can i do this in vb2008? how to declare a global variable in vb2008? so that i could use it anywhere i want. i know global variables are not recommended in programming but i need one.
View 4 RepliesI am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
i am using access database for my program. now i have connected to the database in MDI form of main exe, and ir also works, user can log in, it gets verified etc etc etc. now here is the problem, when i load a form from dll and try to use any sql query on that form, i get message, "database connection is not opened". so what i did was, i added the connect() (a function i designed to connect to database) in the load part of the dll's form, it made the trick, query's started to run, everything went fine, and when i reload the form i.e after closing the form, i load it again from MDI form, i get error, connection already open..
[Code]....
When I fill a ComboBox the usual way, I am able to get it to work but when I try to make it a public sub so that it can be used over and over again, I am getting no where.[code]
View 9 RepliesI have finally got my code all working, but there is just a quick query really. At the moment I have all the database stuff in each form seperatly. When I place it in a global module, it looks like the dataset is being duplicated I was wondering why this happens when I place it in a global module?
This the code I use and the code I would put in a global module
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
[CODE]...
I am working on a windows application project on NIST time synchronization, but can't get a proper solution for it. If anyone can send me the code to synchronize time from the global time server in VB.net or C # code
View 2 Repliesi started programming with .NET (i have express edition) and wanted to make a connection to an SQL Server..previously i had .net 2005 - i started having the issue there - i unistalled it, n installed visual studio 2008. I have installed SQL Compact that came with the .net 2008, and besides it SQL Server 2000.When I try to make a connection to the SQL Server, if server is running I have to stop it and then choose the DB i want to use. (if its running wont let me choose any DB). Then, when i select the DB i need, Im getting this error:
"The instruction CREATE FILE fount SO error 5 (failed to retrieve text for this error.Reason:15105) while trying to open or creating the fysichal file : -path- to northwnd_log.ldf. Cant open the new database -path to northwnd.mdf. CREATE DATABASE discarded.Error while trying to attach a DB automatically named for archive -path to northwnd.mdf. There already exists a database with the same name, cant open the specified file or it is in a shared UNC resourse.File activation error. File name -path to northwnd_log.ldf- might be wrong"And when i try to connect with the SQL compact edition that came installed with the visual studio, im getting this error:"Can not allow access to the file in DB [File name = path to northwind.sdf]"
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]...