函数:
string strConn = "database";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
string sql = "Test";
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter pa = cmd.Parameters.Add("@recordcount",SqlDbType.Int);
pa.Direction = ParameterDirection.OutPut;
SqlDataReader reader = cmd.ExecuteReader();
int count = Convert.ToInt32(cmd.Parameters["@recordcount"].Value);
DataGrid1.VirtualItemCount = count;
DataGrid1.DataSource = reader;
DataGrid1.DataBind();
conn.Close();
Label1.Text = "recorcount:"+count.ToString();
存储过程:
ALTER PROCEDURE dbo.Test
(
@count int output
)AS
select @count=count(*) from CropInfo
select * from CropInfo
RETURN 为什么得不到count的值啊!!!!!!!!!!
string strConn = "database";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
string sql = "Test";
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter pa = cmd.Parameters.Add("@recordcount",SqlDbType.Int);
pa.Direction = ParameterDirection.OutPut;
SqlDataReader reader = cmd.ExecuteReader();
int count = Convert.ToInt32(cmd.Parameters["@recordcount"].Value);
DataGrid1.VirtualItemCount = count;
DataGrid1.DataSource = reader;
DataGrid1.DataBind();
conn.Close();
Label1.Text = "recorcount:"+count.ToString();
存储过程:
ALTER PROCEDURE dbo.Test
(
@count int output
)AS
select @count=count(*) from CropInfo
select * from CropInfo
RETURN 为什么得不到count的值啊!!!!!!!!!!
解决方案 »
- 呵呵!又有问题了?按两个相等的条件查询不重复记录问题??
- 判断asp:TextBox控件 提交Button1_Click提示不可为空数据操作,求讲解,最好是用、后台代码
- 关于window.dialogArguments接收参数的问题
- 求IbatisNet登陆例子源码
- DataGrid里面如何带参数
- c#语言怎么调用activex组件?
- 求.net书籍
- 为什么datagrid中的绑定列是这样的?(加分贴)
- 苦想了一天的傻瓜问题
- 怎样使gridviewer控件在运行后居中
- treeView的节点怎么使鼠标放上去有背景效果呢,如像CSDN、那样
- 这段函数怎么理解,这样做有什么好处?欢迎大家 COME IN !!!!
ALTER PROCEDURE dbo.Test
(
@count int output
)AS
select @count=count(*) from CropInfo
select * from CropInfo
return @count
GO
改成 适配器,DataSet就可以得到