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();
}
