Sandeep Prajapati - Asp.net

PAYU Plugin for NopCommerce

noreply@blogger.com (Sandeep Prajapati) — Mon, 22 Sep 2014 17:35:00 +0000

Hello

Download NopCommerce PayU plugin from http://www.nopcommerce.com/p/1556/payu-india-inr.aspx

To get the Plugin Please mail on prajapatisandeepk@gmail.com with Subject "PayU Plugin"

Nuget Package for Push Notification on Android and iOS

noreply@blogger.com (Sandeep Prajapati) — Mon, 23 Dec 2013 08:30:00 +0000

Continue to my previous post for Push Notification, I have generated a simplified process to implement Push notification for iOS and Android.

Anyone can download my Nuget package from https://www.nuget.org/packages/EasyPushNotification/

To install Push Notification for Android and iOS, run the following command in the Package Manager Console

PM> Install-Package EasyPushNotification

Web.config settings

Add following keys into AppSettings into web.config file.

<appSettings>
        <add key="APIKey" value="SOME_API_KEY"/>
        <add key="ApnsCertPath" value="CERTIFICATE_PATH"/>
        <add key="ApnsCertPassword" value="CERT_PASSWORD"/>
</appSettings>

For Android

APIKey is API key provided by GCM server. Follow the steps from here to generate project and obtain API key. The generated Project ID will be used to generate Device Token from Android devices.

For iOS

ApnsCertPath is the physical path where iOS apns certificate is stored. This should be a located into server and the path should be something like "~/Certificate_Folder/Certificate_Name.p12” follow the steps from here to generate certificate. (iOS developer might have better ideas how to generate certificate.)

ApnsCertPassword is password for certificate generate from above step.

Call Method

Use below code block to raise push notification.

string DeviceID = string.Empty;
string Message = string.Empty;
DeviceType DeviceType = DeviceType.Android;

NotificationInfo objNotificationInfo = new NotificationInfo();
bool result = objNotificationInfo.SendNotification(DeviceID, Message, DeviceType);

Parameters:

DeviceIDis Device token generate using phone and stored into database table using a service call.

Messageis string variable. The message is to be displayed as notification.

DeviceTypeis an Enum variable to decide whether the device is Android or iOS device. Fetch Device type from database which as stored with DeviceToken using service.

Returns:

Method will return Boolean result as success or failed.

ProcessResult will provide handled exception message.

isError is Boolean variable to indicate any error occurs.

Happy Mobilizing..

Push Notification for Android

noreply@blogger.com (Sandeep Prajapati) — Tue, 19 Nov 2013 10:11:00 +0000

Hello,

Now a Days in era of smart phones and mobile app developments, a very important feature is "Push Notification".

For any Mobile app (Android, iPhone, Blackberry, etc.) Push Notification is part of requirement and complete project.
To know more about Push notifications please Google !! here is a quick Wikipedia link.

In this post I am going to demonstrate Push notification for Android phones. As of now I don't have any Android device connected with my machine so can't get snapshots of result but one can trust me that whatever I have implemented is fully working.

OK.. So Let's Start ..........

Create an Asp.net application .(whatever you like..MVC, or anything)

I hope you are aware about NuGet Package Manager. if not refer official website of NuGet. visual Studio 2010 + comes up with inbuilt support of NuGet Packages. still can't find NuGet Packages into your Visual Studio Install from Website.
Once You are done with Above step, Right click on Solution of project. and Select "Manage NuGet Packages for Solution.."
"Manage NuGet Package" window will appear.
Thanks to "Redth", who has provided us a very useful NuGet Package Named "PushSharp"search from Right top search window for "PushSharp" and Select the First Package.
Click on "Install" Button. If Prompts to "Select Project", Select the Projects in which you would like to add reference of PushSharp library.Click OK.
Here we go.. Nuget Package Installation will start and wait until is completes.
Close all other open window. you can track output windows whether installation completed successfully. You can check in Project Reference, whether new references of PushSharp are assigned or not. If everything is good then let's move ahead Or feel free to post your problem. I will try my best to support you.

Now It's Time to create Project for Android Push Notification.

Please Follow the article to Create and Configure http://developer.android.com/google/gcm/gs.html (you might find some changes as recently Google has changed API Console UI. So try to push more efforts to understand)

Alright, I hope You have successfully Created Android API Project. It's very important part for Android push notification.

You might have come across two important Key works while creating Project.

Project Number : is used to generate Device Token from Android Device. The Project number keeps track of the notification raised for particular device consumes for which Project ID. You have to provide the Project number to Android phone developer. They will use the project number and Provide Device Token.
API key : API key secured key mandatory to pass while processing notifications.

Keep this information somewhere stored.

Now There are three important credentials required to accomplish Push notification for Android.

Device Token : using Project Number, Android Phone developer can provide the Device Token. I have no Idea how they does..
API Key : The API key provided by Project.
Message: The message to be passed on as Push Notification.

Basically, Some implicit or explicit action required to raise the Notification. In My Case I used to created a WCF Restful service (Sample Application). We had a message with minor database parameters to be passed. So Whenever the notification was supposed to raise, phone developers were making a request on my WCF service with Device Token as Parameter.

