I would review the kb article for help doing the xml conversion:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;313649

-----Original Message-----
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Baudouin,
Andrew
Sent: Wednesday, July 14, 2004 10:44 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Passing a datatable schema to perform
searc h - Best Practices

Thanks for your answer.  I have tried to serialize the datatable to
write
out a file on the filesystem (XMLHTTP is probably better...) (it is not
an
entire Dataset but a strongly typed DataTable) as follows:

public ProductCodeDS.PPRCDataTable ProductCodeDT  = new
ProductCodeDS.PPRCDataTable()

*misc code here*

StreamWriter s1 = new StreamWriter(HTTPContext.Current.Server.MapPath
("../Search/SearchTable.xml"));
XMLSerializer xml1 = new XMLSerializer(ProductCodeDT.GetType());
xml1.Serialize(s1,ProductCodeDT);

The instantiation of the XMLSerializer fails because I need to perform
an
Add(object) on the ProductCodeDS+PPRCDataTable due to its implementing
IEnumerable.  I don't understand what that means.



Andrew Baudouin
Applications Programmer
Information Technology Department
AWC Inc




-----Original Message-----
From: Jesse Sanders [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 11:31 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Passing a datatable schema to perform
search - Best Practices


I'm pretty sure that the cache would not be available b/c the
applications have different IIS contexts.  This is a result of different
name spaces, global.asa files, virtual directories, etc.  I would
suggest streaming the datatable as xml from one application to the
other.  This could be achieved via a web services or xml.http and would
not require you to change the structure of your existing applications.
HTH,

Jesse

  

-----Original Message-----
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Baudouin,
Andrew
Sent: Wednesday, July 14, 2004 7:52 AM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] Passing a datatable schema to perform search
- Best Practices

Hi all,

I am trying to pass a datatable from one Web Application to a Search
Application.  The Search Application should take the datatable, examine
its
schema, and dynamically create a search form consisting of labels and
textboxes based on the keys I have defined in the table (basically, any
indexed field in the datatable should have a textbox/label assigned to
it).

Putting it in the HTTPContext.Current.cache from the "Web Application"
doesnt work , because the "Search Application" indicates that there are
no
items in the cache.  These two applications have their own separate
"bin"
folders out on the development server.

Is there a better way to do this?

Andrew Baudouin
Applications Programmer
AWC Inc

===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com
Some .NET courses you may be interested in:

NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles
http://www.develop.com/courses/gaspdotnetls

View archives and manage your subscription(s) at
http://discuss.develop.com

===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com
Some .NET courses you may be interested in:

NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles
http://www.develop.com/courses/gaspdotnetls

View archives and manage your subscription(s) at
http://discuss.develop.com

===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com
Some .NET courses you may be interested in:

NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles
http://www.develop.com/courses/gaspdotnetls

View archives and manage your subscription(s) at
http://discuss.develop.com

===================================
This list is hosted by DevelopMentor�  http://www.develop.com
Some .NET courses you may be interested in:

NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles
http://www.develop.com/courses/gaspdotnetls

View archives and manage your subscription(s) at http://discuss.develop.com

Reply via email to