排序(datagrid)2.txt

来自「C# 是创新性的新式编程语言」· 文本 代码 · 共 9 行

SqlDataAdapter adapter=new SqlDataAdapter("select * from titles where price!=0",
	"server=localhost;database=pubs;uid=sa;pwd=;");
DataSet ds=new DataSet();
adapter.Fill(ds);
DataView view=new DataView(ds.Tables[0]);
view.Sort="Title ASC";
MyDataGrid.DataSource=view;
MyDataGrid.DataBind();