I know below code causes an error since "Property 'AAConnectionString ' is 'ReadOnly". What other choice do I have to assign a value for a user ID or a password with a value of textbox by coding?
My.Settings.AAConnectionString = "Data Source=bb.allgood.com;Initial Catalog=aadb; Persist Security Info=True;User ID=aa123;Password=aa123"
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.
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 RepliesI am creating an login page connected to a database. I am using access ODB. the problem is, if the user makes an wrong input, and the invalid data message box appeared, when typing the data again, and press ok, the following exeption occured:Not allowed to change the 'ConnectionString' property. The connection's current state is open.[code]
View 3 Replieshow to traverse all TableAdapter in xsd file?
I want to change default connectionstring of all TableAdapter objects in xsd at beginning of application,
i want to change proxy setting of IE through code.
View 1 RepliesI have problem with datagridveiw how can I change row setting Height?
View 1 RepliesI have created my own Internet browser.Now i m Interested to put a button through which i can change the proxy setting.
View 1 Repliesi am using a webbrowser to view folder files. if it's possible, i'd like to add the view settings (thumbnails, tiles, icons, list, details) to button commands. if it's not possible for the webbrowser, i could still use the information for a folderbrowserdialog, or such.
also, a button to view folders or the windows listing on the left side of the windows browser. this is for a folder/file browser set in a tabcontrol to load all my favorite folders in one. nice project to have for a dev'ie.just a squirrel looking for my nut...
I want to change this registry setting in windows vista and 7 ("HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesUSBSTOR","Start",4) by clicking a button.[code]how do i change ("HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesUSBSTOR","Start") value to 4..How do i request administrative privilages for my aplication to change registry setting when it starts?
View 6 RepliesI am developing a software and give to user sevaral time. When i give them i change Assembly version of my software. But problem is that when they update new version they lost all application setting. Application setting save with new root with version. Is they any way application version not to change with version. save only one root by application name or something.
View 9 RepliesI am working on an application using vb 2008 express. I have built test programs over the past few weeks and shared them for feed back. Today when I finished some work, I built another test application, but when I install it the start-up screen maximizes but is set between one and two desktop icons from the top of the screen.
In debug mode it looks fine. In the past it looks fine. Each time I start the program the screen is in a slightly different location. It is set to start maximized and to the best of my knowledge, I did not change any settings in the property area. I have tried loading on three computers and the results are the same. Any ideas on what I could have done to produce this strange result?
I need to change the color of an oval on the user interface form based on a variable being true or faulse.
View 10 Replies I got a form, another form, another form, another form, etc.And I got a quit form (Msgbox is not pretty)So, there starts a problem.I have two quit forms now, so that the user can pick the best one.The problem is that I don't know how the user can pick it. I have a quit button in Form3. I want SettingsForm have one label that says "Use the new quit dialog:" and two RadioButtons (which it has.) The Yes Radiobutton = Uses the new form, the no button uses the old one.Settings save the selection for the next session, etc.
RadioButton2 = Yes
RadioButton1 = No
Label = Use the new quit dialog
ButtonQuit = The Quit Button
I am basically from VC++, for compiling a project with Unicode support we will change the setting in project properties and build it. In VB.net is there anything like that, Do I have to change any setting before building to enable Unicode support.?
View 1 RepliesI have a form that allows use the use to change the Email address to be sent to and that is save in a my.setting. my issues is that the Email is in a variable to be used and Dim sendTo As New MailAddress("Email Address")well I cant figure out how would i variablize the "Email address" I tried to place a Variable just says its not a address because it a variable. but it work if i put in a email as a hardcode.
View 1 RepliesHow to control the font DPI in .NET WinForms app..How to change the Appearance/UI of win-forms in vb.net as per Windows display setting? default windows display setting is 100%, if i change it to 125% then my win-forms in my application doesn't display properly as per display settings.
View 1 RepliesIam looking to change programmatically, from Regional language setting [control pannel] date format to dd/MM/yyyy .
View 4 Repliesi used date in my project often. but every time i used format(now,"dd/MM/yyyy"). But i want to change the system date format to "dd/MM/yyyy" permanently.
View 16 RepliesI'm making an editor for my app. which allows the user to change properties of the controls including the font.I'm storing the values in a collection but I'm having trouble re-setting the fontstyle from the stored value. I'm storing the font information like so...
FontString = SpeedGroupbox.Font.Name & "|" & SpeedGroupbox.Font.Size & "|" & SpeedGroupbox.Font.Style
EditedControlsCollection.Add(FontString, "SpeedGroupbox.Font")
I use dbf files from db2k in my application.When I try to connect, it takes a long time and I find the application exited without any error msg.The connection string I use:Return "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\agbvseng01APPLISNomenclature_Eng_Bvs;Extended Properties=dBASE IV" Data source is on a server.I dont know why this happens.
View 10 RepliesDim SQLInfo As String = "server=https://lotus.x10hosting.com:2083/frontend/x3/index.html;" _
& "uid=uid;" _
& "pwd=pwd;" _
[code].....
I designed a DAL (data access layer). This DAL mainly consists of a handfull of methods to call stored procedures. All methods are shared. So no instance generation of the DAL class occurs.
The DAL with it's single class is located in an own project. The connection string is defined in the app-config file of this project.
I want other applications to use the DAL class by referencing the dll generated by the DAL-project. For this reason, I can not any longer define the connection string in the DAL app-config as it is, because the client application determines which database needs to be used.
- Dropping the "shared" keyword of my methods. Create an instance of the DAL class. Add a property for the connection string. When application starts, create one global or multiple local instance/s of the DAL and set it's connection string property.
Comment: I don't like this, because it implies more coding work on the application code side (create instance of class, assign connection string)
- Granting the DAC class access to the connection string defined in the application code by adding a connection string property inside the application code. Thus the DAC class remains "shared".
Comment: I'd need to set a reference from the DAL to the application code during without knowing the application yet. I could try stack tracing or something like that. But it feels to convoluted for me.
I'm merging two of my projects that can share a lot of the same classes into one solution with two web applications and a shared class library.
I've literally just dumped all the classes into the class library project and as expected I've got a ton of errors to fix. My main problem at the moment is the connection string. Currently I have this (which is obviously not going to work):
''' <summary>
''' Initialise the data access layer by loading the database connection string from the Web.Config file
[Code].....
I am just having a hard time figuring out what does the number 2 in
ConfigurationManager.ConnectionStrings(2).ConnectionString
define? What does it mean?
I've looked at a lot of posts on different forums where others have received the same error. Most say they were not referencing the connectionstring from the web.config file correctly, or they were trying to open the connection before setting the connectionstring. Well, if that were the case for me, then how does it work on two different systems, but not on the third? It works on my development PC and on the development server, but not in the production environment. The difference is the web and DB server are separate physical servers in my production environment and on a single server for development. My setup, error message and code will be listed below.
I can simulate the error on my PC if I rename the connection string in either section of the web.config file (appsettings, connectionstrings) to something else. You will see how I have tested both below.
[Code]...
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.
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 RepliesHow does a real life connectionString look like? I my sample application, I have this in the app.config file:
[Code]...
ConnectionString on real website
View 1 Replies