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] .....
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.
I have a table with data in it and i have text box above it. when i type data into the text box i would like it to search for that phrase in the first name and surname columns of the table however i cannot get it to work
Public Sub LoadEmployeeGrid(ByVal SearchString As String)
'this opens the connection with the database
database_connection.Open()
[code].....
Printing Work Orders from with in a .NET scripted screenSummary of code:
Public Overrides Sub onload(ByVal e As ScriptonloadEventArgs)
Dim CWONO As String
SetValue("CWONO") = "WO_Number" '(This field is automatically created with previous code)
[code].....
I am trying to execute a shell command with vb.net that includes variable from the vb.net code.I have experience with batch, and Unix scripting. I had to modify the contents of the code as it is confidential to me at the moment.Example of my problem:
Dim Variable1 As String = "Location_to_.exe"
Dim Location As String = "UNC_Path_Goes_Here"
Dim Options As String = "/Options go here"
Shell("cmd.exe", /C Variable1, Location, Options) This is something that must be run from CMD.exe and I am trying to do it this way to make it as dynamic as possible.
i am working on this code that is going to query a database for an entry and return the value of the tracking number and the time to print on a label if the tracking number exist in the databse. it does not right now it only seems to reprint the number that is enetered in a text box and it does not grab the date. here is the code.
Dim TrNum As String = Me.DupTNText.Text
Dim TrDate As <=something if it is even needed
Dim connectionString As String = "Data Source=XXXXX;Initial Catalog=YYYYY;Integrated Security=True;Pooling=False;Encrypt=False"
Dim cmdText As String = "SELECT TrackingNumber, Date" & _
[code].....
I 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)?
Is there a way to use the string.split command to get a section of a string without using an intermediary array?for example, if my string is "1 2" and I want to get the "2" part using string.split(" "), is there a way to avoid creating a new array, and just get the bit of the string I want in a single line?
View 4 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 RepliesIve 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.
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.
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].....
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]...
i am running a Sub which takes as arguments a Datatable and a String.
Private Sub Populate(ByVal dttemp As DataTable, ByVal strWhichPart As String)
At one point there is a combobox which is populated with some of the data in the datatable. The name of the combobox is cmd plus the name of the string for example when the string is Person_FirstName the name of the combobox is cmbPerson_FirstName.Then i add items to the combobox like this:
cmbPerson_FirstName.Items.Add(strHold(rr))
My question is this can i make a String into a command? Because i have many comboboxes which have the same name as the string argument of the sub how can i do something like this to work
strWhichPart.Items.Add(strHold(rr))
in which strWhichPart is a string. Is there a command that i can execute a string as a command?
I have a form that asks for a name, and a phone number, it has 3 buttons, a add customer button, show list button and an exit button. When the add customer button is clicked, it increments intCustomer variable, formats the phone number, makes sure only the first letters of the name are capitalized and creates an ID that is the first 4 letters of the name plus the customer number, the show list button takes ALL customers added to the array and displays them into a multi-line text box, like so:
ID Num Customer Name Phone Number
JOHN-1 John Harry Peters (111) 111-1111
Paul-2 Paul J Rodgers (111) 111-1111
Etc...
The area where I am completely lost in, is how to add the consecutive customers to the array, in the correct way. here is my code in its entirety
Public Class frmCustomerName
Dim intCustomer As Integer = 1
Dim names(9, 2) As String
[code]....
i am retrieving a iMAGE Extension variable string. for example: test.case-function.two.jpg and want to return the end '.JPG' portion only. so i can add to another variable value. Note the .JPG substring could be other Extension types such as PJPEG ect
View 1 RepliesI'm having difficulty passing a variables in a an array list. [Code] I have to pass the paramvals array to the function. The paramvals array contains the string but not the value of variable of that name. For example, parmaval(0) should contain the value of vSequence but it showing me that it contains string "vsequence".
View 3 RepliesBasically i have a query string that when i hardcode in the catalogue value its fine. when I try adding it via a variable it just doesn't pick it up.This works:
Dim WaspConnection As New SqlConnection("Data Source=JURA;Initial Catalog=WaspTrackAsset_NROI;User id=" & ConfigurationManager.AppSettings("WASPDBUserName") & ";Password='" & ConfigurationManager.AppSettings("WASPDBPassword").ToString & "';")
This doesn't:
Public Sub GetWASPAcr()
connection.Open()
Dim dt As New DataTable()
Dim username As String = HttpContext.Current.User.Identity.Name
[code]....
When I debug the catalog is empty in the query string but the WASP variable holds the value "WaspTrackAsset_NROI"
I'm tasked with the job of creating a javascript version of a units conversion application written in vb6. I have the source code but I don't have vb 6. The source code uses a dat file to hold a conversion array (unit type, unit, xfactor, plusfactor). Getting the data out of this file would be good to me. I tried creating a little app in vb 2010 to write the data from that dat file to a txt file using essentially the same code as the source code. And that has been somewhat successful (took a while to figure out the fixed string business). Now I can pull the data out as an array. The math elements of this array look fine but the strings are somewhat read-able but too garbled to use. I can't seem to fix that by changing the character set/encoding.
View 3 RepliesI am a beginner trying to write code. I am creating an application that is a questionaire with 3 forms that have questions for the user with text boxes, list boxes, and check boxes for response. Some of the text boxes with the user response are on different forms. Will that cause me problems? I would like to write code that will combine a literal string with responses from text boxes and string snippets which are inserted based on check box condition. I think I would like to create the string to be printed to a RichTextBox and then output to peripheral printer. How do I make inserting or not inserting a string based on check box condition? How can I trim the response string to allow a output string without annoying extra spaces and such?
View 3 RepliesI was wondering if it is possible to point to a textbox created in the form designer via a string variable. Basically, I'm creating a golf management system with a feature allowing a user to define their own course. Each hole has a corresponding textbox into which a user can input the hole's par and then the system should total up the first 9 pars, the last 9 pars and then all 18 pars; displayed in 3 different textboxes.
The input textboxes have been named txtP1, txtP2, ..., txtP18, so I was wondering if I could simply concatenate a loop control variable onto a constant of "txtP" to point to each input box.
This is what I have at the moment, but it's throwing up errors saying that .text is not a member of string.
Sub UpdatePar()
Dim inpar, outpar, totalpar As Integer
Dim pointer As String
[code].....
Here is what im trying to do. I have a loop and trying to concatenate it to produce the string. For whatever reason im getting test1, test2, etc instead of the variable equals to. What i am trying to do is get the value test1, etc.... from the concatenating test & cstr(a)
dim test1, test2, test3, test4, test 5 as string
test1 = "The"
test2 = "dog"
[CODE]...
