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 }