本文實例講述了C#窗體讀取EXCEL并存入SQL數據庫的方法。分享給大家供大家參考。具體實現方法如下：
windows窗體上放了一個Textbox1,2個按鈕button1和button2~按button1選擇excel文件~按button2進行相關處理
復制代碼代碼如下:
private void button1_click(object sendeer,EventArgs e)
{
OpenFileDialog openFiledialog1=new OpenFileDialog();
openFileDialg1.filter="Excel文件|*.xls";
openFileDialg1.ShowDialog();
textBox1.Text=openFileDialog1.FileName;
}
{
OpenFileDialog openFiledialog1=new OpenFileDialog();
openFileDialg1.filter="Excel文件|*.xls";
openFileDialg1.ShowDialog();
textBox1.Text=openFileDialog1.FileName;
}
private void button2_click(object sender, EventArg e)
{
DataSet dt=ReadExcel(textBox1.Text);
//然后進行您需要的數據處理
}
希望本文所述對大家的C#程序設計有所幫助。
