使用C#从网格视图Controll将文件保存在sql server 2005中 [英] save file in sql server 2005 from grid view controll using c#
本文介绍了使用C#从网格视图Controll将文件保存在sql server 2005中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我必须将该文件保存在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屋!
查看全文