I suspect there's something wrong with your sql statement，and plz have a try like this：

using(SqlDataAdapter adapter = new SqlDataAdapter("select * from xxx","your conn here"))   //Make sure that your xxx table must have a primary key
{
   SqlCommandBuilder sub = new SqlCommandBuilder(adapter);
   SqlCommand cmd = sub.GetUpdateCommand();
   ……………………
}