static void Send() {
int i = 2;
string ConnStr = "server=.;database=ext;uid=sa;pwd=sa;";
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@Name", SqlDbType.VarChar).Value="A";
//comm.Parameters["@Name"].Value = "A";
comm.Parameters.Add("@Rowcount", SqlDbType.Int);
comm.Parameters["@Rowcount"].Direction = ParameterDirection.Output;
comm.Connection.Open();
try
{
i = (int)comm.ExecuteScalar(); // ExecuteScalar:返回第一行第一列值
}
catch (SqlException er)
{
Console.WriteLine(er.ToString()); //向上一级抛异常
}
finally
{
comm.Connection.Close();
conn.Close();
}
Console.WriteLine(i.ToString());
}
static void Main(string[] args)
{
Send();
Console.ReadKey();
}
int i = 2;
string ConnStr = "server=.;database=ext;uid=sa;pwd=sa;";
SqlConnection conn = new SqlConnection(ConnStr);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@Name", SqlDbType.VarChar).Value="A";
//comm.Parameters["@Name"].Value = "A";
comm.Parameters.Add("@Rowcount", SqlDbType.Int);
comm.Parameters["@Rowcount"].Direction = ParameterDirection.Output;
comm.Connection.Open();
try
{
i = (int)comm.ExecuteScalar(); // ExecuteScalar:返回第一行第一列值
}
catch (SqlException er)
{
Console.WriteLine(er.ToString()); //向上一级抛异常
}
finally
{
comm.Connection.Close();
conn.Close();
}
Console.WriteLine(i.ToString());
}
static void Main(string[] args)
{
Send();
Console.ReadKey();
}
}
存储过程如下:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_TEST]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_TEST]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE PROC P_TEST
@Name VARCHAR(20),
@Rowcount INT OUTPUT
AS
BEGIN
SELECT * FROM T_Customer WHERE NAME=@Name
SET @Rowcount=@@ROWCOUNT
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO