Sandeep Prajapati

Improve Performance by using OUTPUT in Insert Or Update Statement in single query

noreply@blogger.com (Sandeep Prajapati) — Sat, 07 Jan 2012 06:51:00 +0000

Hello friends,

recently I needed to fire a single SQL statement for Insert and Update and using the single statement I also needed to return the result of all Inserted/Updated Records details..

after searching a lot ... I came to know a very interesting way to perform both statement in single Query.

Generally for the scenario I got lots of suggestions to use Stored Procedure, but which was difficult for my scenario.

so I must get solution for it.

ok ok... let's come to point.

let's we have created a sample Table using the query

Create Table Table_1(Id Int Identity,Name nvarchar(100))

to insert records and get its generated Id
basically we perform like this

Insert into Table_1(Name) 
Select 'Sandeep'
Select @@IDENTITY

and same way for update
here the Updated value comes from other process which is not available Directly
[My case is only For Insert. but the concept we can use in Update also]

Declare @NewValue nvarchar(100)='Sandeep Prajapati'
Declare @ID int=1

Update Table_1
set Name=@NewValue
Where Id=@ID

select @ID as ID,@NewValue as Name

Now We can use OUTPUT key word to select the inserted/Updated Value to get affected rows in single query which also helps to improve performance.

Here is query for Insert

Insert Into Table_1(Name)
OutPut Inserted.Id,Inserted.Name
values('Sandeep')

after execution of the query the output is

Same way for Update

Update Table_1
set Name='Sandeep Prajapati'
OutPut inserted.ID,inserted.Name

Hope this helps...

Happy Coding...

Sample for WCF using json

noreply@blogger.com (Sandeep Prajapati) — Mon, 02 Jan 2012 12:07:00 +0000

Here is a sample for start WCF using json
in aspx page

  <script type="text/javascript">
        function ajaxService2() {
            serviceUrl = "http://localhost/WCFS/Service1.svc/GetData";
            var time = new Object();
            time.value = "1";
            $.ajax({
                type: "POST",
                url: serviceUrl,
                data: JSON.stringify(time),
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (transport) {
                    var string = transport;
                    $("#<%= Text2.ClientID %>").val(string);
                },
                error: function (ex) {
                    alert("error" + ex.responseText);
                }
            });
        }

        function ajaxService1() {
            serviceUrl = "http://localhost/WCFS/Service1.svc/GetAllProducts";
            $.ajax({
                type: "GET",
                url: serviceUrl,
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (transport) {
                    var string = transport;
                    $("#<%= Text1.ClientID %>").val(string);
                },
                error: function (ex) {
                    alert("error" + ex);
                }
            });
        }
    </script>
    <h2>
        Welcome to ASP.NET!
    </h2>
    <p>
        <p>
            <input id="Button2" onclick="ajaxService1()" value="Ajax call service 1" type="button">
            <asp:textbox id="Text1" runat="server" />
        </p>
        <p>
            <input id="Button3" onclick="ajaxService2()" value="Ajax call service 2" type="button">
            <asp:textbox id="Text2" runat="server" />
        </p>

Web.config Settings for WCF and json in WCF’s Web.config

<?xml version="1.0"?>

<configuration>
    <system.web>
        <compilation debug="true" targetFramework="4.0" />
    </system.web>
    <system.serviceModel>
        <services>
            <service name="WCFS.Service1">
                <endpoint
                address="" binding="webHttpBinding"
                behaviorConfiguration="EndBehave"
                contract="WCFS.IService1"/>
            </service>
        </services>
        <behaviors>
            <endpointBehaviors>
                <behavior name="EndBehave">
                    <webHttp/>
                </behavior>
            </endpointBehaviors>
            <serviceBehaviors>
                <behavior>
                    <serviceMetadata httpGetEnabled="true"  />
                    <serviceDebug  includeExceptionDetailInFaults="false" />
                </behavior>
            </serviceBehaviors>
        </behaviors>
        <serviceHostingEnvironment multipleSiteBindingsEnabled="true" aspNetCompatibilityEnabled="true" />
    </system.serviceModel>
    <system.webServer>
        <modules runAllManagedModulesForAllRequests="true"/>
    </system.webServer>
</configuration>

