473,605 Members | 2,734 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

convert datatable to xml in aspx

jk
I'm having trouble converting a datatable into xml, with resonse.write
to aspx. I'm basically converting vb code that saved a recordset into a
stream into c#, but the format is wrong. I've tried using streams,
datadoc, xmlreader, etc with no success. I need to convert it directly
to a string or via a stream, but not in a file. Here's some sample
code that gives me the bad format. I'll post the good format below that
give me rowsets rather than tables. thanks for any help!!

StringWriter sw = new StringWriter();
dt.DataSet.Writ eXml(sw, XmlWriteMode.Wr iteSchema);
string s = sw.ToString();
Response.Write( "<?xml version='1.0' ?>");
Response.Write( s);

<!-- give me this: /-->
<?xml version='1.0' ?>
<NewDataSet>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:attribute name="VAR_VALUE " type="xs:string " />
<xs:attribute name="VAR_KEY" type="xs:string " />
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<Table VAR_VALUE="LSUS " VAR_KEY="DIVISI ON" />
<Table VAR_VALUE="DB2T " VAR_KEY="DB2DSN " />
<Table VAR_VALUE="TRUE " VAR_KEY="PRODPR OF" />
</NewDataSet>

<!-- I need this: /-->
<?xml version='1.0' ?>
<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='VAR_VALUE ' rs:number='1'
rs:nullable='tr ue'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='2 00'/>
</s:AttributeType >
<s:AttributeTyp e name='VAR_KEY' rs:number='2'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='1 0'
rs:maybenull='f alse'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row VAR_VALUE='LSUS ' VAR_KEY='DIVISI ON'/>
<z:row VAR_VALUE='DB2P ' VAR_KEY='DB2DSN '/>
<z:row VAR_VALUE='TRUE ' VAR_KEY='PRODPR OF'/>
</rs:data>
</xml>

Nov 12 '05 #1
5 52665
How about

dim tableString as String = DataSet.getXML

"jk" <jk******@levi. com> wrote in message
news:11******** *************@c 13g2000cwb.goog legroups.com...
I'm having trouble converting a datatable into xml, with resonse.write
to aspx. I'm basically converting vb code that saved a recordset into a
stream into c#, but the format is wrong. I've tried using streams,
datadoc, xmlreader, etc with no success. I need to convert it directly
to a string or via a stream, but not in a file. Here's some sample
code that gives me the bad format. I'll post the good format below that
give me rowsets rather than tables. thanks for any help!!

StringWriter sw = new StringWriter();
dt.DataSet.Writ eXml(sw, XmlWriteMode.Wr iteSchema);
string s = sw.ToString();
Response.Write( "<?xml version='1.0' ?>");
Response.Write( s);

<!-- give me this: /-->
<?xml version='1.0' ?>
<NewDataSet>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:attribute name="VAR_VALUE " type="xs:string " />
<xs:attribute name="VAR_KEY" type="xs:string " />
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<Table VAR_VALUE="LSUS " VAR_KEY="DIVISI ON" />
<Table VAR_VALUE="DB2T " VAR_KEY="DB2DSN " />
<Table VAR_VALUE="TRUE " VAR_KEY="PRODPR OF" />
</NewDataSet>

<!-- I need this: /-->
<?xml version='1.0' ?>
<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='VAR_VALUE ' rs:number='1'
rs:nullable='tr ue'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='2 00'/>
</s:AttributeType >
<s:AttributeTyp e name='VAR_KEY' rs:number='2'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='1 0'
rs:maybenull='f alse'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row VAR_VALUE='LSUS ' VAR_KEY='DIVISI ON'/>
<z:row VAR_VALUE='DB2P ' VAR_KEY='DB2DSN '/>
<z:row VAR_VALUE='TRUE ' VAR_KEY='PRODPR OF'/>
</rs:data>
</xml>

Nov 12 '05 #2
jk
that gives me this:
<NewDataSet>
<Table>
<VAR_VALUE>LSUS </VAR_VALUE>
<VAR_KEY>DIVISI ON</VAR_KEY>
</Table>
<Table>
<VAR_VALUE>DB2T </VAR_VALUE>
<VAR_KEY>DB2DSN </VAR_KEY>
</Table>
<Table>
<VAR_VALUE>TRUE </VAR_VALUE>
<VAR_KEY>PRODPR OF</VAR_KEY>
</Table>
</NewDataSet>

