Showing posts from March, 2013

join two table using Linq

var quaryFirst = from RecordId in dtXMLFILE3.AsEnumerable()
                                 join rowId in dtXMLFILE4.AsEnumerable()
               on RecordId.Field<int>("ColumnName") equals rowId.Field<int>("ColumnName")
                                 join policy in dtXMLFILE5.AsEnumerable()
               on rowId.Field<int>("ColumnName") equals policy.Field<int>("ColumnName")
                                 select new
                                     Id = RecordId.Field<int>("ColumnName"),
                                     rId = rowId.Field<int>("ColumnName"),
                                     rr_Id = rowId.Field<int>("ColumnName"),
                                     source = rowId.Field<string>("ColumnName"),
                                     count = rowId.Field<string>("ColumnName"),

Merge Header or header and subheader in gridview

protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)

        if (e.Row.RowType == DataControlRowType.Header)
            //Build custom header.
            GridView oGridView = (GridView)sender;
            GridViewRow oGridViewRow = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert);
            TableCell oTableCell = new TableCell();

            //Add Department
            oTableCell.Text = "";
            oTableCell.ColumnSpan = 4;

            oTableCell.Style.Add("background-color", "#E0F0FD");
            oTableCell.Style.Add("border", "1px solid #8BB7D6");
            oTableCell.Style.Add("font-weight", "bold");
            oTableCell.Style.Add("font-family", "Arial,Helvetica,sans-serif");
            oTableCell.Style.Add("color", "#1077C4");

            //Add Emp

Microsoft 70-536 sample questions

Microsoft 70-536 sample questions

What are the restrictions imposed on the signature of a method that is called when a serialization event occurs?