تحويل ال Dataset كامتا ببياناتها الى قاعدة البيسانات Sql ؟

#118 فبراير 2009 في 13:54 صاحب الموضوع

السلام عليكم ورحمة الله وبركاته

عامل web service V.B .netاقراْ ملف XML حجمة كبير من كثرة البيانات حوالى 200 mg

واريد ان اخزن البيانات الموجودة بالملف الى قواعد البيانات sql server

استخدمت الكود للتحويل ال XML الى داتا سيت

Dim billDataset As New DataSet

billDataset.ReadXml(sReader1)

مشكلتي منى عارف احصر الجدوال الموجودة في الداتا سيت عشان انشئلها جداول في قاعدة البانات عشان اعملها insert فيها

ملف ال XML معقد

هل في طريقة ممكن ارمي الداتا سيت زي ماهي بالجدوال الي فيها الى الsql server تتحول هناك الى جدوال متتطابقة مع الداتا سيت بالبيانات الى فيها؟

وشكراً

#226 فبراير 2009 في 18:30

اخي الكريم في مجال تبعث جزء من ملف ال(XML) او عمل (Print Screen) له وان شاء الله بحل المشكلة

#328 فبراير 2009 في 11:48

السلام عليكــم ورحمـة الله وبركاتــة ،،

انا ابغى طريقة عامة لاي

اكس ام ال دون التدخل بأي تفاصيل الملف

على العموم

هذا جزء من الملف

<?xml version="1.0" encoding="utf-8" ?> - <SALES_ORDER_REQUEST xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance'>http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">- <header> <PARTNER_ID>ede-ff-co</PARTNER_ID> </header>- <orderRequestHeader> <BATCH_ID>20090122230006</BATCH_ID> <RECORDS_SENT>30</RECORDS_SENT> </orderRequestHeader>- <OrderRequestItem>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721152</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090131</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721153</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090131</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721154</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090202</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721155</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090204</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721150</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090131</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721151</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090202</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721146</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090131</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721147</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090202</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721148</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090202</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721149</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090204</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721141</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090131</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721142</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090201</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721143</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090201</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721144</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090204</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721145</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090204</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721139</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090131</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721140</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090201</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721135</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090131</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721136</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090202</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721137</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090204</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721138</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090204</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-721134</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-030</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090203</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720982</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090122</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720983</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090123</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720980</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090122</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720981</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090123</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720979</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090123</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720977</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090122</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720978</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090123</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM>- <ORDER_REQUEST_ITEM> <PO_NUMBER>1-09-720976</PO_NUMBER> <CUSTOMER>405204</CUSTOMER> <PLANT>S184</PLANT> <MATERIAL>A-873</MATERIAL> <ORDER_QUANTITY>32000</ORDER_QUANTITY> <UNIT_OF_MEASURE>L</UNIT_OF_MEASURE> <DELIVERY_DATE>20090123</DELIVERY_DATE> <DEL_START_TIME>000000</DEL_START_TIME> <DEL_END_TIME>235959</DEL_END_TIME> <CREATE_UNCONFIRM>X</CREATE_UNCONFIRM> </ORDER_REQUEST_ITEM> </OrderRequestItem> </SALES_ORDER_REQUEST>

#41 مارس 2009 في 10:18

اسف على التأخير اخي الكريم

ان شاء الله الحل بالمرفقات

ReadXMLFile.rar

تحويل ال Dataset كامتا ببياناتها الى قاعدة البيسانات Sql ؟

مواضيع مشابهة

عدد الزوار حالياً