本文整理汇总了C#中GridView.RenderControl方法的典型用法代码示例。如果您正苦于以下问题:C# GridView.RenderControl方法的具体用法?C# GridView.RenderControl怎么用?C# GridView.RenderControl使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类GridView
的用法示例。
在下文中一共展示了GridView.RenderControl方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: OutputExcel
/// <summary>
/// 輸出為Excel
/// </summary>
/// <param name="webpage">傳入目前網頁Page變數</param>
/// <param name="Dt">需要匯出的內容</param>
/// <param name="FilePath">輸出的檔名</param>
public void OutputExcel(Page webpage,
DataTable Dt,
string FilePath
)
{
GridView gvExport = new GridView();
gvExport.DataSource = Dt;
gvExport.DataBind();
string UTF8FileName = HttpUtility.UrlEncode(FilePath,
System.Text.Encoding.UTF8
);
webpage.Response.Clear();
webpage.Response.AddHeader("content-disposition",
string.Format("attachment;filename={0}",
UTF8FileName)
);
webpage.Response.Cache.SetCacheability(HttpCacheability.NoCache);
webpage.Response.ContentType = "application/vnd.ms-excel";
webpage.Response.Charset = "big5";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gvExport.RenderControl(htmlWrite);
webpage.Response.Write(stringWrite.ToString().Replace("<div>", "").Replace("</div>", ""));
webpage.Response.End();
}
示例2: ExportGridToExcel
private void ExportGridToExcel(GridView grid, string filename)
{
if (string.IsNullOrEmpty(filename))
throw new ArgumentException(
"Export filename is required");
if (!filename.EndsWith(".xls"))
filename += ".xls";
grid.AllowPaging = false;
grid.AllowSorting = false;
grid.DataBind();
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader(
"content-disposition",
"attachment;filename=" + filename);
Response.Charset = string.Empty;
Page.EnableViewState = false;
grid.RenderControl(hw);
Response.Write(
"<html xmlns:x=\"urn:schemas-microsoft-com:" +
"office:excel\" >");
Response.Write(GetExcelStyle(grid));
Response.Write(tw.ToString());
Response.End();
}
示例3: ExportExcel
public void ExportExcel(DataTable dt, string title, string from_time, string to_time, string User)
{
GridView GridView8 = new GridView();
GridView8.AllowPaging = false;
DataTable dt_Header = new DataTable();
dt_Header.Columns.Add("Thong_Tin", typeof(string));
dt_Header.Rows.Add("");
dt_Header.Rows.Add("" + title);
dt_Header.Rows.Add("");
dt_Header.Rows.Add("User: " + User);
dt_Header.Rows.Add("");
dt_Header.Rows.Add("Tu ngay: " + from_time);
dt_Header.Rows.Add("Den ngay: " + to_time);
dt_Header.Rows.Add("");
GridView GridView7 = new GridView();
GridView7.AllowPaging = false;
GridView7.DataSource = dt_Header;
GridView7.BorderStyle = BorderStyle.None;
GridView7.DataBind();
//Add row if no data found
//if (dt.Rows.Count <= 0)
//{
// int num_col = dt.Columns.Count;
// dt.Rows.Add();
//}
GridView8.DataSource = dt;
GridView8.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + User + "_Report.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView7.Rows.Count; i++)
{
//Apply text style to each Row
GridView7.Rows[i].Attributes.Add("class", "textmode");
}
GridView7.RenderControl(hw);
for (int i = 0; i < GridView8.Rows.Count; i++)
{
//Apply text style to each Row
GridView8.Rows[i].Attributes.Add("class", "textmode");
}
GridView8.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
示例4: ExportExcel
public void ExportExcel(DataTable dt, string title, string to_time, string User)
{
GridView GridView = new GridView();
GridView.AllowPaging = false;
DataTable dt_Header = new DataTable();
dt_Header.Columns.Add("Thong_Tin", typeof(string));
dt_Header.Rows.Add("");
dt_Header.Rows.Add("");
dt_Header.Rows.Add("" + title);
dt_Header.Rows.Add("");
dt_Header.Rows.Add("User: " + User);
dt_Header.Rows.Add("");
dt_Header.Rows.Add("Thoi gian: " + to_time);
dt_Header.Rows.Add("");
dt_Header.Rows.Add("");
GridView GridView7 = new GridView();
GridView7.AllowPaging = false;
GridView7.DataSource = dt_Header;
GridView7.DataBind();
GridView.DataSource = dt;
GridView.DataBind();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + User + "_Report.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView7.Rows.Count; i++)
{
GridView7.Rows[i].Attributes.Add("class", "textmode");
}
GridView7.RenderControl(hw);
for (int i = 0; i < GridView.Rows.Count; i++)
{
GridView.Rows[i].Attributes.Add("class", "textmode");
}
GridView.RenderControl(hw);
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
示例5: ExportExcel
public void ExportExcel(GridView gv,string FileName,Page pp )
{
//GridView gv = (GridView)Page.Form.FindControl(gvc.Replace('_', '$')); //gvResult
pp.Response.Clear();
pp.Response.Buffer = true;
pp.Response.AddHeader("content-disposition", "attachment;filename=" + FileName + ".xls");
pp.Response.Charset = "";
pp.Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gv.AllowPaging = false;
//gv.DataBind();
//Change the Header Row back to white color
gv.HeaderRow.Style.Add("background-color", "green");
//Apply style to Individual Cells
/*gv.HeaderRow.Cells[0].Style.Add("background-color", "green");
gv.HeaderRow.Cells[1].Style.Add("background-color", "green");
gv.HeaderRow.Cells[2].Style.Add("background-color", "green");
gv.HeaderRow.Cells[3].Style.Add("background-color", "green");
*/
/*for (int i = 0; i <= gv.Rows.Count-1; i++)
{
GridViewRow row = gv.Rows[i];
//Change Color back to white
row.BackColor = System.Drawing.Color.White;
//Apply text style to each Row
row.Attributes.Add("class", "textmode");
//Apply style to Individual Cells of Alternating Row
if (i % 2 != 0)
{
row.Cells[0].Style.Add("background-color", "#C2D69B");
row.Cells[1].Style.Add("background-color", "#C2D69B");
row.Cells[2].Style.Add("background-color", "#C2D69B");
row.Cells[3].Style.Add("background-color", "#C2D69B");
}
}*/
gv.RenderControl(hw);
//style to format numbers to string
//string style = @"<style> .textmode { mso-number-format:\@; } </style>";
//Response.Write(style);
pp.Response.Output.Write(sw.ToString());
pp.Response.Flush();
pp.Response.End();
}
示例6: ExportDataToExcel
/// <summary>
/// Returns string for a Given Dataset Values
/// </summary>
/// <param name="ds"></param>
/// <param name="exportColumnHeadings"></param>
public void ExportDataToExcel(string strFileName, GridView gridViewControl)
{
Response.Clear();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + strFileName);
// Set as Excel as the primary format
Response.AddHeader("Content-Type", "application/Excel");
Response.ContentType = "application/Excel";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridViewControl.RenderControl(htw);
Response.Write(sw.ToString());
//
gridViewControl.Dispose();
Response.End();
}
示例7: GridOutExcel
public static void GridOutExcel(GridView gvTable, object data, Page page, string Outname)
{
try
{
page.Response.ClearContent();
//page.Response.Charset = "GB2312";
page.Response.AddHeader("content-disposition", "attachment; filename=" + page.Server.UrlEncode(Outname) + ".xls");
page.Response.ContentType = "application/excel";
//page.Response.ContentEncoding = System.Text.Encoding.UTF7;
GridView oView = new GridView();
foreach (DataControlField field in gvTable.Columns)
{
oView.Columns.Add(field);
}
if (page.GetType().GetMethod(gvTable.ID + "_RowCreated", BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance) != null)
oView.RowCreated += delegate(object sender, GridViewRowEventArgs e)
{
page.GetType().GetMethod(gvTable.ID + "_RowCreated", BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance).Invoke(page, new object[] { sender, e });
};
if (page.GetType().GetMethod(gvTable.ID + "_RowDataBound", BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance) != null)
oView.RowDataBound += delegate(object sender, GridViewRowEventArgs e)
{
page.GetType().GetMethod(gvTable.ID + "_RowDataBound", BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance).Invoke(page, new object[] { sender, e });
};
oView.AutoGenerateColumns = false;
oView.DataSource = data;
oView.DataBind();
for (int i = oView.Columns.Count - 1; i >= 0; i--)
{
if (oView.Columns[i].HeaderText == "")
oView.Columns[i].Visible = false;
}
StringWriter o_sw = new StringWriter();
HtmlTextWriter o_htw = new HtmlTextWriter(o_sw);
oView.RenderControl(o_htw);
page.Response.Write(o_sw.ToString());
page.Response.End();
}
catch (Exception ex)
{ }
}
示例8: GetDynamicContent
public static string GetDynamicContent(string contextKey)
{
SqlConnection conn;
SqlCommand cmd;
string cmdString = "Select * from Customers";
switch (contextKey)
{
case ("1"):
cmdString = "Select * from Employees";
break;
case ("2"):
cmdString = "Select * from Products";
break;
}
conn = new
SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;User Instance=True");
cmd = new SqlCommand(cmdString, conn);
conn.Open();
SqlDataReader myReader;
myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataTable dt = new DataTable();
dt.Load(myReader);
myReader.Close();
GridView myGrid = new GridView();
myGrid.ID = "GridView1";
myGrid.DataSource = dt;
myGrid.DataBind();
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
myGrid.RenderControl(htw);
htw.Close();
return sw.ToString();
}
示例9: ExcelOut
public void ExcelOut(GridView gv)
{
if (gv.Rows.Count > 0)
{
Response.Clear();
Response.ClearContent();
Response.AddHeader("Content-Disposition", "attachment; filename=" + DateTime.Now.ToString("_yyyyMMdd_HHmmss") + ".xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();
}
else
{
Response.Write("没有数据");
}
}
示例10: OutExcel
public void OutExcel(DataTable dt, Page page)
{
GridView gv = new GridView();
page.Response.Clear();
page.Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">");
page.Response.AddHeader("content-disposition", "attachment;filename=StudentMarks.xls");
page.Response.Charset = "GB2312";
page.Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gv.AllowPaging = false;
gv.AllowSorting = false;
gv.AutoGenerateDeleteButton = false;
gv.AutoGenerateEditButton = false;
gv.AutoGenerateSelectButton = false;
gv.ShowFooter = false;
gv.DataSource = dt;
gv.DataBind();
gv.RenderControl(htmlWrite);
page.Response.Write(stringWrite.ToString());
page.Response.End();
}
示例11: DataTable1Excel
/// </summary>
/// 导出Excel文件,自动返回可下载的文件流
/// </summary>
public static void DataTable1Excel(System.Data.DataTable dtData)
{
GridView gvExport = null;
HttpContext curContext = HttpContext.Current;
StringWriter strWriter = null;
HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "utf-8";
strWriter = new StringWriter();
htmlWriter = new HtmlTextWriter(strWriter);
gvExport = new GridView();
gvExport.DataSource = dtData.DefaultView;
gvExport.AllowPaging = false;
gvExport.DataBind();
gvExport.RenderControl(htmlWriter);
curContext.Response.Write("<meta http-equiv=\"Content-Type\" content=\"text/html;charset=gb2312\"/>" + strWriter.ToString());
curContext.Response.End();
}
}
示例12: OrderExcelBack
/// <summary>
/// Excel表格导出
/// </summary>
/// <param name="dataTable">要导出的数据源</param>
/// <param name="fileName">导出文件的文件名</param>
public void OrderExcelBack(DataTable dataTable, string fileName)
{
GridView gvExport = new GridView();
//当前对话
HttpContext curContext = HttpContext.Current;
//IO用于导出并返回excel文件
StringWriter strWriter = new StringWriter();
HtmlTextWriter htmlWriter = new HtmlTextWriter(strWriter);
if (dataTable != null)
{
curContext.Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8) + ".xls");
curContext.Response.ContentType = "application/vnd.ms-excel";// "application/x-xls";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
curContext.Response.Charset = "GB2312";
//为了解决dataTable中可能进行了分页的情况,需要重新定义一个无分页的GridView
gvExport.DataSource = dataTable.DefaultView;
gvExport.AllowPaging = false;
gvExport.DataBind();
//下载到客户端
gvExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
示例13: ExportExcel
public static void ExportExcel(GridView iGridView1, String filrName)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + filrName + "_" + DateTime.Now.ToString("yyyyMMddHH") + ".xls");
//HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
iGridView1.RenderControl(htmlWrite);
//Appendg CSS file
FileInfo fi = new FileInfo(HttpContext.Current.Server.MapPath("~/styles/SiteMaster.css"));
System.Text.StringBuilder sb = new System.Text.StringBuilder();
StreamReader sr = fi.OpenText();
while (sr.Peek() >= 0)
{
sb.Append(sr.ReadLine());
}
sr.Close();
HttpContext.Current.Response.Write("<html><head><style type='text/css'>" + sb.ToString() + "</style><head>" + stringWrite.ToString() + "</html>");
//HttpContext.Current.Response.Write(stringWrite.ToString());
HttpContext.Current.Response.End();
}
示例14: ExportToPDF
public static void ExportToPDF(string fileName, GridView GridView1, bool includeGridLines, DataTable dt, string title)
{
try
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = String.Empty;
HttpContext.Current.Response.ContentType = "application/pdf";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename='" + fileName + "'");
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.DataSource = dt;
GridView1.DataBind();
GridView1.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
iTextSharp.text.Document pdfDoc = new iTextSharp.text.Document(PageSize.A2, 7f, 7f, 7f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, HttpContext.Current.Response.OutputStream);
pdfDoc.Open();
Chunk c = new Chunk(title + "\n\n", FontFactory.GetFont("Verdana", 15));
Paragraph p = new Paragraph();
p.Alignment = Element.ALIGN_CENTER;
p.Add(c);
pdfDoc.Add(p);
htmlparser.Parse(sr);
pdfDoc.Close();
HttpContext.Current.Response.Write(pdfDoc);
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
throw ex;
}
}
示例15: renderGrid
private void renderGrid(GridView gridView1)
{
using (StringWriter StringWriter1 = new StringWriter())
{
HtmlTextWriter htw1 = new HtmlTextWriter(StringWriter1);
gridView1.RenderControl(htw1);
htw1.Flush();
result = StringWriter1.ToString();
}
}