string conString = "data source=127.0.0.1;initial catalog=codematic;user id=sa;password=";
string strSQL = "SELECT * FROM P_Sell where sex=0;SELECT * FROM P_Sell where sex=1";
SqlConnection myConnection = new SqlConnection(conString);
DataSet ds = new DataSet();
myConnection.Open();
SqlDataAdapter adapter = new SqlDataAdapter(strSQL, myConnection);
adapter.Fill(ds, "sell");
myConnection.Close();
DataTable dt1 = ds.Tables[0];
DataTable dt2 = ds.Tables[1];
dt1.Merge(dt2, true, MissingSchemaAction.AddWithKey);