THis code extract a value from a table to a var...
Dim var_IES_fornecedores as double = 0
For Each dRow In ds.Tables("Tabelavalor").Rows
If dRow("numeroconta").Equals("221") Then
[CODE]...
This is the problem...the numbers after the period should be just 2 and not a lot of numbers...everythin wrong with the code?
this application for computing the gcd but it give me just the value for first iteration but i need the final values of x2 y2 a
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim x1 As Integer
Dim x2 As Integer
Dim y1 As Integer
Dim y2 As Integer
[Code]...
phi(n) to any number in this code give me one?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim n As Integer
n = CStr(TextBox1.Text)
[code]....
I am currently writing a code that prompts a user if they want to convert F to C or C to F, two functions with the calculations. My problem is my loop, it exits one time through and doesn't prompt again. And also doesn't display the final result.
' VB Script Document
option explicit
const menuBar = "Temperature Conversion"
Dim userPrompt, prompt, Temperature, toCelcius, toFahrenheit
prompt = vbOk
Do While prompt <> ""
[Code] .....
this application for computing the gcd by using extended euclidean but it give me just the value for first iteration but i need the final values of x2 y2 a
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim x1 As Integer
Dim x2 As Integer
Dim y1 As Integer
[code]....
im parsing the data from a webpage... It basically contains a table whose source code ive pasted below.... Now i need to get the values of each cell of the table into a listbox... So basically i need to extract the numbers in the <td> tags... Now the table has approx 10 values similar to the 4 ive added below..
<table cellspacing="0" cellpadding="0">
<tr>
<th>Serial NO.</th>
[code]....
I want to be able to get the one record I return from a table and put the results into text box's directly rather than put the result into a combo box and then transfer the text across.
Private Sub GetStationStats()
conn.ConnectionString = myConnString
Dim myCommandStationStats As New MySqlCommand
Dim myAdapterStationStats As New MySqlDataAdapter
Dim myDataStationStats As New DataTable
Dim SQLStationStats As String
[Code] .....
The fields Signon and SignOff, plus many others which I didn't include in this sub. Above code does work, its how to get it into a text box.....
I am looking for a logic that loops to all records in a temptable and checks if the record exists in the final table (structure is different, only some fields are to be inserted in final). When the record does exist in final, a record should be created in a table duplicate.
[Code]...
My code Adds a New Row from a Source Table called "objTablaOrigen" To a final table called "objTablaDestino". This tables are passed ByRef because they come from a DataSet respectively. objRowNuevo is The Row that will be added to "objTablaDestino" The data from "objRow" is well copied to the "objRowNuevo" (that is the new Row with type of objTablaDestino).
'The problem occurs when the instruction Add is executed. ¿What happens? The new row is added as well, but this generates an Exception with the next message:
[Code]...
I am having trouble trying to get my shared class final value
Class name : Encryption
Public Shared Sub PassEn(ByVal PassTxt As String)
Dim strText As String = PassTxt
Dim salt As String = "61651616516161651615"
Dim bytHashedData As Byte()
[Code] .....
I am trying to call this from the call and get the return hash but when I try to make a global variable it doesn't allow it. How would I call this and get "HashValue" on to a textbox on my form.
How do I extract a datum from a table and visualize it in a form control?. I'm using Visual Basic 2008.
View 3 RepliesI'm trying to write an application with vb.net that could interact with a Borland Interbase database. I would like some help to know:
- How to connect with the database
- How to extract a table from the database
- How to edit the values, save the database and close it.
I am currently updating an application I wrote to view Car Insurance Policies, using a backed SQL database and a front end vb.net GUI. I now need to make a change.
I haev added a new table which has all Active Policies, and i have the old table with every policy there has been active or not. We do an import from a separate company, and there is no Active/Not Active field.
I need a query/code that will populate an "Active/NotActive" field in the old table. For example:
CODE:
I'm wanting to extract a table on a regular basis from an HTML web page in to a listview control. Before I start the long winded manual process (which I'm sure I can do, finding strings etc). I was wondering if there was a built-in way with VB.NET?
View 6 RepliesI want to execute an SQL statement and put the result in to a data table.
Sub getvehicletypes()
Dim dt As New DataTable
Dim intLine As Integer = 0
[Code].....
Once Ive got it in a dataset I need to work out how to search the dataset for a code and return the corresponding description and vice versa
I need to pupulate a Grid, but i like to do like Microsoft SQL Server Management Studio, when you make a Select to a table with bounch of rows, it start show the result but in the botton still retriving data.So you can start looking the data, not like you get the data and after you get the last row you can asing to the Grid.
View 6 RepliesI am new here and really excited to see the huge resources on this forum for vb.net. I have just started my learning of vb8 and need to create some basic applications for my personal use.I need to develop an application that can extract data from a html table and store that data into Access database. I have learned to create web browser on Visual Studio 2008. Below is the link from which I need to extract data and store into a database
View 3 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?
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?
Does anyone know how to implement in VB an algorithm for final differences that changes the network (the matrix) during the computation (decrease its dimensions)?
View 1 RepliesThe program I am making contains many Form ,and I see that adding Forms increase the size of the final .exe . Is there any way to avoid making the large .exe ,as I have came to know that Large .exe is not good and also consume more RAM memory.
View 8 RepliesI've looked up this answer and changed 'build' option to embed the files but I still get a io file not found error. where exactly are my resources located? atm my code is this:
Private Sub TextBox1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown
Select Case e.KeyCode
[Code].....
Dim Test_Output As System.Byte = 0
Try
For test_value As System.Byte = 0 To 255
Test_Output = test_value
Next test_value
Catch ex As Exception
MsgBox("Exception occurred: " & vbNewLine & "Test_Output is: " & Test_Output.ToString & vbNewLine & ex.Message)
End Try
i have a little problem with the ping in vb. i have a richtextbox and i want to write in a text file the result. I done it, but my txt file loks like this:
[Code]...
I'm making a program where the answer to a question is a number(0-100) ends up being the file name(picture), EX: 10 = 10.jpg or 98 = 98.jpg this does not work, is there something that will that pulls it out of my resources.
result = 98 PictureBox1.Image = My.Resources.result
I have a BaseClass, a DerivedClass1 and a DerivedClass2 from a third party library. DerivedClass1 and DerivedClass2 both inherit from BaseClass.There's a ContainerClass, from the same library, with a member variable ActiveItem, which can be of DerivedClass1 or DerivedClass2, so it is declared as BaseClass.I want to know if ActiveItem is of DerivedClass1, as it can change in runtime without notice.If I do
Dim isDerivedClass1 as boolean = TypeOf(oject.ActiveItem) Is DerivedClass1
then I get a compile time error, telling me that ActiveItem can never be of DerivedClass1 type.I have tried several combinations of GetType and TypeOf but it doesn't seem possible to check this. I have also tried to declare an auxiliary DerivedClass1 variable and comparing their types, but haven't got any luck either.
Edit:The following code doesn't compile in vs2005 SP1.
Public Class Base
Public x As Integer
End Class
Public Class Derived1
[code]....