Code:
public string[] CCNumLookup(string prefixText) 
        {

            SqlConnection conn = new SqlConnection("connectionstring goes here");
            
            SqlCommand command = null;
            command = new SqlCommand("You stored Procedure name here", conn);

            DataTable dt = new DataTable();
            SqlDataAdapter adapter = null;
...