How can I change my connection configuration of my datasets and project. I mean, my datasets are not hard coded, I am using dataset wizard. Now, I have to change the computer name to IP.
I am worried that it could give a destruction to my project. How could I change it easily and safe?
Receive 'ConfigurationManager' is not a member of 'Configuration' in VS2008.I read all of the topics in the forum about this error Tried adding areference to System.Configuration.dll to the project and an "Imports System.Configuration" to the vb file.Still get an error
View 7 RepliesI am creating a VB windows form applications , the working can be summarized as users fills some form and data is saved in sql server database.Now the problem i am facing is that i have to deliver this as a setup file to someone, and that person will further distribute it to different users to run on their PC, what i am thinking is that the code once installed on other computers and executed will give errors because of the connection string of sql server db as it will not match with that computer . I know that if a distribute projects i can put connection string in app.config and every user can change it according to his/her machine .But as i am giving a setup file how to solve this problem
View 1 RepliesIn my earlier project I was able to change the connection string during the app settings loaded event and it was successfully. When I try to do the same for a code library project, I am not getting the system.configuration.connectionstringsettings to work. Could you please tell if there is a work around for this, or else it is always better to write the sql code instead of depending on the adapters etc.
Additional information: Clients App is WPF with Vb. Database is SQL Server 2008 Code Lib would only be on server, slq connectiona and data retrieving and saving actions are stored in classes in code lib only. Code Lib would be used with WCF, wcf is used to share the classes only and classes have the data. WCF is hosted as a windows service on server used by NET.TCP
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 have set the connection string of my dataset(typed) asData Source=MyHomeServerSQLEXPRESS;Initial Catalog=dbTestSharing;Integrated Security=TrueThis is going to be a client side application. I need to change the machinename in the connection string so it could connect with server.
View 1 RepliesI have declared a dataset (let's call it 'Fred') as public in a VARs module. In the main form in a sub routine called at the start of the project I connect to an Excel spreadsheet and read it into the 'Fred' dataset into one table (called 'Table') I then bind the dataset table to a datagridview and I can see the spreadsheet. Which is very nice :-)
Having loaded the dataset I want to be able to get some values so I created a button and used the following
msg = Fred.Tables("Table").Rows(0).Item("Name")
I think this should get the value in the first row and in the column called 'Name' in the table called 'Table'
But I get an error when I click the button 'Object reference not set to an instance of an object' which I think means I need to use the 'New' keyword...
So I added to the button
Dim Fred = New DataSet
But I get the same error.
Now I have to admit that I've never really got my head around how to use the 'New' keyword and would have hoped to be able to get data from a dataset through my entire project - especially as I've declared it as 'Public'. Surely if I use 'New' all over the place then I create new datasets
I'm working on my first real vb.net project, after years of using VB6. I'm using Visual Studio 2008. While I've been learning, I've added lots of DataSets to my project and then realised I'd got something wrong, so I've added, and begun to use, a new one. Trouble is, I'm not sure now which ones are used and which aren't.
How can I identify which DataSets aren't being used, and then what is the best way to remove them cleanly? Or should I stop worrying about tidying up and get on with the development work? ;)
How To Editing The "Connection String" in the Configuration file by the Code in the Runtime. This is my Code
My.MySettings.Default.Item("ConString") = "New Connection String"
My.MySettings.Default.Save()
This code can edit the Configuration file in the run Time but if I restart the system the Configuration file will return back to the first Configuration.
When connecting to data I always like to use the Configuration methods:
2005
Dim settings As ConnectionStringSettings = _
onfigurationManager.ConnectionStrings("csCambra_2")
[code].....
I have a dilemma. The program I"m trying to complete is one VB project with three (3) forms. The first form will act as a menu dialog box. The other two forms will have a dataset (database) on each form. The first form will have a button when clicked it will pull up form 2 and the second button when clicked will bring up form 3. What I add the dataset to form 2 everything is fine. I can see my tableadapter, dataset and so on. Now, when I add the second dataset (database) to form 3, I loose my, dataset and so on. It doesn't appear on any of the two forms (in designer)tableadapter.
View 1 RepliesWhilst playing around with DataGridViews in VS I've accumalated quite a few TestDataSets within my project.
Can someone please tell me the correct way of removing these cleanly? At the moment I've been Right Clicking a DataSet (from within Solution Explorer) and either clicking 'Delete' or 'Exclude From Project'
Doing this throws up Errors in the Error list such as;
TestDataSet is not defined
TestDataSetTableAdapters is not defined
TestDataSet is not defined
TestDatasetTableAdapters is not defined
I then double click each error in turn which takes me to the actual code with the error and delete this.
I have quite a lot of TestDataSets and I'm hoping there is another way to do this much cleaner.
I am looking to make a data connection with a network server(sql server 2005). When I run the data source configuration wizard, it allows me only to pick a local database file. I want to use a connection string like this "Data Source=SQLSERVER;Initial Catalog=mydb;User Id=username;Password=password;" I know I can do that programmatically. But I would like to know whether I can do that using the data source wizard so that I will be able to use Bindingsources and tableadapters.
View 4 RepliesFrom my DLL project I have succeded in making AutoCAD launch by pressing F5 from VB.net IDE (Visual Studio 2008) en route to try to make debugging of the DLL easier ...
... however one last obstacle is currently in the way and the obstacle is that for some reason when I hit F5 and AutoCAD is launched my breakpoints are not recognized at all... and program runs from start to finish instead of allowing me to debug ...
It issues a strange message which says "The following module was built either with optimizations enabled or without debug information... to debug this module, change its project build configuration to Debug mode..." and it is all weird because as far as I know I am not in release mode .. but in debug mode (anyhow I am relatively new to Visual Studio .NET so I am thinking that my impression could be that I am in debug mode when in actuality I maybe in release mode)...
Here is why I think I am debug mode ...
1. From Solution explorer ... when I click on the Solution Name and view its properties ... the Active config property says Debug|Any CPU
2. When I look at the properties of the project and look at the compile tab it says that the Configuration is Active (Debug) and under Platform it says Active (Any CPU).
3. Under the Advanced Compile Options of Compile Tab from project properties ... Enable optimizations is UNchecked ...
Anyhow with all the settings mentioned above it seems that I have everything okay but then the message above proves otherwise ... and so at this point I know that I am still missing something ... like a setting somewhere... wondering what else do you think am I still missing?
As additional info...there are seven projects in the solution and it is the main one (the one that I set as startup project) whose properties I refer to in all the paragraphs above.
An error that arises when I take a vb project Visual Studio 2010 that works on my local machine to a server. How precisely would I work around it?
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately.
Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Source Error:
Line 24: ASP.NET to identify an incoming user.
Line 25: -->
Line 26: <authentication mode="Windows" />
Line 27: <!--
Line 28: The <customErrors> section enables configuration
I have a vb.net 2008 desktop application to make changes to it. Since the production database will be changing within a month, I know that i need to change the .net remoing.
1.I change the configuration manager file (app.config) in debug mode to point to the 'new' test database, however the changes are not pick up. The application is still pointing to the current database. Thus can you tell when what kind of files.I need to change so that this application picks up the 'test' data base?
2. After I have tested the changes that need to be made, I will need to deploy the changes. Thus i am assuming that I will need to do something different so I can put the application changes into production. Thus, can you tell what kind of extra dlls,exe, xml, and other files I will need to include in the deployment package? Is there anything else I need to do in the deployment package? This application uses .net remoting to have the database connect to the various proejct files in the entire solution file.
well until a few day ago. I don't know what I have introduced to cause the problem but now, whenever I load the project, VS 2010 (SP1) crahes. If I delete the project's suo file, the project loads (really quickly) and all is well until I exitVS 2010. When I re-run it and try to load the project, it crashes again unless I delete the suo file.The program can be built for x64 and x86. Now, when I reload the project (after deleting the suo file), it comes up in Debug - Any CPU mode. I can change from Debug to Release and from Any CPU to x86 but if I try and change from x86 to x64, VS 2010 crashes.This is not always the case though. If I build the x86 version and then switch to x64, all is well and I can build the x64 version. Obviously, there's something wonky going on.
View 7 RepliesI am writing a program to automatically switch my proxy address based on the network I am connected to.
I have so far got everything to work except the part that I have highlighted below.
Is there any way to change the automatic configuration script and the automatically detect settings in code?
The solution can be either P/Invoke registry editing. I just need something that works.
How To Editing The "Connection String" in the Configuration file by the Code in the Run time
View 1 RepliesI want to use "System.Configuration.ConfigurationManager" in my project, but when attempting to use it, I get the error "ConfigurationManager is not a member of Configuration".
[Code]...
I have 3 components :
1.Manager : dll containing Iterface definition and other things
2.Implementation: dll containing Implementation of the Interface
3.Executable: (maybe this one could be a external application or another dll using the libraries)
I have particular methods (iside the interface dll file) that extract information of real Implementation from AppSettings keys in order to instance it using reflection. I use the Manager inside the Excecutable, but when I try to retrieve a especific key defined in "Manager.dll.config" (appSettings), the value returned is empty because the configuration file used is "Excecutable.exe.config" I need this configuration information in Manager config file because this Manager will be used from other programs and the configuration must be centralized into that config file to replicate the possible changes to every app calling this dll.How can I to specify that the ConfigurarionManager.AppSettings must extract values from manager.dll.config file?
I get this error
Format of the initialization string does not conform to specification starting at index 34.
When I take my connection string and store it in the project settings. I know that this works.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Employees.accdb
Because if I use it like this
Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Employees.accdb")
conn.Open()
The connection succeeds but if I try this
Dim conn As New OleDbConnection(My.Settings.Default.employeeConnection)
conn.Open()
I get that error.
name:employeeConnection
type:string
scope:application
value:Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Employees.accdb
friends i m a newer for dotnet...and i m a student i m creating a project with a simple database connection
i need to make a setup of that project but whenever i create a set up it wont connect with my database
it'll shows a error how to make a setup in vb.net with a project with a database connection
I am creating a custom config section that will allow me to manage what ELMAH exceptions I want to ignore from my VB.NET/ASP.NET app. Here's my code. I made it easy to paste in a blank code file if anyone's up to the challenge of diagnosing the problem.
CODE:
When I execute this code:
CODE:
I get the error An error occurred creating the configuration section handler for IgnoredExceptionSection: Could not load file or assembly 'WEB' or one of its dependencies..
What boggles my mind is that this all works fine in my C# console test app after I convert the code from VB.NET using a web utility. However, when I paste the VB code from my web app into my VB.NET console test app, it doesn't work there, either, so it appears to be a C#/VB issue. What am I doing wrong here?
I have some questions about mysql database; I have set up columns and rows on mysql database and I would like to make mysql connection for a test before I would release the project in the near future, but my doubts is that how would I be able to keep mysql admin username and password details secure in the project without anyone could find out??Secondly, I don't want anyone to crack my project to get the details, which it will put me and other clients at risks.
View 22 RepliesI'm writing a Windows form application. I created a SQL database called myDB.mdf. The database/form connection was created using the wizard provided by VS2008. The connection string, table adapter, dataset, etc were all generated automatically. In runtime, I copied the database to several folders and I want to the application to connect to them one by one and do some data manipulation.
Here below are the relevant code I'm using:
Namespace My
Partial Friend NotInheritable Class MySettings
Public WriteOnly Property RunTimeConnectionString() As String
[Code].....
i connect the datagrid to database using wizard ..... now the connection string is in config.app.. it has a password and user to access to database .. i have login form that the user should enter the username and the password for database ... how i can join the usertext.text wand passtext.text (textboxs) with the connection string in config.app ??by default is root, root, .. but it will change and i cant modify the application every time for change the connection string ?
View 1 RepliesI'm writing a windows form application using vs2008. I need to connect to different SQL server express database files during runtime. There is a "how to do" video showing a technique for this
[Code]...
and then in the Form1_load sub and before calling the data adapter to fill data, insert codes below:
Dim strConnectingSting = NewConnectionString
My.Settings.RunTimeConnectionString = strConnectingSting
The method works but only for the first database. I found once adapter.fill is called and the connection to a database is established, the connection can't be changed.To do what I want, I have to create a startup project to call my main project. When I want to change connection, close the main project and start again.
I have developed a windows form application using VB.Net with data access layer using LINQ-SQL. I want to allow the database to be configured from the application. I have created a form for input and save the input details in an XML file.
I need to know how to configure the LINQ to start using the new configured database on startup. I have read in one of the threads here about dynamic allocating the connection string with the following solution to include in every file where the data context is instantiated. [code]...
I have an excel with 10 sheets, each sheet has a connection stored in it because i am using the ms query to read data from access database. when I code the below, both line are accepted by vb.net (with new or without)
Dim wb1 As Excel.Workbook
Dim wb2 As New Excel.Workbook
Now when I code
Dim wb_cnn1 As Excel.ODBCConnection ' Works Fine
Dim wb_cnn2 As new Excel.ODBCConnection ' Error 'New' cannot be used on an interface.
Q1: Why I cannot create New Excel.ODBCConnection? I have this
Dim xlsApp As New Excel.Application
Dim wb_cnn As Excel.ODBCConnection
Dim wb As Excel.Workbook
[code]....
Maybe because it is read only. I want that because the ms query is hardcoding the path of the access db even if i choose DSN so, if I change the location of the access file the query in the excel will not work, Q2: How I can change the connection in the Excel sheet?