asp.net读excle的数据类型不统一取出空值问题_Asp.Net开发技巧

如果表格里某列全是数字或是字符没问题,但如果混合了全是数字和部分字符就会有部分读取为空连接Excel方式如下

string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source=" + _physicalPath +";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();

先是直接FILL到DATASET里,以为是数据类型不正确,再建了一个临时的datatable,导进去还是空值,网络上搜了下,全是一样的问题解决不了

string strConn ="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + _physicalPath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1';";

http://www.cnblogs.com/newblue/archive/2006/11/27/573831.html

sunset villa apartmentsblack leather clutch pursehello kitty luggagehorse rentalsmonogrammed ink stampslarge canvas tote bagswool coatrevelle collegetiger print pursest bags designeroffensive yo mama jokesgiclee canvas transfertrunk restorationmagazine clutch handbagworking cruise ship reviewsdolce gabbana clearancewatercolor inn hotelarts and crafts supply centercanvas paintings onlinej&r american tourister 18637kingstown hotelamerican holland cruisesfashion handbag offerscarpet upholstery leather cleaningjuicy couture bags saleprada handbags pricesdominican republic resortspatent hobo handbagholland america cruise line employmentkaysize xs for salebeach front propertyluggage bag suppliersshort joke of the daystainless steel wireprint napkinsstores handbagswomen leatherdistributors of handbagsaurora world cruise 2010large roxy suitcaseroxy ski jacketscolumbia ski jackets80s leather jacketgift ideas personalized jewelrygrenada grenadinesmen initial ringpersonalized guest towels reviewopi russian collectionkensington saddlebagleather hat patternsnovelty beach towels shopnorwegian sun cruise shipskin heavy leatherbeavers bend cabin rentalsleather dining chairmediterranean travel itinerarylouis vuitton spring summer 2009fendi zucca bag pricesocean sands beachdesigner blazers for mencelebrity princess cruisejungle tours st luciabraided handle handbagsflowers growbarefoot dreams bathrobeslouis vuitton cherry blossom pochettealyson stoner emailmonogram multicolor speedy 30boss winter jacketsbest tea bags iced tearuby princess stateroomsinternational airline luggage rulesdrink kooziesM95796jobs cruise linesmirage speakers frx 5womens braided leather beltschristmas cruisesbeach decor kitchenmarc jacobs designer bagsgucci-213-08luxury vacation homes for rentbeautiful roxy quiksilver backpackluggage carrier with wheelswheeled carry totescruise travel dealdiscount sunglassescarnival insuranceroberto cavalli clothesroyal caribbean hawaiian cruisedior gaucho handbagsmy discount bagsmusic tote bag1700 nomad forumstravelpro luggage storesfree europe toursshopping sites shoescarnival cruise august 2009shoe leathernavarre beach condosduffle bag supplierscheap designer handbags chinasuede boots winterpersonalized party themewildmans leather and lacenorwegian gem cruise criticmacy junior coatswholesale lingerie supplierscommercial sewing machineouter banks beach homesmotor boat cruiseleather computer bagamerican tourister travel bagsartworks gallerykipling luggage ukadvertising pensvintage purses saleflights to bermudad&g bagcruise sailboatGucci-131233-05guess handbags usaleather business card walletavirex bomber jacketscarnival cruise line cruisesblack designer bagsmonogram almaarmani pursesspring wedding dresseswhite star line shiphawaiian vacation homes rentcute cheap tote bagsboyt garment baghello kitty makeup bagcarnival conquest reviewshoneymoon cruise vacation celebrity cruises galaxypfaff industrial sewing machinewholesale country road handbagship hop jacketsasia cruise your swaggerprincess cruise homeGucci-207301-1disney world trip reporthotel esprit saint germainwatercolor instructional videosrent my condoopera travelstorage shed rentaldiy mens fashion

Replica lv Hangbags

Replica Hangbags

Hangbags

replica handbags

replica handbags

replica handbags

replica handbags

handbags

replica handbags replica handbags replica handbags replica handbags replica handbags