trying to set the result of dropdownlist to a variable but having great troubles.
Sub OutageSource(ByVal sender As Object, ByVal e As EventArgs) Handles Year.SelectedIndexChanged
Dim year As Integer
[code].....
How do I assign the query result to a variable.I am using SQLlite. Below is the code for retrieving password from the User Table. I need to compare the given password and the given password.
Dim i As String
Dim p As String
i = txtUserID.Text
[code].....
I'm looking to store the result of SQL count function in a variable, i've tried numerous ways but haven't managed to get it to work?
View 3 RepliesIm trying to get the result of an SQL statement and store it in an integer variable "count" in vb so it can then be displayed on my website showing the user the total Open records:SELECT COUNT (recordID) FROM [tbl_Records] WHERE [Status] = 'Open'
View 2 RepliesI'm just wondering if it's possibe to get the results from a query and then assign the results to a variable. So I will run a query which will return the names of the tables stored in the database, then I want them to be stored in a variable. So it would be something along the lines of:
Dim strFrom AS String = "FROM "
strQuery = "SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'Database1'"
con.Open()
[Code]....
Private Sub cmdLogin_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles cmdLogin.Click
Dim conn As MySqlConnection
[Code]....
i supposed it can show the result of count(ID), in this instant it is the number of records count on the OUTBOX so the debug.writeline is RESULT, instead of now it is showing "SELECT COUNT(ID) FROM OUTBOX"
I'm relatively new to VB. I want to perform a SELECT statement that uses a variable to return a value, example;
mysql> SELECT room_description FROM room_descriptions WHERE current_room = 'someVariable';
And display the result in a TextBox i.e. TextBox.text = someVariable.
So how do I perform a query from VB that passes a variable? How do I assign the result to a variable?
I've actually gotten this program running on paper, BUT, when I try to write a code for it, it doesn't work . . . somewhat . . . When the user clicks the compute button, the total value of inventory is computed by multiplying the cost per item times the quantity of the item and then adds the result to the value in an accumulator variable.
So far this is what I've come up with:
CODE:
The quantity and cost per item is suppose to multiply each row, but it only multiplies the first row.
Variable 'loNode' is used before it has been assigned a value. A null reference exception could result at runtime.
why I am getting this error?
Imports System.Xml
Module Module1
Sub Main()
Dim doc As New XmlDocument
[code].....
I have a situation to show response coming back from host in some control of a Form and want to print it.The response is coming from Host mainframe system in text based format. I want to show the response in a graphical format. I am looking for suitable control that help me to print and should look like word document. I looked PrintPreview and PrintDocument controls but my requirement is there should be some control on Form where my formatted output should be placed (like Rich Textbox). Which control I should use.
View 6 RepliesI'm having a problem with part of my application I'm trying to get the directory entry for a computer object in AD (it could be mutiple computer objects based on whether or not the users passes a wild card for the object name). These names would be added add a child node of the parent node "Computers" in the tree view. I'm just having problems with using the search results...
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim parentCNNode As TreeNode = New TreeNode("cn")
TreeView1.Nodes.Add("Computers")
[code].....
I need a few threads working simultaneously with URL requests in a VB.NET 2010 app. Once one of them finishes, it should continue with the next task in a list. I'm new to using threads. Since it seems like I can't declare an array of BackgroundWorker, I thought I'd have a control class that creates an instance of a task class for each task, which in turn starts a BackgroundWorker in its constructor.
However, with this approach I'm not sure how to report the result back to the control class upon completion. I had this vague idea that I could send a reference to an object in the control class (or to a public event I can trigger, is this possible?), but then I have to somehow store this address until the work is done. And I don't know how I can store the address from a ByRef for future use.
I'm currently working with a client's VB.Net code, which was developed for them by a small development shop a few years ago and which they purchased and have been maintaining and uprgrading since. This client's primary developer is out on indefinite (likely permanent) medical leave and I'm now filling in until they bring in a full timer (as I'm a contractor here). My current task is to add some functionality to a the VB.Net code they purchased. I'm finding practices and techniques in the code that absolutely baffle me and can't make the code do what I want. I'm starting to wonder if it's me and was hoping to get some thoughts on the code I've encountered.
For example: Setting a variable to accept the result of a function by calling the function with many parameters, clearing the parameters in the function, setting them to some value, calling another function with those new values, then never using the values returned by the functions. I'll add a code snippet in the first comment since this is already getting long.
I want to use explicit conversion (CType function in VB.NET) to convert the variable d from double type to integer type and store the result as 132.
Imports System.Console
Module Module1
Sub Main()
[CODE]...
This is my code. But Visual Basic tells me an error: Error1Type 'i' is not defined.C:\Users\mihaispr\Desktop\Conversie explicita\Conversie explicita\Module1.vb1922Conversie explicita
I am working on a custom report in access and I do have a query which I want the outcome to appear in a text box control. Howver when I link this under the control source property, It returns an error.
View 1 RepliesI'm trying to lern VS 2010 from VB 6 and one of the things i'm hawing a problem whid is control array.In vb 6 if you create a text box it's named "Text1" and if you yust copy it and paste it it renames to "Text1(0)" and the new one's name is "Text1(0)" and the code would lock like this
[code]...
then it would print for each loop the random result in one of the text boxes corresponding to i.
How do i do this in VS 2010?
I am currently having a headache on how to solve this problem that i am facing. here is the situation: I have a combobox and a list box on the main form. The combobox will get the data from the ms access database. In the database, i have the details of a person's IC, Name and DOB say for eg on one entry I have D215311523C,SHAWN,13/04/1987 So now, my combobox on form load will show the list of dates in the database to allow the user to search base on the date itself by clicking on the selected date. So when the user clicks on the particular date say 13/04/1987, people in the database whose birthday is 13/04/1987 will be shown on the listbox.Meaning to say if i have 3 entries whose dates are the same 13/04/1987, 3 entries will appear. If there is only two entry, then two results will be shown. But now, when i do a single click on the date, one result will be shown. That is correct. But the problem is when i click on the same date again, three of the same results will be shown on the list box. that is it will display : 13/04/1987 13/04/1987 13/04/1987 which is not the case. Then it will show more duplicates of the same results if i click more times on the same date which should not be the case.
Dim n As Integer
Dim numbers() As Integer
Dim StartFrom As Integer
Dim EndAt As Integer
[code].....
I am using a datagrid in my where i am having four columns. In first column the parameter values are entered and in the second column measured value is entered and in third column the nominal value is entered.Inthe fourth column the result is displayed by subtracting the measured value and nominal values. I am doing this calculation in Datagrid cell validated event. What i want is,there will be many rows in the grid,when typing the value in the third column the corresponding result will be displayedin the rowof theresult column,save button will be displayed while the form loads,when the calculate part is completed that is there should not any cell of the resut column empty then i should enable the save butto.
View 2 RepliesI am encountering the following issue So i have a device that sends stuff at the serial port, i then parse it and put it into an array of bytes like that:
Dim HCI_Command_Rcvd_Byte() As Byte All good till here What i wanna do is make an array and put this result every time the serial port gives me a new result, for example:
[Code]...
Basically what i wanna do is let the port parse the messages, fill in the array with the result at an empty spot in this array and then i will have a separate thread that will look in into this array in each non empty space and after it looks into the non empty space it will use or discard the info and also mark this space as empty (after it checked)
I just read about DataSet in VB.NET, it uses disconnected concept. My question is: if my apps has "List All" button that query data from 1 table in the database, and that table has "very very very" many rows, so my DataSet will be filled with those data and eat up memory. Can I limit the data that being put to the DataSet from that query? But I want to be able to retrieve the next data from the same query if the user want to see it?
For example:
I have 1000 rows in my database, and i query all of them. But I just want 200 rows being inserted to my DataSet, but if the user want to see rows number 201 and so on, I want to be able to retrieve the next 200 rows, and so on. So it just like cutting those data into a group of 200 rows. Can I do this with the concept of "disconnected" of the DataSet?
I have a user control that checks if a certain query string and session value are present then returns a boolean based on that, if it's true I want to set the master page. The page is throwing an Object reference exception when it tries to call the method EditUser1.UserAuthorization(). Why is this happening? I imagine that the method doesn't exist at that point in the stack. Protected Sub Page_PreInit(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreInit
[Code]...
I'm trying to add a varible to a control, so I can reference the Variable with the Controls name. I would like to set the variable how you would set a regular Integer. [code]...
View 3 RepliesI have the following code inside my MDI parent form:For Each crl As Control In me.Controlscrl.?????Next
The code mainly used for getting some info from all child forms.I can get all the general property like size, location by crl.size or crl.location. But if all the forms have an own variable like myTxt. How could I get this own variable by this For Each method?
I have a simple control that sets a variable to a value. What I want to be able to do is check the value of this variable on another form.Here's the code:
[Code]...
What type can i assign a for loop control variable? I want the for loop to be the output file of a calculation, but i can not define it as anything, and i do not know how to write it so that the output is actually what the code spits out once the code has finished running.
[Code]...
Is it possible to use a variable as part of a control name kinda like you would use a variable in a SQL statement. For example:
Lets say we have 4 text boxes txtP1Val, txtP2Val, txtP3Val and txtP4Val. Is it possible to have the P1 - 4 as a variable so it would be "txt + Some string variable + Val"
I'm working on a function that handles events from a number of buttons and trying to define a Select...Case based on the clicked button. Something like this...
Private Sub btnClick(ByVal sender As System.Object, ByVal e As System.EventArgs) _
Handles btnThis.Click, _
btnThat.Click, _
[Code]....
which don't work either. Is there any way I can define a Select...Case in this manner or is it always destined to fail due to the attempt at comparison of reference types?
i have few cotrols on form (text box, combo box, checkbox etc). Thru some condition i stored the name of the control in a variable.
for example
dim cntrlname as string
if x=1 then
cntrlname = 'txtCode'
[code]....
at some other place on form i want to use above variable to give the focus to control.
Basically, I have a large number of text boxes. Within these text boxes, I'll be doing calculations based on user input and other things. These boxes will be grouped by numbers, eg Cost1, Profit1, Stock1... Cost26, Profit26, Stock26. Without too much explanation, I went to write a FOR loop to perform a repetitive calculation across multiple groups, and the following line came up.
FOR num = 1 TO 26
Cost(num).text = ItemCost
What I've tried to do is use a variable to decide which 'Cost' textbox, from the available 26, to use in the calculation. For whatever reason, it won't work. I would like to be able to use a variable to specify exactly which textboxes I want used, so that on the 3rd pass of the loop, the 3rd box is used, and on the 19th pass, the 19th box is used. Otherwise, I'd just have to do each calculation separately, and write the same thing 26 times, with slightly different numbers.
The basic question is can I assign a variable to represent a control? As an example which of 12 tickBoxes have been ticked. Is this possible with a for next loop?
View 5 Replies