Wednesday, August 6, 2014

With only ASPX (asp.net) code, connect to SQL server database, and list table contents with query (no compilation or dll needed)

Mypage.aspx


<html xmlns="http://www.w3.org/1999/xhtml">
<head><title></title></head>
<body>
    <form id="form1" runat="server">
        <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" EnableModelValidation="True" AllowPaging="True" AutoGenerateColumns="true">            
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:maniConnectionString %>" SelectCommand="SELECT * FROM [Server_Capacity_1]"></asp:SqlDataSource>
    </form>
</body>
</html>
Sample web.config connecting to SQL Server


<?xml version="1.0"?>
<configuration>
  <connectionStrings>
    <add name="MyConnectionString" connectionString="Data Source=myservername.com;Initial Catalog=MyDBName;Persist Security Info=True;User ID=myuserid;Password=myPassword"
      providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>
at No comments:
Labels: ,

Hyperion interactive reporting studio BQY file grows large/huge over a period of time

If you use Brio to develop reports and save the file multiple time's you may have noticed that the file have grown huge over a period of time, and hence takes a long time to save. To reduce the file size, follow the below steps:

Warning: You will temporarily lose all data saved in the report (ie; generated report). Please don't try if you cannot generate it back and this data is important


  1. Open the bqy file in hyperion interactive reporting studio (I have tied this on 11.1.2)
  2. File --> Save Options --> Save Query Results with Document
  3. A small popup will open. In the left box that say query results, uncheck all boxes and hit OK
  4. Save the document. Now if you see the file size, it will be much smaller
  5. Close the report (or if you want, you can close the hyperion interactive reporting studio itself)
  6. Follow the below steps if you need to save the data as well
  7. Re-open the bqy report
  8. Process your report again so it will generate results
  9. File --> Save Options --> Save Query Results with Document
  10. A small popup will open. In the left box that say query results, check all boxes and hit OK
  11. Save the file
  12. You should have the data back, and the file size will be still much lower

at No comments:
Subscribe to: Posts (Atom)

Turn on Windows 11 Fast Boot

If windows starting is slow, to enable windows 11 fast startup/boot,  Press Windows + R, type powercfg.cpl, and hit Enter.  This will direct...