How tranform query result : I need transform string query to int for to evaluated. Im going well or exists another way to do that ?. I really need the help. this is a extract to the code.  its that possible transform the result or is not . Im newbie by the way . thanks
I really apreciated ur help .

CODE

    string query = "SELECT Movie.Code FROM Movie WHERE Movie.Code = @code";
               
                

                int i = 0;
                i = int.Parse(query);

                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    con.Open();
                    
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        //string R1 = "OK";
                        if (sdr.Read())
                        {
                            
                            if (i > 0)
                            {
                                Re1 =  "OK";

                                
                            }
                            else
                            {
                               
                               Re1 = "Fail";
                                
                            }

                           
                            
                        }

                        return Re1;
                       
                    }