Private void btnsearch_click (object sender, system.eventargs e) {stringbuilder sql = new stringbuilder ();
// limited maximum results sizesql.append (@select Top); SQL.Append (ConfigurationSettings.AppSettings ["SearchLimit"]); SQL.Append (@ "[user] .userid, [user] .firstname, [user]. LastName, Place.PlaceID, Place.Name as PlaceName, Place.Type.Name as PlaceType, PlaceType.TypeID, TimeLapse.Name as LapseName, TimeLapse.YearIn, TimeLapse.MonthIn, TimeLapse.YearOut, TimeLapse.MonthOutFrom [user] left outer Join TimeLaspse OntimeLapse.Userid = [user] .useridleft @ = placepe.typeid ");
// builder the where clause now
Stringbuilder QRY = New stringbuilder (); if (txtfirstname.text! = String.empty) {qry.append ("[user] .firstname like '%"); QRY.Append (txtfirstname.text) .append ("%' And ");
} IF (txtlastname.text! = String.empty) {qry.append ("[user] .lastname like '); QRY.Append (txtlastname.text) .append ("%');} if (CBPLACE) .Selecteditem.value! = "0") {QRY.Append ("[place] .PlaceId = '"); QRY.Append (Cbplace.selectedItem.Value) .append ("' and");} String filter = QRY .Tostring (); if (filter.Length! = 0) {SQL.Append ("where"); sql.Append (Filter.length-4, 4);
Sqldataadapter ad = new sqldataadapter (sql.tostring, cnfriends); dsResults = new dataset (); ad.fill (dsrusult, "user"); // Adjust label for Results
IF (dsreusult.tables ["user"]. Rows.count // Place Results in Sessin State session ["Search"] = dsResults; DSRESULTS = (Dataset) session ["Search"]; gRDRESULTS.DATABIND ();
