Excel Report Created in VB.Net - Visual Basic Discussion Boards

Data Dictionary

Britnt72-Aug-04 3:07

Britnt7

2-Aug-04 3:07

Can anyone explain to me, What I need to do to create a data dictionary? D'Oh! | :doh:

The following is from the help section of Advantage. I don't know how to implement this into VB.Net code in my ASP.Net project.

Creates a data dictionary.<br />
<br />
Syntax<br />
UNSIGNED32 AdsDDCreate( UNSIGNED8 *pucDictionaryPath,<br />
                        UNSIGNED16 usEncrypt,<br />
                        UNSIGNED8 *pucDescription,<br />
                        ADSHANDLE *phAdminConn );<br />
<br />
Parameters<br />
pucDictonaryPath  (I)	Full file path of the data dictionary to create. <br />
<br />
usEncrypt  (I)	        A non-zero value will cause the data dictionary data<br />
                        file to be encrypted.<br />
<br />
pucDescription  (I)	An optional description of the database in the data <br />
                        dictionary. If NULL, no database description is <br />
                        stored in the data dictionary. The database<br />
                        description can be added or changed later with <br />
                        AdsDDSetDatabaseProperty.<br />
<br />
phAdminConn  (O)	Returns a database administrative connection handle <br />
                        if the data dictionary is created successfully.<br />
<br />
Example:<br />
Create a data dictionary without encrypting the data dictionary data files, and then add a table to the database.<br />
<br />
AdsDDCreate( "n:\\MyData\\myData.ADD", 0, "This is the database of my tables and indexes.", &hDD );<br />
AdsDDAddTable( hDD, "Customer Information", "n:\\MyData\\customer.ADT", ADS_ADT, "customer.adi;customer2.adi",<br />
               "This table contains information on all customers." )

Thanks in advance. Smile | :)

Beginner in VB and ASP.Net

editing XML config file from within executing program

Vineet Rajan2-Aug-04 1:57

Vineet Rajan

2-Aug-04 1:57

hi
i am writing an application which maintains records of several clients. Each client has different settings. This is maintained in a XML file. When the user wants to update the data of a particular client changes have for that client.

this is what my XML document looks like.

<?xml version="1.0" encoding="UTF-8"?>
<config>
<client name="Cadbury">
<mcastg>222.23.342.1</mcastg>

<port>2222</port>

<path>c:\</path>

<repeat>4</repeat>

<spawn>4</spawn>

<ttl />

<profile>Custom</profile>

<custom>
<bw>1200</bw>

<dgsize>1024</dgsize>
</custom>
</client>

<client name="dabur">
<mcastg>222.23.432.23</mcastg>

<port>3333</port>

<path>d:\</path>

<repeat>5</repeat>

<spawn>5</spawn>

<ttl>4</ttl>

<profile>High</profile>

<custom>
<bw />

<dgsize />
</custom>
</client>

<client name="Vineet Inc">
<mcastg>222.23.43.4323</mcastg>

<port>5555</port>

<path>e:\</path>

<repeat>10</repeat>

<spawn>1</spawn>

<ttl>4</ttl>

<profile>Low</profile>

<custom>
<bw />

<dgsize />
</custom>
</client>

<client name="ICICI">
<mcastg>223.533.456.234</mcastg>

<port>54334</port>

<path>e:\hello</path>

<repeat>10</repeat>

<spawn>45</spawn>

<ttl>4</ttl>

<profile>Low</profile>

<custom>
<bw />

<dgsize />
</custom>
</client>

<client name="Vikram">
<mcastg>223.533.456.234</mcastg>

<port>5433</port>

<path>d:\vineet</path>

<repeat>10</repeat>

<spawn>45</spawn>

<ttl>4</ttl>

<profile>High</profile>

<custom>
<bw />

<dgsize />
</custom>
</client>
</config>

say i want to edit the settings for ICICI, how do i do from within the executing program. please give proper code.

Thanks

Re: editing XML config file from within executing program

