ur logic here is perfectly fine but dere's a problem in code, u gave me d
following code right :
Dim pos as Integer = -1
'Assumes that the "id" column is set as the Primary Key of the
DataTable.
Dim dr as DataRow = DataSet11.Table1.Find("4")
If dr isnot nothing then
*pos = DataSet11.Table1.Rows.IndexOf(dr)
* Me.BindingContext(DataSet11, "table1").Position = pos
End If
take a look at the bold statement, i found out tht dere's no "indexof" method
available 4 "dataset11.table1.rows", atleast not in vb.net(version 2005).
pls suggest an alternative.
thank u
On Sun, Jun 21, 2009 at 11:25 PM, Cerebrus <[email protected]> wrote:
>
> I already showed you how to do that!
>
> On Jun 21, 4:12 pm, anubhav nidaria <[email protected]> wrote:
> > thnks 4 ur answer but i wsn't askin 2 for finding row index.
> >
> > see i hv an access database "employee". the database contains table
> "table1"
> > which has columns as stated below:
> >
> > 1. empid - datatype autonumber (primary key)
> >
> > 2. name - datatype text
> >
> > 3. designation - datatype text
> >
> > now i take a variable "a" n input a number in it through inputbox.
> >
> > for eg. i give a=4, now wht i want is d value of variable "a" should b
> > checked with entire "empid" column n whichever row/record contains empid
> as
> > 4 shud b displayed. I want 2 do dis with ado.net dataset but without sql
> n i
> > m using textboxes 2 display d data.
> >
> > to b more precise: *"I WANT TO COMPARE A VARIABLE WITH AN ENTIRE COLUMN
> IN A
> > TABLE OF ACCESS DATABASE IN VB.NET <http://vb.net/> ENVIRONMENT USING
> ANYTHING BUT NOT SQL"*
