I also databinded the name of each item to a dropdown list.
Code:
DropDownList1.DataSource = metalsSource
DropDownList1.DataTextField = "Name"
DropDownList1.DataBind()
As all data will be on a grid how do...
choudhmh
Last Activity: Jan 31 '15, 02:31 PM
Joined: Feb 27 '07
Location:
-
Thank you its functions.
I also databinded the name of each item to a dropdown list.
Now say if I choose Silver from the dropdown list, how will I display on a say textbox the price of Silver in one of the currency rate say in Euro or Dollar
As all data will be on a grid how do... -
Thank you very much for the code. Sorry been away from coding for a week concentrating on the theory aspect of the course.
The code works perfectly.
When it data binds it also displays the rates for each currency.
tried amending the code so the databind is not shown instead it just reads it and calculates EURO AND Dollar value. Is there a way of doing this?
Again thank you very much for showing me the rope.
...Leave a comment:
-
Now having issues with this line
Gridview1.Datab ind()
It throws an exception stating object reference not set to an instance.
Had to physically add in the path to the csv file instead of the servermapLeave a comment:
-
Tried adding check for length but still the same issues as mentioned above arises:
...Code:If File.Exists("C:\Users\Mahmud\Documents\Visual Studio 2013\WebSites\WebSite2\metals.csv") Then Dim data As String() = File.ReadAllLines("C:\Users\Mahmud\Documents\Visual Studio 2013\WebSites\WebSite2\metals.csv") If File.Exists("C:\Users\Mahmud\Documents\Visual Studio 2013\WebSites\WebSite2\rates.csv")Leave a comment:
-
Done what you asked me to do.
an IndexoutOfRange Exception is thrown on this code:
metalsSource.Ad d(New Metal(data(0), data(1)))
It seems metalsSource cannot retrieved the data. What else can be doneLeave a comment:
-
Tried your code with the metal as object. Keep on getting errors:
...Code:Imports System.IO Imports System.Data Public Class Metal Inherits System.Web.UI.Page Public Property Name As String Public Property BasePriceInGrams As Double Public Property AmountInGrams As Double Public ReadOnly Property Cost As Double Get ReturnLast edited by Rabbit; Jan 13 '15, 10:54 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. Second warningLeave a comment:
-
Sorry its a project for college, so a bit confused on what your trying to communicate.
The model is not doing any calculation at the moment, its just reading data from the CSV (metal) file.
I need to assign calculation on the Euro & Dollar column using the figures from the pound column and rates from the CSV file.
If you can direct me with some codes that will be great; all files are attached with the website I'm trying to...Leave a comment:
-
Bit confused with your model.
The data is in a CSV file I only made it into a table so you understand.
I have 2 CSV, first one should display the metal type and the price in pounds. These item should be shown in DataGrid.
The next CSV has rates in Euro and Dollar, I should use (read) the rates and use (multiply) by the pound rate value in the DataGrid column 2 and get a total value on column 3 & 4:
...Code:Imports
Last edited by Rabbit; Jan 13 '15, 12:49 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data.Leave a comment:
-
Read CSV Files, then Display in Table format using variables
I need to read and display data from a csv file in a table format. I then will need to use these data to calculate different values.
This is how the CSV file looks:
...Code:<table> <tr> <td>9 carat gold</td><td>11.87</td> </tr><tr> <td>18 carat gold</td><td>23.73</td> </tr><tr> <td>Silver</td><td>0.49</td> </tr><tr>
-
The Null is stopping at:
password = DLookup("Passwo rd", "tblUsers", "[UserName]=" & Me.txtUser).
Also if i keep the:
On Error GoTo Err_go_Click
then i get this error: Label not defined.
If i delete that line then the null error comes in.
Thanks for all your helpLeave a comment:
-
now i get
run time error '94'
invalid use of nullLeave a comment:
-
I tried what you showed me, i still get the same error;
"compile error: Syntax Error" on If password = Me.txtPass
Not sure whats the problem. I've named my textboxes as txtUser & txtPass - but still get the error. Try on your one - i'm giving up on this now.
Thanks for your helpLeave a comment:
-
I inserted this code in the button click event handler but keep on getting a command syntax error on If password = Me.txtPass.
at present my table has three field loginid, username and password. Do i have to specify the table through a select statement.
Private Sub go_Click()
On Error GoTo Err_go_Click
Screen.Previous Control.SetFocu s
Dim password As String
If Not IsNull(Me.txtUs er)...Leave a comment:
-
Login Code
I have a problem; i know its a simple code but find it difficult to contruct the code.
I have two fields username and password. I need some code, when a user clicks the button event in the form it checks against the username and password in the table to see if its correct; if correct it let you login else a message box should show either the username or password is wrong.
Can someone give me a sniplet of the code that...
No activity results to display
Leave a comment: