private void btn_SelectData_Click(object sender, EventArgs e) { //---------点击查询前,先清理表格上的数据 grid.Reset(); SelectData(); progressBar1.Value = 0; sqlstr = System.Configuration.ConfigurationManager.AppSettings["R_materialConnString"]; m.Catalog = DealData.RetSubstringBracket(txbList.Text); SqlConnection sqlConn = new SqlConnection(sqlstr); sqlConn.Open(); string selectStr = "select * from tb_Resource where Catalog = ('" + m.Catalog + "')"; SqlCommand sc = new SqlCommand(selectStr, sqlConn); SqlDataReader reader = sc.ExecuteReader(); row = 0; int k = 1; dataload(); progressBar1.Value = 5; while (reader.Read()) { worksheet[row, 0] = false; worksheet[row, 1] = k; //序号 worksheet[row, 2] = reader["Title"]; //显示名称2 worksheet[row, 4] = DealData.SelectString(resultRSORTList, Convert.ToInt32(reader["ResourceStyle"])); //资源类型10 worksheet[row, 5] = txbCe.Text.Split('_')[0] + "_" + txbCe.Text.Split('_')[1]; //教材名称 worksheet[row, 6] = txbList.Text; //教材目录 worksheet[row, 7] = reader["KeyWords"]; //关键字12 worksheet[row, 8] = reader["Description"]; //描述16 int copyright = Convert.ToInt32(reader["Copyright"]); worksheet[row, 11] = banquanMirror[copyright]; worksheet[row, 12] = reader["ResourceClass"]; worksheet[row, 13] = reader["FileID"]; k++; row++; if (progressBar1.Value < 95) { progressBar1.Value += 5; } } for (int i = 1; i < reader.FieldCount; i++) { worksheet.SetColumnsWidth(i, reader.FieldCount, 150); //worksheet.AutoFitColumnWidth(i, true); worksheet.HideColumns(13, 1); } progressBar1.Value = 100; }