I am creating an application for a friend and have no issue inserting or updating the table, but I am having trouble relaying the information from the query back to the corresponding textbox when searching for an entry.
This is the closest thing I've got to a working model, but I'm still getting and "array out of index error".
[Code].....
I have a VB.Net program that will basically make a query to a remote MS-SQL DB using TSQL, return two columns (normally 4 rows/records), 1 is a datetime and 1 is a double. I will then need to return the average of the doubles (which is easy in VB.NET).
As I will need to run this query perhaps 1000 times an hour (programmatically with different input parameters for the query), I am looking for the most efficient way to code this up so that it will take the shortest time to run. I tried SQLDataAdapter and then using dataAdapter.Fill and sometimes it returns an empty set although the raw select query has values returned.
how do i simply query the database and return values to my textboxes etc? all i can fiqure out is the default views but that is not what im after, also how to add data as well (lets say i have a text box with data and i wish to add it to the database)im sure its simple but i cant figure it out, in vba i just used the current sheets or tables but this is beyond me. i will admit it.
View 23 RepliesI have a stored procedure:
CREATE PROCEDURE [TestProc]
AS
BEGIN
select '1a', '1b'
select '2a', '2b', '2c'
select '3a', '3b'
END
If I execute the following query using SQL Management Studio,
[Code]...
How can I get the three result sets using SqlDataReader? Or even three SqlDataReader's? Or is it possible to get multiple result sets in just one query in VB.NET? Is DataSet my only option?
I'm not sure how to do the following (in VB.NET), I'm hoping you will give me some insight or examples on how it can be done. My database is an SQL one.I have an assets table, which in it has the amount, growth percentage, income percentage. There are multiple assets per client.
I need to get the amount, growth and income into three separate boxes or variables and I'm not quite sure how to do this. The only other problem is that there would be two or three rows returned also, which need to have those three variables or textboxes again.
So for x amount of rows, I need 3 variables which the amount, growth and income will go into.
The reason I need everything into variables is that I can't find an effective way of showing each assets growth over x amount of years and the income it will produce into a data grid view. I'm able to do it if I specify what the growth and income are on the form, but not through the query.
I have an assets table, which in it has the amount, growth percentage, income percentage. There are multiple assets per client.
I need to get the amount, growth and income into three separate boxes or variables and I'm not quite sure how to do this. The only other problem is that there would be two or three rows returned also, which need to have those three variables or textboxes again. So for x amount of rows, I need 3 variables which the amount, growth and income will go into.
The reason I need everything into variables is that I can't find an effective way of showing each assets growth over x amount of years and the income it will produce into a data grid view. I'm able to do it if I specify what the growth and income are on the form, but not through the query.
how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code
Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String
[code]....
visual basic 2008 express
access 2007 db
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.
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].....
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 RepliesI am trying to call a SELECT query (with parameters) in Access from VB.Net 2008. I am able to call queries without parameters using the code below. The problems are (1) how to apply the parameters to procName and (2) how to get a dataset returned. I have looked around the net for hours and have found some examples. However, they are all for ms access action (update, delete, etc) queries using ExecuteNonQuery which does not return a dataset.
[Code]...
I use this code to return records in a DataGridView:
[Code]....
I have a program with a lot of textboxes.They are all named Textbox[numbers].I have 39 textboxes.I want to take the text of textboxes 1-26, in order, and output their text into the clipboard, with a loop.I do not know how to make it so it only loops through 1 - 26, and make it not include 27 - 39.
View 7 RepliesI'm trying to do a LINQ Query against a typed datatable that will return me duplicated data.With out going into too much detail, here's the basic setup:
strCode1 - string type
intCode1 - int32 type
intAdjustor - int32
There are more fields but these are the ones that are important.I'm going to do my best to describe this, as it's kind of confusing.In theory intCode1 is a key for strCode1 (hence the names). So each time intCode1 is duplicated, the same strCode1 should appear. Example:
[code]...
Ultimately I'd like to get a List(Of T) - where T is my typed data row. In SQL, I would simply use a sub query, to get a distinct list of strCode1 and intCode1, then do a count, grouped by strCode1 where I get more than one row.I'm not sure how to translate that into LINQ, AND get the original types data rows returned in a list.
Is there another way to handle the leave event of multiple textboxes other then coding in each event handler? I may not be using correct terms instead of doing this: (Existing)
Private Sub leveladjstvaltxt_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles leveladjstvaltxt.Leave
If Me.leveladjstvaltxt.Text <> "" Then
Dim levels As Integer = CInt(Me.leveladjstvaltxt.Text)
Me.leveladjstvaltxt.Text = Format(levels, "#,###")
I have 30 TextBoxes all need same formatting , so I was trying to come up with something like this: (trying)
For Each ctrl As Control In Me.Controls
If TypeOf ctrl Is TextBox And ctrl.Text <> "" Then
Dim val As Double = CDbl(ctrl.Text)
CType(ctrl, TextBox).Text = Format(val, "#,###")
End If
I am stuck though and don't know where I would place that code if this is something that is even possible. Only thing I can currently think of is in the leave event which defeats the purpose, I wanted to avoid having to place the code in 30 different textoxes leave event.
I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox
sql =
"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.
Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....
I've created a log in system using a database and query builder to return the correct values, however, once the users signed in I need to bring up the rest of their data from the same table in the database. How'd be the best way of going about this? I'm not sure whether the log in should be changed to use the primary key as well.
View 2 RepliesI have four textboxes that only accepts numeric data.On each box is a corresponding checkbox.I want to have a button that will get the total sum of all textboxes wherein their checkboxes are on checked state.
View 1 Repliesi want to use DataGridView to display the result from 3 textBoxes?
View 3 RepliesI am working to make a function that will update the back color of a text box based on multiple variables values. I can write the code to do the calculation, but I am not sure how to make the function realize which text box to update (as I will have about 30 different boxes). Below is the code that I have for each box so far, but I will have quite a few more, and would rather use a function to reduce the amount of code, and also make it cleaner as well.
If sngPreviousPrimaryPropertyTotal >= sngPrimaryPropertyTotalCost Then
txtPreviousPrimaryPropertyTotal.BackColor = ColorProgramLightGreen
Else
txtPreviousPrimaryPropertyTotal.BackColor = ColorProgramLightRed
End If
[Code] .....
Or is there a way that I can tell the function that it's updating the text box that call the function in the first place? Say if txtBox1 has updated text and calls the function, then the function 'knows' to update txtBox1, but will update txtBox2 when it's called by txtBox2.
Am I able to return a value that belongs in more than one result?
I mean, I want to return a value that is based off of 2 calculations and I was wondering if this is correct:
Function CalcParkingFees() As Decimal
Dim dblDays As Double
Dim dcmParkingTotal As Decimal
[Code].....
I need to add the contents (integers) of two textboxes and display the result in a label. I've been trying like this within a button click event:
Private
Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
TextBox1.Text + TextBox2.Text = Label.Text
End Sub
But it doesn't compile, and I dont know why. I've used arithmetic operators before, but now I'm just confused.
here is my WCF server code (VB.NET)...
Service1.svc
Public Class Service1
Implements IService1
[code]....
For some unkown reason, I can run the VS 2010 client test and it the WCF host works fine. The code above just returns nothing (it's supposed to return a string)
I use this code to refresh my combox with bindingsoure but it cant return result.
Private chucvudatabindingsource As New BindingSource
chucvudatabindingsource.DataSource = dat.getChucVuCB()
cobchucvu.DisplayMember = "ChucVu"
cobchucvu.ValueMember = "ChucVuID"
chucvudatabindingsource.CurrencyManager.Refresh()
add a code to handle the TextChanged event of my Textboxes to clear the Result box.
Private Sub btnCalculate_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
txtResult.Text = txtRate.Text / 100 * txtAmount.Text * txtYears.Text
End Sub
[code]....
I would like to be able to return the text generated from an httphandler and insert it into my web page during an onload event. There are examples that show how to return an image by setting the image source to the path of the handler. But how do you do this for just text as in the "hello world" basic template. I would like the text value of a label on my page to be set to "hello world", preferably withour using javascript.
View 2 RepliesI have a stored procedure that repeats a block of T-SQL statements using WHILE logic until it finds a matching record in a table. When I execute the procedure directly from the SQL Management Studio, it works and returns a record, even when the statements within the WHILE logic have to be repeated over and over again before a matching record is found.
However, when I use the same stored procedure as the commandtext property of an sqlcommand object in Visual Studion 2008 (VB) and call the executereader method of the sqlcommand, the resulting SqlDataReader will only return a row if the T-SQL statements within the WHILE logic find a matching record after a single pass. If it takes more than one pass to find a matching record the SqlDataReader does not return a row. It's like it abandons the execution of the stored procedure after the first pass of the statements within the While logic, disregarding the repetition.
I have some pieces of code like this:
strSoftware = "select MobileSoftware.Entertainment, MobileSoftware.MobileApplication, MobileSoftware.RingingTone, MobileSoftware.Directory from MobileSoftware where MobileName = '" + strName + cmdSoftware = New SqlCommand(strSoftware, con)
drSoftware = cmdSoftware.ExecuteReader
When I write the query in one line, then it works. But when I do like this:
[Code]...
Anyone else have an issue using read, It appears when I use read it gives me the correct buys but returns the wrong integer value So I use it and it fills the Array i make with &h10, &h6 but read reutnrs number of bytes returned to 1. if there a better way to go with Vb.net with RS232 I mean really my projet dosent have anything out of the Normal
Friend WithEvents CashValidator As System.IO.Ports.SerialPort = New System.IO.Ports.SerialPort("COM1", 9600, IO.Ports.Parity.Even, 8, IO.Ports.StopBits.One)
CashValidator.Read(MyResponce, MyResponceLen, 4)
7 textboxes, 7 values, well not always as the textboxe might contain nothing
What im trying to do is add up the textboxes and return the value(total) in the array where am i going wrong??
[code]...