SqlParameter用法

最新推荐文章于 2017-10-13 00:12:00 发布

tzp_8

最新推荐文章于 2017-10-13 00:12:00 发布

阅读量330

点赞数

分类专栏： C#(ASP.NET)知识库

本文链接：https://blog.csdn.net/tzp_8/article/details/3093449

版权

C#(ASP.NET)知识库专栏收录该内容

18 篇文章 0 订阅

订阅专栏

1 public static void Sql_Operation(string userID)
2    {
3        using (SqlConnection myConncetion = new SqlConnection(ConfigurationManager.AppSettings["ConnString"]))
4        using (SqlCommand myCommand = new SqlCommand("select UserID, UserName, UserPwd from WHERE userID = @userID ", myConncetion))
5        {
6            try
7            {
8                SqlParameter myParameter = new SqlParameter("@userID",SqlDbType.Int,4);
9                myParameter.Value = Int32.Parse(userID);
10                myCommand.Parameters.Add(myParameter);
11                myConncetion.Open();
12                myCommand.ExecuteNonQuery();
13            }
14            catch (Exception err)
15            {
16                throw new Exception("Err info:"+err.Message.ToString())
17            }
18            finally
19            {
20                myDataAdapter.Dispose();
21                myConncetion.Close();
22                myConncetion.Dispose();
23            }
24        }
25    }