Im 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 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 RepliesI 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 have added a column to a Datatable called CallsPerDay which is there to tell me how many telephone calls have been made on a particular day or days.Is there a datacolumn.expression which will allow me to Filter on the day, count the rows and then populate this added column with the result.
View 1 RepliesI am looking for a way to count words in VB My full code is as follows Public Class lblTranslator
[Code]...
I've been working with my project. I make a quiz and I put check value for every label. If the user is correct the label with shows or else the label is in a hide status. My problem now is how do I count those labels to display his/her result. If there are 3 labels shown in the form in automatically the user got 3 points and that "3" with be put into a textbox...
View 5 RepliesI have a requirement where I have to add items into a List(Of T) (let's call it Target) from an IEnumerable(Of T) (let's call it Source) using Target.AddRange() in VB.NET.
Target.AddRange(Source.TakeWhie(Function(X, Index) ?))
The ? part is a tricky condition that is something like: As long as the as yet unenumerated count is not equal to what is needed to fill the list to the minimum required then randomly decide if the current item should be taken, otherwise take the item.Somethig like...
Source.Count() - Index = _minimum_required - _curr_count_of_items_taken _
OrElse GetRandomNumberBetween1And100() <= _probability_this_item_is_taken
' _minimum_required and _probability_this_item_is_taken are constants
The confounding part is that _curr_count_of_items_taken needs to be incremented each time the TakeWhile statement is satisfied. How would I go about doing that? I'm also open to a solution that uses any other LINQ methods (Aggregate, Where, etc.) instead of TakeWhile.If all else fails then I will go back to using a good old for-loop =)
I experience some difficulties with property Item of DataGridView component.
The application is made in Visual Basic 2008 Express Edition and I'm using Sql Server Management Studio as DBMS.
I have made a query starting from my tables and I want to add the result of query in a datagridview in reference with what the user selects: (I have 3 textboxes and 2 datetimepickers).
Here's the code in button search:
(don't know how to add the 5 components in the dategridview and integrate the query in datagridview).
My form is this:
Here's the full code of search button:(where I have problems) (I made a reader to read my query and I need to store the result of query in a datagridview related with what user types in the 3 textboxes and selects from the 2 datetimepickers.)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conexiune As SqlConnection 'for connection with sql server
[Code].....
I want to make a search form the user completes the 3 textboxes and 2 datetimepickers. (so five components).
Also I have a button called search and a datagridview.
When the user presses the search button it searches into those 2 tables (depending on what user typed in the 3 textboxes and selected on 2 datetimepickers).
Example of search:
The user searches like this:
When it presses the search button the results will be stored in datagridview(first textbox is the field DB-20-RTS from table PatrimoniuMasini and the rest are fields from the specified columns (name of labels) from the second table FoaieParcursMasina -is the second row from this second table).
Here's the code in my search button (don't know how I can store the 5 things(2 datetimepickers and 3 textboxes in the DataGridView) . My problem is in understanding the property item of DataGridView(DataGridView1):
DataGridView1.Item(row_index,column_index) -general syntax
Here's the full code of button search:
Dim conexiune As SqlConnection 'conexiune cu sql server
Dim comandasql As SqlCommand 'cerere -interogare sql
Dim msg As String ' msg- variabila dk suntem conectati sau nu
[Code]....
What I need to do, is to call a SQL stored procedure from VB.NET, and then store the returned query value in a string.
View 13 RepliesWhat type of collection should I use to store data from a table (in a book) that has multi-dimensional Keys to get a single value result?
What is the best way to store and retrieve these values in a program?
In my VB.net code i have:
cmd.CommandText = "SELECT * FROM [strfg].[dbo].[Myfunc] (@MyParam)"
Dim myparam As New SqlParameter("@MyParam", a)
cmd.Parameters.Add(myparam)
The function (runnig on SQL server) returns a table with four columns, one row.How do I call this function from Visual Basic? cmd.ExecuteScalar() is obviously not correct. In c++ I use a recordset. What is the equivalent in vb? Does anyone have a short example?
How can I store the value of a variable into another variable that wont be changed unless it meets certain criteria
View 1 Repliestrying 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 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 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 RepliesI'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.
when the form loads, there is a table and i use code to set the row count to a variable from a previous page. this works fine. the problem i am having is that i cant get the row height sizes to be evenly spaced, there is 1 huge row then heaps of tiny ones.
View 7 RepliesI 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]....
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 RepliesJust 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 have tried altering some code i have to ping an ip address and store the result in an access db.i had it working when i had the ip hardcoded in as a string but I am now gettin an error.instead of having the ip address hardcoded in to the code i want it to be read in from the access db but im now getting this error:System.nullreferenceExceptionbject reference not set to an instance of an object at...button1.click event args ei have underlined the piece of code i tried to change
Imports System.Data
Public Class Form1
Dim Ping As Net.NetworkInformation.Ping
[CODE]...
I 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.