会不会都问问 -
关注数: 14 粉丝数: 18 发帖数: 464 关注贴吧数: 9
菜鸟级问题憋了3天 namespace WindowsFormsApplication1 { public partial class Form1 : Form { string path = string.Empty; //获取数据库连接字符串 private readonly string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString(); //链接SQL数据库 public Form1() { InitializeComponent(); } //浏览路径按钮 private void button1_Click(object sender, EventArgs e) { OpenFileDialog flog = new OpenFileDialog(); DialogResult result = flog.ShowDialog(); if (result == DialogResult.OK) { path = flog.FileName; txtEntry.Text = path; } } public DataSet ExecleDs(string filenameurl) { string strConn = "Provider=Microsoft.JET.Oledb.4.0;Data Source=" + filenameurl + ";Extended Properties='Excel 8.0;HDR=NO; IMEX=1'"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); DataSet ds = new DataSet(); OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn); odda.Fill(ds); return ds; } //录入按钮 private void button2_Click(object sender, EventArgs e) { if (txtEntry.Text == "") { MessageBox.Show("请选择要导入的Excel文件!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtEntry.Text = ""; return; } string IsXls = System.IO.Path.GetExtension(path).ToString().ToLower();//System.IO.Path.GetExtension获得文件的扩展名 if (IsXls != ".xls") { MessageBox.Show("只可以选择Excel文件!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtEntry.Text = ""; return;//当选择的不是Excel文件时,返回 } SqlConnection cn = new SqlConnection(strConn); cn.Open(); string savePath = path; //SaveAs 将上传的文件内容保存在服务器上 DataSet ds = ExecleDs(savePath); //调用自定义方法 DataRow[] dr = ds.Tables[0].Select(); //定义一个DataRow数组 int rowsnum = ds.Tables[0].Rows.Count; if (rowsnum == 0) { MessageBox.Show("Excel表为空表,无数据!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } //显示数据 dataGridView1.DataSource = ds.Tables[0]; } //插入数据 private void button3_Click(object sender, EventArgs e) { } } } 问下点击按钮3 插入Excel数据到SQL Server数据库 怎么实现 现在Excel表内容点击按钮二显示出来了 学了一个星期C#的菜鸟求指教
1 下一页