in WCF Interface

 // NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService1" in both code and config file together.
    [ServiceContract]
    public interface IService1
    {

        [OperationContract]
        [WebInvoke( ResponseFormat = WebMessageFormat.Json, Method = "POST", BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        string GetData(int value);

        [OperationContract]
        CompositeType GetDataUsingDataContract(CompositeType composite);

        [OperationContract]
        [WebInvoke(UriTemplate = "/GetAllProducts", ResponseFormat = WebMessageFormat.Json, Method = "GET")]
        List<product> GetAllProducts();
        // TODO: Add your service operations here
    }


    [DataContract]
    public class Product
    {
        [DataMember]
        public int ProdId { get; set; }
        [DataMember]
        public string PropName { get; set; }
        [DataMember]
        public int Quantity { get; set; }
        [DataMember]
        public int Price { get; set; }
    }

    // Use a data contract as illustrated in the sample below to add composite types to service operations.
    [DataContract]
    public class CompositeType
    {
        bool boolValue = true;
        string stringValue = "Hello ";

        [DataMember]
        public bool BoolValue
        {
            get { return boolValue; }
            set { boolValue = value; }
        }

        [DataMember]
        public string StringValue
        {
            get { return stringValue; }
            set { stringValue = value; }
        }
    }

Service Class

[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] 
    public class Service1 : IService1
    {
        public List<product> GetAllProducts()
        {
            return new List<product>
            {
                 new Product() {ProdId=101,PropName="Laptop",Quantity=200,Price=45000},
                 new Product() {ProdId=102,PropName="Desktop",Quantity=300,Price=35000},
            };
        }
        public string GetData(int value)
        {
            return string.Format("You entered: {0}", value.ToString());
        }

        public CompositeType GetDataUsingDataContract(CompositeType composite)
        {
            if (composite == null)
            {
                throw new ArgumentNullException("composite");
            }
            if (composite.BoolValue)
            {
                composite.StringValue += "Suffix";
            }
            return composite;
        }
    }

Happy Coding….

Session Timeout in IIS 7 - Worker Process of ApplicationPool

noreply@blogger.com (Sandeep Prajapati) — Wed, 21 Dec 2011 10:04:00 +0000

Problem
Recently while testing my application, I was facing problem of Session time out.
By Default Session time is 20 mins and I wanted to extend it
Attempts
if we want to extend it we can set in web.config within System.web tag
<sessionState mode="InProc" timeout="30"></sessionState>
that I already have done.
I set it as 30 mins.
but still my session was getting timed out after 20 min.
So I doubt that it doesn’t apply to my Code so I set It by code also like

System.Web.HttpContext.Current.Session.Timeout = 30;

still no progress

Resolutions

after a long invastigation I came to know Its because Of Default Settings of ApplicationPool for the application in IIS.

There is a setting for Worker process of IIS which will set memory and resource to allot to application application wide.

in my case I was testing my application alone. So application was being idle for more than 20 min to check weather session is alive or not..

To open the settings refer the steps

Type “inetmgr” in run window to open IIS

from left pane “Connections” select your application.

right click on your application and refer the image to open “Advanced Settings” of application(to check which ApplicationPool is referred by application )

from “Application Settings” window you can see the Name of ApplicationPool. like Asp.net V4.0, DefaultAppPool, Asp.net V4.0 Classic.

now close both opened windows.

from left pan double click on “Application Pools”, a list of created application pools will be displayed. if you want to create new application pool for specific application refer this

Right click on the ApplicationPool that was assigned to your Application and click on "Advanced Settings...."
in the popup window ... check the Idle time out for ... that cause the timeout while web application is idle.

Here are the steps to set Idle time..

Happy Deploying...

Steps to Remove Menu options in Export for Report Page in SSRS

noreply@blogger.com (Sandeep Prajapati) — Thu, 15 Dec 2011 14:51:00 +0000

Hi,
In SSRS(Sql Server Reporting Service), I wanted to remove extra options to export my report.

Here are the steps to remove option to export like (word, Excel, PDF, MHTML etc...) in SSRS (Sql Server Reporting Service)

Installation folder may be different from MSSQL.1, can be MSSQL.x (search for rsreportserver.config under Program Files\Microsoft SQL Server if not found)
Here are the steps for Disabling Excel Export Option in Reporting Services -

Go to Database server where reporting services is installed, open the rsreportserver.config file located at <Drive Letter>:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Go to section.
Change this entry to i.e. add Visible="false" for Excel rendering extension
Same for PDF.

Happy Reporting

Create Excel File From DataTable

noreply@blogger.com (Sandeep Prajapati) — Sat, 19 Nov 2011 04:56:00 +0000

Hello Friends,
Many times we need to create Excel files in our application using existing Data.
I have figured out a class which will help to create excel file by just passing DataTable and preferred location to generate on server.
please download the cs file from here .. and use it :)

here is full code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Xml;


    public class ExcelHelper
    {
        private static readonly ExcelHelper _instance = new ExcelHelper();

        public static ExcelHelper Instance
        {
            get { return _instance; }
        }
        /// <summary>
        /// Create one Excel-XML-Document with SpreadsheetML from a DataTable
        /// </summary>
        /// <param name="dataSource">Datasource which would be exported in Excel</param>
        /// <param name="fileName">Name of exported file</param>
        public void Create(DataTable dtSource, string strFileName)
        {
            // Create XMLWriter
            using (XmlTextWriter xtwWriter = new XmlTextWriter(strFileName, Encoding.UTF8))
            {

                //Format the output file for reading easier
                xtwWriter.Formatting = Formatting.Indented;

                // <?xml version="1.0"?>
                xtwWriter.WriteStartDocument();

                // <?mso-application progid="Excel.Sheet"?>
                xtwWriter.WriteProcessingInstruction("mso-application", "progid=\"Excel.Sheet\"");

                // <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet >"
                xtwWriter.WriteStartElement("Workbook", "urn:schemas-microsoft-com:office:spreadsheet");

                //Write definition of namespace
                xtwWriter.WriteAttributeString("xmlns", "o", null, "urn:schemas-microsoft-com:office:office");
                xtwWriter.WriteAttributeString("xmlns", "x", null, "urn:schemas-microsoft-com:office:excel");
                xtwWriter.WriteAttributeString("xmlns", "ss", null, "urn:schemas-microsoft-com:office:spreadsheet");
                xtwWriter.WriteAttributeString("xmlns", "html", null, "http://www.w3.org/TR/REC-html40");

                // <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
                xtwWriter.WriteStartElement("DocumentProperties", "urn:schemas-microsoft-com:office:office");

                // Write document properties
                xtwWriter.WriteElementString("Author", "Sandeep Prajapati");
                xtwWriter.WriteElementString("LastAuthor", "Sandeep Prajapati");
                xtwWriter.WriteElementString("Created", DateTime.Now.ToString("u") + "Z");
                xtwWriter.WriteElementString("Company", "XXXXXXXXXX");
                xtwWriter.WriteElementString("Version", "12");

                // </DocumentProperties>
                xtwWriter.WriteEndElement();

                // <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
                xtwWriter.WriteStartElement("ExcelWorkbook", "urn:schemas-microsoft-com:office:excel");

                // Write settings of workbook
                xtwWriter.WriteElementString("WindowHeight", "8010");
                xtwWriter.WriteElementString("WindowWidth", "14805");
                xtwWriter.WriteElementString("WindowTopX", "240");
                xtwWriter.WriteElementString("WindowTopY", "105");
                xtwWriter.WriteElementString("ProtectStructure", "False");
                xtwWriter.WriteElementString("ProtectWindows", "False");

                // </ExcelWorkbook>
                xtwWriter.WriteEndElement();

                // <Styles>
                xtwWriter.WriteStartElement("Styles");

                // <Style ss:ID="Default" ss:Name="Normal">
                xtwWriter.WriteStartElement("Style");
                xtwWriter.WriteAttributeString("ss", "ID", null, "Default");
                xtwWriter.WriteAttributeString("ss", "Name", null, "Normal");

                // <Alignment ss:Vertical="Bottom"/>
                xtwWriter.WriteStartElement("Alignment");
                xtwWriter.WriteAttributeString("ss", "Vertical", null, "Bottom");
                xtwWriter.WriteEndElement();

                // Write null on the other properties
                xtwWriter.WriteElementString("Borders", null);
                xtwWriter.WriteElementString("Font", null);
                xtwWriter.WriteElementString("Interior", null);
                xtwWriter.WriteElementString("NumberFormat", null);
                xtwWriter.WriteElementString("Protection", null);


                // </Style>
                xtwWriter.WriteEndElement();

                //<Style ss:ID="s16">
                xtwWriter.WriteStartElement("Style");
                xtwWriter.WriteAttributeString("ss", "ID", null, "s16");
                xtwWriter.WriteStartElement("Font");
                xtwWriter.WriteAttributeString("ss", "Bold", null, "1");
                xtwWriter.WriteAttributeString("ss", "Size", null, "11");
                xtwWriter.WriteAttributeString("ss", "Underline", null, "Single");
                xtwWriter.WriteEndElement();

                // </Style>
                xtwWriter.WriteEndElement();


                // </Styles>
                xtwWriter.WriteEndElement();

                // <Worksheet ss:Name="xxx">
                xtwWriter.WriteStartElement("Worksheet");
                xtwWriter.WriteAttributeString("ss", "Name", null, dtSource.TableName);

                // <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="3" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="60">
                xtwWriter.WriteStartElement("Table");
                xtwWriter.WriteAttributeString("ss", "ExpandedColumnCount", null, dtSource.Columns.Count.ToString());
                xtwWriter.WriteAttributeString("ss", "ExpandedRowCount", null, (dtSource.Rows.Count + 1).ToString());
                xtwWriter.WriteAttributeString("x", "FullColumns", null, "1");
                xtwWriter.WriteAttributeString("x", "FullRows", null, "1");
                //xtwWriter.WriteAttributeString("ss", "DefaultColumnWidth", null, "60");

                // Run through all rows of data source


                // <Row>
                xtwWriter.WriteStartElement("Row");
                foreach (DataColumn Header in dtSource.Columns)
                {
                    // <Cell>
                    xtwWriter.WriteStartElement("Cell");
                    xtwWriter.WriteAttributeString("ss", "StyleID", null, "s16");

                    // <Data ss:Type="String">xxx</Data>
                    xtwWriter.WriteStartElement("Data");
                    xtwWriter.WriteAttributeString("ss", "Type", null, "String");
                    // Write content of cell
                    xtwWriter.WriteValue(Header.ColumnName);

                    // </Data>
                    xtwWriter.WriteEndElement();

                    // </Cell>
                    xtwWriter.WriteEndElement();
                }

                xtwWriter.WriteEndElement();


                foreach (DataRow row in dtSource.Rows)
                {
                    // <Row>
                    xtwWriter.WriteStartElement("Row");

                    // Run through all cell of current rows
                    foreach (object cellValue in row.ItemArray)
                    {
                        // <Cell>
                        xtwWriter.WriteStartElement("Cell");
                        //if (cnt == 0)
                        //    xtwWriter.WriteAttributeString("ss", "StyleID", null, "s16");

                        // <Data ss:Type="String">xxx</Data>
                        xtwWriter.WriteStartElement("Data");
                        xtwWriter.WriteAttributeString("ss", "Type", null, "String");
                        // Write content of cell
                        string strcellValue = (cellValue == System.DBNull.Value ? string.Empty : (string)cellValue);
                        xtwWriter.WriteValue(strcellValue);

                        // </Data>
                        xtwWriter.WriteEndElement();

                        // </Cell>
                        xtwWriter.WriteEndElement();
                    }
                    // </Row>
                    xtwWriter.WriteEndElement();
                }
                // </Table>
                xtwWriter.WriteEndElement();

                // <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
                xtwWriter.WriteStartElement("WorksheetOptions", "urn:schemas-microsoft-com:office:excel");

                // Write settings of page
                xtwWriter.WriteStartElement("PageSetup");
                xtwWriter.WriteStartElement("Header");
                xtwWriter.WriteAttributeString("x", "Margin", null, "0.4921259845");
                xtwWriter.WriteEndElement();
                xtwWriter.WriteStartElement("Footer");
                xtwWriter.WriteAttributeString("x", "Margin", null, "0.4921259845");
                xtwWriter.WriteEndElement();
                xtwWriter.WriteStartElement("PageMargins");
                xtwWriter.WriteAttributeString("x", "Bottom", null, "0.984251969");
                xtwWriter.WriteAttributeString("x", "Left", null, "0.78740157499999996");
                xtwWriter.WriteAttributeString("x", "Right", null, "0.78740157499999996");
                xtwWriter.WriteAttributeString("x", "Top", null, "0.984251969");
                xtwWriter.WriteEndElement();
                xtwWriter.WriteEndElement();

                // <Selected/>
                xtwWriter.WriteElementString("Selected", null);

                // <Panes>
                xtwWriter.WriteStartElement("Panes");

                // <Pane>
                xtwWriter.WriteStartElement("Pane");

                // Write settings of active field
                xtwWriter.WriteElementString("Number", "1");
                xtwWriter.WriteElementString("ActiveRow", "1");
                xtwWriter.WriteElementString("ActiveCol", "1");

                // </Pane>
                xtwWriter.WriteEndElement();

                // </Panes>
                xtwWriter.WriteEndElement();

                // <ProtectObjects>False</ProtectObjects>
                xtwWriter.WriteElementString("ProtectObjects", "False");

                // <ProtectScenarios>False</ProtectScenarios>
                xtwWriter.WriteElementString("ProtectScenarios", "False");

                // </WorksheetOptions>
                xtwWriter.WriteEndElement();

                // </Worksheet>
                xtwWriter.WriteEndElement();

                // </Workbook>
                xtwWriter.WriteEndElement();

                // Write file on hard disk
                xtwWriter.Flush();
                xtwWriter.Close();
            }
        }
    }

Write me if help full
Happy Coding..

Scroll to particular record in GridView

noreply@blogger.com (Sandeep Prajapati) — Fri, 18 Nov 2011 06:31:00 +0000

Hello Friends,
here is a tip to scroll the gridview to particular record.
the basic concept is html scrolling. to scroll at particular position create an anchor tag with name as address (eg. #ScrollPoint '# is must')

now redirect the page to the location using javascript call

window.location.href = "#ScrollPoint";

same thing can be achieved by anchorlink href
here is sample code

HTML Page

<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="return MoveTo();" />
    <div style="height: 100px; overflow: auto;">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:TemplateField HeaderText="ID" SortExpression="ID">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ID") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <a name='<%# Eval("ID") %>'></a>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("ID") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            </Columns>
        </asp:GridView>
    </div>  


<script type="text/javascript">
        function MoveTo() {
            window.location.href = "#" + document.getElementById('<%= TextBox2.ClientID %>').value;
            return false;
        }
    </script>

Code Behind

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindControls();
            }
        }

        private void BindControls()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("ID");
            dt.Columns.Add("Name");
            for (int i = 0; i < 200; i++)
            {
                AddRow(dt);    
            }


            GridView1.DataSource = dt;
            GridView1.DataBind();

        }

        private static void AddRow(DataTable dt)
        {
            DataRow dr = dt.NewRow();
            dr["ID"] = dt.Rows.Count + 1;
            dr["Name"] = "Sandeep" + dt.Rows.Count + 1;
            dt.Rows.Add(dr);
        }
    }

