Visual Basic

FirstPrevNext

Re: How can I format a numeric value? ofox24-Mar-07 3:13 ofox 24-Mar-07 3:13  ****************************************************** * in VB 6.0 * ****************************************************** Dim i As Integer i = 1 Dim s As String s = Fromat(i,"00") ****************************************************** * in VB.Net * ****************************************************** Public Function FrmtNum(ByVal n As Integer) As String If n<10 Then FrmtNum = "0" & n Else FrmtNum = n End If End Function if there is a time for non sense then you are running out of time Re: How can I format a numeric value? Dave Kreskowiak24-Mar-07 4:27 Dave Kreskowiak 24-Mar-07 4:27  How is it possible that it became more complicated to do in VB.NET than in VB6?? Dave Kreskowiak Microsoft MVP - Visual Basic Re: How can I format a numeric value? Christian Graus24-Mar-07 4:30 Christian Graus 24-Mar-07 4:30  ROTFL - it took me three looks to work out what you were saying 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 ) Re: How can I format a numeric value? Dave Kreskowiak24-Mar-07 6:04 Dave Kreskowiak 24-Mar-07 6:04  Did you catch his tag line too? Dave Kreskowiak Microsoft MVP - Visual Basic Re: How can I format a numeric value? Dave Kreskowiak24-Mar-07 4:29 Dave Kreskowiak 24-Mar-07 4:29  Easily handled by a custom formatting string: Dim str as String = myNumber.ToString("0#") Dave Kreskowiak Microsoft MVP - Visual Basic I see font... font.. font.. and more fonts... NANCO24-Mar-07 1:57 NANCO 24-Mar-07 1:57  hi everyone, can anybody tell me how to change font settings using fontdialog and a way to save the settings so next time I run the software the settings that I set will automatically take effect. and This forum is great. Re: I see font... font.. font.. and more fonts... Christian Graus24-Mar-07 4:32 Christian Graus 24-Mar-07 4:32  A font is made up of several things, such as a name, a point size, and flags such as is it bold, is it italic. A Font Dialog will return a font to you, you can then store the settings used to rebuild that font. I'm not sure if a font is serialisable, itself. It could be. A Font Dialog lets you choose a font, it does not cause that font to be used anywhere. So, what you want to do, is write code that assigns this font to whatever controls you wish to use it. Call it when the font is changed, and call it on startup, using the font you rebuild from the settings you saved. 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 ) Re: I see font... font.. font.. and more fonts... Dave Kreskowiak24-Mar-07 6:01 Dave Kreskowiak 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 Convert Number to Currency 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 Re: Convert Number to Currency Dave Kreskowiak24-Mar-07 4:26 Dave Kreskowiak 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 Re: Convert Number to Currency 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 ) Re: Convert Number to Currency Dave Kreskowiak24-Mar-07 5:53 Dave Kreskowiak 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 Re: Convert Number to Currency Christian Graus24-Mar-07 6:12 Christian Graus 24-Mar-07 6:12  ROTFL - does Java come below VB in the pecking order ? 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 ) Re: Convert Number to Currency Dave Kreskowiak24-Mar-07 7:16 Dave Kreskowiak 24-Mar-07 7:16  What do you think? Dave Kreskowiak Microsoft MVP - Visual Basic Re: Convert Number to Currency 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. 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 ) connectivity in vb.net bhawna_k24-Mar-07 1:00 bhawna_k 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 Re: connectivity in vb.net 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... Re: connectivity in vb.net bhawna_k24-Mar-07 2:05 bhawna_k 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 Re: connectivity in vb.net 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 Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 4:24 Dave Kreskowiak 24-Mar-07 4:24  There's just about never a reason to use a UDL file anymore. Dave Kreskowiak Microsoft MVP - Visual Basic Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 4:24 Dave Kreskowiak 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 Re: connectivity in vb.net bhawna_k24-Mar-07 5:34 bhawna_k 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. Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 5:55 Dave Kreskowiak 24-Mar-07 5:55  The full path to your Access database file. Dave Kreskowiak Microsoft MVP - Visual Basic Re: connectivity in vb.net bhawna_k24-Mar-07 6:09 bhawna_k 24-Mar-07 6:09  my database is in oracle Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 7:15 Dave Kreskowiak 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

Last Visit: 31-Dec-99 18:00     Last Update: 16-May-24 4:07 Refresh ᐊ Prev1...2682268326842685268626872688268926902691 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.