IT Solution

2013-07-24T03:40:00.002-07:00

Hi this is my first post.. i am really getting confused regarding trigger.. please correct me if am wrong there is no way we can get output from trigger into our web forms.. right ?? So my question is what is the main use of trigger in a application and also if possible please tell me can i use in my online shopping system if its possible please clarify this using real world example. I know basic of that we can bind trigger or register trigger with some command like insert delete and so on. Is it only use for testing purpose only ?? Please i am not able to find any answer on google please help me out with this.

Display XML in Table Format

2012-11-19T23:28:00.000-08:00

XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.LoadXml(strXml);
            xmlReader = new XmlNodeReader(xmlDoc);

<table cellpadding="3" cellspacing="0" border="0" width="98%" class="border">
                <tr class="hrow">
                    <th>
                        Name</th>
                    <th>
                        Value</th>
                </tr>
                <%while (xmlReader.Read())
                  { %>
                <tr style="background-color: #E0E6F8; font-weight: bold;">
                    <td colspan="2">
                        <%=xmlReader.Name%>
                    </td>
                </tr>
                <%if (xmlReader.HasAttributes)
                  { %>
                <% while (xmlReader.MoveToNextAttribute())
                   {%>
                <tr>
                    <td>
                        <%=xmlReader.Name%>
                    </td>
                    <td>
                        <%=xmlReader.Value%>
                    </td>
                </tr>
                <%} %>
                <% xmlReader.MoveToElement(); %>
                <%} %>
                <%} %>
            </table>

Method To Create The PDF File From GridView In Asp.net

2012-06-30T05:01:00.000-07:00

protected void ExportToPDF(GridView gvuser, string fileName, bool isLastColVisible, bool isLogo)
{
if (gvuser == null)
return;
if (string.IsNullOrEmpty(fileName))
fileName = "Bucco.pdf";
gvuser = PrepareGridViewForExport(gvuser);
Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();

if (!isLastColVisible)
gvuser.Columns[gvuser.Columns.Count - 1].Visible = false;

//gvuser.RowStyle.Height = 20;
//gvuser.HeaderRow.Style.Add("height", "20px");
gvuser.GridLines = GridLines.Vertical;
gvuser.HeaderStyle.BackColor = System.Drawing.Color.Green;
gvuser.HeaderRow.Style.Add("background", "green");
gvuser.HeaderRow.Style.Add("font-size", "8px");
gvuser.Style.Add("text-decoration", "none");
gvuser.Style.Add("font-family", "Arial, Helvetica, sans-serif;");
gvuser.Style.Add("font-size", "6px");

gvuser.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(gvuser);
frm.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();

if (isLogo)
{
iTextSharp.text.Image gif = iTextSharp.text.Image.GetInstance(Server.MapPath("~/App_Themes/buco/images/logo.jpg"));
pdfDoc.Add(gif);
}
pdfDoc.Add(new Paragraph(fileName.Substring(0, fileName.IndexOf('.'))));
pdfDoc.Add(new Paragraph(" "));

htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}

Read Data From Excel Sheet In ASP.net or create dataset from excel sheet

2012-06-30T04:59:00.001-07:00

Here The Simple Method Which Make DataSet From Excel Sheet

Public dataset dataSetFromExcel(string filePath)
{

string SheetName = GetExcelSheetNames( filePath );
string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;'";
OleDbConnection con = new OleDbConnection(constring);
string sql = "select * from [" + SheetName + "]";
OleDbDataAdapter da = new OleDbDataAdapter(sql, con);
da.TableMappings.Add("Table", SheetName);
try
{

da.Fill(ds);
if (ds.Tables.Count > 0)
{
ViewState["data"] = ds;
}
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
if (con != null)
{
con.Close();
con.Dispose();
}
}

}

public static string GetExcelSheetNames(string excelFile)
{
OleDbConnection objConn = null;
DataTable dt = null;
try
{
String connString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + excelFile + "';Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(connString);
objConn.Open();
dt = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt == null)
{
return null;
}
string SheetName = "";
if (dt.Rows.Count > 0)
{
SheetName = dt.Rows[0]["TABLE_NAME"].ToString();
}
return SheetName;
}
catch (Exception ex)
{
ex.ToString();
return null;
}
finally
{
if (objConn != null)
{
objConn.Close();
objConn.Dispose();
}
if (dt != null)
{
dt.Dispose();
}
}
}

