Exporting data to msword - Visual Basic Discussion Boards

First Prev Next

Re: registering dll problem

uktrips0079-Dec-05 2:24

uktrips007

9-Dec-05 2:24

hi dear
I have register my dll file on server.but after using it in my asp coding it shows incorrect program id.could u tell me y it is so?

try to be the best... whereever you go,

Re: registering dll problem

Gerben Jongerius9-Dec-05 7:22

Gerben Jongerius

9-Dec-05 7:22

Each class in your dll should have its own progid. This will include the full namespace, you can check that by using regasm and exporting to a register file instead of directly into the register. (add /regfile:<dllname>.reg

So if I have a class in the VB.Net DLL called Test in a project called Test1 the full progID name should be Test1.Test and not just Test. However you can set a custom ProgID for each class with the ProgIdAttribute, see MSDN Article for more on that attribute.

Re: registering dll problem

uktrips0079-Dec-05 18:59

uktrips007

9-Dec-05 18:59

I did so now when i call the function of this class in dll it shows me that

Microsoft VBScript compilation error '800a0414'

Cannot use parentheses when calling a Sub

/uttam/dlltest/test.asp, line 14

myObject.callweb(intvalue,i)
----------------------------^

I used myObject=Server.CreateObject("dllkeysearch.Class1")
where dllkeysearch is dll project name and Class1 is the class name.
Confused | :confused:

try to be the best... whereever you go,

Alternative of Debug.Print() in .Net

kumar_Chandan7-Dec-05 19:35

kumar_Chandan

7-Dec-05 19:35

Dear,

In VB we have Debug.Print() which prints on Immediate window. In VB.Net do we have something which print on Immediate window. Now I am using
Debug.WriteLine() which prints on Output Window. I want debug message to be printed on Immediate window. Confused | :confused:

Thanking you.

Regards,
Chandan Kumar Gupta.

Re: Alternative of Debug.Print() in .Net

Dave Kreskowiak8-Dec-05 4:24

Dave Kreskowiak

8-Dec-05 4:24

There's nothing that targets the Immediate window. All the Debug outputs are sent to the Output window. This has nothing to do with VB itself, rather it's how the Debug class works.

I don't know of any classes that will target the Immediate window.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[Message Deleted]

kumar_Chandan7-Dec-05 19:25

kumar_Chandan

7-Dec-05 19:25

[Message Deleted]

Re: ListBox in .Net

Gerben Jongerius7-Dec-05 21:52

Gerben Jongerius

7-Dec-05 21:52

I am presuming that the adding is going correctly. If that is the case then you can simply use the property SelectedItem or SelectedIndex to select the item in the second listbox.

So an example is:

<br />
 lbBox2.Items.Add(lbBox1.SelectedItem)<br />
 lbBox2.SelectedItem = lbBox1.SelectedItem  // can be set and read<br />

Note that this only works if you put the reference of the first listbox in the second and not a copy.

Hope that this helps you a little bit.

Exporting data to msword

sreejaps7-Dec-05 19:22

sreejaps

7-Dec-05 19:22

Hi I am working on a VB.net application, from which I need to export data to MS Word in a tableformat.I can export the data to MS Word. Now i want to Display it in a table format. Can anyone suggest any ideas for exporting Data to MS word. I couldnt find any helpful topics on net. I need it urgently

Please help..

Thanks in advance...

Re: Exporting data to msword

uktrips0077-Dec-05 22:00

uktrips007

7-Dec-05 22:00

Dear sreejaps
the best way to export ur data to ms word in tabular format is to create an html file and create table store ur data. but while saving u must save it with .doc extension.since word understand html formatting ur document in ms word will show ur data in tabular format.use the following code to create a file and open it in word format.
code for writing in data
dim fname as string
dim ofile as filestream
dim owriter as streamwriter
fname = "search.doc"
ofile = New FileStream(fname, FileMode.Create, FileAccess.Write)
owriter = New StreamWriter("ur content in html formatting goes here")
owriter.close
owriter=nothing
ofile=nothing

code for opening it in ms-word
Dim word_app As New Word.Application()

word_app.Documents.Open( _
fileName:=Path.GetFullPath("search.doc"), _
ConfirmConversions:=False, _
ReadOnly:=True, _
AddToRecentFiles:=False, _
Format:=Word.WdOpenFormat.wdOpenFormatAuto)
word_app.Visible = True

Happy Programming Blush | :O

Thanks n Regards
Uttam Kumar :->

be the best...

Re: Exporting data to msword

sreejaps7-Dec-05 23:06

sreejaps

7-Dec-05 23:06

thank u so much .It helps me a lot
Regards
Sreeja

SSTab

Sasmi7-Dec-05 17:58

Sasmi

7-Dec-05 17:58

Can i add new tab in SSTab control at the run time

Sasmi

Re: SSTab

Dave Kreskowiak8-Dec-05 4:18

Dave Kreskowiak

8-Dec-05 4:18

Yes. See the documentation[^] on SSTab, Tabs property on MSDN.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

The InterfacePrg service terminated unexpectedly. It has done this 2 time(s).

miceisland7-Dec-05 15:57

miceisland

7-Dec-05 15:57

Need help, anybody know what is this message in the application log means.
"The description for Event ID ( 105 ) in Source ( InterfacePrg ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ."
after this message comes up, then my services just suddenly terminated, then i have to restart my services again.

program is created in VB6, running as services.

Mike

Reading Textfiles

ADY0077-Dec-05 11:05

ADY007

7-Dec-05 11:05

Hello, I am saving a textfile from a form and I am saving it example: Name & "|" & Surname etc..! I am seperating each income with a "|"! Now how can i read The name then the surname! I dont want the '|' to be seen of course! I want to read behind the | and after the |! Help me please!!

Adrian De Battista

Re: Reading Textfiles

Curtis Schlak.7-Dec-05 11:08

Curtis Schlak.

7-Dec-05 11:08

You might be interested in the String.Split() method.

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Re: Reading Textfiles

ADY0077-Dec-05 11:27

ADY007

7-Dec-05 11:27

But if i have more than 1 '|' what can i do!??

Adrian De Battista

Re: Reading Textfiles

Steve Pullan7-Dec-05 12:22

Steve Pullan

7-Dec-05 12:22

ADY007 wrote:
But if i have more than 1 '|' what can i do!??

With all due respect to you: RTFM[^]. The answer to this question and more are contained therein.

...Steve

Re: Reading Textfiles

Curtis Schlak.7-Dec-05 12:26

Curtis Schlak.

7-Dec-05 12:26

Dim s As String = "Eins|Zwei|Drei|Vier|Fuenf"
Dim items() As String = s.Split("|")
Console.WriteLine(items(0)) ' Writes "Eins"
Console.WriteLine(items(1)) ' Writes "Zwei"
Console.WriteLine(items(2)) ' Writes "Drei"
Console.WriteLine(items(3)) ' Writes "Vier"
Console.WriteLine(items(4)) ' Writes "Fuenf"

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Adding controls to a form programmatically

Shoulder_Devil7-Dec-05 9:20

Shoulder_Devil

7-Dec-05 9:20

I am attempting to create a windows component that acts as a "drop point" for drag and drop operations. I would like to be able to drop a label (or any other component that can return a string) onto this new control. The dragdrop subroutine should then create a new label and add it to the form. Since this operation can be performed multiple times, I cannot explicitly dim new labels because I cannot name them programmatically. For instance:

Dim lbl as New label<br />
lbl.location = New Point(10, 10)<br />
...<br />
me.controls.add(lbl)

will add a label to the form, but you cannot create dim statements on the fly. Perhaps I am totally off base on how to create this control. Could someone spare a little advice or some sample code that can explain how to create multiple instances of the same control type programmatically?

Thanks!

Re: Adding controls to a form programmatically

Curtis Schlak.7-Dec-05 11:16

Curtis Schlak.

7-Dec-05 11:16

When your drop target event handler gets invoked, you could run the following code.

Dim l As Label = New Label
l.Text = tb.Text
' l.Left = Where you need to place it
' l.Top = Where you need to place it
Me.Controls.Add(l)
Me.Invalidate()
Me.Update()

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

foxpro and VB connectivity

madhuris057-Dec-05 8:54

madhuris05

7-Dec-05 8:54

I want to fetch records from foxpro table throgh VB command object
I am using odbc connection for connecting to the foxpro table.
so i write a qry and assign it to the command object and then took the records in recordset.

ID NAME ADDRESS doc_tyep
===============
1 FRED 1234 Main St 37
2 TOM ABCD Whatever 37
5 JIM Homeless 38
9 John Jail 37
10 ryan home 37
Now, if I set the record source to select * from clients where doc_type = '37' It will return
ID NAME ADDRESS
===============
5 JIM Homeless
9 John Jail

but if i execute the same qry in foxpro table (that means opening it in Visual foxpro) ,it returns
1 FRED 1234 Main St 37
2 TOM ABCD Whatever 37
9 John Jail 37
10 ryan home 37

Re: foxpro and VB connectivity

uktrips0077-Dec-05 22:09

uktrips007

7-Dec-05 22:09

Dear Madhuri

"select * from clients where doc_type = '37'".

in the query u have written doc_type

but in table design attribute name is doc_tyep

write query as
select * from clients where doc_tyep = '37' also check for the data type.

if this topic solve ur porblem mail me at trickyuk001@rediffmail.com
********************All The Best**********MADHURI***************

Thanks n Regards
Uttam Kumar Rose | [Rose]