Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markyjj
Starting Member
8 Posts |
 Posted - 2008-10-10 : 16:21:56
|
| Can someone please help me with the followng problem. I currently have a sql express database which has records of movies (title, category etc). Users can retrieve the data through a datagrid on windows form. What I want is for a record to be retrieved through a matching string entered by the user. However, I am unsure of how to go about finding the string as the data is unpredetermined. Below is part of the code I am using for the search.private void button3_Click_1(object sender, System.EventArgs e) { //Movset is dataset Dv = new DataView(Movset1.Tables[0]); dataGrid1.DataSource = Dv; //Below code doesnt work Dv.RowFilter = "Title = textBox1.Text"; } |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-15 : 07:50:30
|
| Can you explain: "data is unpredetermined". Do you mean the search may be for either title or category etc using a single text box as user input?You question is a little confusing can you re-phase it please? |
 |
|
|
|
|
|
Using rowfilter for dataview