Create Generic List From Reader In ASP.net

2012-06-30T04:52:00.001-07:00

Here The Code By Using Which We Can Create a list from reader in C# ASP.net

public List<T> SelectAll(string constr, string table, object val)
{
List<T> list = new List<T>();

try
{
SqlConnection conn = Tools.GetConnection(constr);
IDbCommand command = Tools.GetSelectCommand(table, conn, "id", val);
IDataReader reader = command.ExecuteReader();

list = Cbo.FillCollection<T>(reader);
constr.cloase();
}
catch (Exception)
{

throw;
}

return list;
}

public static List<T> FillCollection<T>(IDataReader dr)
{
List<T> objFillCollection = new List<T>();
T objFillObject;

while (dr.Read())
{
// fill business object
objFillObject = CreateObject<T>(dr);
// add to collection
objFillCollection.Add(objFillObject);
}

if (!(dr == null))
{
dr.Close();
}

return objFillCollection;

}

private static T CreateObject<T>(IDataReader dr)
{
Type objType = null;

T obj = Activator.CreateInstance<T>();

List<PropertyInfo> properties = Helper.GetPropertyInfo(typeof(T));

int i;
for (i = 0; i < dr.FieldCount; i++)
{
string columnName = dr.GetName(i);
//now find matching property
PropertyInfo propMatch = properties.Find(delegate(PropertyInfo p)
{
Type t = typeof(T);
PropertyInfo pi = t.GetProperty(p.Name);
Column[] atrb = pi.GetCustomAttributes(typeof(Column), false) as Column[];
if (atrb != null)
{
if (atrb.Length > 0)
{
foreach (Column at in atrb)
if (at != null && !string.IsNullOrEmpty(at.Name))
{
return at.Name.ToLower() == columnName.ToLower();
}
}
}

return p.Name.ToLower() == columnName.ToLower();

});
if (propMatch != null)
{
//we have found a matching property. fill it in

if (Convert.IsDBNull(dr.GetValue(i)))
{
propMatch.SetValue(obj, Null.GetNull(propMatch), null);
}
else
{
try
{
// try implicit conversion first
propMatch.SetValue(obj, dr.GetValue(i), null);
}
catch
{
try
{
objType = propMatch.PropertyType;
// need to handle enumeration conversions differently than other base types
if (objType.BaseType.Equals(typeof(System.Enum)))
{
if (Helper.IsNumeric(dr.GetValue(i)))
{
propMatch.SetValue(obj, System.Enum.ToObject(objType, Convert.ToInt32(dr.GetValue(i))), null);
}
else
{
propMatch.SetValue(obj, System.Enum.ToObject(objType, dr.GetValue(i)), null);
}
}
else
{
propMatch.SetValue(obj, Convert.ChangeType(dr.GetValue(i), objType), null);
}
}
catch
{
propMatch.SetValue(obj, Convert.ChangeType(dr.GetValue(i), objType), null);
}
}

}

}
else
{
Console.WriteLine("property not found {0}", typeof(T).Name);
}
}

return obj;
}

FireFox Descriptions

2012-06-30T03:37:00.001-07:00

For Debugging of FireFox FireBug

For Coloring System rainbow

for screenshots AweSome Screen Shot for firefox

Converting DataReader To generic List Using C#...

2012-06-21T01:22:00.000-07:00

First make one class having similar attribute as you database table for eg:
        public class Student
        {
            public int ID { get; set; }
            public string Name { get; set; }
            public DateTime DateOfBirth { get; set; }

        }
after that
            List<Student> student = new List<Student>();
            SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Prac\TestAssembly\ForumsProjectCSharp\App_Data\Studetnt.mdf;Integrated Security=True;User Instance=True");
            SqlCommand cmd = new SqlCommand("select * from Student", conn);
            SqlDataReader dr;
            try
            {
                conn.Open();
                dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    student.Add(new Student()
                    {
                        ID = dr.GetInt32(dr.GetOrdinal("ID")),
                        Name = dr.GetString(dr.GetOrdinal("Name")),
                        DateOfBirth = dr.GetDateTime(dr.GetOrdinal("DateOfBirth"))
                    });
                    
                }
                dr.Close();
            }
            catch (Exception exp)
            {

                throw;
            }
            finally
            {
                
                conn.Close();
            }

new features added to sql server 2008

2012-06-13T23:32:00.004-07:00

• Database mirroring. Microsoft first introduced this feature
in SQL Server 2005 and enhanced it in SQL Server 2008.
Database mirroring provides data administrators a low-cost
disaster recovery solution.
• Service Broker. SQL Server Service Broker provides an
integrated infrastructure on which developers can create
asynchronous messaging applications.
• Policy-based management. SQL Server 2008 lets you
automatically enforce and monitor policies for database
operations. You can also push these policies to your servers.
• Resource Governor. The Resource Governor lets you limit
the resource consumption of incoming requests by
classifying incoming connections as specific workload types
and defining limits for those types. You can also redefine the
limits in real time.
• Backup compression. SQL Server 2008 can automatically
compress database backups, a feature previously available
only via the purchase of third-party software products.
• Performance data collection. SQL Server 2008 lets you
store performance data in a centralized database. It also
provides enhanced tools for analyzing and reporting on such
performance data.
• New data types. The new SQL Server 2008 FILESTREAM
data type allows you to store large binary data, such as
documents or images, directly in an NTFS file system. Other
new data types include support for spatial data and the time
date type.
• “Hot add” hardware. First introduced in SQL Server 2005,
hot add memory helps system administrators decrease
downtime when important memory upgrades are necessary.
On supported hardware platforms, SQL Server 2008 also lets
you add one or more CPUs while the program is running.

What's Difference Between SQL Server 2005 And SQL Server 2008..

2012-06-13T23:10:00.000-07:00

In sql server 2005,There is no option to compress backup files, but in sql server 2008,there you find it.

storing backup file takes 5 minutes without compression in sqlserver 2005,but it takes only 3 minutes in sql server 2008 for storing backup files with compression.

CPU is used to compress the data before it is written to disk,so less data is written to disk.

There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and want to use date and time data types, need to encrypt your databases, etc you will definitely want to look at 2008. The nice thing is that it upgrading should be much easier from 2005 to 2008 than it was from 2000 to 2005.

Server 2008 also added CMS which is Central Management Server. It only works with Windows Authentication but it allows you to management multiple SQL Servers at once. If SQL Server systems are popping up like weeds it will appear in the CMS provided that they point to the CMS via SSMS. Its a really cool feature.

PBM Policy-Based Management is another added feature introduced with SQL Server 2008. PBM allows you to define and enforce policies for configuring and managing SQL Server across your enterprise. It goes hand-in-hand with CMS.

One of my favorite is that fact that Reporting Services no longer requires IIS as it makes direct calls to HTTP.SYS.

SQL2008 has support for additional datatypes:
date
time
geospatial
timestamp with internal timezone

How I Make Excel Sheet From Genric List In Asp.net??

2012-06-05T20:51:00.002-07:00

This Is The Complete Method To export List Item Into Excel

public void ExportToExcel<T>(List<T> list)
{
int columnCount = 0;
DateTime StartTime = DateTime.Now;
StringBuilder rowData = new StringBuilder();
PropertyInfo[] properties = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
rowData.Append("<Row ss:StyleID=\"s62\">");
foreach (PropertyInfo p in properties)
{
if (p.PropertyType.Name != "EntityCollection`1" && p.PropertyType.Name != "EntityReference`1" && p.PropertyType.Name != p.Name)
{
columnCount++;
rowData.Append("<Cell ss:StyleID=\"s62\"><Data ss:Type=\"String\">" + p.Name + "</Data></Cell>");
}
else
break;
}
rowData.Append("</Row>");
foreach (T item in list)
{

rowData.Append("<Row>");
for (int x = 0; x < columnCount; x++) //each (PropertyInfo p in properties)
{
object o = properties[x].GetValue(item, null);
string value = o == null ? "" : o.ToString();
rowData.Append("<Cell ><Data ss:Type=\"String\">" + value + "</Data></Cell>");
}
rowData.Append("</Row>");

}
var sheet = @"<?xml version=""1.0""?>
<?mso-application progid=""Excel.Sheet""?>
<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet""
xmlns:o=""urn:schemas-microsoft-com:office:office""
xmlns:x=""urn:schemas-microsoft-com:office:excel""
xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet""
xmlns:html=""http://www.w3.org/TR/REC-html40"">
<DocumentProperties xmlns=""urn:schemas-microsoft-com:office:office"">
<Author>MSADMIN</Author>
<LastAuthor>MSADMIN</LastAuthor>
<Created>2011-07-12T23:40:11Z</Created>
<Company>Microsoft</Company>
<Version>12.00</Version>
</DocumentProperties>
<ExcelWorkbook xmlns=""urn:schemas-microsoft-com:office:excel"">
<WindowHeight>6600</WindowHeight>
<WindowWidth>12255</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>60</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID=""Default"" ss:Name=""Normal"">
<Alignment ss:Vertical=""Bottom""/>
<Borders/>
<Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000""/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>

<Style ss:ID=""s62"">
<Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000"" ss:Bold=""1""/>
</Style>
</Styles>
<Worksheet ss:Name=""Sheet1"">
<Table ss:ExpandedColumnCount=""" + (properties.Count() + 1) + @""" ss:ExpandedRowCount=""" + (list.Count() + 1) + @""" x:FullColumns=""1"" x:FullRows=""1"" ss:DefaultRowHeight=""15"">
" + rowData.ToString() + @"
</Table>
<WorksheetOptions xmlns=""urn:schemas-microsoft-com:office:excel"">
<PageSetup>
<Header x:Margin=""0.3""/>
<Footer x:Margin=""0.3""/>
<PageMargins x:Bottom=""0.75"" x:Left=""0.7"" x:Right=""0.7"" x:Top=""0.75""/>
</PageSetup>
<Print>
<ValidPrinterInfo/>
<HorizontalResolution>300</HorizontalResolution>
<VerticalResolution>300</VerticalResolution>
</Print>
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveCol>2</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name=""Sheet2"">
<Table ss:ExpandedColumnCount=""1"" ss:ExpandedRowCount=""1"" x:FullColumns=""1"" x:FullRows=""1"" ss:DefaultRowHeight=""15"">
</Table>
<WorksheetOptions xmlns=""urn:schemas-microsoft-com:office:excel"">
<PageSetup>
<Header x:Margin=""0.3""/>
<Footer x:Margin=""0.3""/>
<PageMargins x:Bottom=""0.75"" x:Left=""0.7"" x:Right=""0.7"" x:Top=""0.75""/>
</PageSetup>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name=""Sheet3"">
<Table ss:ExpandedColumnCount=""1"" ss:ExpandedRowCount=""1"" x:FullColumns=""1"" x:FullRows=""1"" ss:DefaultRowHeight=""15"">
</Table>
<WorksheetOptions xmlns=""urn:schemas-microsoft-com:office:excel"">
<PageSetup>
<Header x:Margin=""0.3""/>
<Footer x:Margin=""0.3""/>
<PageMargins x:Bottom=""0.75"" x:Left=""0.7"" x:Right=""0.7"" x:Top=""0.75""/>
</PageSetup>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>";
System.Diagnostics.Debug.Print(StartTime.ToString() + " - " + DateTime.Now);
System.Diagnostics.Debug.Print((DateTime.Now - StartTime).ToString());
string attachment = "attachment; filename=Report.xls";
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.AddHeader("content-disposition", attachment);
HttpContext.Current.Response.Write(sheet);
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.End();
}

2012-05-31T22:10:00.002-07:00

What Are Generics In C# ???

Introduction
Generics Are Very Use Full Feature Provided By C# And Its Introduced In C# 2.0, Actually Generics Allow Us To Declare A Type Safe Data Structure Without Commuting Actual Data Type, Higher Performance And Quality Code.

Let Us Take An Example Of Stack

If We Are Making A Stack Then

Class Stack
{

}

2012-05-29T22:16:00.002-07:00

Method To Convert A Number To String .

