Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP.NET¶ÁÈ¡EXCELÎļþµÄÈýÖÖ·½·¨


1.·½·¨Ò»£º²ÉÓÃOleDB¶ÁÈ¡EXCELÎļþ£º
°ÑEXCELÎļþµ±×öÒ»¸öÊý¾ÝÔ´À´½øÐÐÊý¾ÝµÄ¶ÁÈ¡²Ù×÷£¬ÊµÀýÈçÏ£º
public DataSet ExcelToDS(string Path)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();  
string strExcel = "";   
OleDbDataAdapter myCommand = null;
DataSet ds = null;
strExcel="select * from [sheet1$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds,"table1");   
return ds;
}
¶ÔÓÚEXCELÖÐµÄ±í¼´sheet([sheet1$])Èç¹û²»Êǹ̶¨µÄ¿ÉÒÔʹÓÃÏÂÃæµÄ·½·¨µÃµ½
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,null);
string tableName=schemaTable.Rows[0][2].ToString().Trim();  
ÁíÍ⣺Ҳ¿É½øÐÐдÈëEXCELÎļþ£¬ÊµÀýÈçÏ£º
public void DSToExcel(string Path,DataSet oldds)
{
//Ïȵõ½»ã×ÜEXCELµÄDataSet Ö÷ҪĿµÄÊÇ»ñµÃEXCELÔÚDataSetÖеĽṹ
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ="+path1+";Extended Properties=Excel 8.0" ;
OleDbConnection myConn = new OleDbConnection(strCon) ;
string strCom="select * from [Sheet1$]";
myConn.Open ( ) ;
OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom, myConn ) ;
ystem.Data.OleDb.OleDbCommandBuilder builder=new OleDbCommandBuilder(myCommand);
//QuotePrefixºÍQuoteSuffixÖ÷ÒªÊǶÔbuilderÉú³ÉInsertCommentÃüÁîʱʹÓá£
builder.QuotePrefix="[";     //»ñÈ¡insertÓï¾äÖб£Áô×Ö·û£¨ÆðʼλÖã©
builder.QuoteSuffix="]"; //»ñÈ¡insertÓï¾äÖб£Áô×Ö·û£¨½áÊøÎ»Öã©
DataSet newds=new DataSet();
myCommand.Fill(newds ,"Table1") ;
for(int i=0;i<oldds.Tables[0].Rows.Count;i++)
{
//ÔÚÕâÀï²»ÄÜʹÓÃImportRow·½·¨½«Ò»Ðе¼Èëµ½newsÖУ¬ÒòΪImportRow½«±£ÁôÔ­À´DataRowµÄËùÓÐÉèÖÃ(DataR


Ïà¹ØÎĵµ£º

ASP.NET ºÍ IIS ÅäÖÃ×Ô¶¨ÒåÀ©Õ¹ÃûÍøÒ³

¿´¹ý΢ÈíµÄÍøÕ¾ÓÐʱºò£¬ÊÇ.MSPXµÄÀ©Õ¹Ãû£¿ÆäʵÄãÒ²¿ÉÒÔÅäÖ㬺ܼòµ¥¡£Here We Go!
ÅäÖÃWEB.CONFIG£º
<system.web>
    <compilation>
       <buildProviders>
          <add  ......

Asp.netÒ³Ãæ´«µÝ²ÎÊýµÄ¼¸ÖÖ·½·¨¶Ô±È½²½â

µÚÒ»ÖÖ·½·¨£º
ͨ¹ýURLÁ´½ÓµØÖ·´«µÝ
send.aspx:
   protected void Button1_Click(object sender, EventArgs e)
     {
         Request.Redirect("Default2.aspx?username=honge");
     }
receive.aspx:
string user ......

ÔÚASP.NETÖÐʹÓÃTreeview¿Ø¼þºÍXML


ÔÚASP.NETÖÐʹÓÃTreeview¿Ø¼þºÍXML
ÒÔǰ£¬ÔÚWEBÒ³ÃæÖÐÈç¹ûÏëʹÓÃÊ÷ÐοؼþµÄ»°£¬ÍùÍù»áÓÐЩÂé·³£¬ÓÐʱÉõÖÁÒª×Ô¼ºÐ´´úÂëÀ´´ïµ½ÓÃÊ÷ÐÎÁбíÏÔʾÊý¾ÝµÄÄ¿µÄ¡£ÔÚasp.netÖУ¬ÎÒÃÇ¿ÉÒԺܷ½±ãµØÊ¹ÓÃÓÉ΢ÈíÌṩµÄInternet Exploer Web Controls¿Ø¼þÀ´ÊµÏÖÊ÷ÐÎÁÐ±í¡£ÔÚ΢ÈíÌṩµÄÕâÌ×Internet Exploere Web Controls¿Ø¼þ¼¯ºÏÖУ¬°üÀ ......

asp.netÁ¬½ÓmysqlÊý¾Ý¿â

MysqlµÄconnector/net5.0ÏÂÔØµØÖ·:
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.6.zip/from/pick
°²×°ºÃÒÔºó,
µãÊôÐÔ,È»ºóµã²éÕÒÄ¿±ê,µãÏòÉÏÒ»²ãĿ¼,ÕÒµ½Binaries\.NET 2.0,È»ºó½«Õâ¸öÎļþ¸´ÖƵ½ÄãµÄ¹¤³ÌĿ¼ÏÂ,Ò»°ãÕâÑùµÄDLLÎļþ»á±£´æµ½binĿ¼ÏÂ.
ÔÚ´úÂëÒ³ÀïÊäÈëusing Mysql.Da ......

asp.net ÖÐÓÃJSµ¯³öģ̬´°¿ÚµÄ·ÖÒ³ÎÊÌâ

ÔÚasp.netÖÐÓÃjs¿ØÖƵ¯³öÒ»¸öģ̬´°¿Ú£¬Ä£Ì¬´°¿ÚÈ´²»ÄÜ·ÖÒ³¡£µ¥¶ÀÔËÐдËÒ³·ÖҳЧ¹ûÊÇ¿ÉÒÔ´ïµ½µÄ¡£
Îҵĵ¯³öģ̬´°¿ÚµÄ´úÂëÊÇ£º
var param=window.showModalDialog("../StorageList.aspx",null,"height=100px;width=950px;status=yes;toolbar=no,location=nu");
²»ÖªµÀΪʲô»á³öÏÖÕâÖÖЧ¹û£¿
½â¾ö·½·¨ÊÇÔÚÒªµ¯³öµÄģ̬´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