I made a Windows service which daily deletes some records from a SQL Server database. But i don't know what my connectionstring should look like ... the service and the database will both be located on the server.I found this example, which parts do i need to change ?
Datasource=.SQLEXPRESS;AttachDbFilename=|DataDirectory|DB_ftp.mdf;Integrated Security=True;User Instance=True;"
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've got an issue with a program I am writing. The specific issue is replacing characters in a parent string by finding, and matching, specific characters within it that are parsed from an external xml file. It's for a chat-like client.Here's the 2 classes I am using to pull the emote strings, titles, and id from external XML:
Imports System.Text.RegularExpressions
Imports System.Xml.Serialization
Public Class emote
[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 RepliesPrivate Sub txtname_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtname.TextChanged
myConnection.Open()
[CODE]...
I want to four digit code like Abneesh than first query finding max of A and second string take string A than code generate like A001----------A999
i have a string array that i want to output to a text file. the array size is 10000. i fill the array starting from 0 with some strings. at the end, i only want to show the array from index 256 to the last array that is not empty (for eg. if the array is filled with data from 0 to 2000, i only want the text file to show the data from 256 to 2000 and ignore the remaining strings). Is there any function to do this?t i use is shown below
Dim myArray(10000) as string
Dim strArray As New System.IO.StreamWriter("c:List.txt")
strArray.WriteLine("{0,10}{1,30}", "Index", "Symbol")
[code].....
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 have a string array that i want to output to a text file. the array size is 10000. i fill the array starting from 0 with some strings. at the end, i only want to show the array from index 256 to the last array that is not empty (for eg. if the array is filled with data from 0 to 2000, i only want the text file to show the data from 256 to 2000 and ignore the remaining strings). Is there any function to do this? i am using visual basic express 2008. The code that i use is shown below
[Code]...
I have a somewhat unique problem that I have looked for an answer to and continually hit brick walls. The problem is this. I'm using vb.net to read a byte array from memory which total 32768 in length, which is converted to a string. The memory is the active console chunk in the game Call of Duty 4.
[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 Repliesis instr used in vb.net for this?
View 3 RepliesMy problem seems simple but I can't find an answer for it.I need to be able to pull a phone number (string) from an entire string. example: "My phone number is (xxx) xxx-xxxx, call me as soon as possible."
Its obvious to me that the phone number should be able to change depending on who you are talking too. So the question becomes, how do i search for the phone number's format within the above string?
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 I would find certain characters in a string.
View 4 RepliesI have a window app written in VB 2008. I would like to find the first occurance of CRLF from a string.
I tried the following codes and none of them is working.
str="Things found wrong: Cover on left side of engine leaking.
Starter mounting gasket leaking.
Left hoist cylinder leaking.
[Code]....
I think VB has a way of doing this, but for the life of me I can't find it. I want to search through a string for anything contained between two certain characters, e.g between 2 | characters. I'm not sure if I want to split the string at this point, but I only want anything contained between the two | markers. So for example if the string reads |ABC|DEF I only want to retrieve the ABC, but not the DEF as it's not completed yet.
View 3 RepliesI want to be able to find both spaces using the indexof method. Here's my code so far. Basically the program will turn the string "Will Smith" to "Smith, Will" But I noticed when I type in a name with a middle initial or middle name "Will J Smith" I would get "J Smith, Will" And I want to be able to find that second space when its there and apply a code that would produce "Smith, Will J" When there is a second space. How would I go about doing so?
[Code]...
Ive got a question about finding the greatest value in a string. I am connected to a database but I am positive that part is right. So i posted here instead of there.
Dim x As Double
Dim ConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=DBASE.MDB"
[Code]...
How do I make my If..Then statement return the highest value of row 0's x? My output (by changing the if then statement) will either return the first or last entry in row 0. I hooked up my code to a list box and got all the data to list perfectly i just don't know how to get the highest number after i use the formula for x (which is {c1-c2}/c2).
Basically what I'm trying to achieve is to extract all the words within a piece of string and transfer that from one text box to another text box.
An example piece of the string would be
<laugh:894u8438:4434:words>
However the words within the string will never remain constant and the characters before and after will change. Is there anything that will read the string and take a word from the string without it being pre-programmed. The string it is reading from is uploaded from a text file.
I am trying to use the following code, however if my searchString variable contains a # (hash) then it is not being found. Why is this?
[Code]...
I am trying to use the following code, however if my searchString variable contains a # (hash) then it is not being found.
dim searchString as string = "*simon#*"
If line Like searchString Then
any other approach on finding next word in a string. What im trying solve is this.
Lets say this is the whole paragraph.
Hello visual basic
Hello visual basic
Hello visual basic
Hello visual basic
Hello visual basic
Hello visual basic
now i search for the word basic.if i press the button find. the first "basic must highlighted, and then if i press again the button the next "basic" is the highlighted one and so on.I already finsih that scenario. What i've done is that first im going to search all the positions of the word and then store it in a array. Then after the array populated with different location of the word that is searching. that is the time i call all the indexes of the array one by one. But i don't want my approach because imagine i have 10000 words. and i search for a word or letter. Lets say the result is 5000 match. so it needs my array to be size in 5000. what a mess in memory.
I don't want to used the FinsString or Find function of VB i want some algorithm to do this. Anyone have a easy approach..
I have a networkstream (using C#/VB.NET). while on reading values coming like this:
&% 68 kg K A&% 23 kg K A&% 174 kg K A &% 68 kg
&% 34 kg K A&% 2334 kg K A&% 68 kg K A &% 68 kg K A
&% 2348 kg K A&% 78 kg K A&% 28 kg K A&% 68 kg
The numerical(weight) value will be continuously varying.
Every time i am reading the starting of the stream differs. But the pattern remains the same. How to split that into '&% 78 kg K A' which represents one set.
How to extract the weight value from this stream using Regex or any other methods?
I have like a three word expression: "Shut The Door" and I want to find it in a sentence. Since They are kind of separated by space?
View 6 RepliesI have a text file that is automatically generated by an older computer system daily. Unfortunately, the columns in this file are not delimited and they are not exactly fixed width (each day the width of each column could change depending on the amount of chars of the data in each column). The file does have column headings, so I want to find the width of each column using the column headings. Here is an example of the column heading row:
JOB_NO[variable amount of white space chars]FILE_NAME[variable amount of ws chars]PROJECT_CODE[variable amount of ws chars][carriage return]
What I want to do is get the index of of the first char in a column and the index of the last white space of a column (from the column heading). I would want to get the index of the "J" in JOB_NUM and the last white space before the "F" in FILE_NAME for the first column.I guess I should also mention that the columns may not always be in the same order from day to day but they will have the same header names. I know I can use the string.indexOf("JOB_NO") to get the index of the start of the column, but how do I get the index of the last white space in each column? (or last whitespace before the next first non-whitespace that denotes the start of the next column)
I am working on a program and for one of my features, I need to replace all spaces in a program with - (dashes.) Is there a way in which I can do this?
Example:
Start String = "The rain in Spain falls mainly in the plain."
End String = "The-rain-in-Spain-falls-mainly-in-the-plain."
[code].....
Im trying to make an on access file scanner, YES I know that C++ is better, but this is a concept of thought, trying to challenge myself to see if its possible in vb.
Anyways, I have a list of Hex definitions, my question is, how can I index this list so I can access the definitions faster. A definition looks like this:
Eicar.Test.File.a=58354f2150254041505b345c505a583534285
The part after the equals sign is the HEX signature, while the first part is the name of the definition.
Basically what I am trying to do is index them somehow where I can scan faster, as I have over 60,000 definitions and I have to split each individual one in order to get the signature name. It takes about 45 seconds or so to scan a 500KB file. I need it to be WAY faster.