使用C#从网格视图Controll将文件保存在sql server 2005中 [英] save file in sql server 2005 from grid view controll using c#

问题描述

嗨 我正在做一个项目，我想选择一个Excel文件并在网格视图中显示记录，而不是

我必须将该文件保存在sql server 2005数据库名称"pension"中

检索文件并在网格视图控件中显示的代码如下:

private void button3_Click(object sender, EventArgs e)
        {
            DialogResult dr = this.openFileDialog1.ShowDialog();
            if (dr == System.Windows.Forms.DialogResult.OK)
            {
                string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data 
                                                        Source={0};Extended Properties=""Excel 
                                           8.0;HDR=YES;IMEX=1;""", openFileDialog1.FileName);
                string query = String.Format("select * from [{0}$]", "Sheet1");
                OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
                DataSet dataSet = new DataSet();
                dataAdapter.Fill(dataSet);
                dataGridView1.DataSource = dataSet.Tables[0];
            }
        }

这工作正常，现在我想保存在数据库中

private void button2_Click(object sender, EventArgs e)
        {
           DataSet ds = new DataSet();
           SqlConnection cs = new SqlConnection("Data Source=admn\\SQLEXPRESS;Initial             

                                Catalog=DB;Integrated Security=True");
               SqlDataAdapter da = new SqlDataAdapter();

            da.InsertCommand = new SqlCommand("INSERT INTO Pension                          

VALUES(@ID,@Experience,@pension)", cs);
           
            cs.Open();
            da.InsertCommand.ExecuteNonQuery();
            MessageBox.Show("Your value has been added");            
            cs.Close();
        }

在cs.open之前写什么代码，可以有人帮我吗

解决方案

，" Sheet1)； OleDbDataAdapter dataAdapter =新的OleDbDataAdapter(query，connectionString); DataSet dataSet =新的DataSet(); dataAdapter.Fill(dataSet); dataGridView1.DataSource = dataSet.Tables [0]; } }

这工作正常，现在我想保存在数据库中

private void button2_Click(object sender, EventArgs e)
        {
           DataSet ds = new DataSet();
           SqlConnection cs = new SqlConnection("Data Source=admn\\SQLEXPRESS;Initial             

                                Catalog=DB;Integrated Security=True");
               SqlDataAdapter da = new SqlDataAdapter();

            da.InsertCommand = new SqlCommand("INSERT INTO Pension                          

VALUES(@ID,@Experience,@pension)", cs);
           
            cs.Open();
            da.InsertCommand.ExecuteNonQuery();
            MessageBox.Show("Your value has been added");            
            cs.Close();
        }

在cs.open之前写什么代码，谁能帮我

看看 da.InsertCommand.Parameters.添加(" ，SqlDbType. VarChar ).值= textbox1.文本;

hi i am working on a project, i want to pick up an excel file and display record in grid view, than

i have to save that file in sql server 2005 database name ''pension''

code to reterieve file and display in grid view controll is as follows:

private void button3_Click(object sender, EventArgs e)
        {
            DialogResult dr = this.openFileDialog1.ShowDialog();
            if (dr == System.Windows.Forms.DialogResult.OK)
            {
                string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data 
                                                        Source={0};Extended Properties=""Excel 
                                           8.0;HDR=YES;IMEX=1;""", openFileDialog1.FileName);
                string query = String.Format("select * from [{0}$]", "Sheet1");
                OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
                DataSet dataSet = new DataSet();
                dataAdapter.Fill(dataSet);
                dataGridView1.DataSource = dataSet.Tables[0];
            }
        }

this is working fine , now i want to save in database

private void button2_Click(object sender, EventArgs e)
        {
           DataSet ds = new DataSet();
           SqlConnection cs = new SqlConnection("Data Source=admn\\SQLEXPRESS;Initial             

                                Catalog=DB;Integrated Security=True");
               SqlDataAdapter da = new SqlDataAdapter();

            da.InsertCommand = new SqlCommand("INSERT INTO Pension                          

VALUES(@ID,@Experience,@pension)", cs);
           
            cs.Open();
            da.InsertCommand.ExecuteNonQuery();
            MessageBox.Show("Your value has been added");            
            cs.Close();
        }

what to write code before cs.open, can any one help me out

解决方案

", "Sheet1"); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); dataGridView1.DataSource = dataSet.Tables[0]; } }

this is working fine , now i want to save in database

private void button2_Click(object sender, EventArgs e)
        {
           DataSet ds = new DataSet();
           SqlConnection cs = new SqlConnection("Data Source=admn\\SQLEXPRESS;Initial             

                                Catalog=DB;Integrated Security=True");
               SqlDataAdapter da = new SqlDataAdapter();

            da.InsertCommand = new SqlCommand("INSERT INTO Pension                          

VALUES(@ID,@Experience,@pension)", cs);
           
            cs.Open();
            da.InsertCommand.ExecuteNonQuery();
            MessageBox.Show("Your value has been added");            
            cs.Close();
        }

what to write code before cs.open, can any one help me out

Look at the DbDataAdapter.Update Method (DataSet)[^]

specifically ths is a code to enter only one value, what will be the code to enter number of fields and number of records

da.InsertCommand.Parameters.Add("@Login", SqlDbType.VarChar).Value = textbox1.Text;

这篇关于使用C#从网格视图Controll将文件保存在sql server 2005中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！