C#调用存储过程笔记

C#调用存储过程笔记,比较简洁的写法:

Code 
 1 SqlCommand cmd =new SqlCommand();
 2 cmd.Connection=DBHelper.conn;
 3 cmd.CommandType=CommandType.so..
 4 cmd.CommandText="存储过程名";
 5 cmd.Parameters.Add("@id",model.Id);
 6 cmd.Parameters.Add("@name",model.name);　　
 7 
 8 cmd.Connection.Open();
 9  int result =cmd.ExecuteNonquery();
10 cmd.Connection.Close():
11  
posted @ 2010-10-10 22:12  aShu123  阅读(233)  评论(0)    收藏  举报