none of the options i've tried gives me the output expected from
responseStream. it's like it's interpreting the data as a higher node
(maybe since it's dataset not datatable). i need rowset not table info.
this was just a few lines of code in vb.net that worked fine:

stream = Server.CreateOb ject("ADODB.Str eam")
stream.Type = 1
stream.Open()
rs.save(stream, 1) '1=adpersistxml
sXML = stream.ReadText
stream.Close()
stream = Nothing
Response.Write( "<?xml version='1.0' ?>")
Response.Write( sXML)

Scott M. wrote:
How about

dim tableString as String = DataSet.getXML

"jk" <jk******@levi. com> wrote in message
news:11******** *************@c 13g2000cwb.goog legroups.com...
I'm having trouble converting a datatable into xml, with resonse.write to aspx. I'm basically converting vb code that saved a recordset into a stream into c#, but the format is wrong. I've tried using streams,
datadoc, xmlreader, etc with no success. I need to convert it directly to a string or via a stream, but not in a file. Here's some sample
code that gives me the bad format. I'll post the good format below that give me rowsets rather than tables. thanks for any help!!

StringWriter sw = new StringWriter();
dt.DataSet.Writ eXml(sw, XmlWriteMode.Wr iteSchema);
string s = sw.ToString();
Response.Write( "<?xml version='1.0' ?>");
Response.Write( s);

<!-- give me this: /-->
<?xml version='1.0' ?>
<NewDataSet>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:attribute name="VAR_VALUE " type="xs:string " />
<xs:attribute name="VAR_KEY" type="xs:string " />
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<Table VAR_VALUE="LSUS " VAR_KEY="DIVISI ON" />
<Table VAR_VALUE="DB2T " VAR_KEY="DB2DSN " />
<Table VAR_VALUE="TRUE " VAR_KEY="PRODPR OF" />
</NewDataSet>

<!-- I need this: /-->
<?xml version='1.0' ?>
<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='VAR_VALUE ' rs:number='1'
rs:nullable='tr ue'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='2 00'/>
</s:AttributeType >
<s:AttributeTyp e name='VAR_KEY' rs:number='2'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='1 0'
rs:maybenull='f alse'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row VAR_VALUE='LSUS ' VAR_KEY='DIVISI ON'/>
<z:row VAR_VALUE='DB2P ' VAR_KEY='DB2DSN '/>
<z:row VAR_VALUE='TRUE ' VAR_KEY='PRODPR OF'/>
</rs:data>
</xml>


Nov 12 '05 #3
Going back and reading your first post again, I see that what you say that
you want is data in the MS XDR format (XML Data Reduced). XDR was replaced
by the W3C XSD (XML Schema Document) standard, some time ago.

The XML methods of ADO.NET objects do not produce XML in the format that you
seek (XDR).

Since what you want is produced via the, now legacy, ADO Recordset and since
the code that you says works for you is all Classic ADO/COM code, you are
probably better off, sticking with Classic COM, rather than .NET. Or, you
may want to consider writing a COM component that does the job and then call
that component from within .NET using COM interOp.
"jk" <jk******@levi. com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
that gives me this:
<NewDataSet>
<Table>
<VAR_VALUE>LSUS </VAR_VALUE>
<VAR_KEY>DIVISI ON</VAR_KEY>
</Table>
<Table>
<VAR_VALUE>DB2T </VAR_VALUE>
<VAR_KEY>DB2DSN </VAR_KEY>
</Table>
<Table>
<VAR_VALUE>TRUE </VAR_VALUE>
<VAR_KEY>PRODPR OF</VAR_KEY>
</Table>
</NewDataSet>

none of the options i've tried gives me the output expected from
responseStream. it's like it's interpreting the data as a higher node
(maybe since it's dataset not datatable). i need rowset not table info.
this was just a few lines of code in vb.net that worked fine:

stream = Server.CreateOb ject("ADODB.Str eam")
stream.Type = 1
stream.Open()
rs.save(stream, 1) '1=adpersistxml
sXML = stream.ReadText
stream.Close()
stream = Nothing
Response.Write( "<?xml version='1.0' ?>")
Response.Write( sXML)

Scott M. wrote:
How about

dim tableString as String = DataSet.getXML

"jk" <jk******@levi. com> wrote in message
news:11******** *************@c 13g2000cwb.goog legroups.com...
> I'm having trouble converting a datatable into xml, with resonse.write > to aspx. I'm basically converting vb code that saved a recordset into a > stream into c#, but the format is wrong. I've tried using streams,
> datadoc, xmlreader, etc with no success. I need to convert it directly > to a string or via a stream, but not in a file. Here's some sample
> code that gives me the bad format. I'll post the good format below that > give me rowsets rather than tables. thanks for any help!!
>
> StringWriter sw = new StringWriter();
> dt.DataSet.Writ eXml(sw, XmlWriteMode.Wr iteSchema);
> string s = sw.ToString();
> Response.Write( "<?xml version='1.0' ?>");
> Response.Write( s);
>
> <!-- give me this: /-->
> <?xml version='1.0' ?>
> <NewDataSet>
> <xs:schema id="NewDataSet " xmlns=""
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
> <xs:element name="NewDataSe t" msdata:IsDataSe t="true">
> <xs:complexType >
> <xs:choice maxOccurs="unbo unded">
> <xs:element name="Table">
> <xs:complexType >
> <xs:attribute name="VAR_VALUE " type="xs:string " />
> <xs:attribute name="VAR_KEY" type="xs:string " />
> </xs:complexType>
> </xs:element>
> </xs:choice>
> </xs:complexType>
> </xs:element>
> </xs:schema>
> <Table VAR_VALUE="LSUS " VAR_KEY="DIVISI ON" />
> <Table VAR_VALUE="DB2T " VAR_KEY="DB2DSN " />
> <Table VAR_VALUE="TRUE " VAR_KEY="PRODPR OF" />
> </NewDataSet>
>
> <!-- I need this: /-->
> <?xml version='1.0' ?>
> <xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
> xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
> xmlns:rs='urn:s chemas-microsoft-com:rowset'
> xmlns:z='#Rowse tSchema'>
> <s:Schema id='RowsetSchem a'>
> <s:ElementTyp e name='row' content='eltOnl y'>
> <s:AttributeTyp e name='VAR_VALUE ' rs:number='1'
> rs:nullable='tr ue'
> rs:writeunknown ='true'>
> <s:datatype dt:type='string ' rs:dbtype='str'
> dt:maxLength='2 00'/>
> </s:AttributeType >
> <s:AttributeTyp e name='VAR_KEY' rs:number='2'
> rs:writeunknown ='true'>
> <s:datatype dt:type='string ' rs:dbtype='str'
> dt:maxLength='1 0'
> rs:maybenull='f alse'/>
> </s:AttributeType >
> <s:extends type='rs:rowbas e'/>
> </s:ElementType>
> </s:Schema>
> <rs:data>
> <z:row VAR_VALUE='LSUS ' VAR_KEY='DIVISI ON'/>
> <z:row VAR_VALUE='DB2P ' VAR_KEY='DB2DSN '/>
> <z:row VAR_VALUE='TRUE ' VAR_KEY='PRODPR OF'/>
> </rs:data>
> </xml>
>

Nov 12 '05 #4
Hi,

see the code download for Dino Esposito's "Applied XML Programming for
Microsoft .NET"

http://www.microsoft.com/MSPress/books/6235.asp .

In chapter 4 there is an example of an XmlRecordsetWri ter class (custom XML
writer) which
is capable to write ADO recordset compliant XML. It has WriteRecordset
method which can take a DataSet, DataTable or DataView and write it as
Recordset.

Hope this helps.

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU
"jk" <jk******@levi. com> wrote in message
news:11******** *************@c 13g2000cwb.goog legroups.com...
I'm having trouble converting a datatable into xml, with resonse.write
to aspx. I'm basically converting vb code that saved a recordset into a
stream into c#, but the format is wrong. I've tried using streams,
datadoc, xmlreader, etc with no success. I need to convert it directly
to a string or via a stream, but not in a file. Here's some sample
code that gives me the bad format. I'll post the good format below that
give me rowsets rather than tables. thanks for any help!!

StringWriter sw = new StringWriter();
dt.DataSet.Writ eXml(sw, XmlWriteMode.Wr iteSchema);
string s = sw.ToString();
Response.Write( "<?xml version='1.0' ?>");
Response.Write( s);

<!-- give me this: /-->
<?xml version='1.0' ?>
<NewDataSet>
<xs:schema id="NewDataSet " xmlns=""
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSe t" msdata:IsDataSe t="true">
<xs:complexType >
<xs:choice maxOccurs="unbo unded">
<xs:element name="Table">
<xs:complexType >
<xs:attribute name="VAR_VALUE " type="xs:string " />
<xs:attribute name="VAR_KEY" type="xs:string " />
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<Table VAR_VALUE="LSUS " VAR_KEY="DIVISI ON" />
<Table VAR_VALUE="DB2T " VAR_KEY="DB2DSN " />
<Table VAR_VALUE="TRUE " VAR_KEY="PRODPR OF" />
</NewDataSet>

<!-- I need this: /-->
<?xml version='1.0' ?>
<xml xmlns:s='uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid: C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:s chemas-microsoft-com:rowset'
xmlns:z='#Rowse tSchema'>
<s:Schema id='RowsetSchem a'>
<s:ElementTyp e name='row' content='eltOnl y'>
<s:AttributeTyp e name='VAR_VALUE ' rs:number='1'
rs:nullable='tr ue'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='2 00'/>
</s:AttributeType >
<s:AttributeTyp e name='VAR_KEY' rs:number='2'
rs:writeunknown ='true'>
<s:datatype dt:type='string ' rs:dbtype='str'
dt:maxLength='1 0'
rs:maybenull='f alse'/>
</s:AttributeType >
<s:extends type='rs:rowbas e'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row VAR_VALUE='LSUS ' VAR_KEY='DIVISI ON'/>
<z:row VAR_VALUE='DB2P ' VAR_KEY='DB2DSN '/>
<z:row VAR_VALUE='TRUE ' VAR_KEY='PRODPR OF'/>
</rs:data>
</xml>

Nov 12 '05 #5

Try this:

Cmd.CommandText = s
Conn.Open()
Dim da As New SqlDataAdapter( Cmd)
da.SelectComman d = Cmd
Dim ds As New DataSet
da.Fill(ds)

Dim Writer As New XmlTextWriter(R esponse.OutputS tream
System.Text.Enc oding.UTF8)

Writer.Formatti ng = Formatting.Inde nted
Writer.Indentat ion = 3
Writer.WriteSta rtDocument()
' Writer.WriteCom ment("Created b
XmlRecordsetWri ter")

Writer.WriteSta rtElement("xml" )
Writer.WriteAtt ributeString("x mlns", "s", Nothing
"uuid:BDC6E 3F0-6DA3-11d1-A2A3-00AA00C14882")
Writer.WriteAtt ributeString("x mlns", "dt", Nothing
"uuid:C2F41 010-65B3-11d1-A29F-00AA00C14882")
Writer.WriteAtt ributeString("x mlns", "rs", Nothing
"urn:schema s-microsoft-com:rowset")
Writer.WriteAtt ributeString("x mlns", "z", Nothing
"#RowsetSchema" )

' Open the schema tag (XDR)
Writer.WriteSta rtElement("s", "Schema", Nothing)
Writer.WriteAtt ributeString("i d", "RowsetSche ma")
Writer.WriteSta rtElement("s", "ElementTyp e", Nothing)
Writer.WriteAtt ributeString("n ame", "row")
Writer.WriteAtt ributeString("c ontent", "eltOnly")

' Write the column info
Dim index As Integer = 0
Dim dc As DataColumn
For Each dc In ds.Tables(0).Co lumns
index += 1
Writer.WriteSta rtElement("s", "AttributeT ype"
Nothing)
Writer.WriteAtt ributeString("n ame", dc.ColumnName)
Writer.WriteAtt ributeString("r s", "number", Nothing
index.ToString( ))
Writer.WriteEnd Element()
Next

' Close the schema tag
Writer.WriteSta rtElement("s", "extends", Nothing)
Writer.WriteAtt ributeString("t ype", "rs:rowbase ")
Writer.WriteEnd Element()
Writer.WriteEnd Element()
Writer.WriteEnd Element()
' Write data
Writer.WriteSta rtElement("rs", "data", Nothing)
Dim row As DataRow
For Each row In ds.Tables(0).Ro ws
Writer.WriteSta rtElement("z", "row", Nothing)

For Each dc In ds.Tables(0).Co lumns
Writer.WriteAtt ributeString(dc .ColumnName
row(dc.ColumnNa me).ToString())
Next
Writer.WriteEnd Element()
Next
Writer.WriteEnd Element()

Writer.WriteEnd Document()
Writer.Close(
-
makot
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1287639.htm

Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
5251
by: Eidolon | last post by:
I have a class which inherits from System.Data.DataTable. The code is basically (property procs omitted for clarity): Public Class DataTable() Inherits System.Data.DataTable Public Property SQL As String = "" End Class Now, i have a proc which given a SQL returns the System.Data.DataTable
3
5658
by: Rodusa | last post by:
I am looking for an example of how to save a DataTable into Base64 and vice-versa. I tried using Convert.ToBase64String(), but it says that it cannot convert DataTable to byte. Any help or pointing would be appreciated. Thanks Rod
2
13371
by: mimi | last post by:
I would like to convert an arraylist to dataset or datatable so that I can filter or make a select distinct from it. How to do it? Can someone show me the syntax? Thanks
3
2686
by: Thubaiti | last post by:
Hi, I have this code in my ASP.NET and I want to convert it to C# (code behind) <asp:Repeater id="subCategoryRepeater" runat="server"> <ItemTemplate> <ul> <li> <asp:HyperLink id="subCategoryHyperLink" runat="server" NavigateUrl='<%# "subcategory.aspx?subcategoryid=" +
3
3616
by: Zean Smith | last post by:
I wrote an ASPX web application and a C# Classes which compiled as a seperated DLLs. In my ASPX web app. I import that DLL as Reference. How do I convert those Classes to Web Services? is it easy? so that other ASPX web app can reuse my classes over the network. Is this possible? or do I have to rewrite the classes? Thanks a lot
5
2715
by: manmit.walia | last post by:
Hello All, I am stuck on a conversion problem. I am trying to convert my application which is written in VB.NET to C# because the project I am working on currently is being written in C#. I tried my best to convert it, but somehow the app does not work. I am also not getting any errors when I complie thus, letting me know I am on the write track. Basically what I want to do is edit,add,delete, and update an XML file in a DataGrid. Below...
6
16729
by: Nick | last post by:
I have a code that returns data in IList. My webGrid doesn't allow me to sort with IList returned, it say it only suports DataView, DataTable and DataSet, not IEnumerable. I don't know how to return the DataSet type when using the following code: ======== this is my interface ====================== namespace WareHouse.DataLayer.DataObjects { /// <summary> /// Defines methods to access categories and products.
1
6070
by: pnbaocuong | last post by:
Dear All When I try to use convert function of MS sql server like this: String sql = " (employee_id = '" + employee_id + "') and ((convert(VARCHAR,w_date,103) = '" + w_date + "'))"; PAYROLLDataSet.WORKINGTIMESRow workingtime_row = (PAYROLLDataSet.WORKINGTIMESRow)pAYROLLDataSet.WORKINGTIMES.Select(sql); Whe I run, it rais bellow exception:
5
8628
by: Frank Hauptlorenz | last post by:
Hello, I recognized some days ago, that returning a DataTable blocks my WCF-Service. Is this a known bug? If I add this table to a new DataSet() and return this, it works. Thank you, Frank
0
7934
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8424
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8415
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
6742
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5886
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5445
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3912
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2438
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1270
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.