I have created a project in VB.net in which i have used SQL database connectivity
connection string of my project is stored in project properties > settings in the way
<connection string name>, <type>, <scope>,<actual connection string>
I want to provide that connection string dynamically at the startup of my applicaion
Hence the connection string stored should be changed dynamically at startup
I want my application to startup thorugh registry if the specified checkbox1 is checked and to delete it from registry if the checkbox1 is not checked.With the following code im able to create registry but, im unable to delete it.I want it to work like it works for softwares for e.g Utorrent.
Code:
Private Sub CheckBox1_CheckStateChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckStateChanged
If CheckBox1.Checked Then[code]....
I'm creating window application with VB.NET and flatfiles.the problem is how do i store the connection string in the app.config file that include the application.startup path?
<add name="cn" connectionString="provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "data;Extended Properties=text;" />
i got some error when writing to app.config.
"Missing attribute value on attribute 'Application.StartupPath'."
I am using vb.net and SQL server 2005 I have a project with database classes which are generated from database objects. That is I add a dataset to the project and drag and drop a database object onto it. The problem with this is that I have to give a connectionstring which is stored in the code. This is ok while developing the application. But runtime I want to use another connectionstring, both for security reasons and because each user of the application will correspond to a database user (SQL) and shall have a corresponding connectionstring. Is there an easy way to do this without having to restore to plain all datasets and do everything myself?
View 2 RepliesI have application in VB.net that have two different form (Form1 and Form2). Now I need to examine some condition and if condition is true then i set Form1 for startup for and if it not then i set Form2 for startup form.So is there anyway to dynamically call startup form?
View 3 RepliesHow 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 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"
Here is my dataset.xsd code
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)"
[code]....
how i can create a connection to a database when i open my program and then close that connection when the program closes, so that the user has a permanent connection while the program is running that can be used for multiple things depending on what the user decides to do.
View 5 RepliesI have done a lot of searching and cannot find a solution to my problem of, my application appearing in the processes even after exit.
Note: It doesnt appear in the processes due to the type of exit i have used after the click function happens.
Public Class FCAM
Public Sub Launch(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Launch_FCAM_FarCry.Click
Process.Start("....Bin32FarCry.exe", "-MOD:FCAM")
System.Windows.Forms.Application.Exit()
[code]....
Using WINFORMS (VB 2008 Professional) in an XP Pro system, I have been able to create Data entry forms that capture required variables from user necessary to generate price/profit/resources required for a given project. The entry forms comprise textboxes, numeric updowns, comboboxes. All my calcs run well and I output the control contents to tables in SQLExpress. (I am a landscape architect).
But, I have to find out how to:1. Save contents of all data entries on the quotation form as a Project1.(suffix) file (as well as the current SQL DB), such that the user can at a later date, reopen original quotation details and rework the original estimate by altering one or more of the controls on the form. User can then save again and so on until user issues his/her final quote estimate to client.
I have been on some journey trying to pin this down - to no avail really; although tempted to ring the infamous (and very eloquent) Beth Massi, thought I would seek help from this Forum first.
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 understand the possibilities for encrypting a connection string in .net v4. I have a win forms application that will be used by multiple people on different machines. I understand that I need to protect the connection string at time of the app being first run on the target machine. However I am concerned that for a period of time my connection string will be unencrypted. I am looking for advice in how to deploy my app with the connection string already encrypted or encrypted during installation. encrypting the connection string in a secure way?
View 1 RepliesI have a connectionstring in MySettings which all my datasets use. The project has three copies of the same database: LIVE, WHATIF and TEST. I need to have a dialog in my startup that asks the user which db they want to use and then I thought I could amend MySettings.Connection string dynamically. Hey-ho it's read-only! Is there any other approach I can use where I change a connection string once and all my datasets will then point to the selected db?
View 3 RepliesI'm developing an app in vb.net (visual studio 2008). I have a Teradata back-end that will be supporting multiple users in a production environment. I need to use variables in the connection string as the user/pass will be changed every 3 months.
For the gist of the application:
In it's most basic form - I have a search form which works correctly - it pulls results into a listbox and the user then double clicks the list box which will then open a form that is bound via table adapter to the back-end table (Teradata). My connection string is fine everywhere in the application. My problem is using a modified connection string for the "fill" function of the table adapter once the form is opened.
I'm using the code below for the on-load event and keep getting an "invalid connection string" - again, the connection string works fine everywhere else in the app, and the variables etc... are working correctly.
Private Sub adaptertest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DBConnStr As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security
[Code].....
I'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
View 3 RepliesI am trying to connect DSN from my VB 2008 project. When i try using myoledb.connectionstring="DSN=myDNSname" I get the following error message An OLEDB provider was not specified in the connectionstring.
View 1 RepliesFor my application, there is a login form in which users have the option for it to "save the login information" Kind of like MSN or other websites in which you go to a login page an the information is filled out. On my login form, I am using this code for my checkbox which is to "save login info"
Private Sub CheckBox1_CheckChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.Click
Dim s As New System.Text.StringBuilder
[Code]....
Why doesn't an exception get thrown when this function is called when there is no ConnectionString set for the Connection? I just spent 15 minutes debugging and staring at it and finally figured out it needed the connection string. Shouldn't an exception get thrown?
Friend Function GetValues(ByVal TableName As String, ByVal FieldName As String) As DataTable
Dim cn As New SqlConnection
Dim cmd As New SqlCommand[code].....
I can hide my startup form (or make it appear hidden) on startup. I can start my app on windows startup--through registry values--if the user checks a checkbox.
But if the app starts up on windows startup, I want the form to be hidden, so the program can just keep working without bothering anyone. If it starts up because the user started it, I want the form to be showing, because the user probably wants to change some settings or something.
How to make an Application to startup at the system startup? and How to enable and disable?
View 6 RepliesIs there a way to dynamically create an object using a string as the class name?I've been off VB for several years now, but to solve a problem in another language, I'm forced to develop a wrapper in this one. I have a factory method to dynamically create and return an object of a type based on input from elsewhere. The provided input is meant to be the class name from which to create an object from. Normal syntax means that the entire class has to be explicitly spelled out. To do it this way, there could literally be hundreds of if/then's or cases to handle all the available class/object choices within the referenced libs:
If c_name = "Button" then obj = new System.Windows.Forms.Button
If c_name = "Form" then obj = new System.Windows.Forms.Form
....
[code].....
I'm trying to reference a public property from a string. How can this be done in vb.net?I have the text value of "FirstName" stored in strucParam(i).TxtPropertyName.[code]...
View 1 RepliesIn my windows form I have an empty datagridview that contains strings loaded from a csvfile. The datagridview has no initial column collection. There are four columns in the csv file. In the csv file, columns 1 and 2 have values of true orfalse. So far I am able to load the text perfectly.
What I want to do is change the strings "true" or "false" into an image in my resources (a pretty green checkmark and a red x).
I would like to leave the csv file text as it is, and then change the columns dynamically.
Then, when I save the information back to the csv file, the images must be converted to text strings to accomodate the csv.
I have this class Framework.Asd.Human with a public empty constructor. and i want to be able to dynamically create an instance of it from a string input "Framework.Asd.Human". Is this achievable? (in java and C#)
View 2 RepliesThe code below works so i know the resource is registering correctly ...
vb.net
My.Computer.Audio.Play(My.Resources.alrt2xuk, AudioPlayMode.Background)
But what im trying to do is make a function where I can play the audio file in the programs resources with a string variable being passed to it representing the resource objects filename.
this is so users can type in a audio files name and pull it from the program's resources dynamically VS a big case i would keep having to expand ...
heres my code
[Code]....
but that isnt working for some reason ... keeps throwing "objects reference not set to instant of an object" on the "Return ..." line
I have a need for an application with a SQL database back-end. The application will run on a laptop and will therefore be used both on and off the network. I can write the app and I can link it to SQL over the network. I also know how to dynamically change the connection string so I can handle online/offline data source connections. Where the data can be stored on the local client? I'd like the data to be held in the central SQL DB and to automatically copy to the laptop upon connection to the network. The client data source is read-only and will not upload back to SQL. I've seen XML mentioned but that looks overly complex.
View 2 RepliesI have a label that reads a random line from a text file and that string becomes the text for the label.
Now the problem; the label will only work if it is clicked because the event handler is click.What I need is this to work automatically at startup. In other words, it should change the label's text to the random string of the text file on startup of the application.
Here is my code.[code..]
i deleted my previous start up form to be replaced by another one but each time i launch the application,the deleted start up form is still displayed.i dont know from where this deleted start up form is being loaded.
View 3 RepliesI have two website application,
first Application is located at:
MyApp/WebApp1
and the second at:
MyApp/WebApp2
is it possible WebApp2 get a Connection String from WebApp1 web.config?
Can you have a SQL database on a ftp server and connect to it from a windows application?
View 2 Replies