Visual Basic

Convert Number to Currency

24-Mar-07 6:01

Christian Graus wrote:
I'm not sure if a font is serialisable, itself. It could be.

Even thought the class is tagged Serializable, it's not do-able using the standard XML Serializer methods. You have to write your own Serialization wrapper to get it to work. There's an example in the "Community Content" section on it on this page[^].

Dave Kreskowiak
Microsoft MVP - Visual Basic

mdDiwan24-Mar-07 1:55

mdDiwan

24-Mar-07 1:55

How to conver Specified Number into Currency. Ex Rs.1100 into ONE THOUSAND and ONE HUNDARD

Mohamed Diwan M
Cell:99403 85545

Dave Kreskowiak24-Mar-07 4:26

24-Mar-07 4:26

This is a typical homework assignment. Noone here is going to give you the code to it. Google for "convert number to words" and you'll find LOTS of information on it.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Christian Graus24-Mar-07 4:32

Christian Graus

24-Mar-07 4:32

ONE HUNDARD.......

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Dave Kreskowiak24-Mar-07 5:53

24-Mar-07 5:53

I didn't even notice that! Hmmm... I think that'll make him a future Java programmer!.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Christian Graus24-Mar-07 6:12

Christian Graus

24-Mar-07 6:12

ROTFL - does Java come below VB in the pecking order ?

Dave Kreskowiak24-Mar-07 7:16

24-Mar-07 7:16

What do you think?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Christian Graus24-Mar-07 4:33

Christian Graus

24-Mar-07 4:33

When you google for help in doing your homework, you're converting a number into words, not into currency.

connectivity in vb.net

bhawna_k24-Mar-07 1:00

24-Mar-07 1:00

i m doing connectivity in vb.net
i m having problem while opening the connection
in code

myconnection.open
im having an error
"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll"
i cann't understand it

manni_n24-Mar-07 1:17

manni_n

24-Mar-07 1:17

can u provide your code ....
because this error comes for many reasons like if yr path in not correct or yr coonection string is wrong... and you have writtn wrong format etc
put your code, may be that cud provide some idea..
rite now its not clear what problem exactly it has...

bhawna_k24-Mar-07 2:05

24-Mar-07 2:05

Imports System.Data.OleDb
Public Class Form1
Inherits System.Windows.Forms.Form

Public mycon As New OleDbconnection
Public mycomm As New OleDbCommand
Public d As New OleDbDataAdapter
Dim i As Integer
Public strquery As String
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
mycon = New OleDbConnection("provider=msdaora.1;user id=scott;data source=;password=tiger;")
mycon.Open()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
strquery = "insert into bhawna values(? ? ?)"
mycomm.Connection = mycon
mycomm.Parameters.Add(New OleDbParameter("name", OleDbType.VarChar, 10, "name"))
mycomm.Parameters.Add(New OleDbParameter("class", OleDbType.VarChar, 10, "class"))
mycomm.Parameters.Add(New OleDbParameter("roll_no", OleDbType.Char, 5, "roll_no"))

mycomm.Parameters(0).Value = TextBox1.Text
mycomm.Parameters(1).Value = TextBox2.Text
mycomm.Parameters(2).Value = TextBox3.Text
mycomm.CommandText = strquery
i = mycomm.ExecuteNonQuery
MsgBox("record submitted")

End Sub
End Class

Pankaj Garg24-Mar-07 4:14

Pankaj Garg

24-Mar-07 4:14

Sir/Madam
Try ur connection string using the udl file.Hope this may help u.
Pankaj

Dave Kreskowiak24-Mar-07 4:24

24-Mar-07 4:24

There's just about never a reason to use a UDL file anymore.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Dave Kreskowiak24-Mar-07 4:24

24-Mar-07 4:24

Your connection string is bad. You're trying to use DAO (msdaora.1) which is older than dirt itself. Try http://www.connectionstrings.com[^] for using an Access database.

Dave Kreskowiak
Microsoft MVP - Visual Basic

bhawna_k24-Mar-07 5:34

24-Mar-07 5:34

i m cery new to vb.net i dont knw much abt it.whtever i knw is
if i run this command on server there is no problem

mycon = New OleDbConnection("provider=msdaora.1;user id=scott;data source=;password=tiger;")
mycon.Open()

i think for a standalone sys there should be data source value.if yes
if yes can u tell wht it should be.

Dave Kreskowiak24-Mar-07 5:55

24-Mar-07 5:55

The full path to your Access database file.

Dave Kreskowiak
Microsoft MVP - Visual Basic

bhawna_k24-Mar-07 6:09

24-Mar-07 6:09

my database is in oracle

Dave Kreskowiak24-Mar-07 7:15

24-Mar-07 7:15

I just assumed you were using access. Next time, specifiy which database you're using. It makes all the difference in the world how accurate an answer is going to be.

Now, which provider aare you using? If you don't know (you REALLY should!), then use:

Provider=msdaora;Data Source=yourDatabaseName;User Id=username;Password=password;

Dave Kreskowiak
Microsoft MVP - Visual Basic

bhawna_k24-Mar-07 21:25

24-Mar-07 21:25

i heard frm somwhere data source should be the host string
if yes then while opening oracle,there is no need for host string.i leave it blank

Dave Kreskowiak26-Mar-07 2:40

Crystal Report (Cross Tab Report)

26-Mar-07 2:40

Then how are you going to tell it which database to use?

Are you going to believe the documentation, or some rumor?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Shady Aly23-Mar-07 23:12

Shady Aly

23-Mar-07 23:12

dear all
how can i make my cross tab report designed by crystal report 9.0 direction Righ-To-Left , that problem faced me because my report has data in arabic language which force me to print report in right to left format to be suitable in reading.
thank you all

Application Path

siddhi030323-Mar-07 23:04

siddhi0303

23-Mar-07 23:04

Hi,

I have a vb.Net application saved in D:\VbProject\Library.vbproj.
In this folder there exists a bin folder.
I want to get the application path and for that i have used following line of code:
System.AppDomain.CurrentDomain.BaseDirectory.

But this gives me application path as D:\VbProject\bin. In D:\VbProject , I have a folder named DownLoad and i want the path to come as D:\VbProject\Download.

Please Provide me with suitable solution.

Thanks
Siddhi

Siddhi

Re: Application Path

JUNEYT23-Mar-07 23:47

JUNEYT

23-Mar-07 23:47

At design time Application path is actually under bin\debug diretcory. You can use Application.StartupPath statment to address to directory. If there is no directory as named DOWNLOAD, you should consider using Environment.CurrentDirectory + "\Download" (But this is not advisable because current directiroy changes when user deals with saving and opening the documents.)

I hope that helps! WTF | :WTF:

What a curious mind needs to discover knowledge is noting else than a pin-hole.

Re: Application Path

Dave Kreskowiak24-Mar-07 4:22