regarding sqlDataAdapter

[Madni Abbasi]

hi, I am using sqlDataAdapter select command based on multiple tables using INNER JOIN to populate DataSet . I wanted to update only one table data by using UpdateCommand Property. plz help me to write Update Command. SelectCommand is as sql = "SELECT a.prepaidID,a.revAccountNo,a.AccountNo AS origAccountNo," & _ "a.totalAmount, .description, .distAmount,b.fromDate,b.toDate,b.vtCode, b.voucherNo,b.voucherDate" & _ " FROM prepaidDistribution a,prepaidDistributionDetail b" & _ " WHERE a.prepaidID = b.prepaidID and a.companyCode='" & compCode & _ "' and b.fromDate>='" & startDate & "' and b.toDate<='" & endDate & _ "' and b.vtcode IS NULL and a.accountNo like '" & accountNo & "%'" plz help immediately