I'm traying to write some query but I don't know much about DataBase. I have a variable that store the value entered on a textbox and I want to look value in the DataBase and then show the record on the DataGrid. I'm traying to build some query but I think I'm way off.
Here is my query:
SELECT Name, Record, Plan, [Numero de contrato]
FROM [Record de Pacientes]
WHERE (Name LIKE '%Variable%')
Can someone give me a simple example on how can I store/appear in a variable/or a textbox a value that i retrieved from a database. The sql query is something like "Select Comment from Params where id =1".
View 5 RepliesI want to store a decimal value, but there is the possibbility that no value has been entered. So i would like the decimal value to store a nothing instead of a 0D if no value has be entered is this possible?
View 2 RepliesI am trying to parse a date from a textbox and store it in a date variable
Dim enddt_2 As Date = Date.ParseExact(txtenddt.Text, "dd/MM/yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo) 'txtenddt.Text
expenddt_1 = enddt_2.AddDays(-1)
enddt = enddt_2.ToString("dd/MM/yyyy")
enddt is a Date variable and when i convert enddt_2 to a string i get the error as
Conversion from string "17/01/2012" to type 'Date' is not valid.
Let me clarify, if a value in textbox is 17/01/2012 than after parsing the value is changed to 01/17/2012 (my systems Region and Language are dd/MM/yyyy) in enddt_2 and when i try to convert to dd/MM/yyyy format and store into a date variable i get the above error. This error comes only for the dates after 12. i.e a date variable accepts a date in MM/dd/yyyy format.The dates before 12 work fine, i.e for all dates from 1 to 12 there is no error.How can i make enddt store the date in dd/MM/yyyy format.
How to create a new textbox every time previous textbox.text is entered?
View 7 RepliesI am trying to mkae sure that there has been 16 numeric digits entered into the masked textbox. If not show errror message and if so to call the fucnction ValidateLuhn. When calling Validate Luhn i want the program to tell me if the number entered is valid or invalid using the code in the function:
Private Function ValidateLuhn(ByVal value As String) As Boolean
Dim CheckSum As Integer = 0
Dim DoubleFlag As Boolean = (value.Length Mod 2 = 0)
[CODE]...
OK, every time the letter a is entered into a textbox, I want it to enter in as a 1 instead. Help?
View 3 RepliesHow can I store the value of a variable into another variable that wont be changed unless it meets certain criteria
View 1 Repliesi have 23:23:30 in a texbox and i like to store this in a variable ,if i put a variable m1 as decimal, i have a message error,if i put string , i have 0 and not 23:23:30,why?
View 11 RepliesHow can I store the value of a variable into another variable that wont be changed unless it meets certain criteria
View 2 RepliesIs it possible to validate the value entered within a textbox by comparing it with a text file that is full off accepted values?
in my textbox will be a location like London, i want to be able to validate that it is correct by looking in my text file to see if it is there?
my textfile would be written like this:
|london|manchester|birmingham|leeds|bristol| ... etc so it need to split the values by looknig with the pipe characters ( | )?
I got Minimum date from database using sql qry, And when i try to store that min.date in one variable, its getting error, PlZ help me. for below coding.
Dim qry as string
Dim Min_Date As Date
If SqlCon.State = ConnectionState.Closed Then
SqlCon.Open()
[code]....
Just wondering if it's possible to store a reference to an object in a variable.
I will elaborate:
[Code]...
Can I store the common operators such as '>', '<', '+' etc., in a variable and then use it when required.
[Code]....
so here instead of directly using > and +, Can I use the variables OP1 and OP2 somehow. May be I can put the entire string from "If..... NUM1" in another variable as text string and then execute that variable.
I have a program where I open files and I store the location as a variable so I can reopen them later on. It works much like MS Word does, where it shows the names on the side and when I click it and open, it will open the file. Mine is a little different because it will store large numbers of file names in a list box because people are usually going to open folders full of files. The initial way I did it had the path name stored in a list box and it would open the file using that path. I decided it was a bad idea and I tried to use just the name of the file. However, I ran into a problem with the code that I was using.
Code:
If its checked, it will open the selected item from the list box instead.
If CheckBox1.Checked = True Then
'for all the indexes of the saved location record of array, if the selected item is found, then open that file
For counter = 0 To SavedLocations.GetUpperBound(0)
[code].....
So as you can see, what I have is it decides whether you opened from the list box or not. If it is not from the list box, it opens it up fine. It adds the information to the list box and stores some information in an array so I can access it later on. If it does open from the list box, then it will search for the file name in the array. If it finds it in the array, it will proceed to open the file using the directory. There is no else clause because it should be finding it 100% of the time.
The error I get is that parameter cannot be null. Filename2 never seems to get assigned, which means it's not finding the value in the array. I've tested and the value is in the array and the values are the same values.
'ValueNow is updated by an external link eg ADO.NET
Dim PresentValue as Decimal
Dim PreviousValue as Decimal
[Code].....
I am building a form and i want to prevent certain characters from being typed in a textbox? I want to disable the " and ' characters in some of my textboxes
View 4 RepliesHow to only check that checkbox which is entered in textbox ? If i have 4 checkboxes eith text checkbox1, checkbox2, checkbox3 and checkbox4 and 1 textbox if i type in textbox 1,2 then only checkbox1 and checkbox2 would be checked again directly after doing that i type 3,4 in textbox then only 3,4 will be checked and 1,2 will be uncheked.. remember i wanna do this coding for unlimited no. of checkboxes .. so dnt provide coding for 4 checkboxes only.
View 2 RepliesI want to check if the value in the text box is EVEN NUMBER.else throw an error mssg.
View 3 RepliesI have a text box and I would like to type in a website address and make it go to the given website by clicking a button..I already created a button and a text box. How to go to the entered website address.
View 3 RepliesI have a textbox where the user enters their name, however it is possible to enter numbers in textbox, i was wondering if there is a pre existing function that only allows alphabetical characters to be entered?
View 17 RepliesI have a appointments program and the user must be over 18. I was wondering is there a way to restrict the numbers entered into a textbox to be from 18 to 100. can this be done with e.keychar
View 4 RepliesI'm working on a query where I only want to use the 8 first characters entered in to the textbox. Is there some attribute to textbox that allows me to do this?
View 4 RepliesI have a file which is opened and the bytes are loaded into a class.The file needs to be split into chunks, and there is a header which gives the locations and sizes of the chunks.Should I (upon opening the file) split the file into chunk sand store each chunk in an array of variables And then when I want to access the data in the chunks I just use the array.
or store all the chunks in one variable together and then when I need access to the chunks get the location and size of them and use that to find chunks each time I need to modify them.
Class1:
Dim v as integer
public sub storeVar(byval s as integer)
v = s
end sub
[code].....
I need to save a reference of variable s in Class2 in variable v in Class1.(i.e. when the value of s changes v also changes (and vice versa)Is this possible since vb.net doesn't have pointers?Will it work if I change "byval" to "byref"?
I am doing a college project for a driving instructor, so the heart of the program is getting the booking part right. I've made a structure in a module:
[Code]...
I would like to store a plain text logfile (approx 6 - 30 kB) in a variable belonging to a class that I later serialize. One way to do it is obviously reading it in and storing it to a string.
View 3 RepliesI have a query that brings back a result that I want to be able to use on all forms in my project. Is there a way to store this until the application is terminated?
For example,
I'd like to store the result of this:
Dim ssSQL As String = "SELECT ClaimNo, Custodian, Activity, Code, DateStamp FROM [Activities] WHERE "
ssSQL &= "[ClaimNo] Like ('" & txtClaimNum.Text & "')"
[Code].....
Try to store hex value D9 to byte variable.
Dim x As Byte
x = encText.GetBytes(&HD9)
When Debug.Print for check, answer show hex 83 (decimal 131). Why it cannot store correct hex value?
Is it possible to detect when any button on a form is clicked and then store that buttons name in a variable?
My reason for wanting to do this is because i have over 700 buttons in my form and each one needs to do something different. I want to create one sub with if statements to respond to all button clicks.
