怎样将datatable追加到sql数据库中

Question

怎样将datatable追加到sql数据库中 SqlConnection objconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["测试数据ConnectionString"].ConnectionString);
string sqlstr = "select * from [aa]";
objconn.Open();
SqlDataAdapter objCmd = new SqlDataAdapter(sqlstr, objconn);
SqlCommandBuilder thisbuilder = new SqlCommandBuilder(objCmd);
objCmd.Update(ds2.Tables[0]);
objconn.Close();我用上面那个，数据库里面没有导进去，是不是字段的类型可能不一致造成的？

Answer 1

不是这样的，是这样的
            SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["xxxx"]);
            try
            {
                con.Open();
                string ab = "select * from xxxx";
                SqlDataAdapter com = new SqlDataAdapter(ab, con);
                SqlCommandBuilder ewer = new SqlCommandBuilder(com);
                DataSet dq = new DataSet();
                com.Fill(dq);
                DataTable talbe = new DataTable();
                talbe = dq.Tables[0];
                DataRow row = talbe.NewRow();
                row["title"] = title;
                row["ml"] = ml;
                row["time"] = DateTime.Now;
                talbe.Rows.Add(row);
                com.Update(dq);
            }
            finally
            {
                con.Close();
            }