asp.net µ¼³öExcel
public bool SaveExcel(GridView paramGridView)
{
if (paramGridView.Rows.Count == 0)
{
return false;
}
//´´½¨Excel¶ÔÏó
Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
myExcel.Application.Workbooks.Add(true);
myExcel.Visible = true;
//Éú³É×Ö¶ÎÃû³ÆÁÐÃû
for (int i = 0; i < paramGridView.Columns.Count; i++)
{
//µÚ¶þÐеڶþÁпªÊ¼Â¼Èë
myExcel.Cells[2, i + 2] = paramGridView.Columns[i].HeaderText;
}
//Ìî³äÊý¾Ý
for (int i = 0; i < paramGridView.Rows.Count; i++)
{
for (int j = 0; j < paramGridView.Columns.Count; j++)
{
if (paramGridView.Rows[i].Cells[j].Text != null)
{
myExcel.Cells[i + 3, j + 2] = "'" + paramGridView.Rows[i].Cells[j].Text.ToString();
}
}
}
return true;
}
protected void btnPrint_Click(object sender, EventArgs e)
{
SaveExcel(grdvMessage);
}
Ïà¹ØÎĵµ£º
**//// <summary>
x _0O%f+K)B5D /// Ö§³Ö¶ÏµãÐø´«µÄÏÂÔØ´óÎļþµÄº¯Êý Öв©IT½ÌÓýÍø4P z\2b,h-q `
/// </summary>
_;B$A.} S8E#@ D I /// <param name="downloadFil ......
using System.Security.Cryptography;
using System.IO;
using System.text;
/// <summary>
/// ¼ÓÃÜ
/// </summary>
/// <param name="str"> ......
ÔÚÔçÆÚµÄASP.NET¿ò¼ÜÖУ¬Èç¹ûÄã·ÅÖÃÒ»¸ö¿Ø¼þÔÚÒ»¸öÈÝÆ÷ÖУ¬ÈçGridViewÄ£°åÁС¢µÇ¼ģ°å¡¢ÆäËü£¬ÔÚÔËÐÐʱÕâЩ¿Ø¼þµÄID½«±»Ìæ»»ÓÉASP.NET×ÔÉí²úÉúµÄËæ»úΨһID¡£
Ϊ¿ª·¢ÕßÌṩ·þÎñ·½·ÃÎʿؼþµÄPage.FindControl("controlid")ÒÔ¼°JavaScriptÖÐʹÓà µÄdocument ......
Accordion¿Ø¼þʱµÄ³£ÓÃÊôÐÔ±êÇ©
ÊôÐÔ±êÇ©Ãû Ãè¡¡¡¡Êö
SelectedIndex ¸Ã¿Ø¼þ³õ´Î¼ÓÔØÊ±Õ¹¿ªµÄAccordionPaneÃæ°åµÄË÷ÒýÖµ
HeaderCssClass ¸ÃAccordionÖаüº¬µÄËùÓÐAccordionPaneÃæ°åµÄ±êÌâÇøÓòËùÓ¦ÓõÄCSS Class
ContentCssClass ¸ÃAccordionÖаüº¬µÄËùÓÐAccordionPaneÃæ°åµÄÄÚÈÝÇøÓòËùÓ¦ÓõÄCSS Class
AutoSize Ô ......
ÔÚasp.net ʹÓÃÊý¾Ý¼¯Éè¼ÆÆ÷ ·ÃÎÊÊý¾ÝÖÐ˵¹ý£¬ÒªÊ¹Insert,Update,Delete²éѯ¿ÉÓ㬱ØÐëɾ³ýObjectDataSource¶ÔÏó
ÊôÐÔDataObjectTypeNameµÄÖµ¡£ÏÂÃæÒªËµµÄÊÇ£¬ÔÚ²»É¾³ý¸ÃÖµÏÂʹ²éѯ¿ÉÓõķ½·¨¡££¨ÓÉÓÚ֮ǰÔÚɾ³ý
DataObjectTypeNameºóInsert,Update,Delete²éѯһֱµ÷ÊÔ²»³É¹¦£¬ÓÚÊǵ®ÉúÁËÈçÏÂʹÓ÷½·¨¡££©
Óëasp.net Ê¹Ó ......