Member 9041222-Aug-04 2:48

Member 904122

2-Aug-04 2:48

Dim ds As New DataSet

Private Sub btnGetData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetData.Click
ds = New DataSet
ds.ReadXml("c:\test.xml")
DataGrid1.DataSource = ds
End Sub

Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
ds.WriteXml("c:\test.xml")
End Sub

Re: editing XML config file from within executing program

Vineet Rajan2-Aug-04 3:09

Vineet Rajan

2-Aug-04 3:09

thanks this worked for me

but only one thing, can i do this without the DataGrid. i know it is a bit more complicated but that would be really better

Datagrid row color

benjj1-Aug-04 7:40

benjj

1-Aug-04 7:40

Re: Datagrid row color

Jay Shankar2-Aug-04 16:31

Jay Shankar

2-Aug-04 16:31

Please refer to the article in CP
Changing the background color of cells in a DataGrid
[^]Though the code is in C#. I hope this will give you some direction.
To be very frank, I do not know VB.net, I just happed to browse and saw your question.
Regards,

Jay

Re: Datagrid row color

partt3-Aug-04 11:50

partt

3-Aug-04 11:50

Try putting this in there. It's pretty flexible. The Cells index is zero based.

Private Sub MyDataGrid_ItemDataBound(ByVal sender As Object, ByVal e As DataGridItemEventArgs) Handles MyDataGrid.ItemDataBound
If e.Item.Cells(4).Text.ToString.Trim = "John Henry" Then
e.Item.Cells(4).BackColor = Color.Yellow
e.Item.Cells(4).ForeColor = Color.Blue
End If
End Sub

Excel Report Created in VB.Net

lxhan1-Aug-04 5:00

lxhan

1-Aug-04 5:00

Hello,

Does anyone know how to format a particular column in Excel to an accounting style?

Here's my situation, I created a Excel accounting report in a VB.Net application, but I'm not sure how to format certain columns to the different styles for example, accounting or currency. How is this done in the VB code?

Thanks!

How to Hide Application from Task Manager

Murtuza Husain Miyan Patel1-Aug-04 4:37

Murtuza Husain Miyan Patel

1-Aug-04 4:37

Hello Sir,

I wanna hide my vb application from the task manager. My application is in startup so when I restart the machine anybody can close it from task list before the OS is started. so it could not come on desk top any more.

Best regards
M Smile | :)

urtuza Patel

Re: How to Hide Application from Task Manager

Dave Kreskowiak1-Aug-04 17:04

Dave Kreskowiak

1-Aug-04 17:04

Simple. You can't. Even the system processes show up in the TM...

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

Re: How to Hide Application from Task Manager

s1ihome1-Aug-04 20:21

s1ihome

1-Aug-04 20:21

I think no way to do that

I Believe I Can fly!~~~

Plz Help me how to Hide Application from Task Manager

Murtuza Husain Miyan Patel1-Aug-04 4:36

Murtuza Husain Miyan Patel

1-Aug-04 4:36

urtuza Patel

Re: Plz Help me how to Hide Application from Task Manager

Colin Angus Mackay1-Aug-04 22:31

Colin Angus Mackay

1-Aug-04 22:31

IIRC, you can't.

You could rewrite it as a Windows Service, but that still won't hide it from the Windows Task Manager, although it will appear in the Processes tab rather than the Applications tab. Also, a Windows Service can still be shut down by the user through the Task Manager (which is not recommended) or via the Services management console (in Administrative Tools-->Services).

Does this help?

To my mind it is also highly suspicious that there is a valid reason why a process absolutely must remain active and should never be shut down unless it is an integral part of the operating system.

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

Re: Plz Help me how to Hide Application from Task Manager

Tahseen Zindani2-Aug-04 23:33

Tahseen Zindani

2-Aug-04 23:33

It is possible with the help of API but

with the perfect API u can hide the Apps from Task manager

but sorry i dont know the code...

But it is possible

File Download Trap