Happy Coding...

Power of common table expression (CTE)

noreply@blogger.com (Sandeep Prajapati) — Wed, 14 Sep 2011 11:15:00 +0000

Hello friends,
Recently I came across a case where I was supposed to generate report for Customer based on services availed to him and for that I used A common table expression (CTE) and it really impressed.
initially I referred this great document of MSDN http://msdn.microsoft.com/en-us/library/ms190766.aspx
here is my Table of data.(Actual Tables are not like this, I have managed a simplified Table for the Demo.)

Here is query to generate Table

declare @t table (id int identity,CustID int, AgreementName varchar(100), ServDate Datetime,Price float)
insert @t select 70       ,'First Agreement',CONVERT(datetime,'2011-01-05'),10
insert @t select 70       ,'Second Agreement',CONVERT(datetime,'2011-01-06'),10
insert @t select 75       ,'First Agreement',CONVERT(datetime,'2011-03-14'),10
insert @t select 70       ,'Second Agreement',CONVERT(datetime,'2011-01-05'),30
insert @t select 75       ,'Third Agreement',CONVERT(datetime,'2011-01-05'),10
insert @t select 90       ,'Third Agreement',CONVERT(datetime,'2011-04-16'),20
insert @t select 75       ,'Third Agreement',CONVERT(datetime,'2011-05-05'),10
insert @t select 90       ,'Third Agreement',CONVERT(datetime,'2011-02-20'),90
select * from @t

The scenario is to display Customer’s total bill based on the services availed to him according to Service Agreement and Date..

And Expect out put is as follow

For that I used the following query

;with cteTable(CustID,combined,inx,price)
as
(
select CustID,  AgreementName + ' ['+ CONVERT(varchar,ServDate,106)+']'                        
, inx=ROW_NUMBER() over (PARTITION by CustID order by AgreementName, ServDate),Price
from @t t
)
,cteConcate(CustID,finalstatus,inx,Price1)
as
(
select CustID, convert(varchar(max),combined), 1,(price) from cteTable where inx=1
union all
select cteConcate.CustID, convert(varchar(max),cteConcate.finalstatus+', '+cteTable.combined), cteConcate.inx+1, cteTable.price
from cteConcate
inner join cteTable on cteTable.CustID = cteConcate.CustID and cteTable.inx=cteConcate.inx+1

)
select CustID, MAX(finalstatus) Description ,sum(Price1) Price from cteConcate group by CustID

