I create a hyperlink that when clicks generates a url like so:
[URL]
And I read it into a text box like so:
Me.txtTags.Text = CType(Request.QueryString("Tag"), String)
But the result of this is that the textbox txtTags will only contain C and doesnt have the ++. I tried [URL]and the # is missing as well. But if I look at the address bar these values are there....
I need to filter out characters like /?-^%{}[];$=*`#|&@'"<>()+,. I need replace this with empty string if it is there in the query string. I am using this in ASP pages.
View 3 RepliesI am not sending any sensitive or security information in the query string. I am currently using Base64Encoding along with MD5 Hash. I want to shorten my url as far as possible.
[Code]...
I am trying to pass query string from one page to popup window as follow:
Dim popupScript As String = "window.open('cFinder.aspx?cName=" & c_TextBox.Text & "','', 'width=420,height=200,menubar=no,scrollbars=yes');"
If (Not Page.ClientScript.IsStartupScriptRegistered("popup")) Then
[code].....
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed. Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function: [Code]
I have a string of characters, but I would like to have a string of hexdecimal characters where the hexadecimal characters are converted by turning the original characters into integers and then those integers into hexadecimal characters. How do I do that?
View 3 Repliesi have been trying to remove special characters. i am not able to remove many crlf in middile of the string.
View 3 RepliesI need to create a console program that allows you to enter a string, of which is then outputted in reverse.
Sample:
Input: Diewas
Output: saweiD
Apparently I need to find out about strings and will also need to use a loop.
Not sure if too many people know this, but the following line will cause an error:
GroupName.Substring(0, 3) = "jt_"
....if the length of GroupName is less than 3 characters. I always thought it would simply return whatever characters in GroupName, but no, it errors. I must be thinking of the old VB6 days.So, I now have to change the code to:
If (GroupName.Length > 2) Then
If (GroupName.Substring(0, 3) = "jt_") Then
Note that the two comparisons need to be on separate lines. If they are on the same line, such as:
If (GroupName.Length > 2) and (GroupName.Substring(0, 3) = "jt_") Then then the code will still fail as the length command is executed at the same time as the substring command- which will cause the error when the GroupName length is less than 3.Just thought that those of us not aware of this should be!
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('9844f9bfb55449e6a786fa62aaadfa20')
dp.SyntaxHighlighter.HighlightAll('f6d554fd98464bdba9159b319e51b381')
dp.SyntaxHighlighter.HighlightAll('93bf4ca63ad8447abdf084d8a9991e15')
Following is the format of the data stored in my arraylist.
A-Amsterdam
B- Brussels
C-Canada
so and so forth. I wan to search my array list by passing just the first few characters till '-' So if i have something like AA-Test then i want to pass just 'AA' to check if it exists or not.
I know that i can use contains or binarysearch but it does not serve my purpose as they both compare objects.
I have 2 public variables that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query.
If I declare
Public Class Form1
Public payPeriodStartDate, payPeriodEndDate As Date
[code].....
I have two forms and I'm trying to pass a declared variable from form1 to form2 and then pass that variable in a sql query that I have in a dataset that is bound to my form. I know that my query works but it's not producing any data. I have debugged my form and can see the data being passed in the variables elsewhere on the page but I'm not sure of the syntax within the query.
[Code]...
I have a public variable that I declared in form1 of an application. I am trying to call that variable in form2 and then pass that variable in a sql query. If I declare:
Public Class Form1
Public payPeriodStartDate, payPeriodEndDate As Date
How then to I declare that variable in form2 and how to I pass it to my sql query.
Here is the code I have for form1: [Code]
and when I debug this form, no data will appear. I'm sure that it's something wrong with how I'm either calling the variable in form2 or in the query. Can anyone offer any assistance on this?
I have a Form1 with a query, and I want to display the results in a DataGridView in Form2, like this:
Form1:
VB
Dim Db As New DataClasses1DataContext
Dim Qry = From country In Db.Countries
Select country
[Code]....
I'm trying to write my very first "serious" program using a mysql database. I use the mysql connecter dll to connect with my database. I have a subject and a visit table. I can select a subject and I can get all the visits for all subjects in a list box with:
[Code]...
I have a LINQ query:
VB
Dim Db = New MyDataContext
Dim Qry = From cust in Db.Customers
Select cust.ID, cust.Name
And I want to pass it to a function to filter it, like this:
VB
FilterAnyQuery(Qry, cust.ID) ' WHERE "cust.ID" CAN BE ANY FIELD
The Sub should be of this kind:
VB
Sub FilterAnyQuery(ByVal AnyQry As iQueryable, AnyField as ???)
AnyQry = AnyQry.Where(AnyField = "somevalue")
End Sub
How can I pass "AnyField" to the Sub and make the LINQ "Where" clause work?
Public Shared Function getrealrequests(ByVal itemname1 As String) As ArrayList
Dim sqlStr As String = "data source=localhost;initial catalog=Customers;integrated security = true"
Dim dbRecords As ArrayList = New ArrayList
Dim dbConn As SqlConnection = New SqlConnection(sqlStr)
[Code] .....
I'm trying to pass the value of 'itemname1' to the select query. What's the correct syntax to get it to work?
I am using following code to connect to my database.
Dim conStr As String = "Data Source=.SQLEXPRESS; ![enter image description here][1]
AttachDbFilename=|DataDirectory|dbTest.mdf;
Integrated Security=True;
User Instance=True"
Dim sqlQry As String = "SELECT * FROM [tblTest] WHERE ([Name] = @Name)"
Dim dAdt As New SqlDataAdapter(sqlQry, conStr)
Dim dSet As New DataSet()
Then filling adapter with
dAdt.Fill(dSet, "tblTest")
And then I can use the data the way I want.
My question is: How to pass the value of parameter that user will give through a text box on my webform.
Dim sqlQry As String = "SELECT * FROM [tblTest] <b>WHERE ([Name] = @Name)
I mean how to pass the parameter value to my query?
Do you just need to format the date? Such as msgbox(New Date(2010, 1, 1).ToString("yyyy-MM"))
Or do you need a hashtable:
[Code]...
I want to pass a date as parameter in vb to query the data from the table.If I hardcore the value in the query it works fine for me, but if I pass it as parameter to query, like I am getting the data from edit text and trying to send that as a parameter, this does not work.
SELECT *
FROM VehicleAnalogParamDownload2
WHERE Vapd2_Date between 'From_date.Text' And 'To_Date.Text'
I am using following code and trying to get data by given parameters. I donot know how to pass the parameter value to my query.
[Code]...
I am trying to run a query an Access db from VB. The general query which I want to run is
SELECT * FROM Patient WHERE Patient.PatientID = ?
or SELECT * FROM Patient WHERE Patient.PatientLname = ?
I tried using an input box which captured the user input and pass that variable to the query, but that failed.Then I read about writing a function and using that, however, I keep getting an error which says Function not defined, but when stepping through the code, it seems to work. Here is my function:
Module Module1
Public Function LookUpNow(ByVal userInput As String) As String
LookUpNow = userInput
Return userInput
[code]....
The data was being read from a Gridview which had the html encoding. The solution was the following...
Dim Sht_Text As String = HttpUtility.HtmlDecode(row.Cells.Item(0).Text)
I am trying to prevent from having to escape apostrophes and other special characters in my string variables by using a parameterized query with an OleDbConnection. I have all of the parameters in the same order, the insert is working, it just does not maintain the characters. I keep getting those pesky html codes. I am trying to insert into an Access db from a web pages. As I mentioned, its working, just not the special characters.
Here's the code:
Dim pConn As New OleDb.OleDbConnection pConn = New OleDbConnection(cb.ConnectionString)
Dim SqlString As String = "INSERT INTO Strings (Mlt_String_ID, Lng_ID, Strg_Name, Sht_Text, Lng_Text, Alt_Text) Values (?, ?, ?, ?, ?, ?)"
[code]....
jp and en records already existed, the insert of fr record pushes the html codes for the small circle which represents the degree symbol. Happens for all other special characters as well.
SELECT ContactID, FirstName, LastName, Male, Female, Email, Address
FROM Contact
WHERE (FirstName LIKE @FirstName + '%')
The above query works and returns values on first names that begin with whatever item I type in a text box.
How can I modify that code to search for items containing specified characters instead of just searching for items that begin with the specified characters. I would still need to use a wildcard because it is a search field. see below for an example
For example can I query the FirstName column to display people who's name contain the letters "an" in that order a before n but anywhere within the word e.g.
- Anna
- Jane
- Samantha
I have written a program that uses an array of the english alphabet and Morse code. I also built a form with a input box for the alphabetic information and an output box with the Morse Code. What i am trying to do is basically type a word like "Hi" in the input box and produce the Morse Code equivalent in the Morse Code output box. [Code] This works but only one letter at a time. Do i need to Parse the string of characters one at a time, and then run it through a loop like i have created?
View 6 RepliesI want to pass a comma delemited list of values as a parameter to a query I'm building using the designer in Visual Studio 2008 based on some strongly typed DAL tutorials I was going through. The query is going against a DB2 database. Here's what I want to do:
select * from prices where customer in(?)
It works fine win I pass in 123456 as ?But fails when I pass in '123456' (it is a char field so I don't know why this doesn't work; it must be adding these behind the scenes) or 123456, 123457 or '123456', '123457' I'm adding this page to a portal where all the data access is being done based on the DAL designer model with a BLL that calls it so I wanted to do it this way for consistency.
I previously posted a Question about code that uses a function to return the frequency of characters in an array. I have now got this code.
View 5 RepliesI have a string like 0010000.abc. Is it possible to print just the first 3 characters of the string i.e 001?ajaind
View 1 RepliesI am trying to get input from user then convert it into specific format and hold it in new variable. here is my code
[Code]...
working on user input box , get any value as string and format it as 0000xx here is my code, but value not passing.
Dim dtmInputBox As String = ""
Dim strDTM As String
Do Until Not dtmInputBox = Nothing
[code]....
my input is like 20 and i want to get as 000020