I am doing project in vb.net using ms access database I used one query like
Command.CommandText = "Select DISTINCT(*) from CharacterData where Mesg= '" & message & "'"
here it is executed when message variable value is a & also if A So how should i make it to check only proper case sensitiviy in where clause ..I want case sensitive checking of Mesg= '" & message & "'"
I want to select one item in drop down list in ASP.NET written with VB.NET - I have values and texts in listbox like this: Volvo Audi etc... But values coming from other place in upper case... VOLVO, AUDI..
This code: dropdownlist.FindByValue("CAPITAL") Is not working and giving null for Volvo..
how to validate user inputs.. when the user logs in and his/her password is in Uppercase(saved in database) but forgets to type in uppercase. and it would display warning message saying invalid password...
I am doing a search to look for a value that corresponds in my datagridview. But the problem is it is being case sensitive. Is there a way to disable that? The code I am using is below.
Is there a way to enforce case sensitivity in VB.Net file-names?
The primary issue that I am trying to solve is the difference in how Windows doesn't care about the case of a file-name, but other tools, like Subversion, do care about the case of a file-name
I am trying to compare the contents of 2 collections in a unit test in .NET using MSTEST. To make things simple, instead of having to .Sort() and then loop through the collection and compare items one at a time, I've found the new and very cool .Intersect Extension method.
However, now that I have a test which needs to be case-sensitive, it breaks. I've tried sending Intersect's second parameter StringComparer.Ordinal,StringComparer.InvariantCulture, and StringComparer.CurrentCulture... no luck..
see if an object is already in a generic List(Of T) than the way I am currently doing it? The way I do it at the moment is like so:I have a method that I call each time I want to check to see if an object exists in the list (if it already exists I do not want to add it again) and the list to check is passed in to this method along with the item that should be added to it:
[Code]...
So as you can see this function just loops through the list that was passed in and if the DisplayName property of one of the items in the list is the same as the ProgramName argument that was passed in to the method as well then it returns True to indicate that this program is already in the list.I thought about using a Predicate with the List.Find method but cant see how I would get it to work because that predicate method will not have any way of referencing the list (its a method local list, not class level)
I need to check if a webpage exists if it does whether a certain string exists anywhere on the page. Preferably I'd like to do this without a webbrowser control, so that images don't have to be downloaded and it doesn't have to be rendered.
I would like to know please how to check whether a string exists or not in a html code. I'm executing a for loop. Each time it checks a different url, so I want to be able to check each time if for example "<img" exists .
P.S: What's the difference between using
webrowser1.navigate
AND
dim request webrequest request = WebRequest.Create etc...
I'm having issues with finding something in list, and removing the item, ignoring the case of characters in string.
The code goes: Dim listItems As New List(Of String) Dim pattern As String = "AbC" Dim array() As String array = {"ABC", "abc"} listItems.AddRange(array)
Here I'd like to remove all items from listItems, that are abc, no matter what case single characters of item are, including mixed case items. So in this example, every items should be removed listItems.Remove(listItems.Find(Function(r) r = pattern))
If I change pattern to match the case of item, then item #2 gets removed: pattern = "abc" listItems.Remove(listItems.Find(Function(r) r = pattern)) How can I find item in listItems, ignoring the case characters in pattern?
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
I'm having kind of a hard time about this, just would like to ask if anyone knows how to check if a string that is input by the user in a text of combo box is in the list of the combo box?
I'm searching for specific string method that ignoring the word if it was written in capital or small letters when I want to type this word in a field for searching purposes or when a user wants to enter its usrename in capital or small letters.
I am used to C like languages such as C#. I added a list box with a list of names. In the code behind I added the below code. When I run the code I am getting the MessageBox but it will state "UserName favorite color is " but does not show the color. I thought it might be misspelled or non-matching names but this is not the issue due to the names being correct.
Public Class Form1
Private Sub lstData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstData.SelectedIndexChanged
I was wondering if anyone could show me how to check if a tag exists?Here is the code that I am using to get the information from the xml.
Dim XmlFile As New XDocument XmlFile = XDocument.Load(WorkingDirectory & "ToolsMediaInfoMediaInfo.xml") Dim Manage = XmlFile...<track> For Each XmlTag In Manage If XmlTag.FirstAttribute.Value = "General" Then
This is the standard way of checking if URL exists [code]....
return true; } catch (Exception ex) { return false; } But my problem is that we have to check it for around 100 URL's. It takes more then 2 minutes to check for all as it is trying to get response of all of them. Is there any way that we can check if URL exists without getting complete Response so that total response time is less.
In my code, I want to check if a referrer url exists and if the referrer url contains a specific sub string. I know how to check for the sub string:
If( InStr( Request.UrlReferrer.ToString(), "some sub string here" ) > 0 ) Then
But I don't know how to check if a referrer exists or not. No refer exists if the url is entered in manually in the address bar. So I tried this, but this does not work:
If (Not (Request.UrlReferrer.ToString() = "")) And (InStr(Request.UrlReferrer.ToString(), "some sub string here") > 0) Then
I have a windows service which fetches data from various datasources and build a XML file and send it to a webservice. For example first I will get customer details from Oracle Database and build the XML file and then the SQL Server database and build the customer details XML. I am planning to use the same function below to build the customer object irrespective of what the datasource is. But dr("age") column is not available in SQLserver datbase How can I check if a column exists or not.[code]
I am using Caspol.exe to install a custom Permission set and add Code Groups for my .Net 2.0 Windows Application.
I have created a Console Application that uses caspol.exe to add Permission Set and Code Groups. I first install the Permission Set and if I do not get an error, I continue to install the Code Groups
Now sometimes I need to add a new Code Group to the client machine, so I make the changes to the console app and it is executed on the client machine. If the client machine already has the Permission Set installed, it returns an error and stops the further processing.
So, I want to know if I can check whether a custom Permission Set is already added or not?
How would i just if a website exists, and, if so, launch a browser to open it. I am making a little tool for one of my freinds and it allow then to quickly launch websites. How would I check if that is a valid website to launch, so i don't get an error if it is not valid.[code]The error i want to stop is "Cannot start process because a file name has not been provided."So basically i want to make sure that the program can launch the URL so i don't get this error
I cant get the following code to check if my regestrykey exists can some one help. the idea is to check if it exists if so do nothing if not create it, along with its value...
the full key is HKEY_LOCAL_MACHINESOFTWAREVTSAdvanced Offset 2AdminAccess > If Dir$("HKEY_LOCAL_MACHINESOFTWAREVTSAdvanced Offset 2Admin", vbDirectory) <> "" Then
I have a small database. 2 main tables called CaseDetails and Checks.Each record in CaseDetails can have 3 checks recorded against it in the Checks table. But can only have one check of each type (check types 1, 2, 3).I have 3 linkbuttons which will take the user to the input form for each 'check'. If a 'check' already exists i want to hide the linkbutton that takes the user to that 'check type' input form (the 3 input forms have different fields).So what i need to do, is connect to the SQL database and see if a record exists for each 'check type' and hide the linkbutton to prevent users from entering another record with the same 'check type'?I have tried reading the reults into an array and examining that array, but havent been able to do so.
I'm doing an application to manage a school of music, at the moment i'm working on registration (with MySQL DB).
Imports MySql.Data.MySqlClient Public Class Admin_Reg Dim server As String = "Server=localhost;Database=escola_musica;Uid=root;Pwd=;"
[Code].....
Now i want to verefy the table if the username exists or not. If it exists msgbox "Registration Complete", if not "Username already exists. Choose another one..."