Using writeline to write string with leading 0's to excel worksheet columns? - Visual Basic Discussion Boards

virendra_0072-Aug-07 19:38

2-Aug-07 19:38

Hi! All,
My VB program is send mail by using OsSMTP.DLL and I am sending HTML message of the Email as a string. But in the string I am sending unicode character like "ử" but they are not properly displayed at user's browser. I have already set . Can anyone help me in this?

Thanks and Regards,
Virendra

Circular Controll

Mogtabam2-Aug-07 19:03

Mogtabam

2-Aug-07 19:03

Hi All
I Want To Create A Circular Control (In Visual Basic 6)

Please Guide Me

Tanks.

Mogtabam

Re: Circular Controll

Tom Deketelaere2-Aug-07 20:47

Tom Deketelaere

2-Aug-07 20:47

don't know if it exists in vb6
but in .net this can be done with the region property

see if vb6 has one to

Re: Circular Controll

Mogtabam2-Aug-07 20:57

Mogtabam

2-Aug-07 20:57

Hi & Tanks
Please Guide Me In VB.NET (If Posible)

Tanks.

Mogtabam

Re: Circular Controll

Tom Deketelaere2-Aug-07 21:23

Tom Deketelaere

2-Aug-07 21:23

this is how to do it in vb.Net

<br />
            Dim arrRegion As ArrayList 'fill the arraylist with points<br />
            If Not arrRegion.Count = 0 Then<br />
                Dim pntRegion(arrRegion.Count) As Point<br />
                pntRegion = arrRegion.ToArray(GetType(Point))<br />
                Dim c As New System.Drawing.Drawing2D.GraphicsPath<br />
                c.ClearMarkers()<br />
                c.AddCurve(pntRegion) 'you can add other shapes <br />
                If Not c Is Nothing Then<br />
                    Me.Region = New Region(c) 'here the control is redrawn with you'r points<br />
                End If<br />
            End If<br />

hope this helps

Re: Circular Controll

Mogtabam2-Aug-07 21:33

Mogtabam

2-Aug-07 21:33

Hi & Tanks

Tank You For Your Guides

Mogtabam

Re: Circular Controll

Tom Deketelaere2-Aug-07 22:15

Tom Deketelaere

2-Aug-07 22:15

always glad to help

Using writeline to write string with leading 0's to excel worksheet columns?

Rashar2-Aug-07 17:08

Rashar

2-Aug-07 17:08

Hi,

Consider the following line,

oWrite.WriteLine(strItem & vbTab & partNo)

The variable partNo is a string that pulls in a number as such, 00001567842. I am using the writeline method to send that string to an excel sheet. I need to have the values in strItem in column 1, and the values of partNo in column 2 including the leading zeros.

I have tried the {1,11}, partNo format or Format("###########", partNo). I have tried declairing partNo as a String as well as an Integer, but neither data types work.

I tried to create a csv file, and it does include the leading 0's but when I use vtab, I get the values of strItem, plus a square (which I assume is the vtab), then my partNo all in one cell.

Is it possible to accomplish what I want with just the WriteLine method?

Thanks in advance.

Re: Using writeline to write string with leading 0's to excel worksheet columns?

ne0h2-Aug-07 20:47

ne0h

2-Aug-07 20:47

Change the Cell's property to Text. I think you need to create an object of Microsoft.Office.Interop.Excel.Style then use NuberFormat property. Just Google it. By default Excel cells are Number type.

--------------------------------
txtSignature

Visual Basic 2005 User Control

leiby2-Aug-07 12:58

leiby

2-Aug-07 12:58

Could someone please point me to a really good example/tutorial for creating a user control? Specifically I need to create an object that I can place on a form and get mouse click events from. Thanks!

leiby

Re: Visual Basic 2005 User Control

Christian Graus2-Aug-07 13:03

Christian Graus

2-Aug-07 13:03

A basic user control, as created by the wizard, will, by definition, get mouse events. You just need to handle them in your code, so you can interact with them

Christian Graus - Microsoft MVP - C++

"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: Visual Basic 2005 User Control

koolprasad20032-Aug-07 23:59

koolprasad2003

2-Aug-07 23:59

hi frnd,

check out following link
http://www.startvbdotnet.com/extras/user.aspx[^]

regards,
koolprasad2003 Smile | :)

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Deleteing items from a combobox

dptalt2-Aug-07 7:26

dptalt

2-Aug-07 7:26