if have any query please let me know.

Happy Coding….

Access UserControl from Page

noreply@blogger.com (Sandeep Prajapati) — Fri, 10 Jun 2011 10:47:00 +0000

Hi..
To perform some reparative operation in application, its preferred to use UserControls.
Not necessary to have same display and bindings at everyplace. In that case we need to set values or call methods or pass values accordingly.
Here I have tried to figure out three cases, Hope it is helpful.

Pass Table to Usercontrol and Set dynamically value to Controls
Set Properties of control
Call Usercontrol's Methods

Pass Table to Usercontrol and Set dynamically value to Controls
Here in my case, I am passing Table to a Predefined Usercontrol, Which contains a GridView And on top a Label which is passed as Property of UserControl
It will look like this

to code it try like this
Create a new Usercontrol page e.g. (DisplayControl.ascx)
The HTML will look like this

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="DisplayControl.ascx.cs"
    Inherits="UserControlSample.Controls.DisplayControl" %>
<center>
    <%= strTitle %></center>
<br />
<br />
<center>
    <asp:GridView ID="grdDisplay" runat="server" CellPadding="4" ForeColor="#333333"
        GridLines="None">
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        <EditRowStyle BackColor="#999999" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#E9E7E2" />
        <SortedAscendingHeaderStyle BackColor="#506C8C" />
        <SortedDescendingCellStyle BackColor="#FFFDF8" />
        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
    </asp:GridView>
</center>

in DisplayControl.ascx.cs file code will be like this

 protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {                
                BindGrid();
            }
        }

        private void BindGrid()
        {
            grdDisplay.DataSource = DtTable;
            grdDisplay.DataBind();
        }
        public string strTitle { get; set; }
        public DataTable DtTable { get; set; }

Now on Page where the Usercontrol is going to be displayed.

Here strTitle="Display Page" sets Title for UserControl

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeBehind="Default.aspx.cs" Inherits="UserControlSample._Default" %>

<%@ Register Src="Controls/DisplayControl.ascx" TagName="DisplayControl" TagPrefix="uc1" %>
<%@ Register Src="Controls/SetProperties.ascx" TagName="SetProperties" TagPrefix="uc2" %>
<%@ Register Src="Controls/AccessMethods.ascx" TagName="AccessMethods" TagPrefix="uc3" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h1>
        Pass Table to Usercontrol and Set dynamically value to Controls</h1>
    <hr />
    <uc1:DisplayControl ID="DisplayControl1" runat="server" strTitle="Display Page" />
  
</asp:Content>

on Code behind

  protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DisplayControl1.DtTable = GetTable();            
            }
        }

        private DataTable GetTable()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("ID");
            dt.Columns.Add("Name");

            DataRow dr = dt.NewRow();
            dr["ID"] = dt.Rows.Count + 1;
            dr["Name"] = "Sandeep";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["ID"] = dt.Rows.Count + 1;
            dr["Name"] = "Nilesh";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["ID"] = dt.Rows.Count + 1;
            dr["Name"] = "Kamal";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["ID"] = dt.Rows.Count + 1;
            dr["Name"] = "Esha";
            dt.Rows.Add(dr);

            return dt;
        }

Set Properties of control

Now Lets change property of any control of Usercontrol

Here we will change the orientation of Login Control as “Vertical” / “Horizontal”

The code on page where the control is called is

<uc2:SetProperties ID="SetProperties1" runat="server" CtrlOrientation="Horizontal" />

Here CtrlOrientation is Property which will expect value of Orientation Class that is “Vertical” / “Horizontal”

and on Usercontrol Drop “Login” Control

and in code

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                Login1.Orientation = CtrlOrientation;
        }

        public Orientation CtrlOrientation { get; set; }

Call Usercontrol's Methods

Call method of Usercontrol from Page.

Here I am binding same grid from Page.

to achive this in Usercontrol cs page

 public void BindGrid()
        {
            grdDisplay.DataSource = GetTable();
            grdDisplay.DataBind();
        }

here BindGrid() Method is public so we can access it from Page with Control.

like

AccessMethods1.BindGrid();

Download The Source

Hope this help you..

Enjoy Coding

Set Default Value as Function to column of a Table

noreply@blogger.com (Sandeep Prajapati) — Mon, 06 Jun 2011 12:05:00 +0000

Hello,
Generally we need to set default value to particular column in Database Table like isActive is true, IsDeleted is false.
same way many times we set CreatedOn Date as CurrentDate and that is by query of insert GetDate().
Static Values :
Its very easy to set some static value as Default value for column and that is as follow :

Functions :
Set Default Date for Createdon Field as Follow :

User Defined Functions :
Set User Defined function as Default Value as follow:
In my case I am supposed to get Random Hexa Code for Color. so I Have created an User Defined function for that

CREATE FUNCTION [dbo].[GetRandomColorCode]
( 
)
RETURNS varchar(6)
AS
BEGIN
Declare @Color varchar(6)
 RETURN (SELECT MyNewID FROM dbo.MyNewID)
END

Now set the function in columns as follow :

If this do not allow us to set Default value try following query to set

ALTER TABLE dbo.Table_1 ADD CONSTRAINT
 DF_Table_1_ColorCode DEFAULT ([dbo].[GetRandomColorCode]()) FOR ColorCode
GO

All the best

Happy Coding..

Track Error in Javascript Page

noreply@blogger.com (Sandeep Prajapati) — Thu, 26 May 2011 13:42:00 +0000

Hi
Many times we have faced problems to find what is javascript errors and exactly where??
To track javascript error, It is a good practice to write code in Try..Catch
but sometimes some small syntax error are not allowing to execute the whole js file.
so to track such error during development, we can track by this sample code

  <script type="text/javascript">
        onerror = CallOnError;
        function CallOnError(msg, url, line) {
            var strErrMessage = "";
            strErrMessage += "Message: " + msg + "\n";
            strErrMessage += "Page: " + url + "\n";
            strErrMessage += "Line Number: " + line + "\n\n";
            alert(strErrMessage);
            return true;
        }
    </script>

Here is a sample error

try to put on your page

  <script type="text/javascript">
            alert('This is First Test Page);
    </script>

Enjoy Coding

Second Highest Salary- Sql Query

noreply@blogger.com (Sandeep Prajapati) — Mon, 16 May 2011 09:29:00 +0000

Create Table #Emp(id int identity primary key,
    Emp varchar(100),
    Salary int)

insert into #Emp
select 'XXXX',17000 union all
select 'DDDD',21000 union all
select 'WWWW',30000 union All
Select 'HHHH',21000 union All
select 'CCCC',30000 union All
Select 'TTTT',21000 union All
SElect 'PPPP',21000

select * from #Emp

select #Emp.* 
from (select ROW_NUMBER() over (order by salary desc) as RowNumber, Salary
   from #Emp
    group by Salary) as tempEmp inner join #Emp on tempEmp.Salary = #Emp.Salary
   where tempEmp.RowNumber=2

Drop Table #Emp

Data Will Look like this

Output will be like this

Protect image from being copied

noreply@blogger.com (Sandeep Prajapati) — Fri, 29 Apr 2011 12:30:00 +0000

Hello Friends,