2012-02-28T04:11:00.000-08:00

This Method Returns The String Corresponding To Integer Value Entered By The User

public static string NumberToWords(int number)
{
if (number == 0)
return "zero";

if (number < 0)
return "minus " + NumberToWords(Math.Abs(number));

string words = "";

if ((number / 1000000) > 0)
{
words += NumberToWords(number / 1000000) + " million ";
number %= 1000000;
}

if ((number / 1000) > 0)
{
words += NumberToWords(number / 1000) + " thousand ";
number %= 1000;
}

if ((number / 100) > 0)
{
words += NumberToWords(number / 100) + " hundred ";
number %= 100;
}

if (number > 0)
{
if (words != "")
words += "and ";

var unitsMap = new[] { "zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen" };
var tensMap = new[] { "zero", "ten", "twenty", "thirty", "forty", "fifty", "sixty", "seventy", "eighty", "ninety" };

if (number < 20)
words += unitsMap[number];
else
{
words += tensMap[number / 10];
if ((number % 10) > 0)
words += "-" + unitsMap[number % 10];
}
}

return words;
}

For Getting PublicTokenKey

2012-01-25T00:19:00.001-08:00

Dynamic Menue With Event

2012-01-24T23:32:00.000-08:00

Adding Dynamic Menue With Event

Dim ReportItem As New System.Windows.Forms.ToolStripLabel

AddHandler ReportItem.Click, AddressOf RunTimeToolStripMenuItemForReport_Click
AisStatusStrip1.Items.Add(ReportItem)

Event Method
Private Sub RunTimeToolStripMenuItemForReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
{}

How i Get 5th Highest Salary in sql server 2005

2012-01-17T09:09:00.000-08:00

Create A table From Which 5th Highest Salary to be get
by using the command

create table employee ( code char(10),name varchar(200),sal float)

insert some values as

insert into employee values('1001','surender',20000)
insert into employee values('1002','dev',20000)
insert into employee values('1003','raj',25000)
insert into employee values('1004','narender',2000)
insert into employee values('1005','surender',50000)
insert into employee values('1006','surender',60000)
insert into employee values('1007','surender',70000)
insert into employee values('1008','surender',80000)
insert into employee values('1009','surender',90000)
insert into employee values('1010','surender',10000)
insert into employee values('1011','surender',5000)
insert into employee values('1012','surender',3000)
insert into employee values('1013','surender',7000)
insert into employee values('1014','surender',8000)
insert into employee values('1015','surender',9000)

getting all the salary in descending order

select * from employee order by sal desc

now to find top 5 th highest salary from employee table

select top 1 sal from
(
select distinct top 5 sal from employee order by sal desc
) a order by sal

Also We Can Make It General Query For Getting nth Highest Salary In Sql Server as

select top 1 sal from
{
select distinct top n sal from employee order by sal desc
} a order by sal

Concatenation of multiple rows of single column as a single data(row)

2012-01-02T04:33:00.000-08:00

select Classcode,Classname,

(select subject from ClassSubjectList+',' as 'data()' from ClassSubject for xml path('')) as subject

from Class

where Classcode='LKG'

how to use shortcut keys on the web form when using master page ( i.e inherited)

2011-12-30T23:14:00.000-08:00

What is difference betwen hash table and dictionary and which is best in which condition??

2011-12-27T08:24:00.000-08:00

Eval And Bind Methods For Asp.Net

2011-12-25T00:08:00.000-08:00

The asp.net Eval() and Bind() expressions are heavily used in asp.net GridView and DetailsView data bound controls. The difference between these two is that Eval is used for read only purpose and Bind is used for read/edit purpose.
Syntax For Using :
<%# Eval("Variable")%>
Here Variable is the Name Of Parameter U Want to Pass...

WCF Bindings

2011-12-22T08:35:00.000-08:00

BasicHttpBinding

It is suitable for communicating with ASP.NET Web services (ASMX)-based services that comfort with WS-Basic Profile conformant Web services.
This binding uses HTTP as the transport and text/XML as the default message encoding.
Security is disabled by default
This binding does not support WS-* functionalities like WS- Addressing, WS-Security, WS-ReliableMessaging
It is fairly weak on interoperability.

