I'm trying to insert variables into my connection string hoping that they will be saved for executing multiple queries.
What I'm trying is something like this:
Private sConnectionString As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security Info=True;User ID="&user&";Password="&pass&";Default Database=bcpm_ddbo;Session Mode=ANSI;"
[Code].....
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"
im trying to write to an sql database. im inserting an image, as well as some other information. I am using the following code which works fine, as long as i do not add an extra column/variable "LOCATION" in to the mix and leave "
'Cmd.Parameters.Add("@LOCATION", OleDb.OleDbType., 3).Value = "testing"
commented out. *this is undesireable as im trying to add extra criteria to be saved like LOCATION.
Try
Dim st As New FileStream("\serverfolder1storage" & "pdftemplate.jpg", FileMode.Open, FileAccess.Read)
Dim mbr As BinaryReader = New BinaryReader(st)
Dim buffer(st.Length) As Byte
[code]....
i am trying to store the location e.g "c:file1.jpg" in the sql db. Can anyone reccomend a solution to this using OLEDB? ideally i need to add approx 4 more variables. e,g
firstname
surname
dob
location
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]....
Last year (2010) I came across a FANTASTIC command that allowed me to take a string of variables with a common delimiter and break it all back out into separate variables (possibly an array) with one statement.
[Code]...
As long as the delimiter was a unique specifiable character, this one-statement command could break it out into elements. my memory and point me in the right direction.
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'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 RepliesI am using an INSERT INTO ... VALUES statement in the following matter to insert data into a new row of a database:
[Code]...
How can I substitute variables for the explicit values of X and Y in this statement (for example, variables XName, XAddress supplied by user input via text box)?
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 verified data types that are being inserted to insure that this is my problem. I dont see any exception errors.Am i missing a veriable or something that is related to my connection.
Imports System.Reflection
Imports System.Data.SqlClient
Imports PSXSTL.Data.DataAccess
[code].....
I built a dwonloader program which download a file from the web. I would like to insert an error message that pop up whenever the program fail to download the file and/or when the computer gets disconnected from the internet while the program is downloading the file.
View 12 RepliesIn the form load event, I connect to the SQL Server database:
Private Sub AddBook_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
myConnection = New SqlConnection("server=.SQLEXPRESS;uid=sa;pwd=123;database=CIEDC")
[code].....
how can i access the sql server express database table in vb.net on forms to insert records,delete records,search records,edit records.I have made table by using visual studio.
View 5 RepliesI am writing an app to streamline my downloading and reading or manga, i usually download and manually extract each chapter into a specific location, based on what manga and chapter number it is. i then use windows picture viewer to read it.however, i can't work out a procedure that would take the manga name and chapter number out of the file name.i want to be able to pass the procedure a string containing the format that the file name is. e.g. "<title>_<chapter>_[IEM]" then i want the procedure to return the manga title and chapter umber into variables.for example, i pass the function "<title>_<chapter>_[IEM]" as the format string and [code]...
View 6 Repliesthe following code shows invalid qualifier when executed
Dim strs As String
Dim insStr As String
Dim strRes As String
strs = "This is VB.NET Test"
insStr = "Insert"
strRes = strs.Insert(insStr)
Ive looked it up, nothing really worked on 2008, I have a string that always the same length, and want to split it up into variables. The string looks like:
0-555-555
I have 3 designated variables for each number and I don't want to put them into an array.
What I'm trying to do here is Capture 2 Variables from a Textbox
Here is an example of whats going to be in here.
User:Pass
I want to declare everything before the : as user and everything after the : as pass.
I've Googled, and found a few things, but I couldn't seem to get it working fully.
In the following code i want to replace 'Product7' (in the line : sql = "delete product where Product_name ='Product7'") with a string variable:
dim x as string
x = "example"
how to do it ?
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
[Code] .....
I have a collection of strings that I got from splitting another string. I now need to get each value of the collection into seperate strings.[code]...
View 8 RepliesIs there a way toi insert , say, integer variable in the middle of a message box string. I can tack it on at the end but can't get it in the middle.Say,
Dim number as integer
number = 6
Messagebox.show("You have visited &number& times")
[code].....
I need to split one variable into 3 variables. For example I have a variable called Data and it contains AAA00000001. I need to have them be split between the "AAA", "0000000", and "1". I looked at the Split() function but didn't get a clear example for this situation. The reason I need to do this is because I want to store these 3 variables into fields for a MySQL database.
View 3 RepliesI recently discovered that VB.NET 2010 lets you initialize strings by embedding them in tags instead of between double quotes. This is especially handy for spitting out raw xml and multi line strings.Is there a way to embed variables into the string? For example:[code]
View 5 Replieshow do i compare 2 string variables to determine if they are the same?ie:
if(string1 = string2 AND string3= string 4) then
perform operation
else
perform another operation
end if
If I typed in "Dim X as Integer" in a text box, I figured that I could just use If TextBox1.contains to make vb.net dim it. However, how would, if I typed "X = 3y * 9" in the text box, actually calculate that and print it in another text box?
View 5 RepliesI am trying to reduce the amount of code I have and make it more maintainable and flexible. (I.E Do it the right way). I have a bunch of (48) Form controls (text boxes) and when I click next on that form I save all their text values to some 48 global string variables. The names of these variables are the same as the Text Boxes but with "_saved" appended to them.
For any given operation instead of having a separate line for each control it's nice to just use a loop. I can easily write some code to operate on each Control (set visibility, enabled etc) by using Me.Controls and a For Each Loop. I can even make collections of fractional groups of the 48 controls. For example, If cntrl.name.startswith("sometext") collection.add or perform some other operation only on that subgroup etc.
I'd like to do something similar with my Saved Public String Variables. For example I would like to do the following loop somehow but don't know how to group Variables together and keep their name in a way where I can define that array or collection on 1 line or just a couple lines.
' But this next line only groups the values
Group_of_string_Variables = {Var1, Var2, Var3, Var4}
For Each Name_of_String_Variable In Group_of_string_variables
[Code].....
But I can not access the name of a variable or find a way to easily group in key/value 48 different ones without needing much more than 50 lines of code to make either a 2-dim array, a collection, or a hash.
I'm sure someone will tell me I should be doing it a completely different way. That would be ok as long as I don't have to change too much of my other code. I thought of making an object of some kind instead of a variable so I could access 2 object properties- name and value then I could group those objects in a collection as I have done before. But that seems like it would be many more lines of code and I'm not sure it would work.
My problem is, in VB 2008 I need to convert this[code]...
View 8 RepliesI am wondering how to replace two variables in a query from selections that the user makes. One variable is chosen by a combo box called cboYEARMONTH and the other is selected from a list view called employeeListView. I know that I can use .replace to insert the YearMonth into the string but, how do I also replace the EmployeeID in the query string?
[Code]...
