I am working asp.net for a few years. In asp.net, database connection string is stored at web.config file. All page can share this connection string. Now, I need to learn how to create windows app. Where to store a connection string, e.g. connect to SQL, to Access DB, so that all windows forms can share it?
View 5 RepliesI 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'm stuck regarding to grab connection from app.config file...i'm surf many type and kind to do it..but still can',t.....i need to connect into two database (oracle n firebird).
View 2 RepliesI am working on a VB.net winform application which makes extensive us of a mssql database. For the most part (almost exclusively), I have used the Visual Studio dataset for accessing the data. This means that the connection string was created as a program setting, and is saved in the app.config file. The problem that I have, is that I need to move this connection string to the system registry because it has been deemed by the powers that be that a config file is not secure enough.
I think that I can figure out how to access a registry key, and I know that I can save the string to a registry key, but the problem that I am running into is that I don't access the connection key in the code anywhere to easily swap out the registry key for the existing program setting. When VS creates the connection and dataset, where is the connection string referenced? Is there a simple way to swap these out? is it possible even to just reference the registry key in the setting so that I don't have to find where the setting is used and switch it out?
I just want to know what is your suggestion about storing database connection strings in .NET? I am using My.Setting usually, but now I am facing with versioning of my application. When I upgrade my application to higher version the value in My.Setting has been changed, it didn't remain as user has set before, but changed base on my machine's setting. eg. the value in My.Settings Version 1.0.0.0 (User's computer) is 'ABC' When I develop again some new feature on my machine and set its version to 1.0.0.2, of course the connection string in my computer's My.Setting file is different with User's computer's My.Setting. So when I copied my recent updated file to use's computer, then run the application, the application read the new My.Setting file from my computer but not from their computer. the value in My.Settings Version 1.0.0.2 (Developer's computer) is 'DEF' Therefore I have to reset and reset their connection strings onve I updated their application, that's too annoying?
View 16 RepliesIn my application I have many different forms each use 3 different database. And right now I am placing the connection string in each form but when it is need to change I have to change in every form. Now what I want to store all connection string in a vb class and call them in every form. So that if I need to change I can do in that class. I have stored my connection string in database so even I don't want to connect to database again and again. I have some idea in which maybe a public class is used and some how I will call it on other forms.
View 2 RepliesI am creating a windows application which required Dynamic Connection String in the app starting (user need to provide db credentials through a form), After entering the connection credentials user redirected to new win form Everything is working fine but how can I pass my dynamic connection to another form.I tried to save it to App variable but I couldn't (I think its read only) Also I tried save it to registry but can't retrieve values.Is there any other option available ? like writing & retrieving ConString to a text file or XML.
View 1 RepliesI need to know what is the common way to store a SQL server connection string for an application in VB.NET.How do I read app.config values How to do it in ASP How do I store a connectionstring (unencrypted thus unsafe)It's quite frustrating not to find a decent and full answer on how to store a connection string in VB.NET in app.config (or settings.settings if it's better) safely. At the moment it's hardcoded and so it is immobile and in plain text.
View 2 Repliesi m using Microsoft VS 2008 and in that VB.NET as the language the problem is i m not able to store connection string every time machine changes have to keep on changing the connection string
View 7 RepliesI want to ask that where to store connection string in VB.Net.AS in ASP.net we can store connection string in web.config file and access it in the foll. way [code]In VB.net where to store conn. string on form_Load or any other place???
View 1 RepliesI am storing my connection string in my app.config file. I am using sql server express 2005. The connection string on my dev machine is different from the ones at the clients. so each time I update I open the config file and edit the connection string setting. This is quite a pain.also I have now published my app to an ftp folder so that the clients can get the updates each time I make changes. saves me the hassle of going to them each time i update. so now i need it to be so that I won't have to change the setting all the time.Would the best way be to store the connection string in a settings table in the database?
View 6 RepliesI'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'."
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 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]....
i know that integer is a variable to store whole numbers and that a string is a varialbe used to store any text, but what variable type would you use to store a number that has decimals?
View 7 RepliesI have a WinForms dialog box that contains 3 radio buttons. I am using ApplicationSettings to bind the Checked property of each of these RadioButton controls, but it doesn't do what I am expecting it to do. Now I have to click each radio button twice before it gets checked and the selected radio button is not being persisted.Is there a line of code I need to execute when the form is closed that saves the user settings?How do I eliminate the need for 2x clicking on the radio buttons?Is there a better way to persist this type of user setting? I do have a public property on the dialog box class that gets/sets an enum value based on which radio button is checked, but I didn't see an easy way of binding that property to a user setting. Should have specified that I'm using vb.net. I think that means My.Settings instead of Properties.Settings.
View 4 RepliesI am developing an .net Winforms application and I need to secure the connection to the sql server 2008 database. I plan to create a webservice as a middle tier that will handle the authentication and that will provide data manipulation. Is there a better way to go with? Does .net have components or tools for that? What is the best technique?
View 2 RepliesI am developing a database driven application and need to access the database often. What is the standard/best practice for storing the database connection. Do i need to create a public static variable? The main thing i was to avoid is passing the sqlconnection as a parameter in almost all of my function calls.
View 1 RepliesIn the past I've used a Singleton Pattern to load the connection string when the application starts via the global.asa file.
I have a project now where each user has a unique connection string to the database. I would like to load this connection string once. The issue is that the singleton pattern will not work for me since each user has there own connection string. Basically the connection string is created dynamically.
I do not want to store it is session. If anyway has a clever way of doing this in .NET let me know ?
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'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 RepliesBackground: I have a winForm app that registers a user in the database based on the information provided, auto-generates a random password and username, and e-mails the user a link to take an application based on the marketing company selected. Problem: hen the user clicks "Send Invitation" with data inputted iton all fields except the bundles listbox in debug, the NullReferenceException Error is thrown highlighting the line: Dim MCShort As String = Trim(splitMC(0))How do I fix this issue Here's a screenshot of the web app: Here's the code of the Send_Button_Click method off default.asx.vb:
Private Sub Send_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Send_Button.Click
'TODO Add code to validate that all selections that are reaquired are met.
[code].....
I 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 RepliesIve done a login in vb.net (Visual Studio) which works like a charm. However, i need to store the username of the person that has logged in, in some form of cookie. How can i store the persons username in some form of global "cookie"? It will be cleared when they log out or the program closes PS. I dont literally mean a web cookie - just not sure what else to call it. Just a global variable which will store the current user.
[Code]...
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[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].....
lets say that my string:
test!
i want to get the first character
t est!
also i want to get the last character
test !
I have an issue with finding specific text within a string and then replacing it with " ", which is just a blank entry.[code]So now my issue is to search the ABCTEST text and delete text such as "Tier Market" from it. Then pass it to a new string perhaps ABCTEST_NEW..I know i might have to use a for loop to search out the keywords, but all the examples i have had a look at, are very broad.
View 1 Repliesiam making a dictionary in mediawiki and for this purpose i designed a bot in vb.net when i search in a string which contains [[ code dosne detect the [[ in a string a seems it bypass the [[ code is below
[Code]...
this code search for vbNewLine & "[[ in the string and then add myid to listbox but it search "اسم نکرہ" also (without [[) so it mix up. where iam making mistake?