C#

<br />
IQuery oQuery.SetMaxResults(nMaxResults);<br />
IList lstResult = oQuery.List();<br />
...<br />
OR<br />
...<br />
ICriteria oCriteria.SetMaxResults(nMaxResults);<br />
IList lstResult = oCriteria.List();<br />

<br />
oCriteria.Add( Expression.Eq("spIsAuthorized", "UserId=123,ActionId=2", "Y") )<br />

public DataSet Lis_Databases(String DB)
        {

            Strcon = GetConnectionString(DB);


            con = new SqlConnection(Strcon);

            cmdselect = new SqlCommand();

            cmdselect.CommandText = "[dbo].[sp_ListDatabasesOfType_Booking]";

            cmdselect.CommandType = CommandType.StoredProcedure;

            cmdselect.Connection = con;

            da = new SqlDataAdapter();

            da.SelectCommand = cmdselect;

            DataSet ds = new DataSet();

            try
            {
                con.Open();

                da.Fill(ds);
            }
            catch (SqlException)
            {
                throw;
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                }
            }

            return ds;

        }

public DataSet Lis_Databases(String DB)
        {
            DAL.DAL obj = new DAL.DAL();

            DataSet ds = new DataSet();

            try
            {
                ds = obj.Lis_Databases(DB);
            }
            catch (SqlException)
            {   
                throw;
            }
            finally
            {

                obj = null;
            }
            return ds;
           
        }

private void List_Databases_Grid()
    {
        
            BLL.BLL obj = new BLL.BLL();
        
            DataSet ds = new DataSet();

        try
        {

            ds = obj.Lis_Databases(Convert.ToString(Session["ActiveDatabase"]));

            if (ds.Tables[0].Rows.Count > 0)
            {
                GridView_Database_list.DataSource = ds;

                GridView_Database_list.DataBind();
            }
            else
            {
                lblMessage.Text = "No Booking Database Avaiable,Create one";
                lblMessage.Visible = true;
                lblMessage.ForeColor = System.Drawing.Color.Red;
            }
        }
        catch (SqlException ex)
        {
            lblMessage.Visible = true;
            lblMessage.Text = "The List cannot be Binded, Please Contact ITS" + ex.Message;
            lblMessage.ForeColor = System.Drawing.Color.Red;
        }
        finally
        {
            obj = null;
        }

    }

if (ds.Tables[0].Rows.Count > 0)
           {

GridView_Database_list.DataSource = ds;