如何创建存储过程，我想显示一些选择表
问题描述：
如何创建存储过程，我想在datagrid中显示一些select表列，datagrid显示基于字段列动态选择字段列。
Hi,
How to create stored procedure , i want show some select table columns in datagrid, that datagrid show based on field column dynamically select field column.
答
SQL Server存储过程概述 [ ^ ]
http://msdn.microsoft.com/en-us/library/ ms345415.aspx [ ^ ]
Create Procedure ProcedureName
as
Begin
Select * From TableName
End
在数据库中：
In Database:
Create Procedure ProcedureName
as
Begin
Select * From TableName
End
前端
SqlDataAdapter da = new SqlDataAdapter（）;
da.SelectCommand = new SqlCommand（ProcedureName，con）;
DataSet ds = new DataSet（） ;
da.Fill（ds，result_name）;
DataTable table = ds.Tables [result_name];
返回表
希望明确
In Front End
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("ProcedureName", con);
DataSet ds = new DataSet();
da.Fill(ds, "result_name");
DataTable table = ds.Tables["result_name"];
return table
HOPE ITS CLEAR