datatable.select [filterexpression] not working

[polynaux]

Hi Guys,

I wonder why my filter expression is not working. whatever I write for
'ddd' it always finds all rows

Dim rowsFound As Data.DataRow() = MembershipInfoDataTable.[Select]()
                                                MembershipInfoDataTable.[Select]("MembershipName= 'ddd'") 


' handle the rows array
Dim sum As Integer = 0
For x As Integer = 0 To rowsFound.Length - 1
sum += Integer.Parse(rowsFound(x)("MembershipValue").ToString())
Next

Many thanks for any hints,

polynaux

 

[polynaux]

ok solved, but now, how to handle paramters

ok I solved it by fixing the select part that was first selecting everything.

but now, how to handle paramters

Dim rowsFound As Data.DataRow() = MembershipInfoDataTable.[Select]("MembershipName= " + Rulerow.Cells(3).Text + " And " + Rulerow.Cells(6).Text + " ")

 

[cjard]

.Select( string.Format("sex = '{0}' AND city = '{1}' ", txtGenderToSearch.Text, txtCityToSearch.Text) )

 

[polynaux]

thanks System.Data.cjard,
that helped