SQL 'like' Not Detecting Delimited Multiple Values
Nov 17, 2011I have a delimiter string like this: "2,3" which is grabbed from a listbox values which I will pass to my SProc parameter[code]...
View 1 Replies
ADVERTISEMENT
Asp.net - Retrieve A Comma-delimited String Of Values From A Text Box?
Nov 3, 2010I have a textbox AND 3 checkboxes; checkbox1, checkbox2, checkbox3
In textbox we have 1,2,3
If I type in textbox1 = 1,2 then
checkbox1 and checkbox2 will be checked and checkbox3 will remain unchecked.....
How to do this in vb.net
Converting ArrayList Into String Of Comma Delimited Values?
Mar 1, 2010How do I convert an arraylist into a string of comma delimited values in vb.net. I have an arraylist with ID values
arr(0)=1
arr(1)=2
arr(2)=3
I want to convert it into a string
Dim str as string=""
str="1,2,3"
Detecting Change For Multiple Control?
Jun 15, 2011i need to detect change in multiple control, and fire a sub procedure when any of the mention control value changes in a form.
example of the controls include
checkbox
textbox
NumericUpDown
the problem here is that i have upto 50 controls in all on the form, how do i do this?
[URL]
Auto-complete Textbox Multiple Words Delimited By Semicolon?
Jun 3, 2011I'm trying to make the autocomplete work on a list of items entered into a textbox separated by semicolons. I have a list of authors the user can choose from and it autocompletes as they type the name no problem, but what I'd like to do is after the user types a name followed by a semicolon, the autocomplete works on the next name and so on.e.g., Smith, John; Eastwood, Clint?
View 1 RepliesDetecting Multiple Monitors & Centering Different Forms?
Oct 25, 2009Basically, I have a program that uses up one Monitor (With maximize/minimize/etc options), and I'm going to develop another window that by default, you'll have to swap to. But, if there are two or more monitors detected, throw the 2nd form on the 2nd monitor.
I have found a way to detect multiple monitors (Using the SystemInformation Class to return the monitor count), but it's placing the form on the other monitor that's the problem.
Pass Multiple Values And Return Multiple Values?
Jun 10, 2011When I click on button1, employee_id and P values need to be transferred from button1_click to Cal_Category13() and go through all the calculation. After the calculation, udtnew.X and udtnew.MTD values need to be transferred back to button1_Click
I've no problem to return multiple values Cal_Category13().MTD and Cal_Category13().X from Cal_Category13() to button1_Click but i've no idea how to transfer employee_id and p values from button1_click to Cal_Category13().
Program Code
Public Structure PCB
Public Employee_ID As String
Public MTD As Decimal
[Code]......
Exclude Multiple Values In Sum Depending On Values In 2 Columns In SSRS 2005?
Apr 21, 2009I have simple columns and their respective sums. However, I exclude 1 particular value from each sum, like so [code]...
Now I need to exclude another value ("Awaiting Progression") from a second column called "PROGRESSION".
Since I already exclude value based on 1 column called CATEGORY, how do I change my =Sum(Code.ExcludeOthers(Fields!CATEGORY.Value,Fields!ACTION_PLAN_NEW.Value)) to exclude a value from the PROGRESSION column if it's = ("Awaiting Progression") ?
i.e. How do I exclude multiple values, depending on values in 2 columns in SSRS 2005?
Convert A Pipe Delimited File Into A Tab Delimited File And Show Results In Listbox VBA?
May 7, 2011So i'm new to working with vba in access and i'm having trouble getting this code to work. What it is suppose to do is take a selected text file and read the original file into a list box. Then there is a second button that when pressed will convert the text file from a pipe delimited file into a tab delimited file and then show the changed file into a new listbox.
Option Compare Database
Option Explicit
Function GetFilenameFromPath(ByVal strPath As String) As String
[code].....
Reading A File Line By Line That Within The Line The Values Are Delimited By "?
Dec 1, 2011How would i go about reading a file Line by Line that within that line The values are delimited by " Example of the data:
"bob" "cat" "1243"
"steve" dog" "6789"
I've started this with this code but not sure how to go about the next stage:
Using MyReader As New _
Microsoft.VisualBasic.FileIO.TextFieldParser(My.Application.Info.DirectoryPath & "Records28112011.jd")
MyReader.TextFieldType = FileIO.FieldType.Delimited
[code]....
VS 2010 Comma Delimited Text Into Tab Delimited Text?
Feb 11, 2011how to make a text conversion like the below pic -
1. the textbox 1 is multiline with an array of comma delimited and tab delimited text.
2. the textbox 2 is one line textbox
3. A,B,C,D,E,F,G is where the position of each string before / after conversion
Asp.net - Multiple Values From ListBox?
Jun 9, 2011I am using asp.net with vb.net. I have created 2 listboxes; lstselect and lstroles. List boxes lstselect contains all of the available roles that can be added into lstroles. How do I take the roles that have been added into lstroles and make them into a parameter to pulled into my database when the stored procedure runs?
Here is the code for how my list boxes share the roles:
Protected Sub btnRight_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRight.Click
If lstselect.SelectedIndex <> -1 Then
[Code]....
C# - Cookies With Multiple Values?
Oct 14, 2009I am using ASP.NET and C#. I must read a cookie called "TheCookie".TheCookie have about 3 values in them. Cookie1, Cookie2 and Cookie3.How would i get the value in code to read Cookie2's value inside "TheCookie"?
This is how i would read when a cookie only have 1 value, but i dont know what to do when there are multiple vales in the cookie Code for VB.NET
Dim userCookie As HttpCookie userCookie = Request.Cookies("UserEmail")
Multiple Values Into A SQL Where Clause Via VBA?
Mar 14, 2012I am using visual studio 2010/vb trying to display data that is based on a value read from a text file.Currently i can get it to read a text file with only 1 value and get this value into a label. Then by using a SqlDataSource and setting a parameter in the WHERE clause to use the value from the label, it will display the related data in a data GridView.
BUT i would like to be able to read multiple values seperated by a , or next row down in the text file and enter these values into a WHERE bookID in (value1,value2,...)
.net - Querying Values In Multiple Databases?
Oct 16, 2010I'm using this function to return a value from multiple databases across three SQL instances (On the same server). I'm looping though a DataGridView that lists all the databases on one of the three SQL instances.Is there a faster way of doing this? It's quite slow using this method.
Function DatabaseStatus(ByVal SQLServer As String, ByVal Database As String)
Dim myConn As New SqlConnection("Server=" & SQLServer & ";User Id=USER;Password=PASSWORD;Database=" & Database & ";")
Dim Status As String = ""
[code]....
Finding The Average Of Multiple Values?
Mar 10, 2010I'm working on a simple miles-per-gallon calculator.
Module Module1
Sub Main()
Dim count As Integer = 0
[code]....
This compiles and works for 1 iteration, after many trials and tribulations . What I need to do is make it run for a user-specified number of iterations (the tankfuls variable) and store those separate results in separate locations in the arrays, then average all of those values at the end (find the overall average MPG).
Grabbing Multiple Values From Html?
Jan 13, 2009ok so I am trying to grab a bunch of phone numbers from my html page. I have successfully grabed the first one but I dont know how to get it to loop around and grab the next one and list them out into a listbox. here is the code I have for getting the first value, but how can I make it go in a loop. I have been searching for hours and trying tons of different kinds of loop code but get errors every time.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
WebBrowser1.Navigate("my html page")End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Text = WebBrowser1.Document.Body.InnerHtml()End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]...
Providing Several/multiple Lookup Values?
Jun 29, 2009I have a Person.Profile table with columns like
PersonType (Student, Employee)
____ (Male, Female)
MaritalStatus (Single, Married, Widow, Separated)
[code].....
Put Multiple Text Box Values Into Array?
Jan 29, 2011I'd like to create an array of one column from the text box entries (as shown in the picture) when i click the button.[code]...
View 1 RepliesRetain Values In Select Multiple Box?
Oct 28, 2011I have a javascript function below to move from select multiple box A which is populated from database to another multiple select box B, in the event of a postback my values in B which are moved over from A got lost. Initially I thought because I included a "runat="server"" tag for server side actions but apparently it's not the case. I read about Form.Request but ain't have a clue how to go about it. I just need to retain those values in multiple select box B.[code]...
View 1 RepliesReturn Multiple Values From A Function?
Mar 30, 2011Is it possible to make a function that returns both a datatable AND a list(of custom class) at the same?In my GUI layer, the main form (the application is MDI) calls this function and it has to fill the datagrid on one of its child forms and it also has to fill lot of other child forms with various information that is calculated from my custom class properties.Both the datatable and the class properties are created from the same external database and that's why I don't want to have two separate functions.
View 3 RepliesReturn Multiple Values From A Query .net?
Apr 10, 2012how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
Return Multiple Values From Function?
Mar 15, 2011I have created a function that takes a Car Registation as its argument and I want it to return 3 values (Make, Model, Price and of course True).The code itself works fine (it returning each Individual value but can't find a way to get ALL of them from 1 function) However I need to actually return all 3 values, and I cannot see how to do this with a simple function.
View 8 RepliesReturning Multiple Values From Function
Mar 17, 2009I am working on a project I would like to use a function in a class I created to return multiple values in order to populate a listbox. I wanted to use a do until loop to achieve this. I will just post a simplified example of what I am doing :
Public Function Listboxfiller
Dim astring As String = "This is a string"
Dim Counter as integer = 0
Do until Counter = 5
return astring
Counter += 1
Loop
Then on the form I would do something like :
lstListbox.Items.Add(Myclass.Listboxfiller)
What happens right now is that the listbox only gets the first value, when I ran through in debug mode I found the loop only runs once, even though it should go multiple times.
Searching For Multiple Values Using VBA In Excel?
May 4, 2012I do not know if it is possible to implement this problem in VBA or it must be done with VB. Net using Visual Studio.
Problem: Excel has its search function and it is a pain if there many value available or you must find a value that far away from column A.
I would like to have something like this
In which I can specify what columns I want to display by their header name. Rearrange the column in the way I would like to, and ability to copy and paste. Like datagrid in Visual basic?
Select Multiple Values In DropdownList In Asp.net With VB?
Jan 20, 2012I am creating a page in which I need to show a drop down List. From this drop down List a user can select multiple values. I know I could use a check box list like:
<asp:CheckBoxList ID="CheckBoxList1" runat="server" style="margin-right: 158px">
<asp:ListItem>Value 1</asp:ListItem>
<asp:ListItem>Value 2</asp:ListItem>
[code]....
but if there are more than 50 or so values then that will consume a lot of space on the page and will look odd. So kindly tell me how can I select multiple values from drop down list or if there any alternatives so that I can select multiple values and show many records on a minimum space but not a grid?
SQL Adding Multiple Values Within Query
Nov 15, 2011I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros take a look if there is a problem with my syntax.
CODE:
Storing Multiple Values In A String?
Mar 4, 2012How can i use .filenames of a openfiledialog with a string?
[Code]....
but i get error: Error 1 Value of type '1-dimensional array of String' cannot be converted to 'String'.
VS 2005 Using The Multiple Boolean Values?
Jun 29, 2010I have code like the following:
Dim Flag as Boolean
Flag = Function1ReturnValue
Flag = Function2ReturnValue
Flag = Function3ReturnValue
Now ideally 'Flag' should only have a true value if all three of the functions returned 'True', but as it stands now it won't do that. There needs to be an 'and' or an 'or' or an '&' or something like that, but I'm confused as to what needs to be.
VS 2008 If Statement With Multiple Possible Values?
May 4, 2010Is this not the correct way to do this? I get an error with it but if I change it to only one value then it works.
If dt2.Rows(0)("STATUS") = "COMP" Or "CLOSE" Or "CAN" Or "INCOMP" Or "WAPPR" Then
dt.Rows(currentRow).Delete()
End If