Can data from database be inserted in a label in vb.net?

Question

2.33/5 (3 votes)

See more:

I have 1 column currency in database, now i wanto display that currency in a label at runtime.is it possible?

e.g i have 1 combo box where different currencies are there and also another amt column.
now i want to display currency value in a lable rather than a textbox beacuse in textbox the amt will show and beside that if i take lable,then the currency will show which is fetched from database.

so can i display a value in lable fetched from database? and it should be dynamic at run time,like will change values as and when selected different currencies.

can anyone tell me.
thanks in advance

Posted 16-Aug-13 17:11pm

sudeshna from bangkok

Updated 16-Aug-13 21:43pm

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 17-Aug-13 0:41am

You need to tag the UI library or application type you are using. Of course, it's possible. And there is absolutely no difference what you update, a text box or a label. http://whathaveyoutried.com? Any particular problems?

One note: please keep in mind: there are no controls which are not "dynamic at run time". They are all equally "dynamic", even if you use the designer.

—SA

sudeshna from bangkok 17-Aug-13 0:48am

how to tag ui library or application? can you plz tell me? i dont know

sudeshna from bangkok 17-Aug-13 0:49am

Dim sumAmount As Double = 0
Dim premiumValue As Double
Dim vatvalue As Double
For Each row As DataRow In ds.Tables("item1").Rows
TextBox1.Text = DirectCast(row, System.Data.DataRow)("name").ToString()
TextBox8.Text = DirectCast(row, System.Data.DataRow)("bname").ToString()
TextBox2.Text = DirectCast(row, System.Data.DataRow)("place").ToString()
TextBox3.Text = DirectCast(row, System.Data.DataRow)("date").ToString()
TextBox4.Text = DirectCast(row, System.Data.DataRow)("year").ToString()
ListBox1.Items.Add(DirectCast(row, System.Data.DataRow)("lot_no").ToString())
ListBox2.Items.Add(DirectCast(row, System.Data.DataRow)("amt").ToString())

sumAmount = sumAmount + Convert.ToDouble(DirectCast(row, System.Data.DataRow)("amt"))

Next
premiumValue = (0.175 * sumAmount)
vatvalue = (0.07 * premiumValue)
TextBox6.Text = sumAmount.ToString()
TextBox5.Text = premiumValue.ToString()
TextBox7.Text = vatvalue.ToString()
TextBox9.Text = Math.Round(sumAmount + premiumValue + vatvalue, 2).ToString()

sudeshna from bangkok 17-Aug-13 0:50am

this is my code where in textboxes all the amt shows,i now want to display currency based on combobox selection

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 10186638 · Answer 1 · 2013-08-23T21:32:00

Solution 1

Label1.Text = DirectCast(row, System.Data.DataRow)("currency").ToString()

Posted 23-Aug-13 21:32pm

Member 10186638