请教winform中导出和批量删除！

zorro75317 2008-12-05 05:30:18

这个界面要实现导出和批量删除！

...全文

117 20 打赏收藏转发到动态举报

写回复

用AI写文章

20 条回复

切换为时间正序

请发表友善的回复…

发表回复

HDNGO 2008-12-05

打赏
举报

[Quote=引用 18 楼 zorro75317 的回复:]
C# code
protected void AddExcel(DataSet ds)
{
DataTable dt = ds.Tables[0];

string fileName = Guid.NewGuid() + ".xls";
[/Quote]

嗯，这个比较简单，记得加office和excel的引用~

HDNGO 2008-12-05

打赏
举报

哪些需要导出也可以用for循环判断一下checkbox的状态。。。

zorro75317 2008-12-05

打赏
举报



protected void AddExcel(DataSet ds) 

{ 

DataTable dt = ds.Tables[0]; 



string fileName = Guid.NewGuid() + ".xls"; 



Excel.Application excel = new Excel.ApplicationClass(); 



int rowIndex = 1; 

int colIndex = 0; 



excel.Application.Workbooks.Add(true); 



foreach (DataColumn col in dt.Columns) 

{ 

colIndex++; 

excel.Cells[1, colIndex] = col.ColumnName; 

} 



foreach (DataRow row in dt.Rows) 

{ 

rowIndex++; 

colIndex = 0; 

for (colIndex = 0; colIndex < dt.Columns.Count; colIndex++) 

{ 

excel.Cells[rowIndex, colIndex + 1] = row[colIndex].ToString(); 

} 

} 



excel.Visible = false; 

excel.ActiveWorkbook.SaveAs(fileName, Excel.XlFileFormat.xlExcel9795, null, null, false, false, Excel.XlSaveAsAccessMode.xlNoChange, null, null, null, null, null); 

//excel.Save(fileName); 



excel.Quit(); 

excel = null; 



GC.Collect();//垃圾回收 

}

是这一段吗？

HDNGO 2008-12-05

打赏
举报

删除的话。。判断checkbox是不是true就成了吧~



for (int i = 0; i < dgv.Rows.Count; i++)

            {

                if (dgv.Rows[i].Cells[0].Value != null && (bool)dgv.Rows[i].Cells[0].Value == true)

                {

                    //删除代码                

                }

            }

zorro75317 2008-12-05

打赏
举报

是导成excel
之前只做过web的，窗体的不会啊

HDNGO 2008-12-05

打赏
举报

导出到excel的话。。。
http://www.cnblogs.com/zyh-nhy/archive/2007/06/06/773624.html

zorro75317 2008-12-05

打赏
举报

jishengzu 2008-12-05

打赏
举报

这贴怎么就我们3人我刚去了下赌场出来后就变成乞丐了在这里提醒大家不要赌钱，黑心庄家太多了

HDNGO 2008-12-05

打赏
举报

导出excel？

zorro75317 2008-12-05

打赏
举报

我太笨了,再传一遍

HDNGO 2008-12-05

打赏
举报

表头画个全选的checkbox~

    class DGVColumnHeader : DataGridViewColumnHeaderCell

    {

        private Rectangle CheckBoxRegion;

        private bool checkAll = false;



        protected override void Paint(Graphics graphics,

            Rectangle clipBounds, Rectangle cellBounds, int rowIndex,

            DataGridViewElementStates dataGridViewElementState,

            object value, object formattedValue, string errorText,

            DataGridViewCellStyle cellStyle, DataGridViewAdvancedBorderStyle advancedBorderStyle,

            DataGridViewPaintParts paintParts)

        {



            base.Paint(graphics, clipBounds, cellBounds, rowIndex, dataGridViewElementState, value,

                formattedValue, errorText, cellStyle, advancedBorderStyle, paintParts);



            graphics.FillRectangle(new SolidBrush(cellStyle.BackColor), cellBounds);



            CheckBoxRegion = new Rectangle(

                cellBounds.Location.X + 3,

                cellBounds.Location.Y + 2,

                25, cellBounds.Size.Height - 4);





            if (this.checkAll)

                ControlPaint.DrawCheckBox(graphics, CheckBoxRegion, ButtonState.Checked);

            else

                ControlPaint.DrawCheckBox(graphics, CheckBoxRegion, ButtonState.Normal);



            Rectangle normalRegion =

                new Rectangle(

                cellBounds.Location.X + 1 + 25,

                cellBounds.Location.Y,

                cellBounds.Size.Width - 26,

                cellBounds.Size.Height);



            graphics.DrawString(value.ToString(), cellStyle.Font, new SolidBrush(cellStyle.ForeColor), normalRegion);

        }



        protected override void OnMouseClick(DataGridViewCellMouseEventArgs e)

        {

            //Convert the CheckBoxRegion 

            Rectangle rec = new Rectangle(new Point(0, 0), this.CheckBoxRegion.Size);

            this.checkAll = !this.checkAll;

            if (rec.Contains(e.Location))

            {

                this.DataGridView.Invalidate();

            }

            base.OnMouseClick(e);

        }



        public bool CheckAll

        {

            get { return this.checkAll; }

            set { this.checkAll = value; }

        }

    }