Many times I am asked to protect some copyrighted images over web,
so finally I have found a better way to protect from being copied.
There are some cases by which we can copy the image
Here I have taken care of following cases

Right click on image and Save the Image
Save the Entire page and all images displayed on page will be downloaded to its Data Folder
in mozila Firefox, We can save the media files by following steps
1. Right click on Page, select “View Page Info”
3. It will open a window, Select “Media” tab, here a list of all files will be available
4. select particular file and click on “Save As” button to save the media

Now Let’s Start our main topic,that is protect image from being copied
There is a concept called Data URI scheme.
Generally to display any image on page, we use Relative_URL and if we display image using this, the images can be easily copied.
Here we will save image in database and retrieve the same
To Create table

CREATE TABLE [dbo].[Images](
 [ImageID] [int] IDENTITY(1,1) NOT NULL,
 [ImageName] [varchar](50) NULL,
 [Image] [image] NULL,
 [ext] [varchar](50) NULL,
 CONSTRAINT [PK_Images] PRIMARY KEY CLUSTERED 
(
 [ImageID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Now,

the aspx page will be very simple like

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <table>
        <tr>
            <td>
                Name
            </td>
            <td>
                <asp:TextBox ID="txtName" runat="server" ValidationGroup="Uploadgrp"></asp:TextBox>
            </td>
            <td>
                <asp:RequiredFieldValidator ID="rfvdName" runat="server" ControlToValidate="txtName"
                    ValidationGroup="Uploadgrp" ErrorMessage="*"></asp:RequiredFieldValidator>
            </td>
        </tr>
        <tr>
            <td>
                Image
            </td>
            <td>
                <asp:FileUpload ID="flImgUpload" runat="server" />
            </td>
            <td>
                &nbsp;
            </td>
        </tr>        
        <tr>
            <td>
            </td>
            <td>
                <asp:Button ID="btnUpload" ValidationGroup="Uploadgrp" runat="server" OnClick="btnUpload_Click"
                    Text="Upload " />
            </td>
            <td>
                &nbsp;
            </td>
        </tr>
        <tr>
            <td>
            </td>
            <td>
                <asp:Label ID="lblMessage" runat="server"></asp:Label>
            </td>
            <td>
                &nbsp;
            </td>
        </tr>
    </table>
    <table>
        <tr>
            <td>
                <asp:Button ID="btnFetch" runat="server" OnClick="btnFetch_Click" Text="Fetch the Last image" />
            </td>
        </tr>
        <tr>
            <td>
                <img oncontextmenu="return false;" runat="server" id="imgDisplay" style="width: 400px; height: 400px;" />
            </td>
        </tr>
    </table>
</asp:Content>

here oncontextmenu="return false;" using this line of code you can prevent right click on image.

This will protect image to save by right click

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

namespace TestRequest
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        protected void btnFetch_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = ConfigurationManager.ConnectionStrings["TestBlogConnectionString1"].ConnectionString;
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "Select top 1 ImageName,Image,ext From Images order by imageid desc ";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            con.Open();
            SqlDataReader rd = cmd.ExecuteReader();
            rd.Read();
            imgDisplay.Src = GetBase64Image((byte[])rd["Image"], (string)rd["ext"]);
            con.Close();
        }
        protected void btnUpload_Click(object sender, EventArgs e)
        {
            string strImageName = txtName.Text.ToString();
            if (flImgUpload.PostedFile != null && flImgUpload.PostedFile.FileName != "")
            {
                byte[] imageSize = new byte[flImgUpload.PostedFile.ContentLength];
                HttpPostedFile uploadedImage = flImgUpload.PostedFile;
                string strext = flImgUpload.FileName.Substring(flImgUpload.FileName.LastIndexOf(".") + 1).ToLower();
                uploadedImage.InputStream.Read(imageSize, 0, (int)flImgUpload.PostedFile.ContentLength);

                SqlConnection con = new SqlConnection();
                con.ConnectionString = ConfigurationManager.ConnectionStrings["TestBlogConnectionString1"].ConnectionString;

                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = "INSERT INTO Images(ImageName,Image,Ext)  VALUES (@ImageName,@Image,@ext)";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;

                SqlParameter ImageName = new SqlParameter("@ImageName", SqlDbType.VarChar, 50);
                ImageName.Value = strImageName.ToString();
                cmd.Parameters.Add(ImageName);

                SqlParameter UploadedImage = new SqlParameter("@Image", SqlDbType.Image, imageSize.Length);
                UploadedImage.Value = imageSize;
                cmd.Parameters.Add(UploadedImage);

                SqlParameter Ext = new SqlParameter("@Ext", SqlDbType.VarChar, 50);
                Ext.Value = strext;
                cmd.Parameters.Add(Ext);

                con.Open();
                int result = cmd.ExecuteNonQuery();
                con.Close();
                if (result > 0)
                    lblMessage.Text = "File Uploaded";
                txtName.Text = string.Empty;
            }
        }

      
        private string GetBase64Image(byte[] data, string ext)
        {
            string binaryRepresenatation = string.Concat("data:image/" + ext + ";base64,", Convert.ToBase64String(data));
            return binaryRepresenatation;
        }
    }
}

the main game is

 private string GetBase64Image(byte[] data, string ext)
        {
            string binaryRepresenatation = string.Concat("data:image/" + ext + ";base64,", Convert.ToBase64String(data));
            return binaryRepresenatation;
        }

it will generate base64 format of byte[] of Image. and using Data URI scheme it generates image by CSS…

this is very common to implement and will help to protect image

click here to download the source
All the best

Fetch Data from Control Without Loop- Best Use of LINQ

noreply@blogger.com (Sandeep Prajapati) — Mon, 04 Apr 2011 13:22:00 +0000

Hi friends….

Many times I need to generate collection type Data from GridView or Repeater or any other control.. and in that case I used to loop through each rowitem of particular control..

here each row of repeater is listitem of LINQ query.

same way you can perform for all DataBound Controls like GridView, Repeater, DataList, DropDownlist, CheckboxList, Radiobuttonlist etc…

but after using LINQ, I am able to do that very easily

here is sample of Repeater control to Get List of data

List<ctrlInfo> ctrls = (from item in rptctrlList.Items.Cast<RepeaterItem>()

            where ((CheckBox)item.FindControl("chkctrl")).Checked

            select new ctrlInfo(){

                ctrlId = Convert.ToInt32(((HiddenField)item.FindControl("hdnctrlId")).Value),

                UserctrlId = Convert.ToInt64(((HiddenField)item.FindControl("hdnUserctrlId")).Value),

            }).ToList();

now I can pass XML to database from this List<ctrlInfo> using

XElement ctrlsXML = new XElement("ctrls");

            var ctrlXML = from ctrl in ctrls

                           select new XElement("ctrl",

                              new XElement("UserId", ctrl.UserId),

                              new XElement("ctrlId", ctrl.ctrlId),

                              new XElement("UserctrlId", ctrl.UserctrlId));

            ctrlsXML.Add(ctrlXML);

Now…. You can pass the XML to Stored Procedure. and in Stored Procedure

using

SELECT

                c.value('ctrlId[1]','int') As ctrlId

                , c.value('UserId[1]','BigInt') As UserId

                , c.value('UserctrlId[1]','BigInt') As UserctrlId

            FROM @ctrlIdListXML.nodes('/ctrls/ctrl')e(c)

you can have Table of selected records of Repeater control.

