private void DataGridViewBindData(string tableName)
{
DataSet ds = DataBaseOperate.GetLogInfo(tableName);
if (ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 0)
{
this.dataGridView_AnalyzeResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
else
{
this.dataGridView_AnalyzeResult.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
System.Data.DataTable table = new DataTable();
System.Data.DataColumn column = new DataColumn();
column.ColumnName = "序号";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
table.Columns.Add(column);
table.Merge(ds.Tables[0]);
this.dataGridView_AnalyzeResult.DataSource = table;
this.dataGridView_AnalyzeResult.Refresh();
}
private void button_DeriviveToExcel_Click(object sender, EventArgs e)
{
//获取数据
DataTable dataTable = null;
string tableName = "LogInfo";
DataSet dataSet = DataBaseOperate.GetLogInfo(tableName);
if (dataSet != null && dataSet.Tables.Count > 0)
{
dataTable = dataSet.Tables[tableName];
}
CommFuction.DataGridViewToExcel(dataTable);
}