I am working in visual studio with a datagridview that is bound to a mysql database via the .net mysql connector. In my vb app I have some text fields that provide the necessary fields for building the connection string which I have defined as:
[Code]...
Is this possible? Currently I'm using a login form that passes txt box values to string and then use as variables in the hand coded connection string (for each query) is there a way to use this with a table adapter? something similar to how access remembers your login credentials when accessing an ODBC table? I've tried editing the connection string in the config file, but says it's invalid every time. I'm only using the table adapter to populate my form after running a hand coded search query.
This is what i use for manual insert/update/delete query
Private sConStrFormat As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security Info=True;User ID={0};Password={1};Default Database=bcpm_ddbo;Session Mode=ANSI;"
[code]....
You will find attached the source code of a small program. I wanted to know if it was possible to modify the connection string in Web.config and use a connection to MySQL. I made some attempt, but does not connect.
View 1 RepliesI want to create a dataset.xsd in vs2005, and I am using access database, so I cant know where my client save the application. Hence I used application.startuppath() to get the application folder and appended "Datadb.msd" to the application.startuppath() so i got the target location for the access databse in client machine. Now to create crystal reports I need the dataset.xsd but while creating a new dataset.xsd it was asking the path for the access database, how to programmatically specify the connection string in dataset.xsd so that i can create a connection string. and use that dataset for creating crystal reports.
View 2 Replieswe have several applications in Vb.Net using the built in log system (My.Log) to write log information. Until now this system was configured by the application.config file before execution but now we want to let the user to choose some options.
Is there a way that does not requires to parse the XML file and process it? Is there available something like My.Settings that will do the dirty job done?
An example would be to be able to modify the DefaultSwitch value from Verbose to Warning or changing a property of the FileLog like the maxFiles attribute:
<switches>
<add name="DefaultSwitch" value="Verbose" />
</switches>
<sharedListeners>
[Code]....
I want to programmatically change ACL for all the subdirectories into a containing one. Specially when ACL of a particolar user is found I want to duplicate that ACL, change the security identifier and add the rule.
Look at this code:
cDirectoryInfo = New DirectoryInfo(strPath)
cDirectorySecurity = cDirectoryInfo.GetAccessControl()
cAuthorizationRuleCollection = cDirectorySecurity.GetAccessRules(True, True,
[Code]....
I'm looking for a way to programmatically view and/or modify the permission for an existing share. I'm speaking of SHARE PERMISSION, not NTFS PERMISSION, I know how to view/modify ntfs permission.
View 2 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]....
I have a string which I've split into an array. I need to change a value in the array and join the string together. However I cannot set the value of the array variable as it's read only.Is there any way to do this without creating another array?
Dim LineOfText As StringDim aryTextFile As String[code...]
It will apparently allow me to enable/disable my network connection programatically.I'm not sure how I should call it?I've tried several things such as:Network.SetConnectionState("Network Connections", "Local Area Connection 2", "1", "0", True)[code]
View 3 RepliesI have few crystal 10 reports with default to a server & database during crystal design time (server=SRV1, DB=Pub1). And, i calling these report from VB. net application with a config.ini define my server & DB . Recently,i hv clone the same reports but extract from different server & Database name (Server=Srv2,DB=Pub2, the tables & fields are still same ) i have created a config.ini which contain my server, database, uid & pwd. And, when i execute these cloned report , they still point back to the origin server which was server=SRV1, DB=Pub1.
My coding :-
Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
[Code].....
I have a variable holding a string that is set to the value of 'B Recipes'. I need to know how to modify the string so that the new value is 'B'.
View 1 RepliesI am developing a program to manage inventory and accounts. different clients need different databases like oracle/sqlserver/mysql etc. i want to make my solution work with all these database servers by only changing one string value . i want to declare like :
[Code]...
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've done some VB Script and I know C++ fairly intricately. I'm having trouble understanding, and making for loops with if statements perform as expected. What I'm trying to do is iterate through a string and turn all of the "a"s into "c"s "b"s into "d"s and "c"s into "e"s? Here's what I've got thus far and I'm keeping the old string intact.
For i = 0 To first_string.Length - 1
If first_string(i) = "a" Then
second_string = first_string.Replace("a", "c")
ElseIf first_string(i) = "b" Then
[Code] .....
I can do this for loop in my sleep in C++, but it seems that the increment counter i is never what I expect it to be. It should start as 0 (first letter of string) replace whichever of the three it finds, then change to 1 (second letter of the string) and replace whatever it finds there right?
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 RepliesI need to work with Decoding so that I can Increase/Modify a String Value from 32 entries to 75 entries, and to include the corresponding checkboxes also.
View 14 RepliesHere's my VB code.
[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 RepliesI am working on a text-based game and as your character moves, you get informations such as the room name and below, a description (Lorem ipsum in the example) which is an array of string. I would like to know how to append characters to it. I am actually trying to display a minimap made of ASCII character. See the second bloc code for an example.
From:
code:
Into:
Room Name Here
code;
The game itself is made in VB.NET but a solution in pseudo-code is also welcomed. Also, each line's length is aproximatively the maximum length it must be.
The desired output must be an array of strings because this data is later send to a client connected using sockets.
I have a DataGridView with one column, I set for that column
DefaultcelStyle->Wrapmode=True
Modify data a with a long string, I call also
vb.net
DataGridView1.AutoResizeRows()
DataGridView1.Refresh()
But the DataGridView doesn't refresh wrap,il looks like this : I change manually current selected row moving to another record and now the refresh is done :
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim fso, inputFile
Dim str As String
fso = CreateObject("Scripting.FileSystemObject")
[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].....
how can I call "Add Connection" dialog programmatically at runTime in VB .net?
View 2 RepliesI have a need to apply a mask to a string programmatically and not through any type of Masked Edit Control. So for example a mask of (###) ###-#### would need to be applied to a string such as 5551234567 to create (555) 123-4567.
View 5 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