string ConnectionString = "Server=localhost;Integrated Security=True;Database=Northwind;User=****;password=****;"

        
string QueryString = "SELECT * FROM [Employees]"

        System.Web.UI.WebControls.SqlDataSource SqlDataSource 
= new System.Web.UI.WebControls.SqlDataSource(); 

        SqlDataSource.ConnectionString 
= ConnectionString; 

        SqlDataSource.SelectCommand 
= QueryString; 



        DataSourceSelectArguments arg 
= new DataSourceSelectArguments();

        System.Data.DataView dv 
= (System.Data.DataView)SqlDataSource.Select(arg);

//这样可以得到DataView 
System.Data.DataView dv = (System.Data.DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
posted on 2007-11-15 09:56  阳春  阅读(2125)  评论(0)    收藏  举报