using merge statement you can perform operation.

Hope this Helps

All the Best

Apply Frame to Image with CSS

noreply@blogger.com (Sandeep Prajapati) — Fri, 01 Apr 2011 05:00:00 +0000

Hello

Many times we need to display image like profile image or advertisements

and at that time we need to decorate it within frame…

Here we have a simplest way to apply frame which will help to set frame to any size image and unique for all..

here I have a sample code for it

<html>

<head>

<style>

img {

    background: url("shadow.gif") no-repeat scroll right bottom transparent;

    border-color: #EEEEEE -moz-use-text-color -moz-use-text-color #EEEEEE;

    border-right: medium none;

    border-style: solid none none solid;

    border-width: 1px medium medium 1px;

    padding: 4px 10px 10px 4px;}

</style>

</head>

<body>

<img src='http://4.bp.blogspot.com/-AopW7qPMKPg/TX_vr-QT8CI/AAAAAAAAAe4/MwMlaUa3-1g/s220/Sandeep.JPG'>

</body>

</html>

and the you can have any kind of frame image

here I am uploading a sample image

and the output you will get is

All the Best

Publish webservice locally without separate hosting

noreply@blogger.com (Sandeep Prajapati) — Mon, 07 Mar 2011 11:40:00 +0000

Hi..

here is a way to deploy web service withing project...
Here are the steps for it

in your Project... right click on Project in Solution Explorer.

Click on Add new Item and Select "Web Service"

Name it as per required... and Click on "Add" Button...

now you have your web service ready in local environment...

put you code in Web Service .Cs file

Build the Source and make sure its error free...

now Deployment Part

Right click on "References" in Solution Exporer,

You will find.. three Options like

Add Reference
Add Web Reference
Add Service Reference

Select "Add Web Reference",

you will get a Pop up,

in Below there are three links
Browse to:

    * Web services in this solution
    * Web services on the local machine
    * Browse UDDI Servers on the local network

select "Web services on the local machine "

You will get a list of Web Services existsing on your local machine

select which one you created in current Project

it will be something like

http://localhost/TempProject/WebService1.asmx

now you will get a list of your methods of the web Service..

if till here everything is fine... that means you are going right....

Congratulations

At right side, in Web Reference Name if wish change the name , that name will be the Service name..

now click on "Add Reference"

now in your project you are able to run your service within your IIS.. without any external Deployment

Now whenever you update the Source of Service class... before building the source one update the Service Reference by right click on Service in Web reference Folder in solution explorer..

To change url of your Service...

Remove Url Value from Settings.

Steps

In Solution Explorer, In Properties Folder, double click on Settings.settings file
remove the path.
Now in Web.Config file set your Server path Instead of localhost

Now world is yours...

All The Best

Select Multiple Checkbox with Shift key in Gridview by javascript

noreply@blogger.com (Sandeep Prajapati) — Sun, 17 Oct 2010 20:02:00 +0000

Hello Friends,
Recently i was just looking at my Gridview where i have a checkbox in each row.. now i need to select all Check box.. for that lots of material is available on net..
and all are enough so i am not going to deep in it
check out this… http://www.codeproject.com/KB/grid/GridCheckBox.aspx

but now my problem was that i wanted to select few rows but not all
let’s say in my gridview the number of records are around 100.. and i want to check the checkbox of first 35 records
in that case i had to click on checkbox of all 35 rows.
i thought, like all mail accounts like gmail, yahoo, live and in may more…
i should be able to select multiple records by shift key.
means select the first record and pressing shift key select the 35st record so all the records in between will be selected..
and for that i found lots of jquery or any other javascripts.
but here i have tried to make something my own and i am happy to make it..

here is code

on Page

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
        <Columns>
            <asp:BoundField DataField="ID" HeaderText="Id" />
            <asp:BoundField DataField="Name" HeaderText="Name" />
            <asp:TemplateField>
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox1"

onclick="CheckAllCheckbox(document.getElementById('ctl00_ContentPlaceHolder1_GridView1'),this,event);"
                        runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>

on code Behind

protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           DataTable dt = new DataTable();
           dt.Columns.Add("ID");
           dt.Columns.Add("Name");
           DataRow dr;
           for (int i = 1; i < 130; i++)
           {
               dr = dt.NewRow();
               dr["ID"] = i;
               dr["Name"] = "Record No" + i.ToString();
               dt.Rows.Add(dr);
           }
           GridView1.DataSource = dt;
           GridView1.DataBind();
       }
   }

Javascript

var lst = null;
        function CheckAllCheckbox(ctrl, sValue, e) {
            var chkName = sValue.id;
            var arlstr = sValue.id.split(ctrl.id);
            var id = arlstr[1].split('_')[1].substring(3);

            var ee = (window.event) ? event : e;
            if (ee.shiftKey) {
                if (lst != null) {
                    var First = 0, last = 0;
                    if (parseInt(lst) > parseInt(id)) {
                        First = parseInt(id);
                        last = parseInt(lst);
                    }
                    else {
                        First = parseInt(lst);
                        last = parseInt(id);
                    }

                    for (i = First; i < last; i++) {                        
                        var p = (i <= 9 ? '0' + i : i);
                        var ctrlnew = chkName.replace('ctl' + id, 'ctl' + p);                        
                        document.getElementById(ctrlnew).checked = sValue.checked;
                    }                    
                }
            }
            lst = id;
        }

Here is the Source to Download

http://cid-552998535cb9985d.office.live.com/self.aspx/.Public/SelectWithShift.rar

Thanks

Epic Browser

noreply@blogger.com (Sandeep Prajapati) — Fri, 03 Sep 2010 19:58:00 +0000

Background of Epic

The Epic Browser is the first-ever web browser for India and the first product from the software company Hidden Reflex.

Hidden Reflex is a software product startup founded by Alok Bhardwaj in 2007 and based in Bangalore. Alok, who was raised in the U.S., was inspired by the success of open source software and web 2.0 innovations. Hidden Reflex began as a team of three but soon progressed and now has dedicated teams working on two products simultaneously – the Epic Browser and NewsDrink. The company also has three patents pending related to its product innovations.

The company’s vision is to become the first globally recognized, consumer-oriented software product company in India. According to Alok Bhardwaj, CEO and Founder of Hidden Reflex, “We want to prove that India can be a hub for innovation in software and technology."

Our mission with the Epic browser is to create the most secure, most productive and most “Indian” browsing experience of any web browser!

What Someone might need in a browser..

help to blog
news search
store personal data
upload data directly from browser that of our Hard Drive
multiple language
attractive theaming/background
faster
Various Social Networking sites updates
Mails updates
Antivirus
Online News Channel
and lot more

all this available in a single 9MB application that is Epic Browser

Interface

Please refer this page for mindblowing Interface http://www.epicbrowser.com/press.html

Every one must try Once...

Access ViewState From ClassFile

noreply@blogger.com (Sandeep Prajapati) — Sun, 29 Aug 2010 17:12:00 +0000

teHello Friends

Manytime we need to use ViewState while working 3-tier Architecture but its difficult to use it.
here i have made a sample to use Viewstate from Classfile

ViewState:
Viewstate is an object of Class StateBag

Here is sample of Viewstate in Class file
in this example we will add names from Textbox to gridview using Viewstate.
so
in code behind

<div>

Name :

