Datagrid row color - Visual Basic Discussion Boards

Re: Converting System Time to milliseconds

Dave Kreskowiak3-Aug-04 5:45

3-Aug-04 5:45

VB6 doesn't return the time using a milliseconds field, so you'll have to call into the Win32 API to get the time.

GetLocalTime[^] will get the system time in the local timezone.
GetSystemTime[^] will return the system time in UTC.
Both of these functions will require you to pass in a SYSTEMTIME[^] structure (ByRef) to get the time out of the function. The actual return value will tell you if the call failed or not.
The declare for both functions:

Declare Sub GetLocalTime Lib "kernel32" Alias "GetLocalTime" (lpSystemTime As SYSTEMTIME)
Declare Sub GetSystemTime Lib "kernel32" Alias "GetSystemTime" (lpSystemTime As SYSTEMTIME)
Private Type SYSTEMTIME
    wYear As Integer
    wMonth As Integer
    wDayOfWeek As Integer
    wDay As Integer
    wHour As Integer
    wMinute As Integer
    wSecond As Integer
    wMilliseconds As Integer
End Type

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

Re: Converting System Time to milliseconds

Simon Kearn5-Aug-04 0:05

Simon Kearn

5-Aug-04 0:05

So I presume then that to get the SYSTEMTIME structure into the 8-byte data type, I will have to convert the SYSTEMTIME structure to a FILETIME structure and then convert that into the 8-byte data type that I wish to use. Is that correct?

Re: Converting System Time to milliseconds

Dave Kreskowiak7-Aug-04 6:22

Dave Kreskowiak

7-Aug-04 6:22

That's right. Now all you have to do is make sure that the receiving system gets the bytes in the right order.

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

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

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