C调用存储过程显示.doc

C#调用存储过程显示（含实例） 首先建立存储过程 效果图 其次C#调用显示 if exists (select * from dbo.sysobjects where id = object_id(Pb_TeacherInfoProReport)) drop procedure Pb_TeacherInfoProReport go create procedure Pb_TeacherInfoProReport @count int as declare @aid int,@bid int select top (@count) Z.姓名,Z.人数 from ( select distinct user_name as 姓名, (select count(*) from Vw_TeacherUserInfo x where x.user_name=y.user_name) AS 人数 from Vw_TeacherUserInfo y) Z order by Z.人数 desc //转áa化?￥为a一°?个?datatable DataTable dataTable = new DataTable();//建?§一°?个?新?的ì?实o|ì例¤y for (int i = 0; i dr.FieldCount; i++) //dr.FieldCount字á?段?数oy { DataColumn mydc = new DataColumn();//关?键¨1的ì?一°?步? mydc.DataType = dr.GetFieldType(i); mydc.ColumnName = dr.GetName(i); dataTable.Columns.Add(mydc);//关?键¨1的ì?第ì¨2二t步? } DataRow mydr; while (dr.Read()) { mydr = dataTable.NewRow();//关?键¨1的ì?第ì¨2三¨y步? for (int i = 0; i dr.FieldCount; i++) { mydr[i] = dr[i].ToString(); } dataTable.Rows.Add(mydr);//关?键¨1的ì?第ì¨2四?步? mydr = null; } string values = string.Empty; for (int i = 0; i dataTable.Rows.Count; i++) { mydr = dataTable.Rows[i]; values += trtd style=text-align:right; width:19%;img src=../Images/button/user20.gif alt=/nbsp;/td; values += td style=width:50%;; values += mydr[代?¨2理¤¨a].ToString(); values += /tdtd style=width:30%; white-space:nowrap; values += mydr[人¨?数oy].ToString(); values += 人¨?/td/tr; } this.newslist.InnerHtml = values; } } } using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;