Reading XML attribute and write into datagrid - C# Discussion Boards

Reading XML attribute and write into datagrid

8-Nov-05 7:06

Hand hand1 = new Hand(new Card[] { deck.TopCard, deck.TopCard, deck.TopCard });

dunbshy4-Nov-05 14:47

dunbshy

4-Nov-05 14:47

i have a xml looks like this:
(?xml version="1.0" encoding="utf-8" ?)
(EventLog)
(Log Date="11/1/2005")
(Event) 10:37:42 AM : System is Successfully Loaded
(Event) 10:45:04 AM : System is Successfully Loaded
(/Log)
(Log Date="11/2/2005")
(Event) 8:39:32 PM : System is Successfully Loaded
(Event) 8:40:18 PM : System is Successfully Loaded
(/Log)
(/EventLog)

and i have a method which displays those xml data into the datagrid:

XmlDocument docXML = new XmlDocument();
docXML.Load("EventLog.xml");
DataSet dsEvent = new DataSet("Log");

dsEvent.ReadXml("../Debug/EventLog.xml");
dataGrid1.DataSource = dsEvent;
dataGrid1.DataMember = "Log";
dataGrid1.CaptionText = "NetWatcher Event Log";

It displays all the members for "Log" elements.. My problem is.. how to display the members of "Log" for particular date only?( particular "Log"'s attribute)

I've tried something like dataGrid1.DataMember = "Log Date="+@""11/2/05"" and it gives error like datamember Log Date = "11/2/05" was not found.

-- modified at 20:48 Friday 4th November, 2005

Jon Rista4-Nov-05 16:04

4-Nov-05 16:04

You can filter and sort using a DataView object. Pull the table you want to display out of the DataSet, then create a DataView for it. Set your filter, and then use the DataVeiw object as your .DataSource, rather than the DataSet itself.

dunbshy5-Nov-05 3:32

dunbshy

5-Nov-05 3:32

I've tried this but it's still not executable.

DataSet dsEvent = new DataSet("Log");
dsEvent.ReadXml("../Debug/EventLog.xml");
DataView dv = new DataView(dsEvent.Tables["Log"] ,DateToday,"",DataViewRowState.CurrentRows);

dataGrid1.DataSource = dv;
dataGrid1.DataMember = "Log";
dataGrid1.CaptionText = "NetWatcher Event Log";

Note:variable DateToday is the attribute that i want to filter. I provide the node name and attribute and I want to get their childnode

-- modified at 9:45 Saturday 5th November, 2005

Jon Rista5-Nov-05 9:55

5-Nov-05 9:55

Alright. Let me break it down, to make sure I understand everything. First thing, DateToday is a string variable that you populate elsewhere, correct? I am assuming that your allowing the user to change the date through the UI somewhere?

There are two things that I'm wondering about. First is, are you sure the table in the DataSet that you want to display is called "Log"? Second, are you calling .DataBind() on the DataGrid? If the code was broken down a bit into more granular pieces, say something like this:

<br />
DataSet dsEvent = new DataSet("Log");<br />
dsEvent.ReadXml("../Debug/EventLog.xml");<br />
<br />
// This next line assumes that the xml file EventLog.xml <br />
// creates a table in the DataSet named "Log". NOTE that<br />
// the name of the dataset and the name of the table are<br />
// NOT neccesarily the same. A DataSet contains tables, <br />
// but it is not a table itself. The default table name <br />
// is usually "Table1" if a table name is not found anywhere<br />
// e, then table names are in sequence<br />
// after that.<br />
DataView dv = new DataView(dsEvent.Tables["Log"]);<br />
dv.RowFilter = "TheDate='11/1/2005'"; // Is this what your DateToday string looks like?<br />
dv.RowStateFilter = DataViewRowState.CurrentRows;<br />
<br />
// If a sort was desired, set dv.Sort here<br />
<br />
dataGrid1.CaptionText = "NetWatcher Event Log";<br />
<br />
dataGrid1.DataSource = dv;<br />
// The following line is not needed when using a DataView, only when using a DataSet<br />
// dataGrid1.DataMember = "Log";<br />
dataGrid1.DataBind(); // You MUST call this to populate the grid<br />

Does any of that help? Make sure you know what the table in your DataSet is called. The DataSet is called "Log", but is the table really called "Log", or is it something else? And at the end of it all, make sure you call .DataBind() on your datagrid.

dunbshy5-Nov-05 11:46

dunbshy

5-Nov-05 11:46

First, thanks for you reply. You totally undertood my problem and thanks for all the explanation given. DateToday is a string variable which looks like 11/1/2005. And yes, i have a table named "Log".

Here comes another problem, when i try to run this code, i've got an error like -'System.Windows.Forms.DataGrid' does not contain a definition for 'DataBind' and if i take out the line dataGrid1.DataBind(); then it can be executed but no record is displayed. Why is this happened?

Jon Rista8-Nov-05 6:58

calling a C# dll from an unmanaged C++ dll

8-Nov-05 6:58

Sorry for the late reply. Had to go digging through threads to find this again. Seems your using the Windows DataGrid (I thought it was the web DataGrid). As far as I know, the windows grid is supposed to automatically update. Have you tried debugging your code, and checking to see if there is indeed anything in the DataTable? I guess its possilbe that there is nothing being populated, or that there is nothing with the date 11/1/2005. Try running it without the filter and see if it works.

tmp04-Nov-05 13:56

tmp0

4-Nov-05 13:56

Hello all,

At this point of my project, I built a very small unmanaged C++ DLL and I'm trying to make it call a C# DLL. However, now I know that this looks like (almost) impossible.

I'm *very* new to C++, I started my project in C# and now I'm faced with the truth that I'll have to use unmanaged C++ for some parts of my project which cannot be done with C#. Is there a way to do this?

Also, if I have an application which was coded with an unmanaged C++ code; can this application call a managed C++ DLL or a C# DLL?

Someone told me to use "COM interop in the C# code to expose my C# types as coclasses." Is this the best solution? if yes, can anyone explain more?

I made a quick search in Google but didn't find much; any hint, link, or advice is highly appreciated.

Many thanks in advance,
Naimi

Re: calling a C# dll from an unmanaged C++ dll

Rob Graham4-Nov-05 15:29

Rob Graham

4-Nov-05 15:29

1. C# to unmanaged: you have at most three choices:
a. Use interop code (PInvoke) to call functions in the unmanaged dll. Search this site and Google for Pinvoke should get you some examples. This can be tricky, since you must pay attention to things like pointers, and explicitly "pin" things that might be referenced from the unmanged code, so the GC doesn't move them.
b. If the unmanaged dll happens to be a COM dll, you can use TlbImp tocreate a wrapper dll that will handle the managed-unmanaged buisness for you.
c. Write a managed C++ wrapper that exposes the unmanaged dll's methods as managed versions, and handles data conversions for you.

2. Unamanaged to C#. C# dlls are already COM objects, you just need to specify "register for COM" in the project settings (or use the Regasm utility to register the C# dll (use the /tlb option so it creates a type library file for you). It will need to have a strong name key, and should be installed to the GAC. You can the use normal C++ methods to deal with the C# dll as a COM component.
(use #import to import the type library and create interface wrapper methods for you)

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

Datagrid

mrnoname4-Nov-05 13:36

mrnoname

4-Nov-05 13:36

I have a application with a datagrid...

Works fine but i want to remove the "add a new line row", the one starting with * at the left side.

I removed it with datagrid1.ReadOnly = false, but the i cant edit the fields already in the datagrid...

How can i solve this problem?

//Johan

IDownloadManager COM Component in C#

timothymfox4-Nov-05 12:58

timothymfox

4-Nov-05 12:58

I'd like to make my C# implment the IDownloadManager COM component for IE to handle certain types of files.

Here's an MSDN article on the process, but it's for C++.
http://support.microsoft.com/default.aspx?scid=kb;en-us;327865

Anyone ever develop this component in C#? If so, can you paste the code for your interface?

Thanks,
Tim

Detecting a port

picasso24-Nov-05 11:19

picasso2

4-Nov-05 11:19

I have service that is installed in several workstations. The service uses the same port number.
I would like to create an application that detects how many workstations have the service installed in the subnet.
Maybe by detecting the listening port or by the service name.
Any help will be greatly appreciated

Re: Detecting a port

enjoycrack4-Nov-05 11:41

enjoycrack

4-Nov-05 11:41

Hi there,

IMO, I'd detect the installed service by the listening port. Just simply create a connection to the remote machine on that port. if it's successful, that means the service is installed there

<< >>

Elegant check for .Net Framework 1.1 or 2.0?

Tom Ollar4-Nov-05 9:21

Tom Ollar

4-Nov-05 9:21

When attempting to run a 1.1 based exe on 2.0, you get an ugly TypeInitialization exception.

I have yet to attempt running 2.0 on 1.1 machine.

Either way, assuming the app does not have access to it's native framework, does anyone know a good way to display a user-friendly message explaining the problem?

Carl Mercier4-Nov-05 10:22

Carl Mercier

4-Nov-05 10:22

If it's possible, you're probably better off checking for the framework before the application is installed, and letting the user install it before proceeding further. That's what we do and it works pretty good since our installer is not .NET based. I suspect you are in the same situation.

Innosetup[^] is a great free installation tool.

Carl Mercier
Geek entrepreneurs, visit my blog! [^]

Tom Ollar5-Nov-05 3:58

Tom Ollar

5-Nov-05 3:58

Thanks Carl, I'll check it out...

leppie4-Nov-05 21:51

leppie

4-Nov-05 21:51

Tom Ollar wrote:
When attempting to run a 1.1 based exe on 2.0, you get an ugly TypeInitialization exception.

I have not seen this problem. Did you apply the .NET 2.0 element stuff in the App.config file? I have ran my rather complex application without issues on both runtime, binary serialization is even forwards and backwards compatible Smile | :)

^{xacc-ide 0.0.99-preview7 now with C#, C, C++, IL, XML, Nemerle, IronPython, Perl, Caml, SML, Ruby, Flex, Yacc, Java, Javascript, Lua, Prolog and Boo highlighting support!}