Programming Forums - View Single Post - Preforming a binary(SQL) search on a datagrid.

SydneyMcConnell · Jan 10th, 2008, 11:58 AM

It's going to be a dynamic search, in that it will change the results every time the key is pressed. The where clause is going to be a "LIKE", and not an "=" if that's what you mean.

I'm thinking of doing a Select statement, having that return a row, and then using that row to change the bindingcontext.location property of the form. I just don't know what I would reference to do that. I don't think I'd use the PK of the returned row to find it and then change the location... That seems extremely round-about. But is that how it would be done?

Also, if it helps any, we're using MSSQL.

Jan 10th, 2008, 11:58 AM	#3
SydneyMcConnell 18 Year Old Programmer Join Date: Jan 2008 Posts: 26 Rep Power: 0	Re: Preforming a binary(SQL) search on a datagrid. It's going to be a dynamic search, in that it will change the results every time the key is pressed. The where clause is going to be a "LIKE", and not an "=" if that's what you mean. I'm thinking of doing a Select statement, having that return a row, and then using that row to change the bindingcontext.location property of the form. I just don't know what I would reference to do that. I don't think I'd use the PK of the returned row to find it and then change the location... That seems extremely round-about. But is that how it would be done? Also, if it helps any, we're using MSSQL. __________________ Tier 2 Hardware Technician Net Effects, LLC Brunswick, Ohio