在一个已经有数据的gridview中，有哪些方法可以把这些数据导入到数据库??

Question

哪位老鸟指点一下！！！

Answer 1

csvdb是datagridview 
for (int i = 0; i < csvdb.Rows.Count; i++)
                    {
                        en.accountcode = csvdb.Rows[i][0].ToString();
                        en.password = csvdb.Rows[i][1].ToString();
                        en.deviceproto = csvdb.Rows[i][2].ToString();
                        en.devicenumber = csvdb.Rows[i][3].ToString();   //
                        en.devicestring = csvdb.Rows[i][4].ToString(); //
                        en.fristchecked = int.Parse(csvdb.Rows[i][5].ToString()); //
                        en.transfernumber = csvdb.Rows[i][6].ToString(); //
                        en.diallocal_failed = csvdb.Rows[i][7].ToString(); //
                        en.info_name = csvdb.Rows[i][8].ToString(); //
                        en.info_email = csvdb.Rows[i][9].ToString();
                        en.info_detail = csvdb.Rows[i][10].ToString();
                        en.info_re = csvdb.Rows[i][11].ToString();
                        en.cretime = System.DateTime.Now;
                        //对应好数据库字段 组合 insert into  SQLSERVER支持多条 insert 一起插入
                        en.insert();//插入数据库。
                    }

Answer 2

DataTable dt=(DataTable)gridview.DataSource;
for(int i=0;i<dt.Rows.Count;i++)
{
  //拼接SQL insert持久化到数据库
}

Answer 3

DataTable dt=(DataTable)gridview.DataSource;
for(int i=0;i<dt.Rows.Count;i++)
{
  //拼接SQL insert持久化到数据
}
我用这个怎么提示我，未将对象引用设置到对象的实例。是怎么回事啊啊

Answer 4

这是我写的但是总提示我指定的参数已超出有效值的范围。 SqlConnection sqlcon;
            SqlCommand sqlcom;
            sqlcon = new SqlConnection(strConn);
            sqlcon = new SqlConnection(strConn);
            DataTable dt = (DataTable)GridView1.DataSource;
            
            for (int i = 0; i <= GridView1.Rows.Count; i++)
            {
                
                string sqlstr = "insert into [xuesheng](stu_id,stu_name,stu_sex,stu_bir,stu_shfen,stu_nation,stu_zzmm,stu_xz,stu_pycc,stu_jtzz) values('" +
                    ((TextBox)(GridView1.Rows[i].Cells[1].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[2].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[3].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[4].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[5].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[6].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[7].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[8].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[9].Controls[0])).Text.ToString().Trim() +
                    "','" + ((TextBox)(GridView1.Rows[i].Cells[10].Controls[0])).Text.ToString().Trim() + "')";
                sqlcom = new SqlCommand(sqlstr, sqlcon);
                sqlcon.Open();
                sqlcom.ExecuteNonQuery();
                sqlcon.Close();
           }
高手指教一下

Answer 5

那你的断点调试你的程序.看看你的sqlstr是否可以再查询分析器里正常执行

Answer 6

((TextBox)(GridView1.Rows[i].Cells[2].Controls[0])).Text.ToString().Trim()这个可以写成
GridView1.Rows[i].Cells[2].Value.ToString();