Please help me to filter my data on Crystal Report...if it is possible pls give me instructions...tnx sunshine

I dont know what is the use of performance counter and how to use it... im just wondering if i could use it on my project...tnx Sunshine

tnx...that helps...but i have two tables in one gridview...how could i view those in my gridview when i search for a data that is only in one of the tables

i using vb.net...actually i really want to know about filtering...hos to use the like clause for searching

should i delete my combobox?or can i search any data on my database in my textbox without giving any choices for filtering

any suggestive design that i could make?may i know exacly what is the bad design that you are pertaining of...tnx

yes im using a database and the search result would appear to the gridview...im having a combobox that would give the textbox choices on which to filter...but i dont know how to use the like clause in the select statement propely.. sql = "Select Supplier_Information.Supplier_ID,Supplier_Information.Supplier_Name,Supplier_Information.Address,Supplier_Information.Contact_No, Products.Product_ID, Products.Product_Name,Products.Product_Type, Products.Present_Price, Products.Past_Price from Supplier_Information, Products where Supplier_Information.Supplier_ID like '%s-%' " i have this code but it does not work properly...i want to come up with a textbox that would filter in every letter that they will type in the textbox.tnx

I want to filter my data while im typing the word that i want to search on a textbox.tnx Sunshine

Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source = C:\Users\--Sunshine--\Documents\thesis\Database1.mdb") con.Open() Dim da As New OleDbDataAdapter(sql, con) sql = "Select * from Supplier_Information union all Select * from Products" da.Fill(ds, "Supplier_Information and Products") dgvSupplier.DataSource = ds.Tables("Supplier_Information and Products").DefaultView is this right?how will i assigned in my textboxes the table name? txtsuppID.Text = ds.Tables("which tablename??").Rows(inc).Item(0) tnx

how can i change the color of the heading and how to change its font style sunshine

Im using a VB. net PL i just want to know how to customize gridview...tnx sunshine

How to insert two tables in one gridview?and how to connect it and to navigate...tnx;) sunshine

Can i possibly put two tables on one gridview?how to navigate it? how can i connect it on SQL?tnx for the replies;) -- modified at 3:00 Friday 7th September, 2007