One of the columns in my datagridview is a combobox column. The datasource for the combobox is a datatable. When the user selects an item from the combobox he wants that item to be removed from the list so that when he navigates to a different line in the datagridview and picks an item from the combobox the previously selected item would appear in the list. How can this be done?

Re: Deleteing items from a combobox

mr_lasseter2-Aug-07 8:59

mr_lasseter

2-Aug-07 8:59

Remove the item from the datatable and it will remove itself from the combo box

Mike Lasseter

Re: Deleteing items from a combobox

dptalt3-Aug-07 2:18

dptalt

3-Aug-07 2:18

I've tried that already. If you remove the item that is selected in the combobox, VS displays an error that keeps coming back when you close down the error dialog box. It seems VS cannot display the item in the combobox if it is removed from the list.

Re: Deleteing items from a combobox

mr_lasseter3-Aug-07 7:28

mr_lasseter

3-Aug-07 7:28

You are not going to be able to use databinding for your combobox. You should be able to create your own combobox column and when it is activated you can load the allowed list of values in the drop down.

Mike Lasseter

Re: Deleteing items from a combobox

The ANZAC2-Aug-07 11:12

The ANZAC

2-Aug-07 11:12

or on selected item changed:
me.combobox1.items.remove(me.combobox1.selecteditem)

Please check out my articles:
The ANZAC's articles

multiline in textboxes

sixecho2-Aug-07 6:56

sixecho

2-Aug-07 6:56

when adding data from a list box to a text box the data is add on after the other
eg. (123456789)
i would like to know if there is a way to make them appear one under another
eg.
1
2
3
4
5
6

Re: multiline in textboxes

Luc Pattyn2-Aug-07 7:08

Luc Pattyn

2-Aug-07 7:08

Hi,

the magic value Environment.NewLine causes a string to span more than one line;
use it at your leisure, every time you want to start a new line in a file,
a textbox, etc. Like so: myTextBox.Text="1"+Environment.NewLine+(2).ToString();

BTW: some people use "\n" or '\n' ; on a Windows PC it would have a similar
effect; but other systems may not like it that much.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: multiline in textboxes

dptalt2-Aug-07 7:08

dptalt

2-Aug-07 7:08

When your adding include chr(13) & chr(10) characters.

Re: multiline in textboxes

Colin Angus Mackay2-Aug-07 11:56

Colin Angus Mackay

2-Aug-07 11:56

Better to use Environment.NewLine becuase it will return the correct value for the operating system in which you are running.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

My website

notepad

md_refay2-Aug-07 6:33

md_refay

2-Aug-07 6:33

i create notepad
and i need with every move by arrows to know column number and line number

md_refay

Re: notepad

kubben2-Aug-07 6:39

kubben

2-Aug-07 6:39

What do you expect us to do? Your question is not clear I have no idea what you really need help with. Are you using notepad for something? It sounds like you are trying to catch keyboard entry. What are you trying to do?

Ben

Re: notepad

Luc Pattyn2-Aug-07 7:13

Luc Pattyn

2-Aug-07 7:13

md_refay wrote:
i create notepad

I am afraid Bill has beaten you to that

If you mean you want to create a Notepad lookalike, maybe based on a (Rich)TextBox,
and (its getting a big if) your cursor moves in strange ways when hitting
arrow keys on a (R)TB that is holding jagged text, then I suggest you consider
using the RichTextBox class, not the TextBox, and read up on it; I trust
the RichTextBox.GetLineFromCharIndex() and GetPositionFromCharIndex() methods
would interest you.

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

print preview control

md_refay2-Aug-07 6:31

md_refay

2-Aug-07 6:31

i read text file to view it in printpreview control
i use stream reader to read line by line and i use e.graphices.drawstring to draw line but i must give it font & brush to draw lines so i give them static lines like arial and blue color except of taken this line font and color
this is my code
---------------------
Private Shared filePath As String = Windows.Forms.Application.StartupPath & "\MyDoc.txt"
Private myFont As Font = New Font("Arial", 10)
Private myBrush As Brush = Brushes.Black
While currentLine < linesPerPage
textLine = streamToPrint.ReadLine()
If textLine Is Nothing Then
Exit While
End If
verticalPosition = topMargin + currentLine * myFont.GetHeight(e.Graphics)
e.Graphics.DrawString(textLine, myFont, myBrush, horizontalPosition, verticalPosition)
currentLine += 1
End While

md_refay

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