yes, of course you can. you can use sqlparameter. for example: select * from table where id = @id; sqlParameter p = new sqlParameter( "@id" ); p.value = "XXX";
好像楼上说的方法不行。AccessDataSource是Asp.net 2.0中特有的。
我也是刚接触这个,花了一整晚的时间自己搞定的: Ds.SelectParameters.Clear(); Ds.SelectCommand = "select * from Login where UserName=@username"; Ds.SelectParameters.Add("@username", System.TypeCode.String, user);//////////Ds就是AccessDataSource
you can use sqlparameter. for example:
select * from table where id = @id;
sqlParameter p = new sqlParameter( "@id" );
p.value = "XXX";
Ds.SelectParameters.Clear();
Ds.SelectCommand = "select * from Login where UserName=@username";
Ds.SelectParameters.Add("@username", System.TypeCode.String, user);//////////Ds就是AccessDataSource