private void 数据导出ToolStripMenuItem_Click(object sender, EventArgs e) { ////定义sql连接 //SqlConnectionStringBuilder sqlconStringBuilder = new SqlConnectionStringBuilder(); ////sql连接字串 //sqlconStringBuilder.ConnectionString = @"Data Source=(local);Initial Catalog=DBAS;Integrated Security=True"; ////定义语句计算选定sheet中数据的行数 string strSql = string.Format("select name from sys.tables"); //using (SqlConnection conn = new SqlConnection(sqlconStringBuilder.ConnectionString)) //{ //} SqlDataReader reader = null; List <string> list = new List <string>(); try { //conn.Open(); SqlCommand sqlCommand = new SqlCommand(strSql, conn as SqlConnection);//执行查询,返回查询结果 reader = sqlCommand.ExecuteReader(); while (reader.Read()) { list.Add(reader.GetString(0)); } //MessageBox.Show(list.LongCount().ToString()); download d = new download(list); d.Show(); //conn.Close(); reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } ////定义sql连接 //SqlConnectionStringBuilder sqlconStringBuilder = new SqlConnectionStringBuilder(); ////sql连接字串 //sqlconStringBuilder.ConnectionString = @"Data Source=(local);Initial Catalog=DBAS;Integrated Security=True"; ////定义语句计算选定sheet中数据的行数 //string strSql = string.Format("select name from sys.tables"); //using (SqlConnection conn = new SqlConnection(sqlconStringBuilder.ConnectionString)) //{ // SqlDataReader reader = null; // List<string> list = new List<string>(); // try // { // conn.Open(); // SqlCommand sqlCommand = new SqlCommand(strSql, conn);//执行查询,返回查询结果 // reader = sqlCommand.ExecuteReader(); // while (reader.Read()) // { // list.Add(reader.GetString(0)); // } // //MessageBox.Show(list.LongCount().ToString()); // d = new download(list); // d.Show(); // conn.Close(); // reader.Close(); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} }
private void button1_Click(object sender, EventArgs e) { download DL = new download(); DL.Show(); }