problem in data grid

Apr 25 2006 7:23 PM
hi there
i have problem with 
datagrid when itry to but acondition for the sql it appears awrong for me the code i use it is good whatever dont but condition for it
this is the code used it to have my data viewd on a data grid

public void sql()
{
String s11=TextBox1.Text.Trim();
OleDbCommand cmd;
DataSet ds=new DataSet();

OleDbDataAdapter da;

String 
sql= "SELECT [tel],[name] FROM users ";//where name=s11";
cmd=new
OleDbCommand(sql,connect);
da=new OleDbDataAdapter(sql,connect);
da.Fill(ds,"users");
DataGrid1.DataSource=ds;
DataGrid1.DataBind();

}
then wen itry to but where condition the problem appears .


Answers (2)