把dataSet里的数据拿出来就行了,一般DataGrid都要帮定个DataSet的,数据都保存在DataSet里。
例如:
DataSet ds;
.......
strValue = ds.Table[0].rows[0][i].toString();
例如:
DataSet ds;
.......
strValue = ds.Table[0].rows[0][i].toString();
解决方案 »
- winform中根据ip地位地理位置问题
- 下面的代码怎么实现不了我想要的那个点击datagridview中任意一行,把该行的值对应用textBox显示呢?
- WM_HOTKEY = 0x0312 什么意思 是固定的吗
- 【初学者求教】SQL语句中的单引号和双引号是怎么用的
- GridView动态模板加单元格事件,在触发后数据丢失,求解(模范别人的)
- 怎样知道类占空间的大小?
- 新手用SqlDataAdapter的Update方法更新数据库出错,烦死了!
- 有关volatile说明的一段代码的例子!
- 有无版权问题呢????
- 十万火急求救水晶报表问题,高分相送!!!
- 请问怎么把子窗口写在一个dll中?
- 请问 如何修改button的背景色?急
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
BindGrid();
}
}private void BindGrid(){ string sql_str="select * from repair_now ";
MyDataGrid.DataSource =Getdb.Get_Select_Table(sql_str); //返回一个datatable
MyDataGrid.DataBind(); //导入Excel表时,先求数量
string sql_count="select count(*) from repair_now ";
string temp=Public_Class.Judge_Repeat(sql_count);
ViewState["count"]=temp;} private string Table_Name()
{
string tn="To_Excel";
return tn;
}
private void ToExcel(System.Web.UI.Control ctl,string Table_Name)
{
HttpContext.Current.Response.AppendHeader("Content- Disposition","attachment;filename="+""+Table_Name+".xls");
HttpContext.Current.Response.Charset ="gb-2312";
HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.Default ;
HttpContext.Current.Response.ContentType ="application/ms-excel/ms- word";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword
ctl.Page.EnableViewState =true;
System.IO.StringWriter tw = new System.IO.StringWriter() ;
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter (tw);
ctl.RenderControl(hw);
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
} private void Button_Excel_Click(object sender, System.Web.UI.ImageClickEventArgs e)//倒入Excel按钮事件
{
MyDataGrid.PageSize=Convert.ToInt32(ViewState["count"].ToString());
BindGrid();
MyDataGrid.PagerStyle.Visible =false;
ToExcel(MyDataGrid,Table_Name());
}
楼主只要知道方法就行了
Response.ContentType = "appication/vnd.ms-excel";
Response.AppendHeader("Content-Disposition","attachment;filename=CompletedServiceList.xls");
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw); this.DataGrdSum.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();