Here is code block to raise notification. Very short and simple !! :)

var push = new PushBroker();            
push.RegisterGcmService(new GcmPushChannelSettings(APIKey));            
push.QueueNotification(new GcmNotification().ForDeviceRegistrationId(DeviceTokenID)
                .WithJson("{\"message\":\"" + Message + "\"}"));

That's all. Done..

I have done few more push notification also using PushSharp.
Please feel free to contact me for any kind of assistance.

Custom Message box and Confirm window all in one

noreply@blogger.com (Sandeep Prajapati) — Wed, 21 Aug 2013 08:01:00 +0000

Hello,
I have created a custom message box and confirm window which can be used in all programming languages and all platforms.
syntex :

AlertCust([Control], {Message Title}, [Message Text], {IconType}, {PromptType}, [OnOk], [OnCancel]);

Description :

[Control] : Optional, Pass the control which raises the prompt. in Confirm or Alert window when click ‘OK’ button is clicked, the default server event will be executed, if value is passed. if null, clicking on ‘OK’ the prompt window will be closed, no further action.
{Message Title} : Required, Message Title. Title will appear in bold font.
[Message Text] : Optional, Message text in second line, in normal fonts.
{IconType} : Required, Enum values. pass icon type to display icon specific to message. options Error, Warning, Information
{PromptType} : Required, This property helps to decide what kind of prompt we need. e.g. Validation, MessageBox(OkOnly), OKCancel, YesNo.
[OnOk] : Optional, To provided custom callback method, set javascript method name, will be executed when clicked ‘OK’.
[OnCancel] : Optional, To provided custom callback method, set javascript method name, will be executed when clicked ‘Cancel’.

anyone can download code from Here

JavaScriptStringEncode : Javascript Compitable encoding

noreply@blogger.com (Sandeep Prajapati) — Thu, 01 Nov 2012 15:28:00 +0000

Hello,

Recently I was facing very interesting issue. and the solution for the issue was introduced in the new updates in asp.net framework 4.0.

Generally when we try to render HTML content on page clientside/ by javascript, it gives error of Potential dangerous content error.

http://msdn.microsoft.com/en-us/library/ms972967.aspx

There are lot's solutions but have to compromise security of page.
by setting

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="default.aspx.cs"
    Inherits="_default" ValidateRequest="false"%>

But now we have perfect solution which is introduced in .net framework 4.0

HttpUtility.JavaScriptStringEncode Method

URL encoding makes sure that all browsers correctly encodes text in URL strings. Few Characters such as a question mark (?), ampersand (&), slash (/), and spaces might be truncated or corrupted by some browsers. Therefore, these characters must be encoded in a elements or in query strings where the strings can be re-sent by a browser in a request string.

refer following MSDN link
http://msdn.microsoft.com/en-us/library/system.web.httputility.javascriptstringencode%28v=vs.100%29.aspx

http://msdn.microsoft.com/en-us/library/dd991914%28v=vs.100%29.aspx

Hope this helps

Disable Server Validation Control from ClientSide/ Javascript - ValidatorEnable

noreply@blogger.com (Sandeep Prajapati) — Tue, 16 Oct 2012 18:08:00 +0000

Hello Friends,

Recently I required to disable server validation control (RequiredFieldValidator, CompareValidator, CustomValidator, RangeValidator, RagularExpressionValidator, etc) from clientside/ Javascript.
There are few patches to accomplish the requirement by I liked an approach which is perfect for ClientSide handling.

ValidatorEnable is a javascript mathod lying at asp.net framework javascriptscript

ValidatorEnable(document.getElementById(myVal), Status);

Thanks

DateTime.ParseExact - culturewise Date Comparision

noreply@blogger.com (Sandeep Prajapati) — Sat, 04 Aug 2012 11:02:00 +0000

Hello..

Whenever dealing with cultures, DateTime format is always a headache to handle.

to the date format in Textbox sometimes does not meet the format of culture.
in that case DateTime.ParseExact is good option to handle.

convert the date into current culture format from display culture format using

public static DateTime ParseExact( string str, string Dateformat, IFormatProvider provider)

Parameters

str
Type: System.String
A string that contains a date and time to convert.

Dateformat
Type: System.String
A format specifier that defines the required format of s.

provider
Type: System.IFormatProvider
An object that supplies culture-specific format information about s.

example

DateTime sessionDate = DateTime.ParseExact(txtDate.Text, "M-d-yyyy", provider);

here provide is

CultureInfo provider = CultureInfo.InvariantCulture;

this will get txtDate.Text (Date) into culture wise date format to compare with database formatted datetime.

Hope this Helps

All the best.

Handle Devide By Zero Error

noreply@blogger.com (Sandeep Prajapati) — Tue, 14 Feb 2012 12:47:00 +0000

Hi ..
set Arithaboth and Ansi_Warnings as OFF to handle devide by Zero or any kind of arithmatic errors

SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
Declare @Denominator int =0
Declare @Numerator int =5
SELECT isnull(@Numerator / @Denominator,0) as Result

happy coding....

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 ctrls = (from item in rptctrlList.Items.Cast()
                                    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

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...