如何创建存储过程,我想显示一些选择表 [英] How to create stored procedure , i want show some select table
问题描述
如何创建存储过程,我想在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
这篇关于如何创建存储过程,我想显示一些选择表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!