Oh.. Thank You very much...... U had point out the mistake....
On Sun, Mar 15, 2009 at 5:22 PM, Lee Gunn <[email protected]>wrote: > Hi, > > You SQL string is: > > "Select distinct Subjectname from Subject" > > Therefore you should set your data properties to: > > subopt.DataMember="Subjectname" > subopt.DatatextField="Subjectname" > > > Lee > > ------- > http://www.jiba-jaba.com > http://www.secretorange.co.uk > > > ________________________________ > > From: [email protected] on behalf of Jeena Ajiesh > Sent: Sun 15/03/2009 13:21 > To: [email protected] > Subject: [DotNetDevelopment] Datbind error. > > > > Hi all, > Wen i bind a drop down list, its giving me an error, > > "System.Data.DataRowView does not contain property with the name 'Subject" > > The code is as follows to populate dropdownlist > > Dim con as new sqlconnection(constr) > Dim strsql as string="Select distinct Subjectname from Subject" > Dim ds as new Dataset > con.Open() > Dim cmd as New SqlCommand(strsql,con) > Dim Adapt as New SqlDataAdapter(cmd) > Adapt.Fill(ds,"Subject") > subopt.Datasource=ds.tables(0) > subopt.DataMember="Subject" > subopt.DatatextField="Subject" > subopt.Databind() --- Error > > Pls tell me hw to solve this??? > > Regards > Jeena > > -- **************** Regards, ♪♥♫♥Ĵєєήǎ ♫♥♪♥ Email: [email protected] [email protected] [email protected] Sent from: Dubayy United Arab Emirates.
