如何将GridView中的数据导入到数据库
需求：将Gridview中的数据直接导入到数据苦中对应的学科表中.
界面：导入到总表：
protected void btnExportToMaster_Click(object sender, EventArgs e) { //连接字串"sqlConnString" string sqlConnString = ""; sqlConnString = System.Configuration.ConfigurationManager.ConnectionStrings["sqlconn"].ToString(); SqlConnection con = new SqlConnection(sqlConnString); con.Open(); //配置文件读取examID string examID = System.Configuration.ConfigurationManager.AppSettings["examID"]; //根据examID考试号决定汇总到对应科目的表中 string tbName = System.Configuration.ConfigurationManager.AppSettings[examID]; //事物 SqlTransaction tran = con.BeginTransaction(); try { for (int i = 0; i < GVScore.Rows.Count; i++) { string sqlStr = ""; SqlCommand comm = new SqlCommand(sqlStr, con); string strExamId = GVScore.Rows[i].Cells[1].Text.Trim().ToString(); //获取HyperLink1中StudentId值 HyperLink href = (HyperLink)GVScore.Rows[i].Cells[2].FindControl("HyperLink1"); string strStudentId = href.Text; //如果是超链接只能获取空字符串 //HyperLink hl=(HyperLink)GVScore.FindControl ("HyperLink1"); //string strStudentId = hl.Text.ToString (); string strStudentName = GVScore.Rows[i].Cells[3].Text.Trim().ToString(); string StudentScore = GVScore.Rows[i].Cells[4].Text.Trim().ToString(); sqlStr = "INSERT " + tbName + "(examId,StudentName,StudentId,StudentScore) VALUES ('" + strExamId + "','" + strStudentId + "','" + strStudentName + "','"+StudentScore +"')"; comm.CommandText = sqlStr; comm.Connection = con; comm.Transaction = tran; comm.ExecuteNonQuery(); } tran.Commit(); Response.Write("<script>alert('导入成功！请勿重复导入！');</script>"); } catch (Exception ex) { Response.Write("更新失败,失败原因:" + ex.Message); tran.Rollback();//事务回滚 } finally { con.Close(); } }配置文件：
<!--考试号--> <!--43表示VB--> <add key="examId" value="43"/> <!--考试号对应的总表--> <add key ="43" value="t_VB_ALLStudent_Scores"/>
界面执行结果：
数据库执行结果：
