ADO .net 数据库表绑定到gridview 并排序

SqlConnectionmyConnection=newSqlConnection("DataSource=yourIP;InitialCatalog=YourDatabase;UserID=sa;Password=Yourpassword");

//SqlCommandmyCommand=newSqlCommand("select*fromok",myConnection);
//myConnection.Open();
//SqlDataReaderdr=myCommand.ExecuteReader();

//GridView1.DataSource=dr;
/**//*以上为SqlReader例绑定gridview与以下dataset比较*/
SqlDataAdaptermyCommand=newSqlDataAdapter("select*fromok",myConnection);

DataSetds=newDataSet();
myCommand.Fill(ds,"ok");
DataViewSource=ds.Tables["ok"].DefaultView;
Source.Sort="净重desc";//倒序按净重排序

GridView1.DataSource=Source;
GridView1.DataBind();
myConnection.Close();