thanks buddy maybe sometimes you must look at it in a true point.I have done it. Thnx.

a

I tried,but it doesnt work.I wrote the whole code below.maybe it helps what I want to do. private DataView Get_DataAlphabetic() { string constr = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + Environment.CurrentDirectory + "\\mdb\\film_db.mdb"; OleDbConnection con_ole = new OleDbConnection(constr); string strSQL = "select FilmName from films where FilmName like " + "'" + cmbContent.Text + "*'"; OleDbDataAdapter da = new OleDbDataAdapter(strSQL, con_ole); DataTable dt = new DataTable(); da.Fill(dt); DataView dv = new DataView(dt); dv.Sort = "FilmName ASC"; da.Dispose(); con_ole.Close(); return dv; } I send it to a datagrid's datasource property in another method as I use cmobobox's SelectedIndexChanged method.Hope it is clear.I wait for your replies -- modified at 5:58 Monday 10th September, 2007

a

dear friends, I develop an Win application by using MS Access.I have got a problem in SQL statement.I have got a form that has got 2 ComboBox and a DataGridView.The name of the first is cmbCategories and the second one is cmbContent.Content is listing the content of categories.I use an array to transfer letters when I choose the category in cmbCategories as it is Alphabetical Array.When I choose a letter from cmbContent like A,B or another one,but no records is listing in the DataGridView.I try to use "Like" statement for this action.It is like this: string strSQL = "select FilmName from films where FilmName like" + "'" + cmbContent.Text + "*'"; cmbContent has got the Alphabetical letters by sequence.I want to list the FilmName that is beginning as alphabetic.For example,when I choose letter A,the films begins A must be listed.Does anybody help me?Thanks for your help.