Mega131-Jul-04 13:16

Mega1

31-Jul-04 13:16

I want to create a program that will intercept a file download, and compare it to a database of files i already have. I am not looking for someone to code this for me, just an idea of were to start. TIA!!!

Re: File Download Trap

Dave Kreskowiak1-Aug-04 4:09

Dave Kreskowiak

1-Aug-04 4:09

What do you mean by "intercept"? If you are looking to do this inside of IE, you'll want to check out Browser Helper Objects (warning: Lots of COM Interop involved). You won't be able to see the actual download itself, but you'll be able to see the link that is clicked on and use that instead.

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

Re: File Download Trap

Mekong River1-Aug-04 4:27

Mekong River

1-Aug-04 4:27

Do you mean that the file name that you already download is record into the database? In my opinion, when you click on the hyperlink in the browser just copy the URL in one variable. After you complete its download, you need to pass the string from variable to database. If you did not download complete, the variable is cleared, your database has no new record and next time you have to download it from the beginner again. If you download the same file then it will check the database to make sure that it might duplicate or not.

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

VBA default parameters in EXcel

Anonymous31-Jul-04 7:24

Anonymous

31-Jul-04 7:24

Hi
Now I try to work with C#. My application had to process an *.xml file through Excel COM. Cause of I use native Excel help for VBA : “VBAXL9.CHM” .But there is any troubles .When C# generate proxy for excel object it not consider about optional argument and cause of I should explicit pass this arguments every time in methods call. In many places into excel help referenced behavior of an methods with parameters by default (optional parameters which omit), but I don’t know what it are.
Where I can learn about definition of this defaults parameters????

Re: VBA default parameters in EXcel

Dave Kreskowiak1-Aug-04 4:19

Dave Kreskowiak

1-Aug-04 4:19

You questions concerning C# would be better handled in the C# Forum.

C# doesn't support optional parameters so, you actually have to pass in a value called Type.Missing. See this[^] document on MSDN for some explanations.

This is not a problem in VB.NET.

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

Outlook Com addin IDTExtensibility2

vancouver77731-Jul-04 6:00

vancouver777

31-Jul-04 6:00

Is there any way to add right click menu
(adding extra menu item to launch my app)
on mail. I hope this can be easily by
adding a key in the registry.

Van

Re: Outlook Com addin IDTExtensibility2

Dave Kreskowiak1-Aug-04 4:03

Dave Kreskowiak

1-Aug-04 4:03

What do you mean by "on mail"? Are you looking to add a shortcut to the Explorer Shell Context Menu, like WinZip does?

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

Re: Outlook Com addin IDTExtensibility2

Dave Kreskowiak1-Aug-04 4:04

Dave Kreskowiak

1-Aug-04 4:04

If your looking to do it inside Outlook, it's hardly easy. Now your looking at a big can of COM Interop.

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

Displaying Data from Access

paul@gtns.net31-Jul-04 1:42

paul@gtns.net

31-Jul-04 1:42

Probably dead easy but new to this and just cant work it out.

I want my combobox to display the data from a particular column in an access database. Can somebody please explain how in nice easy steps.

I have a connection in the server explorer and can drag the field from their to the form to get the connection and dataadapter objects and have created the data set (data, generate..) but cant get the combo to display the info from the db.

Paul

Re: Displaying Data from Access

Mekong River1-Aug-04 4:18

Mekong River

1-Aug-04 4:18

I just give you some idea relate to your idea.
1. Connect to your database and write and SQL statement to select all the information from database. Move to last and go to first record (populate the recordset).
2. In the DropDown event of the combobox try to loop one by one record and add it item to the combobox.
Note: before the dropt down list appear clear all the information in the previous list.

Roath Kanel
APO-CEDC
Save Children Norway-Cambodia Office

Multiple Inheritance

Ravi S.V.30-Jul-04 22:17

Ravi S.V.

30-Jul-04 22:17

Does VB.Net support Multiple Inheritance?

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