http://203.208.39.132/search?q=cache:NnArGVItwzcJ:tech.it168.com/a2009/0211/265/000000265078.shtml+&cd=2&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy29lAaEco0WKfvpNcXKqvZeX0LcCSw

http://203.208.39.132/search?q=cache:rMNsTOJZCS0J:www.weste.net/2005/8-5/10032228280.html+c%23+%E9%93%BE%E6%8E%A5+sqlserver&cd=1&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy2-AhPkrnIp5Irzxs21-sEEeiitgsQ

http://203.208.39.132/search?q=cache:J9HvJh1eW58J:www.cnblogs.com/stg609/archive/2008/09/25/1298967.html+&cd=3&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy28WZ07kXYDe4z5JKn88y-S4FIij2Q

[@more@]using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; namespace StoreProduceTest
{ public class Program
{ /**
* 存储过程
*
* create procedure queryStuNameById
@stuId varchar(10),--输入参数
@stuName varchar(10) output --输出参数
as
select @stuName=stuName from stuInfo where stuId=@stuId
* */

static void Main(string[] args)
{
Operater op = new Operater(); string name = op.QueryStuNameById("1234");

Console.WriteLine(string.Format("学号为1234的学生的姓名为{0}", name));
}

}
public class Operater
{ private string ConStr = "server=.;database=User;uid=sa;pwd=1234"; private SqlConnection sqlCon = null; private SqlCommand sqlComm = null;
SqlDataReader dr = null;
public string QueryStuNameById(string Id)
{
string name = "";
try
{ using (sqlCon = new SqlConnection(ConStr))
{

sqlCon.Open();
sqlComm = new SqlCommand("queryStuNameById", sqlCon); //设置命令的类型为存储过程 sqlComm.CommandType = CommandType.StoredProcedure;
//设置参数 sqlComm.Parameters.Add("@stuId", SqlDbType.VarChar); //注意输出参数要设置大小,否则size默认为0, sqlComm.Parameters.Add("@stuName", SqlDbType.VarChar, 10); //设置参数的类型为输出参数,默认情况下是输入, sqlComm.Parameters["@stuName"].Direction = ParameterDirection.Output;
//为参数赋值 sqlComm.Parameters["@stuId"].Value = "1234"; //执行 sqlComm.ExecuteNonQuery(); //得到输出参数的值,把赋值给name,注意,这里得到的是object类型的,要进行相应的类型轮换 name = sqlComm.Parameters["@stuName"].Value.ToString();

}

} catch (Exception ex)
{

Console.WriteLine(ex.ToString());
} return name;

}
}

}