ALTER PROCEDURE GetStatisticInfo
@Bloggers int out,
@Posts int out,
@Comments int out,
@Clicks int out
As
Set @Bloggers=(Select count(*) from Blog_User)
Set @Posts=(Select count(*) from Blog_Post)
Set @Comments=(Select count(*) from Blog_Comment)
Set @Clicks=(Select BlogClicks from Blog_Blog)
public void getstate(ref int x, ref int y, ref int z,ref int f)
{SqlConnection con = new SqlConnection(sql);
con.Open();
SqlCommand cmd = new SqlCommand("GetStatisticInfo",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add( "@Bloggers",SqlDbType.Int ,4);
cmd.Parameters["@Bloggers"].Direction=ParameterDirection.Output;
cmd.Parameters.Add("@Posts", SqlDbType.Int,4);
cmd.Parameters["@Posts"].Direction=ParameterDirection.Output;
cmd.Parameters.Add("@Comments", SqlDbType.Int,4);
cmd.Parameters["@Comments"].Direction=ParameterDirection.Output;
cmd.Parameters.Add("@Clicks", SqlDbType.Int,4);
cmd.Parameters["@Clicks"].Direction=ParameterDirection.Output;
cmd.ExecuteNonQuery();
x =int.Parse(cmd.Parameters["@Bloggers"].Value.ToString());
y = int.Parse(cmd.Parameters["@Posts"].Value.ToString());
z = int.Parse(cmd.Parameters["@Comments"].Value.ToString());
f = int.Parse(cmd.Parameters["@Clicks"].Value.ToString());
}
求解
@Bloggers int out,
@Posts int out,
@Comments int out,
@Clicks int out
As
Set @Bloggers=(Select count(*) from Blog_User)
Set @Posts=(Select count(*) from Blog_Post)
Set @Comments=(Select count(*) from Blog_Comment)
Set @Clicks=(Select BlogClicks from Blog_Blog)
public void getstate(ref int x, ref int y, ref int z,ref int f)
{SqlConnection con = new SqlConnection(sql);
con.Open();
SqlCommand cmd = new SqlCommand("GetStatisticInfo",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add( "@Bloggers",SqlDbType.Int ,4);
cmd.Parameters["@Bloggers"].Direction=ParameterDirection.Output;
cmd.Parameters.Add("@Posts", SqlDbType.Int,4);
cmd.Parameters["@Posts"].Direction=ParameterDirection.Output;
cmd.Parameters.Add("@Comments", SqlDbType.Int,4);
cmd.Parameters["@Comments"].Direction=ParameterDirection.Output;
cmd.Parameters.Add("@Clicks", SqlDbType.Int,4);
cmd.Parameters["@Clicks"].Direction=ParameterDirection.Output;
cmd.ExecuteNonQuery();
x =int.Parse(cmd.Parameters["@Bloggers"].Value.ToString());
y = int.Parse(cmd.Parameters["@Posts"].Value.ToString());
z = int.Parse(cmd.Parameters["@Comments"].Value.ToString());
f = int.Parse(cmd.Parameters["@Clicks"].Value.ToString());
}
求解
解决方案 »
- 求报表制作
- ms-sql 2008 用户权限问题?
- 非常简单的一个查询问题,等于白送分!
- 在Northwind中如何查询……?
- 还有一个sql语句
- 奇怪,我的数据库可用空间始终为0,数据文件和日志文件不再自动增长
- 想装一管理工具开发用,要求能添加新实例,有智能提示,文件尽量小,sqlserver版本最低2008
- 请问怎么才能让自己在数据库里创建的表,在打开SQLServer2000的企业管理器时候只显示系统的表,而不现实自己创建的表呢?又怎么恢复显示
- 求一句sql语句
- SQL数据库出现" 客户和服务器代码页不匹配",高手看看如何解决??
- 谁能帮我把SQL2005生成的sql语法,转换成SQL2000的语法?
- 继续请教:如何删除NOT FOR REPLICATION
@Bloggers
@Posts
@Comments
@Clicks
的值
c#。net
cmd.ExecuteNonQuery();
这里有问题
Set @Bloggers=(Select count(*) from Blog_User)
Set @Posts=(Select count(*) from Blog_Post)
Set @Comments=(Select count(*) from Blog_Comment)
Set @Clicks=(Select BlogClicks from Blog_Blog)