C# 编码、时间条件查询导出SQL数据库
主要代码分为5个部分:
1 . 連接數據庫設置comboBox選項
private void Form1_Load(object sender, EventArgs e)
{
textBox5.ReadOnly = true;
textBox6.ReadOnly = true;
dataGridView1.ReadOnly = true;
string connstring = @"Server=;Database=;User id=;Password=";
SqlConnection conn = new SqlConnection(connstring);
conn.Open();
System.Data.DataTable dt = conn.GetSchema("Tables");
List<string> tableNames = dt.Rows.OfType<DataRow>().Select(x => (string)x["Table_Name"]).ToList();
tableNames.Sort();
comboBox1.DataSource = tableNames;
cb_address = comboBox1.SelectedItem.ToString();
conn.Close();
}
2 .導出數據至Excel文件
private void button5_Click(object sender, EventArgs e)
{
ExportToExcel d = new ExportToExcel();
d.OutputAsExcelFile(dataGridView1);
}
3 .連接數據庫
public void sql_database()
{
SqlConnectio