GridView按某列排序
发布网友
发布时间：2022-04-27 12:30
共2个回答
热心网友
时间：2022-04-27 13:59
SqlConnection myConn = GetConnection();
SqlCommand myCmd = new SqlCommand("Proc_yourmony", myConn);
myCmd.CommandType = CommandType.StoredProcere;
//执行过程
myConn.Open();
try
{
myCmd.ExecuteNonQuery();
}
catch
{
myCmd.Dispose();
myConn.Close();
}
myCmd.Dispose();
myConn.Close();
存储过程代码为:
create procere [dbo].[Proc_yourmony]
as
select * from [表名]order by yourmony
热心网友
时间：2022-04-27 15:17
Select * from [表名]order by [排序的列] asc
