将EXCEL中的数据读出来,能用GridView显示。但是怎么往数据库中写呢??INSERT语句怎么写??
这是BUTTON控件中的的代码
string fullfilename = FileUpload1.PostedFile.FileName.ToString(); string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + fullfilename + "';Extended Properties=Excel 8.0"; OleDbConnection cnnxls = new OleDbConnection(mystring); OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls); DataSet myDs = new DataSet(); myDa.Fill(myDs); GridView1.DataSource = myDs.Tables[0]; GridView1.DataBind();//到这里都能实现
SqlConnection con = DB.createDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = "insert into excel(UserName, UserPwd) values('" + myDs.Tables[0] + "','" + myDs.Tables[0] + "')";
cmd.ExecuteNonQuery();
con.Close();
cnnxls.Close();
这是BUTTON控件中的的代码
string fullfilename = FileUpload1.PostedFile.FileName.ToString(); string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + fullfilename + "';Extended Properties=Excel 8.0"; OleDbConnection cnnxls = new OleDbConnection(mystring); OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls); DataSet myDs = new DataSet(); myDa.Fill(myDs); GridView1.DataSource = myDs.Tables[0]; GridView1.DataBind();//到这里都能实现
SqlConnection con = DB.createDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = "insert into excel(UserName, UserPwd) values('" + myDs.Tables[0] + "','" + myDs.Tables[0] + "')";
cmd.ExecuteNonQuery();
con.Close();
cnnxls.Close();
解决方案 »
- 加上runat="server"后的问题...
- 请问下java里面Struts + Spring + Hibernate 对应.net里面的什么?
- xml中的数据怎么在html文件中显示出来,还有数据库中数据怎么读到xml文件中
- vs2008中如何获取DropdownList选中的文本值?
- 未将对象引用设置到对象的实例。
- 请问有没有可以商用的开源CMS呢?
- 用ASP.NET还是JAVA好?
- asp.net 数据库问题Dataset
- SqlServer2k 数据库名称含有中文,无法连接。请问除了给数据库更改名称还有其它办法吗?
- 请教使用SharpSvn来操作SVN获取信息出错,求大神指导
- 倾家荡产求解!!各位高人,有在win server2003 中asp.net 用cmd 调用flashpaper 转换文件成功的吗?
- 经1.htm跳转<script>window.location.href="1.aspx"</script>,怎么在1.aspx里判读来源地址是1.htm
myDs.Tables[0].Rows[0][0].ToString();
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|\\studentinfo.mdb");//用你的连接
conn.Open();
for (int i = 0; i <= myDs.Tables[0].Rows.Count - 1; i++)
{//用你的插入语句string intostr = "insert into " + tabel_name + " ([enrollment_date],[name],[sex],[study_],[Private_],[class])values('" + myDataSet.Tables["0"].Rows[i][0].ToString() + "','"
+ myDataSet.Tables["0"].Rows[i][1].ToString() + "','" + myDataSet.Tables["0"].Rows[i][2].ToString() + "','"
+ myDataSet.Tables["0"].Rows[i][3].ToString() + "','" + myDataSet.Tables["0"].Rows[i][4].ToString() + "','" + myDataSet.Tables["0"].Rows[i][5].ToString() + "')";
OleDbDataAdapter da = new OleDbDataAdapter(intostr, conn);
OleDbCommandBuilder cmd = new OleDbCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, tabel_name);
conn.Close();
}
string fullfilename = FileUpload1.PostedFile.FileName.ToString(); string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + fullfilename + "';Extended Properties=Excel 8.0"; OleDbConnection cnnxls = new OleDbConnection(mystring); OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls); DataSet myDs = new DataSet(); myDa.Fill(myDs); SqlConnection con = DB.createDB();
con.Open();
for (int i = 0; i <= myDs.Tables[0].Rows.Count - 1; i++)
{
string intostr = "insert into tb_Users(UserName,UserPwd,PassQuestion,PassSoultion,Email,Logo)values('" + myDs.Tables["0"].Rows[i][0].ToString() + "','" + myDs.Tables["0"].Rows[i][0].ToString() + "','"+null+"','"+null+"','"+null+"','"+null+ "')";
SqlDataAdapter da = new SqlDataAdapter(intostr, con);
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "td_Users");
con.Close();
}
{
//将你代码中myDs.Tables[0] 改为 myDs.Tables[0].Rows[0][i]
cmd.CommandText = "insert into excel(UserName, UserPwd) values('" + myDs.Tables[0][?].ToString() + "','" + myDs.Tables[0][?].ToString() + "')";
cmd.ExecuteNonQuery();
}
//插入数据时只插入两项UserName,UserPwd,如下:
string intostr = "insert into tb_Users(UserName,UserPwd)values('" + myDs.Tables["0"].Rows[i][0].ToString() + "','" + myDs.Tables["0"].Rows[i][1].ToString() + "')";
string intostr = "insert into tb_Users (UserName,UserPwd)values('" + myDs.Tables["0"].Rows[i][0].ToString() + "','" + myDs.Tables["0"].Rows[i][1].ToString() + "')";