Changing Connectionstring At Runtime
Feb 18, 2010
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.
View 2 Replies
ADVERTISEMENT
Aug 31, 2009
Im trying to make a query inb a dataset (to fill a report) Why it dont let me do a select (that will return rows)?
View 2 Replies
Feb 6, 2012
Changing connectionstring area of app.config in vb.net
View 1 Replies
Apr 27, 2012
I create project in my pc with vb.net and sql database when i tried to run this project to another pc there is error occurred that the connectionstring has not been initialized. I really troubled this from last one week to solve the problem. how to change the connectionstring on client pc at runtime or any other way to create a connectionstring that has auto detect in any pc where the program is installed.
View 5 Replies
Dec 22, 2011
I am kind of an old 'newbee' at this, so bear with me for a moment. I am developing a windows forms application in Visual Studio 2010 Professional that connects to a remote database (MS sqlServer 2008 R2).To speed up development, I configured a DataSource and used the data objects associated with it. In VB6,
the data source could be assigned to the data objects during runtime using a variety of different runtime database connections, ODBC, ADO, ...
I have been unable to find a similar method with the VS2010 Visual Basic DataSource and underlying TableAdapter, BindingSource, BindingNavigator, down to the individual ComboBox and assorted other bound controls. It's convenient to have the integration, but I've got different users with different permissions, The long and short is that I'd like to be able to assign the data source during runtime operation, at least to the connection string level.
View 9 Replies
Nov 2, 2009
Is it possible to change the icon of my app in runtime?
View 8 Replies
Dec 9, 2010
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
BackgroundImage = Image.FromFile("C:UsersMeFileName.png")
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.
View 8 Replies
Oct 9, 2011
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"
View 10 Replies
May 11, 2010
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]
View 3 Replies
Mar 8, 2011
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
[code].....
View 7 Replies
Mar 15, 2012
I need to change size parameter of OvalShape, I have about 100 of them, named like OvalShape1, OvalShape1...... OvalShape100
This example works for Label, but throws error for OvalShape, following is my modified code that giving error;
For Count As Integer = 1 To 100
[code].....
View 5 Replies
Feb 17, 2012
possible Changing ReportViewer BindingSource at Runtime? in visual basic 2010
View 1 Replies
Jun 4, 2009
I am working on a project that uses a .txt file to store data for my arrays. Everything is working correctly i.e. I can read the file and write to the file, my issues when I exit out of runtime I get this msg
Quote:
M:My4BVB....Customer.txt
This file has been modified outside of the source editor. Do you want to reload it?I understand what it means, what I would like to know - is there a way to stop it from popping-up?
View 2 Replies
Sep 4, 2009
How do I change my code so that it will change the Value of the My.Settings.* to what TextBox1.Text is
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If RadioButton1.Checked = True Then
My.Settings.Acc1 = TextBox1.Text And My.Settings.Pass1 = TextBox2.Text
[code]....
View 2 Replies
May 9, 2009
I have 2 Comboboxes on my Form which also has a DataGridView. One ComboBox is populated with Font Names and the other is populated with a range of Numbers (Font Sizes). On a button click I've added this code
[Code]...
View 2 Replies
Jun 28, 2010
For example at run time if i wanted column header 4 bold is this possible?this bolds all the column headers
Me.DataGridView1.ColumnHeadersDefaultCellStyle.Font = New Font("Tahoma", 8.25, FontStyle.Bold)
View 10 Replies
Mar 30, 2009
I have specified my connectionstring in My.Settings
But when I want to change it at runtime I get the error: Property connectionstring is read only.
Is it possible to change the connectionstring at runtime???
I used the following code:
[Code].....
View 1 Replies
Mar 13, 2012
I am using the PowerPack and trying to change multiple ovalshape size, I have used the following code for changing multiple labels,
For Count As Integer = 1 To 100
Me.Controls("Label" & Count).Text= "Hello World"
Next Count
If I do the same for OvalShape, assume I have OvalShape1, OvalShape2.... OvalShape100
For Count As Integer = 1 To 100
Me.Controls("OvalShape" & Count).Size = New System.Drawing.Size(20, 20)
Next Count
The above throws error when executed.
View 1 Replies
Nov 10, 2011
How do we overwrite config file at runtime. I have four config files for DEV, TEST, UAT, PROD. Based on user selection I need to overwrite the default config file completely with one of the selection specific config files. These config files not only have appsettings section, but also has complex cutom sections and subelements with lot of attributes. I need to overwrite and refreshsections dynamically at runtime. I know there are so many articles on editing appsettings sections. But I want to completely overwrite the entire file.
View 1 Replies
May 16, 2011
I am working on a contract to repair problems in a application that interfaces with a custom built digitizer tablet.The application recognizes the tablet at startup, initiates calibration to locate the pad limits and then saves those limits to file.During the run of the application the user has a cursor that is changed to a line with a X on the left hand side of it. The user then uses this custom cursor to click in a PDF document where they would like the contents of the Digitizer pad to be placed. When they click a box signifying the size of the digitizer pad along with the same blank and X appears. What I have been having issue with is that the box and the line with the X appear most of the time but on occasion the line and X appears at either the top or bottom of the box and the click is no longer at the line with the X but somewhere in the middle of the box. This really screws up things and often the user has to uninstall and re-install the application to get it righted.
The values that save the calibration points are bound to variables during the build process, there is a separate routine to calibrate the digitizer pad if the user desires to do it again.
Public Structure IconInfo
Public fIcon As Boolean
Public xHotspot As Integer[code]......
View 18 Replies
Nov 23, 2009
In my app (written in VS 2003) I use OleDbDataAdapter's to load data. I have some functions that enable be to change the OleDbDataAdapter.SelectCommand.CommandText at run time, by adding a "WHERE" or "HAVING" section to the SQL command, or updating the "WHERE " or "HAVING" section. This way I have have generic load data functions. (load all invoices for Customer 123, load all invoices for the year 2009, or load all invoices for Customer 123 for the year 2009).
With the new VS 2008 TableAdapter, the TableAdaper.CommandCollection property is Protected. How can I edit the TableAdaper.CommandCollection(0).CommandText at run time?
View 2 Replies
May 26, 2010
I'm trying to create an object Of a specific type. I've got the following code, but it fails because it can't cast the new table object to the one that is already defined. I need table to start of an IEnumerable type so I can't declare is an object.
Public sub getTable(ByVal t as Type)
Dim table As Table(Of Object)
Dim tableType As Type = GetType(Table(Of )).MakeGenericType(t)
[code]....
is there a way of changing a variable type at runtime?
View 3 Replies
Jun 24, 2010
I am developing an windows application in VB 2008, My requirment is such that I have to change the applications Splash and Startup object on the basis of "Custom Constants" (Compilation Constants).As far as I have .Net idea it should be done in Application.Startup Event (guide me if i am wrong)Now, in Application.Startup_Event when I write the code
Private Sub MyApplication_Startup(ByVal sender As Object, ByVal e As Microsoft.VisualBasic.ApplicationServices.StartupEventArgs) Handles Me.Startup
My.Application.SplashScreen = SplashScreen2
[code]....
The application dont work as desired, instead it starts with Form2 (which is OK), while in case of Splash it doesnt changes the splash form.
View 5 Replies
Jul 31, 2009
I am trying to convert a value from a radio list box that is populated by an access database. The database loads fine, I have no trouble with that. My issue is that I am trying to take the value of the radio button chosen and turn it into a font color. Therein lies my problem. I see that it cannot be a string, but when I turn it into an object, I get an error. I will note that I am using VS 2008 (Windows Vista x64), and the database is compatible with a 2002 - 2003 Access database. I am using ASP.NET for my programming, however, I am trying to program it in VB. This is my code:
[Code]...
View 4 Replies
Nov 23, 2009
how to change the properties of control which are created at run time. The actual situation goes like this: I will be creating 4 picture boxes at runtime and assigning pictures to them. Now if i wanted to change those pictures, i am not getting how to call those picture boxes.
View 6 Replies
Feb 17, 2009
I would like to have an application setting wherein the user could set the font size of the controls at run-time.
View 10 Replies
Jun 21, 2010
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
[code]....
View 9 Replies
May 23, 2011
Changing DataGridView BindingSource at Runtime Works but then Fails When Changed
View 1 Replies
Nov 28, 2009
Any thoughts on what might cause a thread error like this?Error:InvalidOperationException was unhandledCross-thread operation not valid: Control 'Form1' accessed from a thread other than the thread it was created on.
Relavent Code:
Private Sub SerialPort_DataReceived(ByVal sender As System.Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataReceived
[code].....
View 3 Replies
Oct 15, 2011
I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name)
This is the query that I have in the properties:
SELECT [Date], Address, Customer, Orders
FROM Report_qry
WHERE (Customer= 'JohnDoe')
View 5 Replies
