filterdata using rowfilter expression

[DotNetJunkies User]

Hi

I am trying to filter data using the rowfilter expression. However I want to pass a string variable eg

string sname = txtlastname.Text;

string ln = "LastName = 'sname'";
dataView1.RowFilter=ln; DataGrid1.DataSource=dataView1;
DataGrid1.DataBind();

when I run this, nothing happens to the datagrid

Please help

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

[Shiva]

Perhaps, you wanted to append the value of variable sname to the filter
criteria?

string ln = "LastName = "' + sname + "'";

"DotNetJunkies User" <[e-mail]> wrote in message
news:u4**************@TK2MSFTNGP09.phx.gbl...
Hi

I am trying to filter data using the rowfilter expression. However I want
to pass a string variable eg

string sname = txtlastname.Text;

string ln = "LastName = 'sname'";
dataView1.RowFilter=ln; DataGrid1.DataSource=dataView1;
DataGrid1.DataBind();

when I run this, nothing happens to the datagrid

Please help

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.