asp.net ½«Excelµ¼Èëµ½Sql2005»ò2000
asp.net ½«Excelµ¼Èëµ½Sql2005»ò2000µÄ˼·ºÍ²½Ö裺
1¡¢½«ExcelÎļþÉÏ´«µ½·þÎñÆ÷¶Ë
Õâ¸öÎÒ²»ÏëÏêϸ½²ÁË,ÍøÉÏÒ»ËÑÒ»´ó°ÑµÄ.
×¢Ò⣺£¨1ÔÚÈ¡·þÎñÆ÷·¾¶Ê±Ò»¶¨ÒªÓÃthis.Page.MapPath(".")¶ø²»ÒªÓà this.Page.Request.ApplicationPath »òthis.Page.Request.Path;ÒòΪºóÁ½¸öÔÚµ÷ÊÔµÄʱºò¿ÉÄܲ»±¨´í,µ«ÔÚ·¢²¼Ê±»á±¨´í¡£
£¨2 Õ¾µã¸ùĿ¼Ҫ¸øAsp.netÓû§Ð´µÄȨÏÞ¡£·ñÔòÎļþÉÏ´«²»ÉÏÈ¥µÄ£¬±¨¾Ü¾ø·ÃÎÊ.
2¡¢½«·þÎñÆ÷¶ËµÄEXcelÊý¾Ý¶ÁÈëÄÚ´æ
private static DataTable getXslTable(string XlsFileName)//´ÓexcelÖжÁÈ¡Êý¾Ý,²¢·Åµ½DataTableÖÐ
{
DataSet ZDDataSet = new DataSet();
System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + XlsFileName + ";Extended Properties=Excel 8.0");//Õâ¸ö¸ü¾Ý²»Í¬µÄExcel°æ±¾²»Ò»Ñù
//XlsFileName ΪExcelµÄ·¾¶
objConn.Open();
//DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
// String tableName = schemaTable.Rows[0][2].ToString().Trim();
string SqlStr = "Select * from [CPCMLFXB$]";//CPCMLFXBÊÇÒª¶ÁµÄSheetµÄÃû×Ö
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(SqlStr, objConn);
System.Data.OleDb.OleDbDataAdapter DAP = new System.Data.OleDb.OleDbDataAdapter(command);
DAP.Fill(ZDDataSet, "CPCMLFXB");
objConn.C
Ïà¹ØÎĵµ£º
SQL Server ¼ÓÔØÇý¶¯ºÍurlµÄÓï¾äÔòΪ
Çý¶¯°üΪcom.microsoft.sqlserver.jdbc.SQLServerDriver
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";
Çý¶¯°üΪcom.microsoft.jdbc.sqlserver.SQLServerDriverʱ
String driver ......
create or replace procedure pro_insert_dbms
is
cid number;
cid_DDL number;
selectsql varchar2(1000);
ddlsql varchar2(1000);
row_count number;
nofrows integer;
lrowid & ......
1. DotNetNuke(ASP.NET 2.0) ¸öÈËÍƼöÉîÈëÑо¿
DotNetNukeÊÇÒ»¸öWebÓ¦Óÿò¼ÜµÄÀíÏë,Ϊ´´½¨ºÍ²¿ÊðµÄÏîÄ¿,ÈçÉÌÒµÍøÕ¾,ÆóÒµÄÚÁªÍøºÍÍâÁªÍø,ÔÚÍøÉϳö°æÃÅ»§,²¢¶¨ÖÆ´¹Ö±Ó¦ÓÃÈí¼þ¡£ ·½±ãÓû§-DotNetNukeÖ¼ÔÚʹÓû§¿ÉÒÔ¸üÇáËɵعÜÀíËùÓз½ÃæµÄÏîÄ¿¡£
ÏÂÔØÍøÖ·:http://www.dotnetnuke.com/
2¡¢Ludico
LudicoÊÇC#±àдµÄ¾ÓÓÚASP ......
private void btnUploadPicture_Click(object sender, System.EventArgs e) { //¼ì²éÉÏ´«ÎļþµÄ¸ñʽÊÇ·ñÓÐЧ if(this.UploadFile.PostedFile.ContentType.ToLower().IndexOf("image") < 0) { Response.Write("ÉÏ´«Í¼Æ¬¸ñʽÎÞЧ£¡"); return; } //Éú³ÉÔͼ Byte[] oFileByte = new byte[this.UploadFile.PostedFile.Conte ......
ÔÚ´´½¨ÍøÕ¾ÖУ¬³£³£»áʹÓõ½Éí·ÝÑéÖ¤¡£asp.netÖÐÄÚÖÃÁ˼¸ÖÖÉí·ÝÑéÖ¤µÄ·½Ê½£¬ÈçWindows¡¢froms¡¢PassportµÈ¡£Õ⼸ÖÖÉí·ÝÑéÖ¤µÄ·½Ê½¸÷Óв»Í¬¡£
Ò»°ãÀ´Ëµ£¬ÍøÕ¾µÄÉí·ÝÑéÖ¤·½Ê½¶¼»á¾¹ýÒÔϼ¸¸ö²½Ö裺
1¡¢ÊäÈëÓû§ÃûºÍÃÜÂ룬µ¥»÷È·¶¨°´Å¥¡£
2¡¢ÔÚºǫ́ÅжÏÓû§ÃûºÍÃÜÂëÊÇ·ñÕýÈ·£¬Èç¹û´íÎó·µ»ØÌáʾ£»Èç¹ûÕýÈ·£¬½øÈë¿É·ÃÎʵÄÒ ......