Tell me more ×  I dont know how to compare fields from database
in dataset. I am working with and c#.  and after compare two
dataset i want to insert in anothere table.Any help, thanks.
public void btnProcess_Click(object sender, System.EventArgs e)
if (rdBusinessUnit.Checked == true)             DataSet ds1 =
new DataSet();             DataSet ds2 = new DataSet();
SqlConnection conn = new SqlConnection(strConn);
string sql1 = "";             string sql2 = "";
sql1 = "SELECT * FROM CTORGPROJ   ";                 if
(conn.State == ConnectionState.Closed) { conn.Open(); }
SqlDataAdapter da = new SqlDataAdapter(sql1, conn);
da.Fill(ds1, "temp");                 //int i="';
//i dont know how to compare in here                  sql2 =
"select * from PY33PAYRP WHERE PAPBRCH
='ds1.Tables[]   [CTPAPBRCH]' ";                 SqlDataAdapter
daa = new SqlDataAdapter(sql2, conn);
daa.Fill(ds