C#

MSDN:

It is highly recommended that this default namespace, which is http://tempuri.org, be changed before the XML Web service is made publicly consumable. This is important because the XML Web service must be distinguished from other XML Web services that might inadvertently use the namespace as the default (<http://tempuri.org/>).

SqlConnection Conn = new SqlConnection(CONNSTR);

            try
            {
                //Check for Active from Online Status

                string Sql = "SELECT [IsActive] FROM SqlCodeGen " +
                    "WHERE [UserId] = @UserId AND [RegNumber] = @RegNumber AND [UnlockCode] = @UnlockCode ";

                SqlCommand Comm = new SqlCommand(Sql, Conn);  //Apply Command 
                Comm.CommandType = CommandType.Text;

                //Parameters
                Comm.Parameters.Clear();
                Comm.Parameters.AddWithValue("@UserId", theUser );
                Comm.Parameters.AddWithValue("@UnlockCode", theUnlockCode );
                Comm.Parameters.AddWithValue("@RegNumber", theRegNumber );

                SqlDataAdapter da = new SqlDataAdapter(Sql, Conn);
                DataSet ds = new DataSet();
                da.Fill(ds);