Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / ADO.NET, LINQ, Entity Framework, NHibernate, DAL, ORM Новый топик    Ответить
 Проблема с экранированием текста в OLEDB  [new]
sashenka
Member

Откуда: Krasnodar
Сообщений: 723
пытаемся проинсертить в excel тиблицу церез jet драйвер в поле текст
<TABLE id=AutoNumber1 style=\"BORDER-COLLAPSE: collapse\" borderColor=#111111 cellSpacing=0 cellPadding=0 width=\"75%\" border=0>\n<P align=left>\n<TBODY>\n<TR>\n<TD width=\"100%\">\n<TABLE id=AutoNumber2 style=\"BORDER-COLLAPSE: collapse\" borderColor=#111111 height=24 cellSpacing=0 cellPadding=0 width=\"92%\" border=0>\n<TBODY>\n<TR>\n<TD borderColor=#ffffff width=\"100%\" height=24>\n<P align=right><FONT face=Arial color=#0000ff size=2><STRONG><EM><A href=\"http://stores.ebay.com/Champions-On-Display\">See all of our items for sale <BR>... in our eBay Store!</A></EM></STRONG></FONT></P></TD></TR></TBODY></TABLE>\n<P align=center><IMG height=46 src=\"http://pics.ebaystatic.com/aw/pics/powerseller/Hub/psNew04/logoPS_106x46.gif\" width=106>                                               <A href=\"http://stores.ebay.com/Champions-On-Display\"><IMG class=imageAlign height=55 alt=\"From collectibles to electronics, buy and sell all kinds of items on eBay Stores\" src=\"http://pics.ebaystatic.com/aw/pics/storefronts/hub/subcat/storesLogo_176x55.gif\" width=176 border=0></A><B><I><FONT face=Arial size=5><BR><IMG height=136 src=\"http://admin.championsondisplay.com/managed_files/1961/eby_templte_logo.jpg\" width=321 border=0><BR><FONT size=3>T</FONT></FONT><FONT face=Arial size=3>HE Platinum PowerSeller Source<BR>For Sports Collectibles!<BR></FONT></I></B><B><I><FONT face=Arial size=5><BR></P>\n<P align=center><B><I><FONT face=Arial size=5>ST. LOUIS CARDINALS<BR>PLUSH JERSEY TEDDY BEAR!</P>\n<P align=center><B><I><FONT face=Arial size=4>Plush Bear! Cute and Cuddly! 8\" Tall!<BR>Embroidery Stitched Official Logos!</FONT></I></B></P></FONT></I></B></FONT></I></B>\n<P><FONT face=Arial><B>Features: </B></FONT><FONT face=Arial></P>\n<UL><FONT face=Arial><FONT face=Arial><FONT face=Arial><FONT face=Arial><FONT face=Arial><FONT face=Arial><FONT face=Arial><FONT face=Arial><FONT face=Arial><FONT face=Arial>\n<LI><FONT face=Arial>Top-quality collectible from Forever Collectibles!</FONT> \n<LI><FONT face=Arial>Official logo! Official team colors!</FONT>   \n<LI>This 8\" tall Teddy Bear is the perfect gift for fans of any age<FONT face=Arial>!</FONT> \n<LI>Just the right size for the kids room, the office, or the bookcase! \n<LI><FONT face=Arial>Terrific collectible ... great for anyone in the family!</FONT>!   \n<LI>Officially licensed by MLB and the team!</LI></UL>\n<P>\n<P>\n<P>\n<P><FONT face=Arial><STRONG>Condition: </STRONG>Brand new ... just in from the manufacturer!</FONT></P>\n<P><FONT face=Arial><STRONG>Additional comments: </STRONG>Supplies are limited ... get one of these great great collectibles while they last!</FONT></P></FONT></FONT></FONT></FONT></FONT></FONT>\n<P></P></FONT></FONT>\n<P></P></FONT></FONT>\n<P><STRONG><FONT face=Arial>Shipping: </FONT></STRONG><FONT face=Arial>Use the eBay Shipping Calculator below to determine exact shipping cost to you!</FONT></P>\n<P></P></FONT>\n<P align=center><FONT face=Arial color=#000000><STRONG>The \"Champions On Display\" Difference! </STRONG></FONT></P>\n<UL><FONT face=Arial color=#000000>\n<LI><FONT face=Arial color=#000000>Compare quality and service before you buy! <STRONG>Check our feedback</STRONG> against others selling the same product. Others sellers are sometimes less expensive, but <STRONG>we guarantee your item is in stock and shipping!</STRONG> </FONT>\n<LI><FONT face=Arial color=#000000>Our <STRONG>order fulfillment and shipping time is among the fastest on eBay</STRONG> and head and shoulders above our competition. You'll get your item quickly and safely!</FONT> \n<LI><FONT face=Arial color=#000000><STRONG>Compare our shipping costs.</STRONG> Many sellers offer low prices, but make up the difference by overpricing shipping. Our shipping prices are fair and we utilize both UPS and USPS to provide the <STRONG>best shipping prices and delivery times.</STRONG> </FONT> \n<LI><FONT face=Arial color=#000000><STRONG>Don't take chances with your money or your time ... buy with confidence from Champions On Display!</STRONG></FONT></FONT></LI></UL><FONT size=3>\n<P><FONT face=Arial><STRONG>Don't forget to add Champions On Display to your </STRONG></FONT><A href=\"http://cgi1.ebay.com/aw-cgi/eBayISAPI.dll?AcceptSavedSeller&sellerid=champions_on_display&sspageName=DB:FavList\" target=_blank><FONT face=Arial><STRONG>favorites list</STRONG></FONT></A><FONT face=Arial><STRONG> ... and check out all of our other auctions and more in our <A href=\"http://stores.ebay.com/Champions-On-Display\">eBay Store! </A></STRONG></FONT><FONT face=Arial><STRONG></STRONG></FONT></P>\n<P align=center><FONT face=Arial><STRONG>For lots of great bargains, check out our web store!<BR>Just type <EM>\"Champions On Display\" </EM>into your favorite search engine or go to our <EM><A href=\"http://cgi3.ebay.com/ws/eBayISAPI.dll?ViewUserPage&userid=champions_on_display\">eBay About Me</A> </EM>page for a link to our website!<EM> </EM></STRONG></FONT></P></FONT>\n<P><B><FONT face=Arial size=4><A name=Payment>Payment</A>:</FONT><FONT face=Arial size=5><BR></FONT><FONT face=Arial size=1><BR></FONT></B><FONT face=Arial size=2>PayPal is the preferred payment method. Pay with PayPal for quickest delivery. Most items purchased using PayPal ship in 24-48 hours! Money orders also accepted. Sorry, we don't accept personal checks, but you can use an eCheck to pay through PayPal. Payment from Canadian and International buyers will be accepted ONLY via PayPal (see further details on International shipping below).</FONT></P>\n<P><IMG height=33 src=\"http://admin.championsondisplay.com/managed_files/1723/paypal_icon.gif\" width=88 border=0><FONT face=Arial> <IMG height=26 src=\"http://admin.championsondisplay.com/managed_files/1717/icon_mastercard.gif\" width=39 border=0> <IMG height=26 src=\"http://admin.championsondisplay.com/managed_files/1726/visa_icon.gif\" width=39 border=0> <IMG height=26 src=\"http://admin.championsondisplay.com/managed_files/1725/amex_icon.gif\" width=27 border=0> <IMG height=26 src=\"http://admin.championsondisplay.com/managed_files/1727/discover_icon.gif\" width=39 border=0> <IMG height=26 src=\"http://admin.championsondisplay.com/managed_files/1728/echeck_icon.gif\" width=40 border=0></FONT></P>\n<P><FONT face=Arial><FONT size=2><B>Mail money orders to:</B><BR>Champions On Display<BR>1025 N. University Blvd<BR>Norman, OK 73069</FONT></FONT><FONT face=Arial size=1><BR><BR></FONT><FONT face=Arial size=2><B>Payment must be received within seven (7) days of the close of auction.</B> If payment is not received within 7 days, the auction will be revoked and a \"non-paying bidder\" alert will be filed with eBay. </FONT></P>\n<P><B><FONT face=Arial size=4><A name=Shipping>Shipping</A>:</FONT></B><FONT face=Arial size=2><B> </B></FONT></P>\n<P><FONT face=Arial size=2>Use the Shipping Calculator below to determine exact shipping cost to your Zip Code!</FONT></P>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\"><STRONG>Our shipping procedures:</STRONG></SPAN><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\"> We ship PROMPTLY ... just check our feedback! Most items ship within 48 hours of payment; many within 24 hours. You will receive a confirmation e-mail with a delivery confirmation or tracking number as soon as your order is shipped. We use UPS or USPS shipping, depending on which is fastest and most economical for the item.</SPAN></P>\n<P><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\"><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\">Estimated Delivery times are as follows:<BR><BR></P>\n<LI><STRONG><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\">USPS Priority Mail (probable 2-3 day delivery)</SPAN> </STRONG>\n<LI><STRONG><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\">UPS Ground (3-5 day delivery)</SPAN> </STRONG>\n<LI><STRONG><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\">USPS First Class Mail (probable 7-10 day delivery)</SPAN> </STRONG>\n<LI><SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA\"><STRONG>USPS Express Mail, when available (overnight to most areas)</STRONG></SPAN><FONT face=\"Times New Roman\" size=3> </FONT></SPAN></SPAN>\n<P align=left><FONT face=Arial size=2>Pay with PayPal for fastest shipping (money orders also accepted). We pack items professionally. However, we encourage the purchase of shipping insurance at checkout to protect against damage in transit.</FONT></P>\n<P align=left><FONT face=Arial size=2>We are required to ship to the address the buyer has on record with eBay and/or PayPal. If you would like an item shipped to an alternate address, please log on to your eBay and PayPal account and establish an additional shipping address before checking out.</FONT></P>\n<P align=left><FONT face=Arial><FONT size=2><STRONG>Combined shipping: </STRONG>We are happy to combine shipping for buyers of multiple items. Combined shipping costs are discounted substantially and will be calculated at checkout. The more you buy ... the more you will save!<BR><BR><STRONG><STRONG><FONT size=4>International Orders:</FONT></STRONG></STRONG></FONT></FONT></P>\n<P align=left><FONT face=Arial><FONT size=2><FONT face=\"\">We are happy to ship internationally! PayPal is the only accepted payment method for international orders. We ship by USPS Global Priority or USPS Global Express, depending on which is available in the destination country. Please use the shipping calculator below to determine the exact cost of shipping to you! Most international deliveries take 1-2 weeks to arrive.</FONT></FONT></FONT></P>\n<P align=left><FONT size=2><FONT face=Arial><FONT face=Arial size=2><A name=Returns><STRONG><FONT size=4>Feedback:</FONT></STRONG></A></FONT><FONT face=Arial size=2></FONT></FONT></FONT></P>\n<P align=left><FONT size=2><FONT face=Arial><FONT face=Arial size=2>If you are happy with your transaction, please leave us Positive Feedback. Our AUTOMATED Feedback system leaves positive feedback for buyers IMMEDIATELY on receipt of Positive Feedback! If for any reason you do not wish to leave Positive Feedback, please let us know and we will work with you to resolve problems, so that we can both benefit and improve each other's feedback ratings. Help eBay build a better community through responsible feedback!</FONT> </FONT></FONT></P>\n<P align=left><B><FONT face=Arial size=4><A name=Returns>Returns:</A></FONT></B><FONT face=Arial><BR><FONT size=1><BR></FONT><FONT size=2>Returns accepted within 7 days only if item is flawed. Shipping insurance should be purchased to cover potential damage in transit. Buyer pays shipping. We try to provide thorough and accurate descriptions of our items. If you have any questions, please email us before placing your bid.</FONT></FONT></P>\n<P align=left><FONT size=1>All text and images in this auction are ©Champions On Display, LLC. All rights reserved.</FONT></P></LI></TD></TR>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P>\n<P></P></P></TABLE>\n<P> </P>\n<P> </P>\n\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\t
но инсерт падает с ошибкой type mismutch тоесть теоритически oledbparameter не экранирует вставляемый текст.
Кто и как с этим бореться?
13 фев 07, 17:38    [3779751]     Ответить | Цитировать Сообщить модератору
 Re: Проблема с экранированием текста в OLEDB  [new]
sashenka
Member

Откуда: Krasnodar
Сообщений: 723
в общем проблема что невозможно в ячейку excel вставить данные размером более 255 через oledb если кто знает как это побороть помогите плызз
14 фев 07, 11:08    [3782548]     Ответить | Цитировать Сообщить модератору
 Re: Проблема с экранированием текста в OLEDB  [new]
Изопропил
Member

Откуда:
Сообщений: 31536
Можно не использовать JET и OLEDB, а воспользоваться Jakarta POI (портированную для .net)

http://sourceforge.net/project/showfiles.php?group_id=151482

P.S. Для русского языка cell.setEncoding(HSSFCell.ENCODING_UTF_16) нужно явно делать
14 фев 07, 15:40    [3785239]     Ответить | Цитировать Сообщить модератору
 Re: Проблема с экранированием текста в OLEDB  [new]
sashenka
Member

Откуда: Krasnodar
Сообщений: 723
сенки но проблема решилась) описание решения находится в ветке ms sql
15 фев 07, 12:22    [3789396]     Ответить | Цитировать Сообщить модератору
Все форумы / ADO.NET, LINQ, Entity Framework, NHibernate, DAL, ORM Ответить