<asp:TextBox ID="txtName" runat="server"></asp:TextBox><asp:Button ID="btnAdd" runat="server"

Text="Add" />

</div>

<div>

<asp:GridView ID="grvNames" runat="server" AutoGenerateColumns="False"

CellPadding="4" ForeColor="#333333" GridLines="None">

<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />

<Columns>

<asp:BoundField DataField="ID" HeaderText="No" />

<asp:BoundField DataField="SName" HeaderText="Name" />

</Columns>

<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />

<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />

<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

<EditRowStyle BackColor="#999999" />

<AlternatingRowStyle BackColor="White" ForeColor="#284775" />

</asp:GridView>

</div>

and in aspx.cs file

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

Controller_Default objController = new Controller_Default(this.ViewState);

btnAdd.Click += new EventHandler(objController.btnAdd_Click);

}

Now Create a Controller file named Controller_Default.cs in a Folder named Controller
The Code in the Controller Class will go like this

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Collections;

using System.Data;

using System.Web.UI.WebControls;

public class Controller_Default

{

#region Variables & contructors

IDictionary _ViewState;

public Controller_Default()

{

}

public Controller_Default(IDictionary objStageBag)

{

_ViewState = objStageBag;

}

#endregion

#region Events

/// <summary>

/// Button Event to Add Name

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

public void btnAdd_Click(object sender, EventArgs e)

{

Button btn = (Button)sender;

try

{

DataTable dt = new DataTable();

ViewStateClass objViewState = new ViewStateClass(_ViewState);

if (objViewState.GetViewStateTable("TblNames") != null)

dt = objViewState.GetViewStateTable("TblNames");

else

dt = CreateNewTable();

DataRow dr = dt.NewRow();

dr["ID"] = dt.Rows.Count + 1;

dr["SName"] = ((TextBox)btn.Parent.FindControl("txtName")).Text.ToString();

dt.Rows.Add(dr);

objViewState.SetViewState("TblNames", dt);

GridView grv = (GridView)btn.Parent.FindControl("grvNames");

grv.DataSource = dt;

grv.DataBind();

((TextBox)btn.Parent.FindControl("txtName")).Text = string.Empty;

((TextBox)btn.Parent.FindControl("txtName")).Focus();

}

catch (Exception Ex)

{

}

#endregion

#region Methods

/// <summary>

/// Method to Create New Table

/// </summary>

/// <returns></returns>

private DataTable CreateNewTable()

{

DataTable dt = new DataTable();

dt.Columns.Add("ID");

dt.Columns.Add("SName");

return dt;

}

#endregion

}

in this code we have created and object Named objViewState of class ViewStateClass.

The Syntex objViewState.GetViewStateTable("TblNames") is used to get DataTable from ViewState
Same way objViewState.SetViewState("TblNames", dt); Saves the DataTable in ViewState.

Now here is the class ViewStateClass , you can download it from here
in this class we have many methods to save different types like String,Int, Array and so on ... you can create same whichever you require.
you can download the source from Here

All The Best

Get Nth record from Table

noreply@blogger.com (Sandeep Prajapati) — Thu, 26 Aug 2010 18:08:00 +0000

Hello Friends Here is a simple query to get nth Record from Table

SELECT @NewPriority=Priority FROM ( SELECT Id,Priority, ROW_NUMBER() OVER (ORDER BY priority) as row FROM Job where IsDeleted=0 and Id not in (select jobId from Job_Cylinder where IsDeleted=0)) a WHERE row=@cnt-(@NewPriority)+1

There are many ways to get this.. All the Best

Light-weight Popup using CSS and Javascript..

noreply@blogger.com (Sandeep Prajapati) — Wed, 14 Apr 2010 18:13:00 +0000

Hello Friends
Once Again with a Rocking point we have seen lots of Popup till now…..
all are good at their places just search on Google “Model Popup” and you will get a long list of examples and javascripts for popup…
Ajax Control toolkit Model Popup Extender http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/ModalPopup/ModalPopup.aspx
then few more
http://www.modalpopups.com/blog/
http://www.jquery-dev.com/2008/12/02/jqmodal-jquery-modal-popup-plugin
one more javascript framework is Dojo http://www.dojotoolkit.org/
here i am also one type of popup… but i am sure you will like it
because it don’t require any kind of configuration and dependencies…

it is combination of CSS and javascript… with 70:30 ratio….
means here CSS is used more and rest is javascript….
then also its more power full

so from first sight you can determine its light–weight compare to other model popups

here i have an example…

   1: <input id="Button1" type="button"

   2:      value="Dispay Message" onclick="ShowDiv('DivPopUp')" />

Drop the control on which you want to fire ModelPopup.. and assign javascript event to fire onclick="ShowDiv('DivPopUp')"

if you are using server control like

   1: <asp:Button ID="Button2" runat="server" Text="Dispay Message" />

then at Server Side code….

in Page_Load Event

   1: Button2.Attributes.Add("onclick", "ShowDiv('DivPopUp')");

now

Put this block of code anywwhere in you page

<div id="DivPopUp" class="PopUpDiv">
       <div class="PopUpHeader" id="DivPopUpHeader">
           <div class="TitleLine">
               My PopUp
           </div>
           <div onclick="HideDiv('DivPopUp');" title="Close" class="CloseButton">
           </div>
       </div>
       <div id="Divcontent">
           <p>
               Your Content Goes Here</p>
       </div>
   </div>

“My PopUp” is the title of Modelpopup and put your content in “DivContent”

To make this idea sucessfull we have to add few CSS classes

<style>
        .PopUpDiv
        {
            background-color: White;
            border: 1px solid Black;
            position: fixed;
            display: none;
            top: 15%;
            width: 660px;
            left: 20%;
            padding: 0px;
            height: 450px;
            z-index: 2;
        }
        .PopUpHeader
        {
            font-size: small;
            font-weight: bolder;
            height: 45px;
            position: relative;
            background: url(bg.gif) repeat-x;
            top: 0px;
        }
        .CloseButton
        {
            background: url(close.png) no-repeat;
            float: right;
            cursor: pointer;
            width: 35px;
            height: 35px;
            right: -15px;
            top: -15px;
            position: absolute;
        }
        .TitleLine
        {
            text-align: center;
            float: left;
            width: 90%;
            color: Silver;
            line-height: 25px;
        }
        .LayerDiv
        {
            height: 100%;
            background-color: #030303;
            filter: alpha(opacity=60);
            opacity: 0.6;
            border: 1px solid black;
            position: fixed;
            left: 0;
            top: 0;
            width: 0%;
        }
    </style>

and few Javascript

<script type="text/javascript">
        function HideDiv(DivPopUp) {
            var DivPopUp = document.getElementById(DivPopUp);
            var DivLayer = document.getElementById('DivLayer');
            DivPopUp.style.display = "none";
            DivLayer.style.width = "0%";
        }
        function ShowDiv(DivPopUp) {
            var DivPopUp = document.getElementById(DivPopUp);
            var DivLayer = document.getElementById('DivLayer');
            DivPopUp.style.display = "block";
            DivLayer.style.width = "100%";
        }        
    </script>

here are two images which will help us to give quite descent look

we can also modify as per our requirement

LiveJournal Tags: JavaScript,css,jquery,Ajax Toolkit,Model Popup,Div

Click to Download the Source Here
CodeProject All The best… Hope you like this….

DataBase Specific Queries

noreply@blogger.com (Sandeep Prajapati) — Sat, 06 Mar 2010 21:09:00 +0000

Hello friends

Here are few Database Specific Queries

Select All Database list

1: SELECT [name] FROM sys.databases
2: SELECT [name] FROM sys.sysdatabases

This will Result

Select All Tables of particular Database.

1: SELECT Name, type,type_desc FROM sys.objects 
2: where Type='u'

This will Result

Here Fields Type and Type_Desc are

Type	Type_Desc
C	CHECK_CONSTRAINT
D	DEFAULT_CONSTRAINT
F	FOREIGN_KEY_CONSTRAINT
FN	SQL_SCALAR_FUNCTION
IF	SQL_INLINE_TABLE_VALUED_FUNCTION
IT	INTERNAL_TABLE
P	SQL_STORED_PROCEDURE
PK	PRIMARY_KEY_CONSTRAINT
S	SYSTEM_TABLE
SQ	SERVICE_QUEUE
TF	SQL_TABLE_VALUED_FUNCTION
TR	SQL_TRIGGER
U	USER_TABLE
UQ	UNIQUE_CONSTRAINT
V	VIEW

can be more than this…

Select Columns from particular Table

SELECT column_name as [Column Name],data_type as [Data Type],Character_maximum_length as [Character Maximum Length]
FROM information_schema.columns
WHERE table_name = 'table_1'

This will Result

All The Best

RemoteDataPass- pass data from one page to Remote Page

noreply@blogger.com (Sandeep Prajapati) — Fri, 05 Mar 2010 16:54:00 +0000

As i Committed in my previous post, that i will post code for ReportDataPass.

it is Quite difficult to pass Data from one Application to another application,
because here Cookie, Session variable will not help.
now a very simple way it Query string, But as our previous condition, we don’t want to use Query string.
so the last way..
Post Method
as we know, in any server side scripting languages, like asp, jsp, PHP.. on submit button, the Data is posted to another page or to itself.
and using Request[“Filedname”]
we can have its Value. the same logic we are going to apply..
but as we are using VS, where we have facilities of Masterpages and Content page,so when we are using any ContentPage, in that case we can not have form and its Post method.

So we are going to make a dynamic Html Page, and using dynamic Javascript we will post Data to another page.

So create a Class like this

public class RemoteDataPass
{
    