WSHttpBinding

Defines a secure, reliable, interoperable binding suitable for non-duplex service contracts.
It offers lot more functionality in the area of interoperability.
It supports WS-* functionality and distributed transactions with reliable and secure sessions using SOAP security.
It uses HTTP and HTTPS transport for communication.
Reliable sessions are disabled by default.

WSDualHttpBinding

This binding is same as that of WSHttpBinding, except it supports duplex service. Duplex service is a service which uses duplex message pattern, which allows service to communicate with client via callback.

In WSDualHttpBinding reliable sessions are enabled by default. It also supports communication via SOAP intermediaries.

WSFederationHttpBinding

This binding support federated security. It helps implementing federation which is the ability to flow and share identities across multiple enterprises or trust domains for authentication and authorization. It supports WS-Federation protocol.

NetTcpBinding

This binding provides secure and reliable binding environment for .Net to .Net cross machine communication. By default it creates communication stack using WS-ReliableMessaging protocol for reliability, TCP for message delivery and windows security for message and authentication at run time. It uses TCP protocol and provides support for security, transaction and reliability.

NetNamedPipeBinding

This binding provides secure and reliable binding environment for on-machine cross process communication. It uses NamedPipe protocol and provides full support for SOAP security, transaction and reliability. By default it creates communication stack with WS-ReliableMessaging for reliability, transport security for transfer security, named pipes for message delivery and binary encoding.

NetMsmqBinding

This binding provides secure and reliable queued communication for cross-machine environment.
Queuing is provided by using MSMQ as transport.
It enables for disconnected operations, failure isolation and load leveling

NetPeerTcpBinding

This binding provides secure binding for peer-to-peer environment and network applications.
It uses TCP protocol for communication
It provides full support for SOAP security, transaction and reliability.

How To Create Dynamic RDlC

2011-12-19T08:08:00.001-08:00

http://jclaes.blogspot.com/2009/05/programmaticallydynamically-building.html

I am looking Forward To It If I can Create Report Using this I Will Attach Another Post....

How To Lock Screen While Processing On Server Side

2011-12-18T07:25:00.000-08:00

Their Is Two things To Be Noted ..
1. CSS
2. Javascript

In CSS(Cascade Style Sheet) Their is not Much Popular Attribute which is z-index It is used to Make any Html Element On the Top Of All Html Element Which Is Decide On the Basis Of Its Value element having higher value of z-index is show

Now How To Lock screen On submit Button Click..

Style Sheet

<style type="text/css">
.LockOff
{
display: none;
visibility: hidden;
}

.LockOn
{
display: block;
visibility: visible;
position: absolute;
z-index: 999;
top: 0px;
left: 0px;
width: 105%;
height: 105%;
background-color: #fff;
text-align: center;
padding-top: 20%;
filter: alpha(opacity=100);
opacity: 0.80;
}
</style>

<script type="text/jscript">
function skm_LockScreen() {
var lock = document.getElementById('skm_LockPane');
if (lock)
lock.className = 'LockOn';
}

</scrip>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" OnClientClick="javascript:skm_LockScreen()" />

<div id="skm_LockPane" class="LockOff">
<img alt="Processing " height="60px" width="60px" src="Images/progress.gif" />
</div>

Get Columns and Tables Contain Word

2011-12-18T05:44:00.000-08:00

Get columns and tables contain word

select name as columnName,object_name(object_id)as tableName from sys.columns where object_id in
(select object_id from sys.tables where name like '%account%') and name like '%_%' order by tablename

For finding The Foreign Keys On Table

2011-12-18T05:42:00.001-08:00

Try This Out...

select * from (
Select object_name(rkeyid) Parent_Table,object_name(fkeyid) Child_Table,object_name(constid) FKey_Name,
c1.name FKey_Col,c2.name Ref_KeyCol
From
sys.sysforeignkeys s

Inner join sys.syscolumns c1
on ( s.fkeyid = c1.id And s.fkey = c1.colid )
Inner join syscolumns c2
on ( s.rkeyid = c2.id And s.rkey = c2.colid )

) t where child_table like '%ERP_Accounts%'
Order by Parent_Table,Child_Table