I have a Repeater... And it has a Weight field. the weight it displayed in a textbox. I have this piece of code:
lblTotalWeightCalc.Text += NewDV.Item(i)("Weight")
This will get the Weight and display it in my label. But when I select more than one item (which will have two weights) it will show: For Example:
Item #1 : Weight = 20
Item #2: Weight= 50
The total Weight= 2050 (it doesn't add them together) I need them to be added together....
I have a question related to asp.net and vb.net. I have a repeater control that I bind some data to and allow users to update/change fields within certain text boxes. I added a validation control to trigger when the user doesn't enter a valid date or the text "TBD". On submit, I want to go through and highlight each field where its corresponding validator is not valid. This is my current code, but I am lost as to how to find the text box control.
Sub ValidateDateField(ByVal sender As Object, _ ByVal args As ServerValidateEventArgs) 'validate against three conditions - date, "TBD", and "N/A"
[Code].....
how to get cont = textbox1row1 of my repeater control.All examples I have seen so far directly state the control as in text1.BackColor =
I'm trying to produce a repeater showing amounts of money taken by various payment types into a table.Payment types available come from a global settings file as an array, I am creating a dataTable by looping this list and extracting sales reports (there might be a more efficient way than this loop, but this is not my concern at the minute).My question: How do I bind this to a repeater and display it when I dont necessarily know the table column namesI've tried various methods to give the table a header row and give the columns numerical names from a for > next loop, but am either getting no results, orystem.Data.DataRowView' does not contain a property with the name '7'. < or whatever numberThis is where I currently am:
EDIT: JUST REALISED MY CODE WAS AWFUL, SO UPDATED: Dim paymentTable As New DataTable("paymentTable") For j = 0 To UBound(paymentTypes)
I have a Data Repeater to which I need to add x number of images depending on their existence in the database.I need the images added within hyperlinks for Javascript functionality. In order to dynamically add the hyperlinks and images I have placed them within a panel in the data repeater and am adding them in the ItemDataBound event.The problem is that only the first image is being written to the datarepeater.[code]
I am using a repeater to build a custom table. However, I can't figure out how to make the table show subtotal if the next rows tour does not match the previous rows.
Something similar to that.
row1 tour1 row2 tour 1 tour1 subtotal
[Code].....
but this shows all the data in the nested repeater not the ones that match the parentrepeater fields for example tour,theme,dep7 should match in the child repeater
I have a parent repeater with nested repeaters.My problem is I am trying to use 'Next' and 'Previous' buttons to rebind my repeater (rptTabContent) and thus the inner repeaters also, but when I try to manipulate the state of these links during the ItemCommand event they are overwritten by the bind.
From within Excel, I want to import data from Access. This is simple enough using Microsoft Query. What is not so simple, at least to me, is how to get the SUM of numbers in a specific field in a specific table in Access. I do not need to import every number in the field only the SUM of the field. I need this 'total figure' to be placed in a cell in an Excel spreadsheet.
The data is listed in the Access table in this order: (there are others but these are the three I am interested in) TimeStamp, Terminal, TransActionTotal
Simplistically, there are three cells (A2, B2, C2) on on the spreadsheet (one for each terminal). The first should show a total for the day for Terminal 1, the second for Terminal 2 and the third for Terminal 3. Is there a way to get Excel to read the data in the table, add up the appropriate fields by date and then write this total in the appropriate cell? If it makes it any easier, the date is recorded in another cell on the spreadsheet (let's say E1).
How do i validate a field which contain both characters and numbers? For example, I have a field call Item ID and it must be in the form of ABC123 where ABC is the fix characters that will appear in all the Item ID and 123 is the one that will change accordingly.
In my application I have fields where a phone number can be copied and pasted in a field. I want to strip that number of ),(,- and spaces. I want to use a function so I can just give the number a value like:
Public Function StripPhoneNumber(ByVal PhoneNumber As String) As String PhoneNumber = Replace(PhoneNumber, "'", "") PhoneNumber = Replace(PhoneNumber, ")", "") PhoneNumber = Replace(PhoneNumber, "(", "") PhoneNumber = Replace(PhoneNumber, " ", "") PhoneNumber = Replace(PhoneNumber, "-", "") Return PhoneNumber End Function
Then in my form just simply type Phone= StripPhoneNumber(txtPhone.text) I just needed to add the Return. It works. What do I need to do to that code to make it return a value?
I posted in the Database development forum, but no bites. I have field names in my Access table which have a number as the first character (i.e. "2x2"). Evidently, the DataAdapter doesn't like this. I'm able to view the data in a DataGridView, but I get an exception when I use DataAdapter.Update.
Can I modify my sql statement to make the command builder work or do I have rename the fields?
For example:
"SELECT [2x2] as twoBytwo..."
Changing the names of the fields would be a huge pain-in-the-arse!
I am creating an application install program, but one of the main things i cannot get working is the combobox, this is a drop down list of all my applications that i have put in there. I was wondering if there was a way you could tell the combobox to look at a directory or share and list the names of files within it? So, for example i could place 5 programs inside a share or directory then when i run the program and the click the drop down combo the 5 programs are listed and then i can click and install this program. Also then if i add/remove any programs it also removes it from the combo list.
I'm using ms access 03 to fill a datagridview no problem. I have 4 fields(id, first, last, points), but I just want to fill one in a combobox I have. Here is what I'm using to fill the datagridview:
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsPC #6My Documentsstudent.mdb") Dim sql As String = "Select first,last,points from student" Dim oledbAdapter As OleDbDataAdapter Dim ds As New DataSet [Code] .....
How could I get a combobox to just display just one field, like idk if I'm explaining myself correctly, like a SQL statement look like this: Dim sql As String = "Select first from student" but just for my combobox.
Possible Duplicate: Retrieve identity value from inserted record's primary key.I have a field with a unique field (that I don't have to update automatically) called ID. I'm using this code to add a field to it:
What I need to be able to do is get the unique field it adds. It +1's to ID every time I add a field there, but how do I get that without hacky database looping?
I have a datagridview named Partcotdatagridview. In this datagridview, I have two columns. The first column has a combo box with some names in the data source such as John, David, Alex. The second column is designated for amounts. Each person will have different entries in the datagrid I will select a name and enter an amount for that person. I would like to display the total for each person in 3 different labels in a different form.
ok the problem is that when a button is click I want it to add 1 (+1) to a textbox. This process will keep on going on till I tell it not to...How would I just keep a running total of whats happening in the textbox...What I mean to say is that if I pressed the button 10 times, instead of it showing:111111111 I want it to automatically add the numbers up to show 10 instead.
i have the following piece of code: txtGrandTotal.Text = Val(textbox1.Text) + Val(textbox2.Text) + Val(textbox3.Text) If the numbers entered into textboxes1,2 and 3 are positive integers it all works fine, but if for example the following happens i get unexpected results textbox1 has the number 3, textbox2 has -1 and textbox3 has 6. I expect the result to be 8 (3-1=2 + 6) = 8 Instead I get 14. I understand the concept of precedent but how do I set it if I don't know if the number entered into textbox is positive or negative?
I have a field in my db that stores the path to a picture that will be printed on the report C:Picturespic1.jpg). When I add the field to a input form, I want to allow the user to hit a browse button to select the path and picture name and then store that selection in the field. How do I set up the field on the form so they can do this? I am using VS2008.
How may i retrieve the total number of records from a table via a SQL select, store it in a variable & in turn, add '1' to it @ a textbox to simulate the addition of a new record?[code]...
I know that when I add a record to a table through a binding source using a binding navigator - it completely handles the IDENTITY PK (it's bound to a textbox and you can see it immediately).
Now I'm trying to do this differently in another part of the program - here I only have a BINDING SOURCE - that's bound to a DATAGRIDVIEW.
I put a new record into the DGV like this
Private Sub vendorfilesDGV_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles vendorfilesDGV.DragDrop If e.Data.GetDataPresent(DataFormats.FileDrop) Then
I'm making a program as part of a college assignment that requires my to add up the contents of an array. Now the array has 20 places, and the only method I know of atm is:a + b + c + d + e etc...They are all different numbers so I can't just do a * 20, I need a more code efficient way of adding all these numbers up, is this possible?
I have a text file (*.txt) with a name in each line, like this:
Joe Dane Lisa Kelly
Now I want each name added with a number from 1 to 99.
Like this:
Joe0 Joe1 Joe2
[code]....
I have folowing code:
For n As Integer = 0 To (numbernames) - 1 strContents = objReader.ReadLine() For i As Integer = 0 To 100 - 1
[code]....
With this code all happens ok and a new text file is created with the desired name-list with added numbers.The only problem is that the last name doesn't get a number added from 0 till 99 but for example 0 till 17.
I'm trying to add certain numbers together from a textbox full of numbers from 1 to 10. This is my
Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub[code]....
When the button is clicked, it gathers the list of numbers from the test.txt file and displays it in the textbox. Now what I want to do is make a label so that after it streams the data and displays it in it's multi-line text box, is for every 10 and 1 displayed on one line, it will subtract 1 from the number in the label. For every 2,3,4,5,6 I want it to add 1. For every 7,8,9 it will not add anything.For those who can tell I'm a blackjack fan and I was curious on how to keep a running count in a label from a multi line list of numbers.
I am trying to add up numbers in a listbox.I know how to add them up and make them display on a messagebox but what I cant do is add the numbers in one listbox and then add the numbers in another listbox and subtract the total of the numbers from 2nd listbox from the total of the 1st BUT instead of displaying them on a message box how would I output those results into a label?This is the code I have for outputting the totals of a listbox onto a message box:
------------ Dim intTotal As Integer = 0 'Running Dim intX As Integer = 0 ' Index Position For intX = 0 To lstDebitsBalance.Items.Count - 1
[code]....
btw the name of the second listbox I want to sum up is lstCreditsBalance
