貓~程式碼集散區

ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["WEBConnectionString"]; 
SqlConnection conn = new SqlConnection(connstr.ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("proc name", conn); 
cmd.CommandType = CommandType.StoredProcedure; 
cmd.Parameters.AddWithValue("@VTYPE", "3"); 
SqlDataReader dr = cmd.ExecuteReader(); 
if (dr.Read()) { 
}

dr.Close(); 
conn.Close();