SqlDataSource数据转DataSet,DataView

 

代码如下：

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); //也可以这样做System.Data.DataView dv = (System.Data.DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);