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

ASP.NETÓÚ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 [»õÎïÅÉËÍÇé¿ö$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds, "table1");
conn.Close();
myCommand.Dispose();
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();
//
public void ExportGridView(GridView gridView1, string filename)
{
string attachment = "attachment; filename=" + filename + ".xls";
HttpResponse Response = HttpContext.Current.Response;
Response.ClearContent();
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Create a form to contain the grid
HtmlForm frm = new HtmlForm();
gridView1.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";

frm.Controls.Add(gridView1);
frm.RenderControl(htw);
//GridView1.RenderControl(htw);
Response.Write(sw.ToString());


Ïà¹ØÎĵµ£º

asp.net¼òµ¥ÊµÏÖÒ³Ãæ»»·ô

ʵÏÖÒ³Ãæ»»·ô ¸øhtml form Ìí¼ÓÏàÓ¦µÄÑùʽ ´úÂëÈçÏÂ:
private string _StyleClass;
public string StyleClass
{
get { return _StyleClass; }
set { _StyleClass = value; }
}
private void StyleForm()
{
HtmlForm Form1 = this.FindControl("form1") a ......

asp.net ·µ»ØÉÏÒ»Ò³µÄʵÏÖ·½·¨

·µ»ØÉÏÒ»Ò³µÄÕâ¸ö¶«¶«ÔÚÎÒÃÇ×öÏîÄ¿µÄʱºòÒ»°ãÊÇÓÃÓÚÌîдÍê±íµ¥ºóÈ·ÈϵÄʱºò£¬ÓжÔÔ­À´ÊäÈëµÄÊý¾Ý½øÐÐÐÞ¸Äʱ
Óõ쬻òÕßÊÇÒòÎªÍøÕ¾ÎªÁË·½±ãä¯ÀÀÕß¶øÓÐÐÄÌí¼ÓµÄÒ»¸ö¶«¶«£¬Ò»°ãÕâÖÖ¹¦ÄܵÄʵÏÖÔÚASP.netÖж¼ÊÇÓÃÒ»¸öbuttonµÄ¿Ø¼þÀ´ÊµÏֵģ¬ÊµÏֵķ½·¨ÓкÜ
¶à£¬½ñÌìÇ¡ºÃÔÚ×öÏîĿʱÅöµ½ÒªÓÃÕâ¸ö¶«¶«£¬ÎҾͰÑÄÜʵÏÖ" · ......

ASP.NET¿Ø¼þ¿ª·¢»ù´¡Ö®ÀàÐÍת»»Æ÷dzÎö

ASP.NET¿Ø¼þ¿ª·¢»ù´¡Ö®ÀàÐÍת»»Æ÷1.ÈÏʶĬÈÏÊôÐÔä¯ÀÀÆ÷Ö§³Ö
ÈÃÎÒÃÇÔÙÈÏʶһÏÂÊôÐÔ,´ó¼ÒÖªµÀÿ¸öÊôÐÔ¶¼ÊÇÓÐÀàÐ͵Ä,×îÊìϤ¾ÍÊÇstring,intÕâЩÀàÐÍÁË,VS2005ÊôÐÔä¯ÀÀÆ÷¶ÔÕâЩÊôÐÔÀàÐͽøÐÐÁËʶ±ð,
ÈçÏÂÀý×Ó
(1)table¿Ø¼þµÄHeightÊôÐÔ,µ±ÄãÉèÖÃÊôÐÔΪ×Ö·û´®Ê±,ÔòÌáʾ´íÎóÐÅÏ¢
 
(2)µ±ÊôÐÔÀàÐÍΪColorÊôÐÔʱ,ÊôÐÔä¯ÀÀÆ÷ ......

ASP.NET(ASPX)Ò³Ãæ»ñÈ¡form±íµ¥Ìá½»ÔªËØµÄÖµ


html֪ʶ£¬Request.Form
½ÓÊÕµÄÊÇNameÖµ£¬¶ø·ÇIDÖµ
ÈôÊÇÓÃaspxÒ³ÃæÈ¡Öµ£¬±íµ¥ÖеÄrunat="server"Ҫȥµô¡£
asp.net֪ʶ£¬asp.netµÄ¿Ø¼þµÄIDºÍNameÖµÊÇÒ»ÑùµÚ£¬µ«ÊÇÆäÔÚ¿Í»§¶Ë±íÏÖÊÇcontrol.clientID¶ø·Ç
control.ID
asp.net±¾ÉíÒ²ÊÇ¿ÉÒÔ¿çÒ³Ìá½»µÎ£¬Èç¹ûÊÇʹÓÃ×Ô¼º´øµÄ¿çÒ³Ìá½»¾Í²»´æÔÚÉÏÊöÎÊÌ⣬²»¹ýas ......

asp.net Öиıädatagrid µÄÁпí

private void Page_Load(object sender, System.EventArgs e)
{

DataGrid1.Columns[0].HeaderText = "ÎÄÕ±êÌâ";
DataGrid1.Columns[1].HeaderText = "·¢²¼ÈÕÆÚ";
DataGrid1.Columns[0].HeaderStyle.HorizontalAlign = HorizontalA ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