I've created two forms of which two separate datasets/tableadapters were created by adding a datasource and dragging and dropping the fields onto my form.I was testing the program using a db that was located on my local drive. Well after publishing the app to the users machines, I noticed that the binded information was still being pulled from my local machine and not the database that the user is working off of.I've set the connection modifier properties for both tableadapters to Public, and I have written the following attempting to change the connection strings:
Private Sub btnSaveSettings_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveSettings.Click Dim pap As New frmPap My.Settings.dbLocation = txtSettings.Text
I'm trying to change my connection string to w/e the user wants. After a few tips here and there, this is what I've come up:
1: In my settings I've added - Name(login), Type(String), Scope(User), Value(Nothing)
2: Here is the code I'm using
Private Sub LoginForm1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Here I'm checking if the login in my.settings is there 'If not, I'm going to let the user choose what database
[code]....
The error I get is: Format of the initialization string does not conform to specification starting at index 0.here -
Dim con As New OleDbConnection(My.Settings.login)
When I have my con equal to when I added the datasource from it works.
im currently working on my thesis and i just wanna know how to avoid changing connectiong string? we are 4 members in a group each time that my other groupmate try to run our system in their own laptop/desktop they always change the server name. i wonder what if we implement our system in any computer? how were going to handle that?
For example i have form within the application which shows the connection string in a text box so the user can change it to there database but i cant work out how to save the new string to the connection string within the app.config file
I developed a winform application and I want to send the .exe file to someone else. That means that my datasource for my connection string is not the same any more
Dim da As OleDbDataAdapter Dim dt As New DataSet Dim objConnection As OleDbConnection = New OleDb.OleDbConnection
This is regarding a windows app in Visual Studio 2005, a VB Windows application.'ve stored a connection string called strSQLConn in My.Settings. I'm trying to change the Server in code. I set a string variable called strConn to a new Connection string. My.Settings.Profile2006sql = strConn
This produces an error saying that My.Settings is readonly. I'm missing something basic here.
I don't know if this is the best way to change a connection string to toggle between a development server and a production server. My understanding is that if the setting Connection string is changed it will be used as the default for all the table adapters in a strongly typed dataset. Is that the case?
I'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 read through some other post and haven't been able to find an exact answer that I am looking for. I have a connection string saved in my.settings that I am using. My database is residing on a server. Now I am going to have to install this application at more then one area and they will have the database on their server. What I am wanting to do is for the application when it is loading to search the network to find the database and return the connection string without the user having to do anything. I know with a web application you can search the machine you are on for the connection string without knowing its location but was hoping there was some feature like that to search the network to find it.
I have a project that is executable and I created a dll, which includes commonly used datasets among projects (DLLforApp and App). [DLLforApp]a separate project from App but in the same solution.this is a class library project which creates a dll file this has aconnection string which is LforApp.Properties.Settings.Default.ConnectionString[App]another project in the same solution.this project includes a reference for a set of datasets.. which is DLLforAppThis project also has a connection string which is the same as DLLforApp
I have two seperate databases, one is production the other is test. Before LINQ, I could simply change the connection string to swtich db's. However, the string is read only, and I have no way to change the string.
How can I change the Connection String programmatically?
Edited for Clarity
Im using my.settings to store all of this inforomation
I'm sorry but Microsoft did not think about this very well. I have used the dataset wizard to connect to my sql server and the connection string was placed in the app.config file. The only problem with this is that you can not write to it nor change string at runtime. So I need a way for each one of my users to specify their connection either during installation or after installation. I would appreciate any help in this matter.
I need to be able to change the connection string of a strongly typed dataset at runtime. I have gone into the settings.vb page and written this code:
Namespace My 'This class allows you to handle specific events on the settings class: ' The SettingChanging event is raised before a setting's value is changed. ' The PropertyChanged event is raised after a setting's value is changed. ' The SettingsLoaded event is raised after the setting values are loaded. ' The SettingsSaving event is raised before the setting values are saved. [Code] .....
The way the code is suppose to work is that when a user logs in, the application gets the user's site ID (gvUserSite), then uses that to set the connection string. But when I log on with a SiteID of "21" it always uses the Case Else value. Also when I set breakpoints in settings.vb the application never stops on the breakpoints I set during runtime. As if the breakpoints were never set. Also if I put any code in the "MySettings_SettingChanging" in settings.vb I get a runtime error "The debugger cannot continue running the process. Process was terminated.
You can change the connection string at run-time like this. You make the connection string setting available for writing as a separate property inside the MySettings class:
Partial Friend NotInheritable Class MySettings Public WriteOnly Property RunTimeConnectionString() Set(ByVal value)
[code]....
Then, in some place when the application is being initialized (before using any table adapters of typed datasets), write something like:
Where ProductionConnectionString is a simple String setting. It is a User Scope setting so every user can change it (by assigning a value to it, similar to the code above) and save it by calling My.Settings.Save()This code works well for connection strings which were initially created in the main project and stored in it's settings (= app.config file).
The connection string in the app.config actually has a longer name: MyApp.MySettings.MyConnectionString.When you have a connection string stored in the app.config in a class library project, and reference that project in the main project, the app.config files will somehow be merged, so the class library has it's settings.The thing that don't know how to do, is change a setting from the class library at run-time. I could copy the connection string setting from the class library to the main project's app.config. I must keep the same name, which looks something like: MyClassLibrary.My.MySettings.MyConnectionString.Can the same principle I showed above be somehow applied to this second connection string?
How do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand() cmd.Connection = My.Settings.Item("csStaffHoursWorked") cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "spSaveDeltekImport"
I want to add a Reference to my application in run-time mode and i want to list the public keys of this Reference in run-time mode I'm using VS2005.net Windows XP professional
Converted an VS 2003 VB Application to Visual Studio 2010. Conversion seemed to work great. Having trouble with the Backcolor of buttons. In design mode they are a light gray (I have them set to transperent and they are on a VBPowerPack.Blend Panel) - but in Runtime they turn the correct color (Steel Blue). How do I get design time to look the same as runtime? Also, they stay light grey in run time if I check Enable XP Styles. Makes me feel better to see the same colors at Design time
From 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.
When I compile my solution and execute the program and set the form in window normal, it behaves strangely. The grip is apparent, the mouse changes to the appropriate icon, but I cannot change the size of the window.
I got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
I have written a simple VB.NET program that connects to a MS Access Database. This program runs in Windows 7 XP Mode, but does not run properly in straight Windows 7. Somehow, the Windows 7 does not connect properly or read the MS Access database data properly with the DataAdapter.Fill method. I have dual monitors, so I can run the identical program side by side (one in Windows 7 and the other in XP Mode) - one works and the other doesn't (it doesn't crash, it just get "nothing" from the database when accessing - acts like it's not connected). Has anyone else run into this, or similar, problem with VB.NET and MS Access connectivity?
Im writing a app using vb.net, which has multiple front ends e.g a windows service and a windows forms app. Ive got all my business logic and database stuff compiled into 1 project (producing a dll) then the different front ends as different projects calling the dll.
In the backend / dll project Im connecting to 2 databases using app.config to store the connection strings and DataSets / TableAdapters. This all works fine .... Until
When I deploy the windows app, it deploys the exe and the dll produced by the backend project. when its installed on a client PC, Im need to point the app at a different db server and therefore need to change the connectionstring, but its packaged up in the dll.
is there any way I can use a settings file within my windows app (therefore deployed with my windows app) where I can define the connectionstring, which onload gets passsed through into my dll, so the backend connects the correct database. I know how to pass standard settings through (strings etc) but the my.settings.connectionstrings seem to be readonly.
i have a program i've made a while, and one of the users wants to be able to load his own images to the background instead of the plain grey that is there now. i've searched and searched, and basically can get this working
i just slapped that onto a button just to get it to work as i was experimenting. but that only works for a file of that name, on my computer, in that folder. what i'm looking to do is get it so a user can browse his own directories for images and upload them as the background on the form. and be able to save the settings as well. but so far i have only seen different ways to load preset images that you can load. if it's even possible? i'd assume that you'd use the openfiledialog command, but i'm not that well versed in vb as of yet.
I'm trying to change a forms title at runtime where it = my textbox's text. But I can't even get it to change to "test". When I try to google it, it comes up with vb6's .caption = "test". When I try to search it on the forum, it gives me a error message saying: "Error 502 Bad gateway"
I have a forms application and I have multiple localizations for it. I've figured out how to add a button to a form, to change the localization and then read all the labels/etc and change them to the other language.What I would want to do instead now is click a button and it changes to the other language the current form but also the entire application so that any other windows opened while the application is open open in that other language.[code]This is the code I use when a button is clicked on a form to change it to Hindi the current form. However I want to when the button is clicked, change application to continue to run on that localization instead for the remainder of the time it is open.[code]
I have a forms application and I have multiple localizations for it. I've figured out how to add a button to a form, to change the localization and then read all the labels/etc and change them to the other language.What I would want to do instead now is click a button and it changes to the other language the current form but also theentire application so that any other windows opened while the application is open open in that other language.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If Present <> OriginalCulture Then