regarding sqlDataAdapter

[Madni Abbasi]

hi, I am using sqlDataAdapter select command based on multiple tables to populate DataSet . I wanted to update only one table data by using UpdateCommand Property becauze sqlCommandBuilder is not supported for multiple base tables. 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