Monday, March 12, 2012

How to test your configuration on servers to eliminate Issues before opening to production.










  
Code Snippet
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="NewPage.aspx.cs" Inherits="TestConnection_NewPage" %>
  2. DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html >
  4. <head id="Head1" runat="server">    
  5. head>
  6. <title>jQuery UI Tabs - Open on mouseovertitle>    
  7. <link type="text/css" href="jquery-ui-1.8.custom.css" rel="Stylesheet"/>
  8. <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.js">script>    
  9. <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.js">script>
  10.     
  11.     
  12.     <style type="text/css">.style3 { FONT-SIZE: x-large; COLOR: #ffffff }
  13.         .style4 { FONT-FAMILY: Verdana; TEXT-ALIGN: center }
  14.         .style5 { FONT-SIZE: medium }
  15.         .style6 { FONT-WEIGHT: bold; FONT-SIZE: medium; FILTER: dropshadow(color=#000000,offx=2,offy=2); COLOR: #0b77d3; FONT-FAMILY: Verdana; TEXT-ALIGN: center }
  16.         .moduleGroupDivStyle {width:100%; }
  17.         .appGroupHeadingStyle {width:100%; height:20px; padding-left:20px; text-align:left; vertical-align:bottom; font-weight:bold; font-size:12px; background-color:LightGrey;}
  18.         .RadioButtonStyle {font-size:11px; }
  19.     style>
  20.  
  21. <script type="text/javascript">
  22.     $(function () {
  23.         $("#tabs").tabs({
  24.             event: 'mouseover'
  25.         });
  26.     });
  27.     script>
  28.  
  29. <body>
  30.  
  31. <div class="demo">
  32. <div id="displayLoading"><span style="background-color:Yellow;font-size:larger;">Loading.... span>div>
  33. <table cellspacing="0" cellpadding="0" width="100%" border="0">
  34.                 <tbody>
  35.                     <tr>
  36.                            <td valign="bottom" nowrap width="29%" background="di1.gif" height="55">
  37.                              td>
  38.                         <td class="style3" nowrap background="di1.gif" height="55">
  39.                             Validate Web.config td>
  40.                         <td valign="bottom" nowrap width="22%" background="di1.gif">
  41.                              td>
  42.                     tr>
  43.                 tbody>
  44. table>
  45. <table width="70%">
  46. <tr>
  47.     <td width="10%"> td><td style="height:1cm"> td>
  48. tr>
  49.  
  50. <tr>
  51.     <td width="10%"> td><td><center><h5>Webservices, nHibernate Mapping Files, Database Connectionsh5>center>td>
  52. tr>
  53. <tr>
  54.     <td> td><td> td>
  55. tr>
  56. <tr>
  57. <td>
  58.  
  59. td>
  60. <td>
  61. <div id="tabs">
  62.     <ul>
  63.         <li><a href="#tabs-1">Web Service URLsa>li>
  64.         <li><a href="#tabs-2">Nhibernate Mappinga>li>
  65.         <li><a href="#tabs-3">Connection Stringa>li>
  66.     ul>
  67.     <div id="tabs-1">
  68.         <p>
  69.         
  70.         <asp:Table ID="wsListTable" runat="server" BorderWidth="1" BackColor="AliceBlue"
  71.             Font-Size="Larger" CellPadding="2" CellSpacing="2" BorderColor="Black">
  72.             <asp:TableRow BorderWidth=1 Font-Bold="true">
  73.                 <asp:TableCell BorderWidth="1" Width="10%" VerticalAlign="Middle" align="center">Serial Noasp:TableCell>
  74.                 <asp:TableCell BorderWidth="1" Width="40%">URL/Connectionasp:TableCell>
  75.                 <asp:TableCell BorderWidth="1" Width="10%" align="center">Statusasp:TableCell>
  76.             asp:TableRow>
  77.         asp:Table>   
  78.         <br/>
  79.         <br/>
  80.         <button id="TestConn">Test Webservice button><span style="background-color:Yellow;font-size:larger;" id="lblstatus">span>
  81.     p>
  82.     div>
  83.     <div id="tabs-2">
  84.         <p>
  85.             <span id="TestConnection">span>
  86.              <br/>
  87.             <br/>
  88.             <button id="TestDatabase">Test Mappingbutton>
  89.         p>
  90.     div>
  91.     <div id="tabs-3">
  92.         <p><asp:Table ID="wsDatabaseConnection" runat="server" BorderWidth="1" BackColor="AliceBlue"
  93.             Font-Size="Larger" CellPadding="2" CellSpacing="2" BorderColor="Black">
  94.         <asp:TableRow BorderWidth=1 Font-Bold="true">
  95.             <asp:TableCell BorderWidth="1" Width="10%" VerticalAlign="Middle" align="center">Nameasp:TableCell>
  96.             <asp:TableCell BorderWidth="1" Width="30%">Connection stringasp:TableCell>
  97.             <asp:TableCell BorderWidth="1" Width="10%" align="center">Providerasp:TableCell>
  98.         asp:TableRow>
  99.     asp:Table> p>
  100.     div>
  101. div>
  102. td>
  103. tr>
  104. table>
  105. div>
  106.  
  107. <script type="text/javascript">
  108.  
  109.      $(document).ready(function () {
  110.          $("#displayLoading").hide();
  111.      });
  112.      $("#TestDatabase").click(function () {
  113.  
  114.          var webMethod = 'newpage.aspx/TestAllMapping'
  115.          var resultId = "#ResultData";
  116.  
  117.  
  118.          $.ajax({
  119.              type: "POST",
  120.              url: webMethod,
  121.              data: "{'name': '" + $(this).attr("id") + "'}",
  122.              contentType: "application/json; charset=utf-8",
  123.              dataType: "json",
  124.              success: function (msg) {
  125.                  $("#TestConnection").html(msg.d);
  126.              },
  127.              error: AjaxFailed
  128.          });
  129.      });
  130.  
  131.      $("#TestConn").click(function () {
  132.  
  133.          resetResults();
  134.          testConnections();
  135.  
  136.      });
  137.  
  138.      function resetResults() {
  139.  
  140.          $("td").each(function () {
  141.              var resultId = "#" + $(this).attr("id") + "Result";
  142.              $(resultId).text("");
  143.          });
  144.      }
  145.  
  146.      function testConnections() {
  147.          $("td").each(function () {
  148.              if ($(this).text().substring(0, 4) == "http") {
  149.  
  150.                  var webMethod = 'newpage.aspx/TestHTTP'
  151.                  var resultId = "#" + $(this).attr("id") + "Result";
  152.                  $.ajax({
  153.                      type: "POST",
  154.                      url: webMethod,
  155.                      timeout: 3000,
  156.                      data: "{'name': '" + $(this).attr("id") + "'}",
  157.                      contentType: "application/json; charset=utf-8",
  158.                      dataType: "json",
  159.                      success: function (msg) {
  160.                          if (msg.d == "False") {
  161.  
  162.                          }
  163.                          $(resultId).html(msg.d);
  164.  
  165.                      },
  166.                      async: false,
  167.                      error: AjaxFailed
  168.                  });
  169.              }
  170.          });
  171.      }
  172.  
  173.      function AjaxFailed(result) {
  174.          alert(result.status + ' ' + result.statusText);
  175.      }
  176.  
  177.     script>
  178. body>
  179. html>


Code Snippet
  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Data.OracleClient;
  6. using System.Data.SqlClient;
  7. using System.Net;
  8. using System.Text;
  9. using System.Web.UI.WebControls;
  10.  
  11.  
  12. public partial class TestConnection_NewPage : System.Web.UI.Page
  13. {
  14.     protected void Page_Load(object sender, EventArgs e)
  15.     {
  16.  
  17.         int nCounter = 0;
  18.  
  19.  
  20.         foreach (string appKey in ConfigurationManager.AppSettings.AllKeys)
  21.         {
  22.             string appKeyValue = ConfigurationManager.AppSettings.Get(appKey);
  23.             if (appKeyValue.Contains("http") && !appKeyValue.Contains("swe"))
  24.             {
  25.                 TableRow tRow = new TableRow();
  26.                 tRow.BorderWidth = 1;
  27.                 // Create a new cell and add it to the row.
  28.                 TableCell tCell1 = new TableCell();
  29.                 tCell1.Text = (++nCounter).ToString();
  30.                 tCell1.BorderWidth = 1;
  31.                 tRow.Cells.Add(tCell1);
  32.  
  33.                 TableCell tCell2 = new TableCell();
  34.                 tCell2.Text = appKeyValue;
  35.                 tCell2.BorderWidth = 1;
  36.                 tCell2.ID = appKey;
  37.                 tRow.Cells.Add(tCell2);
  38.  
  39.  
  40.                 TableCell tCell3 = new TableCell();
  41.                 tCell3.BorderWidth = 1;
  42.                 tCell3.ID = appKey.Trim() + "Result";
  43.                 tRow.Cells.Add(tCell3);
  44.                 wsListTable.Rows.Add(tRow);
  45.  
  46.             }
  47.         }
  48.  
  49.         foreach (ConnectionStringSettings connection in ConfigurationManager.ConnectionStrings)
  50.         {
  51.             string name = connection.Name;
  52.             string provider = connection.ProviderName;
  53.             string connectionString = connection.ConnectionString;
  54.             string statusCheck = string.Empty;
  55.  
  56.             TableRow tRow = new TableRow();
  57.             tRow.BorderWidth = 1;
  58.             // Create a new cell and add it to the row.
  59.             TableCell tCell1 = new TableCell();
  60.             tCell1.Text = name;
  61.             tCell1.BorderWidth = 1;
  62.             tRow.Cells.Add(tCell1);
  63.  
  64.             TableCell tCell2 = new TableCell();
  65.             tCell2.Text = connectionString;
  66.             tCell2.BorderWidth = 1;
  67.             tCell2.ID = name;
  68.             tRow.Cells.Add(tCell2);
  69.  
  70.             try
  71.             {
  72.                 if (provider == "System.Data.SqlClient")
  73.                 {
  74.                     SqlConnection conn = new SqlConnection(connectionString);
  75.  
  76.                     conn.Open();
  77.                     if (conn.State == ConnectionState.Open)
  78.                         statusCheck = "Success";
  79.                 }
  80.                 if (provider == "System.Data.OracleClient")
  81.                 {
  82.                     OracleConnection conn = new OracleConnection(connectionString);
  83.                     conn.Open();
  84.                     if (conn.State == ConnectionState.Open)
  85.                         statusCheck = "Success";
  86.  
  87.                 }
  88.             }
  89.             catch (Exception exp)
  90.             {
  91.                 statusCheck = exp.Message.ToString();
  92.             }
  93.  
  94.             TableCell tCell3 = new TableCell();
  95.             tCell3.BorderWidth = 1;
  96.             tCell3.ID = name.Trim() + "Result";
  97.             tCell3.Text = statusCheck;
  98.             tRow.Cells.Add(tCell3);
  99.             wsDatabaseConnection.Rows.Add(tRow);
  100.  
  101.         }
  102.     }
  103.     [System.Web.Services.WebMethod]
  104.     public static string TestHTTP(string name)
  105.     {
  106.         //= "url";
  107.         string appKey = name;
  108.         string appKeyValue = ConfigurationManager.AppSettings.Get(appKey);
  109.  
  110.         if (appKeyValue.Contains("http"))
  111.         {
  112.             if (!(appKeyValue.Contains("wsdl") || appKeyValue.Contains("WSDL")))
  113.             {
  114.                 appKeyValue += "?wsdl";
  115.             }
  116.         }
  117.  
  118.         return ConnectionAvailable(appKeyValue) ? "<span style='color:Green'>Passedspan>" : "<span style='color:Red'>Failedspan>";
  119.  
  120.     }
  121.     public static bool ConnectionAvailable(string strServer)
  122.     {
  123.         try
  124.         {
  125.             HttpWebRequest reqFP = (HttpWebRequest)HttpWebRequest.Create(strServer);
  126.  
  127.             HttpWebResponse rspFP = (HttpWebResponse)reqFP.GetResponse();
  128.             if (HttpStatusCode.OK == rspFP.StatusCode)
  129.             {
  130.                 // HTTP = 200 - Internet connection available, server online
  131.                 rspFP.Close();
  132.                 return true;
  133.             }
  134.             else
  135.             {
  136.                 // Other status - Server or connection not available
  137.                 rspFP.Close();
  138.                 return false;
  139.             }
  140.         }
  141.         catch (WebException)
  142.         {
  143.             // Exception - connection not available
  144.             return false;
  145.         }
  146.     }
  147.  
  148.     [System.Web.Services.WebMethod]
  149.     public static string TestAllMapping()
  150.     {
  151.         StringBuilder stb = new StringBuilder();
  152.  
  153.         stb.AppendFormat("<tr style='height:10'><td><b>{0}b>td><td><b>{1}b>td><td><b>{2}b>td>tr>", "Table Name", "Exception", "Nhibernate Object");
  154.         using (OES.Library.nHibernate.Repository rep = new OES.Library.nHibernate.Repository())
  155.         {
  156.  
  157.             IDictionary allClassMetadata = rep.Session.SessionFactory.GetAllClassMetadata();
  158.             foreach (DictionaryEntry entry in allClassMetadata)
  159.             {
  160.                 try
  161.                 {
  162.  
  163.                     NHibernate.Persister.Entity.SingleTableEntityPersister tableEntity = entry.Value as NHibernate.Persister.Entity.SingleTableEntityPersister;
  164.                     if (tableEntity != null)
  165.                     {
  166.                         int index = tableEntity.ClassMetadata.EntityName.Split('.').Length;
  167.                         if (tableEntity.TableName.Split('.')[1] != tableEntity.ClassMetadata.EntityName.Split('.')[index - 1])
  168.                         {
  169.  
  170.                             rep.Session.CreateCriteria((Type)entry.Key)
  171.                                  .SetMaxResults(0).List();
  172.                         }
  173.                     }
  174.                 }
  175.                 catch (Exception exp)
  176.                 {
  177.  
  178.                     NHibernate.Persister.Entity.SingleTableEntityPersister tableEntity = entry.Value as NHibernate.Persister.Entity.SingleTableEntityPersister;
  179.  
  180.                     stb.AppendFormat("<tr><td>{0}td><td>{1}td><td>{2}td>tr>", tableEntity.TableName, exp.InnerException.Message, entry.Key);
  181.  
  182.  
  183.                 }
  184.             }
  185.             if (stb.Length == 0)
  186.             {
  187.                 stb.Append("Sucess");
  188.             }
  189.         }
  190.         return GenerateTable(stb).ToString();
  191.     }
  192.     private static StringBuilder GenerateTable(StringBuilder sbTableContent)
  193.     {
  194.         StringBuilder sbTable = new StringBuilder();
  195.         sbTable.AppendFormat("<Table cellspacing='0' border='1'>{0}Table>", sbTableContent.ToString());
  196.  
  197.         return sbTable;
  198.     }
  199. }




Posted by at No comments:

Friday, February 24, 2012

How to serialize and Object during debugging.

This is different. If you want to serialize an object directly in watch window, without having to goto immediate window, here is the code.

Utility.SerializeObject(quoteByIdResponse)



Code Snippet
  1. public static byte[] SerializeObject(object pObject)
  2.   {
  3.       byte[] xmlvalue = new Byte[0];
  4.  
  5.       MemoryStream memoryStream = new MemoryStream();
  6.       XmlSerializer xs = new XmlSerializer(pObject.GetType());
  7.       XmlTextWriter xmlTextWriter = new XmlTextWriter(memoryStream, Encoding.UTF8);
  8.       try
  9.       {
  10.           xs.Serialize(xmlTextWriter, pObject);
  11.           memoryStream = (MemoryStream)xmlTextWriter.BaseStream;
  12.           xmlvalue = memoryStream.ToArray();
  13.       }
  14.       catch (Exception e)
  15.       {
  16.  
  17.       }
  18.       finally
  19.       {
  20.           xmlTextWriter.Close();
  21.           xmlTextWriter = null;
  22.           memoryStream.Close();
  23.           memoryStream = null;
  24.           xs = null;
  25.       }
  26.       return xmlvalue;
  27.   }
  28.  
  29.   public static string SerializeObjectString(object pObject)
  30.   {
  31.       string XmlString = null;
  32.       StringWriter sw = new StringWriter();
  33.       XmlSerializer xs = new XmlSerializer(pObject.GetType());
  34.       try
  35.       {
  36.           xs.Serialize(sw, pObject);
  37.           XmlString = sw.ToString();
  38.       }
  39.       catch (Exception e)
  40.       {
  41.           XmlString = e.Message;
  42.           if (e.InnerException != null)
  43.               XmlString += " Inner Exception:" + e.InnerException.Message;
  44.       }
  45.       finally
  46.       {
  47.           xs = null;
  48.       }
  49.       return XmlString;
  50.   }
Posted by at No comments:

Tuesday, January 24, 2012

Weekly reports that needs to be sent manually.


Just want to write out the code for generating weekly reports. It is very boring to run the queries manually then paste in excel and send it out.
 
Code Snippet
  1. using System;
  2. using System.Data.OracleClient;
  3. using System.Text;
  4.  
  5. namespace WeeklyReports
  6. {
  7.  
  8.     public static class DateTimeExtensions
  9.     {
  10.         public static DateTime StartOfWeek(this DateTime dt, DayOfWeek startOfWeek) { int diff = dt.DayOfWeek - startOfWeek; if (diff < 0) { diff += 7; } return dt.AddDays(-1 * diff).Date; }
  11.     }
  12.  
  14.  
  15.     public partial class _Default : System.Web.UI.Page
  16.     {
  17.  
  18.  
  19.  
  20.         protected void Page_Load(object sender, EventArgs e)
  21.         {
  22.  
  23.             StringBuilder allTables = new StringBuilder();
  24.  
  25.             using (OracleConnection oraConn = new OracleConnection(@"Data Source=abc.world;Persist Security Info=True;User ID=abc;Password=abc;Unicode=True"))
  26.             {
  27.  
  28.                 DateTime monday = DateTime.Now.StartOfWeek(DayOfWeek.Monday);
  29.                 DateTime sunday = DateTime.Now.StartOfWeek(DayOfWeek.Sunday);
  30.                 monday = monday.AddDays(-7);
  31.  
  32.                 for (int ctr = 0; ctr < 10; ctr++)
  33.                 {
  34.  
  35.  
  36.  
  37.                     String strMonday = FormatDateToOracle(monday);
  38.                     String strSunday = FormatDateToOracle(sunday);
  39.  
  40.                    OracleCommand oraCmd = new OracleCommand(@"SELECT applicationname,  COUNT(*) FROM  EM_MONITOR.LOAD_DOT_NET_LOG_ERROR_PRD WHERE error_date BETWEEN '" + strMonday + "' AND '" + strSunday + "' AND   applicationname!='(null)' GROUP BY applicationname ORDER BY COUNT(*) DESC ", oraConn);
  41.  
  42.                   //  OracleCommand oraCmd = new OracleCommand(@"select * from (  SELECT COUNT(*),  MESSAGE FROM EM_MONITOR.LOAD_DOT_NET_LOG_ERROR_PRD WHERE error_date BETWEEN '" + strMonday + "' AND '" + strSunday + "'  AND applicationname!='(null)' GROUP BY MESSAGE ORDER BY COUNT(*) DESC  ) where rownum <= 5 ", oraConn);
  43.  
  44.                     oraConn.Open();
  45.                     OracleDataReader oraDr = oraCmd.ExecuteReader();
  46.  
  47.                     StringBuilder sbTable = new StringBuilder();
  48.  
  49.                     StringBuilder sbRows = new StringBuilder();
  50.  
  51.                     while (oraDr.Read())
  52.                     {
  53.  
  54.                         sbRows.Append("");
  55.                         for (int col = 0; col < oraDr.FieldCount; col++)
  56.                         {
  57.                             sbRows.Append("" + oraDr[col].ToString() + "");
  58.  
  59.                         }
  60.  
  61.                         sbRows.Append("");
  62.  
  63.                     }
  64.  
  65.                     sbTable.Append("" + sbRows + "
    "  + "For week " +  strMonday + " - " + strSunday + "
    "    );
  66.  
  67.                     allTables.Append(sbTable.ToString() + @"");
  68.                     oraConn.Close();
  69.  
  70.                     monday = monday.AddDays(-7);
  71.                     sunday = sunday.AddDays(-7);
  72.  
  73.                 }
  74.             }
  75.  
  76.             divTables.InnerHtml  = allTables.ToString();
  77.  
  78.         }
  79.  
  80.         private string FormatDateToOracle(DateTime date)
  81.         {
  82.             return date.ToString("dd-MMM-yyyy").ToUpper();
  83.         }
  84.  
  85.       
  86.     }
  87. }

Posted by at No comments:

Monday, August 29, 2011

Use regular expressions to save time.

Replace in files...

Utils.GetConfigValue\({"[a-zA-Z0-9_ ]+"}\)

to

System.Configuration.ConfigurationManager.ConnectionStrings\[\1\]
Posted by at No comments:

Wednesday, August 3, 2011

Sorting entries in config appsettings.

   How to sort AppSettings without manually missing any keys or important information.
Code Snippet
  1.   private void WriteAppSettingsToFile(string filename)
  2.     {
  3.  
  4.         List<string> lstConfigKeys = new List<string>();
  5.         foreach (string appKey in ConfigurationManager.AppSettings.AllKeys)
  6.         {
  7.             lstConfigKeys.Add(appKey);
  8.         }
  9.  
  10.         lstConfigKeys.Sort();
  12.  
  13.         using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:\" + filename + ".txt"))
  14.         {
  15.             foreach (string key in lstConfigKeys)
  16.             {
  17.                 file.WriteLine(string.Format("'{0}', -- {1}", key, ConfigurationManager.AppSettings.Get(key)));
  18.             }
  19.         }
  20.     }

You can modify the code to write the keys in the form of   . Then copy and paste the output to your actual config file. You have all the keys in sorted order. 
Posted by at No comments:
Labels:
Location: Plano, TX, USA

Monday, June 20, 2011

How to generate dynamic report.

Below is the code that I had written for generating dynamic report. It takes few parameters and generates the reports for a particular frequency.



using System;

using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;


namespace Reports.DynamicReports
{
///
/// Summary description for GetDynamicFrequencyReport.
///
public class GetDynamicFrequencyReport : System.Web.UI.Page
{
protected System.Web.UI.WebControls.PlaceHolder plResults;


ReportDS rds;
DataSet ds;


private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here

// Put user code to initialize the page here

int intid;
string strSourceid ;
int intCount=0;
DateTime dtFromDate;
DateTime dtToDate;
string strFrequency;

string strSourceFromDate;
string strSourceToDate;
string strSourceFrequency;

int inti;

if (Request["id"]!=null)
{
strSourceid = Request["id"];
strSourceFromDate = Request["fromdate"];
strSourceToDate=Request["todate"];
strSourceFrequency = Request["frequency"];

try
{
intid = int.Parse(strSourceid);
dtFromDate = DateTime.Parse(strSourceFromDate);
dtToDate = DateTime.Parse(strSourceToDate);
strFrequency = strSourceFrequency;

rds = new ReportDS();
ds = rds.GetDynamiFrequencyReport(intid,dtFromDate,dtToDate,strFrequency);

if (ds != null && ds.Tables.Count > 0 )
{
intCount = int.Parse(ds.Tables[0].Rows[0][0].ToString());


for (inti = 1; inti <= intCount ; inti++) { DynamicTables(inti); } } } catch(Exception ex) {} } } private void DynamicTables(int inti) { int intLabelTable; int intGridTable; intLabelTable = (inti * 2 )-1; intGridTable = (inti * 2 ); AddToPlaceHolder(CreateLabel(ds.Tables[intLabelTable].Rows[0][0].ToString())); AddToPlaceHolder(CreateDataGrid(ds.Tables[intGridTable])); } private void AddToPlaceHolder(Control oControl) { try { if (oControl != null) { plResults.Controls.Add(oControl); } } catch(Exception Ex) { } } private Label CreateLabel(string sText) { Label oControl = new Label(); oControl.Text = sText; oControl.Font.Name = "Verdana"; oControl.Font.Size = 11; oControl.Font.Italic = true; oControl.Font.Bold = true; return oControl; } private DataGrid CreateDataGrid(DataTable dt) { DataGrid oControl = new DataGrid(); // //
//
//

//
//
//


oControl.BorderColor= Color.Black;
oControl.BorderStyle = BorderStyle.None;
oControl.BorderWidth = System.Web.UI.WebControls.Unit.Pixel(1);
oControl.BackColor = System.Drawing.Color.FromArgb(247,247,247);
oControl.CellPadding = 4;
oControl.Font.Name = "Verdana";
oControl.Font.Size = 9;


//

oControl.AlternatingItemStyle.BackColor = System.Drawing.Color.FromArgb(235,235,235);

//


oControl.PagerStyle.ForeColor = System.Drawing.Color.FromArgb(51,00,153);
oControl.PagerStyle.BackColor = System.Drawing.Color.FromArgb(255,255,204);



oControl.GridLines= GridLines.Vertical;
oControl.CellPadding = 3;



oControl.FooterStyle.ForeColor=Color.Black;
oControl.FooterStyle.BackColor=Color.LightGray;

oControl.AlternatingItemStyle.BackColor =Color.Gainsboro;
oControl.ItemStyle.ForeColor = Color.Black;

oControl.HeaderStyle.Font.Bold = true;
oControl.HeaderStyle.ForeColor=Color.White;
oControl.HeaderStyle.BackColor=Color.Blue;

oControl.DataSource = dt;


oControl.DataBind();

return oControl;
}


#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}
}
Posted by at No comments:

Friday, May 6, 2011

Exciting effect.

I wanted to write a simple exciting effect for my blog at XO. I have decided to eliminate a bunch of lines of crappy code and put decent code which is simple and effective.

http://jsfiddle.net/vijayphani/reRJP/
Posted by at No comments:
Subscribe to: Posts (Atom)