    private System.Collections.Specialized.NameValueCollection Inputs = new System.Collections.Specialized.NameValueCollection();
    public string PostUrl = "";
    public void Add(string FieldName, string Fieldvalue)
    {
        Inputs.Add(FieldName, Fieldvalue);
    }
  
    public void Post()
    {
        System.Web.HttpContext.Current.Response.Clear();
        System.Web.HttpContext.Current.Response.Write("<html><head></head><body onload=\"document.form1.submit()\">");
        System.Web.HttpContext.Current.Response.Write(string.Format("<form name=\"form1\" method=\"post\" action=\"{0}\" >", PostUrl));
        for (int i = 0; i < Inputs.Keys.Count; i++)
        {
            System.Web.HttpContext.Current.Response.Write(string.Format("<input name=\"{0}\" type=\"hidden\" value=\"{1}\">", Inputs.Keys[i], Inputs[Inputs.Keys[i]]));
        }
        System.Web.HttpContext.Current.Response.Write("</form></body></html>");        
        System.Web.HttpContext.Current.Response.End();
    }
}

now to post Data from our Source Page.

RemoteDataPass RemotePost = new RemoteDataPass();
        RemotePost.PostUrl = "http://ransandeep.blogspot.com/test.aspx";
        RemotePost.Add("FirstField", "Sandeep");        
        RemotePost.Post(); 

now at Receiving page

protected void Page_Load(object sender, EventArgs e)
   {
        if (Request.Form[ "FirstField" ] != null  )
        {
           Response.Write( "FirstField : "  + Request.Form[ "FirstField" ] +  "</br>" ) ;
        }         
   }

So this is Simple after getting know….

All the best..

Popup new Window by Javascript

noreply@blogger.com (Sandeep Prajapati) — Fri, 05 Mar 2010 16:19:00 +0000

A very Common trick
Open a new window as Popup by javascript…
Clicking on any Server Button

<asp:Button ID="Button1" 
                runat="server" 
                OnClientClick="window.open('Page2.aspx',null,'height=200,width=400   4:                         ,status=yes,toolbar=no,menubar=no,location=no,scroll=no');
                        return false;"

                Text="Button" />

All The Best..

IsCrossPagePostback–pass data from one page to another

noreply@blogger.com (Sandeep Prajapati) — Fri, 26 Feb 2010 20:11:00 +0000

Hello friends
again with new concept..

Page.IsCrossPagePostBack
in many case we are supposed to pass data from one page to another page.

So we can pass data through Querystring, Session variables,
this options are quiet helpful when Data is less in quantity.. but now what if we want whole page to another page… ?

and in previous page Data is in very big amount around 20 – 40 fields…
so it is not feasible to pass that data in querystring or storing all data in session.

there also another ways, like Cookie or hiddenfields using Post method.. but
all this require more trouble..

but what if we get previous page controls like it is “on same page”

for that we have a good option called IsCrossPagePostback

it is same like our Page.IsPostBack.
Page.IsPostBack treats only for current page’s postback
but to track weather postback is from Current page or previous page we can use IsCrossPagePostBack.

One Important Note : Respose. Redirect will not help us to track IsCrossPagePostBack
for that we must have Server.Transfer or PostbackURL of Button control

So here we have a sample of IsCrossPagePostBack

in First.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="First.aspx.cs" Inherits="First" %>
  
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>First Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="label1" runat="server" Text="This is First Page"></asp:Label>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Pass To Second Page" PostBackUrl="~/Second.aspx" />
    </div>
    </form>
</body>
</html>

Now in Second.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Second.aspx.cs" Inherits="Second" %>
  
<%@ PreviousPageType VirtualPath="~/First.aspx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Second Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server"></asp:Label>
    </div>
    </form>
</body>
</html>

in this page very important line is line no 3

here the Reference is set to inherit controls of Previous page

public partial class Second : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (PreviousPage != null && PreviousPage.IsCrossPagePostBack)
        {
            TextBox text = PreviousPage.FindControl("TextBox1") as TextBox;
  
            if (text != null)
            {
                Label1.Text = " This is from From First Page : " + text.Text;
            }
            else
            {
                Label1.Text = "Empty !!!!";
            }
        }
    }
}

in page load it is very easy to fetch data of previous page..

so this is very simple if the pages are within same project..

we will see very soon when page is in another project means RemotecrossPage

All The Best

Query for Recursive Data

noreply@blogger.com (Sandeep Prajapati) — Wed, 24 Feb 2010 20:13:00 +0000

Hi friends..

here is the query for Data kind of Recursive.
For Example….
for a particular thread in forum, its Comments
so in this case…
The Data structure will be like this
Table_3

Id	int
ThreadText	nvarchar(MAX)
PostedBy	int
PostedOn	DateTime
ParentId	int

Now if we want to have the hierarchical View of Data.
We can have query like this

SELECT     T2.id , T2.name ,T1.id as ParentId, T1.name as ParentName
FROM         Table_3 AS T1 INNER JOIN
                      Table_3 AS T2 ON T1.id = T2.parentid

now the Task is to Arrange the Data how you want to Display..

All the best