Nodejs MongoDB .NET SqlServer Tips & Tricks

MongoDB - How to reduce storage size after deleting documents on replica set?

2018-10-31T16:19:00.002+05:30

MongoDB does not free the disk space for OS use after deleting bunch of documents from the collection. We can reclaim that space using following cases.

By using compact command - Can be run on collections, but block all orations on database, need small downtime
By using repaireDatabase - Run on database need extra space and serious downtime
By dumping database and than drop and restore it - Time consuming and need downtime
By copy database using temporary name drop original and then re copy with original name - Time consuming and need downtime

Following is the best method of achieve same without downtime on replica set

Step down secondary server
Delete database files
Start server, It will start Replica Set Initial Sync.
After sync over do the same with other secondary servers one by one
For primary server step it down.
Make sure one of the secondary become primary
Delete database file on primary
Start primary server It will start Replica Set Initial Sync.
After Replica Set Initial Sync complete it will become primary as per your replica set configuration
Done, that's it..

Check used disk space on each server..

MongoDB Exact Word Search Without $text

2017-08-23T10:35:00.002+05:30

We can use simple $regex to find out documents with specific field have exact word in string value

For Example

Let's say we have following documents in collection sampledata

{
    _id : ObjectId("583bbccc592818101fb7f3f8"),
   "textdata" : "This is sample text data",
},
{
    _id : ObjectId("583bbccc592818101fb7e43w"),
   "textdata" : "data use by default",
},
{
    _id : ObjectId("583bbccc592818101fb723ed"),
   "textdata" : "bird can fly, This is not always true",
}

1 - Now we want only document which have "textdata" contains word "data"

db.sampledata.find({ "textdata" : { $regex : /\bdata\b/ })

Above query will return following documents

{
    _id : ObjectId("583bbccc592818101fb7f3f8"),
   "textdata" : "This is sample text data",
},
{
    _id : ObjectId("583bbccc592818101fb7e43w"),
   "textdata" : "data use by default",
}

2 - Now want only document which have "textdata" contains word "use"

db.sampledata.find({ "textdata" : { $regex : /\buse\b/ })

Above query will return following documents

{
    _id : ObjectId("583bbccc592818101fb7e43w"),
   "textdata" : "data use by default",
}

This will be helpful when your string data contains lots of words and you don't want to create $text index to minimize ram usages. For better performance use this trick with some index fields in where clause to narrow down document examine count.

To implement full text search in MongoDB use $text, You can search documents by word using $text when fields have text index (MongoDB official document on that)

FULL OUTER JOIN into the SQL Server query

2012-10-01T15:34:00.002+05:30

Full outer join is use full when we need following kind of result from tow individual queries

Result 1

IdColumn	Data1
1	Hello1
2	Hello2
.	.
.	.
10	Hello10

Result 2

IdColumn	Data2
1	Hi1
2	Hi2
.	.
.	.
10	Hi10

Final Result = Result 1 + Result 2

IdColumn	Data1	Data2
1	Hello1	Hi1
2	Hello2	Hi2
.	.	.
.	.	.
10	Hello10	Hi10

{{ For Example }}

select isnull(A.Id,B.Id) as Id , A.*, B.*
from
( select IdColumn as Id,* from xyz ) A
full outer join
( select IdColumn as Id,* from abc ) B
on A.Id = B.Id

{{ NOTE }}

You have to care about null in the result set when there are no data in either table for the respected IDs.

Single Quote (') into the data control bind system <%# %>

2012-09-21T15:56:00.000+05:30

Here is Tips to put single quote ( ' ) into the data bind control binding syntax that is <%# ... %>

For Example:

OnClientClick=<%# "xyz('" + Eval("DataColumn").ToString() "'); return false;" %>

Direct put the binder syntax after = of the property you want to bind, don't use single or double quote. And put any string constant before and after your Eval("").

It is use full when we want to call javascript function on the click event of link,button,image etc controls.

SqlConnection from ObjectContext.Connection

2012-09-14T12:01:00.008+05:30

Following is C# code to get the SqlConnection from ObjectContext.Connection.
This is usefully to run dynamically created query using ADO.NET using connection string specified into the EDMX ObjectContext object.

C# Code Example :

using (EntityContext context = new EntityContext())
{
EntityConnection ec = (EntityConnection)context.Connection;
SqlConnection sc = (SqlConnection)ec.StoreConnection;

SqlDataAdapter da = new SqlDataAdapter(strQuery, sc);
DataSet ds = new DataSet();
da.Fill(ds);

return ds.Tables[0];

}

Set focus on selection of date from jQuery datepicker to control it self

2012-05-09T16:27:00.000+05:30

Following is the jQuery code to set focus on control after selecting the date from the jQuery Date Picker

jQuery.extend(jQuery.datepicker, { afterShow: function (event) {
jQuery.datepicker._getInst(event.target).dpDiv.css('z-index', 99999999);
}
});

jQuery(function(){
$("#divGameQuestionPanel [datepicker]").datepicker({
changeMonth: true,
changeYear: true,
yearRange: 'c-99:c+0',
showOn: "button",
buttonImage: calImageSrc,
buttonImageOnly: true,
dateFormat: 'dd/mm/yy',
onSelect: function (dateText, inst) { $(this).focus(); }
}).focus(function (event) {
jQuery.datepicker.afterShow(event);
});
});

Developer must have Browser Addons list

2012-05-09T16:25:00.000+05:30

Google Chrom

1) Chrome - use full to select color and its different sades

https://chrome.google.com/webstore/detail/gefgglgjdlddcpcapigheknbacbmmggp

Live website to use it without add into the browser

http://lucumalabs.com/chroma

LINQ union with group by

2011-11-01T16:19:00.001+05:30

In my recent development activity with LINQ query, I need to get the some of user points from tow different tables where user's points are based on some activities. There are many users who are into one table but not in another table and some are in both table.

For example tables having data like this

Table 1
UserID Points
1 10
2 20

Table 2
UserID Points
2 20
3 30

Result should be
UserID Points
1 10
2 40
3 30

I try to get this result with LINQ query using joins and group by samples from the web.
I had googling to get something useful but dont get any success.

So I try with new logic and here it is, I think it will help full to other also.

Example Item class to use

public class Item
{

public int ID { get; set; }

public int Total { get; set; }

public Item()

{

}

public Item(int ID, int Total)

{

this.ID = ID; this.Total = Total;

}

Code to get result

class Program
{

static void Main(string[] args)

{

List<Item> i1 = new List<Item>();

i1.Add(new Item(1, 10));

i1.Add(new Item(2, 20));

List<Item> i2 = new List<Item>();

i2.Add(new Item(2, 20));

i2.Add(new Item(3, 30));

var result = (from c in i1.Union(i2)

group c by c.ID

into g

select new

{

ID = g.Key,

Total = g.Sum(c=>c.Total)

}).ToList();

foreach (var r in result)

{

Console.WriteLine("ID {0} total {1}", r.ID, r.Total);

}

Console.ReadLine();

}

It is simple console code in c# to demonstrate the logic.

JQuery Tool Tip plug in Tipsy

2011-01-08T12:27:00.001+05:30

You may found many jQuery tooltip plug in from the web. Here I am going describe the one of them which one is the best as per my opinion to use with the ASP.NET.

JQuery Tool Tip plug in Tipsy.

You can get the more information and how it work by click over here.

Following are the Steps to use this wonder full plug in into you asp.net page.

Step 1: Download the latest Jquery library js. and Tipsy plug in js.

Step 2: Add the reference of these js file into the page header. JQuery library js must be added before the Tipsy plug in js.

Step 3: Now add the following Java script block at the end of you .aspx page.

$(document).ready(function() {
$("*[title]").tipsy({ gravity: $.fn.tipsy.autoNS });

})

Step 4: You done with it. Enjoy the exiting Tool tip on your page.

NOTE: If you are going to use the partial page post back. In simple word if you are going to use update panels in you page then you have add following code into you Page_Load event.

ScriptManager.RegisterStartupScript(UpdatePanel1, GetType(), "tooltip", "$('div[class*=\"tipsy\"]').remove(); $('*[title]').tipsy({ gravity: $.fn.tipsy.autoNS });", true);

Please visit the Tipsy site to know how to change the CSS and default behaviour of the plug in to make it customize as per your need.

Radio Button in Grid View

2010-07-22T17:08:00.002+05:30

I had use radio button in grid view into my recent development.

Radio button Group problem in Grid view

I found that radio button is not create group when they are render on client side into grid rows because of the automated id and name creation of the asp.net.

Radio button checked property problem in Grid view on server side code

One more problem I found that when we iterate through grid view rows on server side code. I can find the radio button using the rows[0].findcontrol('id') method but its always give me a checked value false.

Following is solution I applied into my development to get out of this tow.

I replace Radio button server control with the HTML input control with type radio.

~~<asp:RadioButton ID="RadioButton1" runat="server" />~~

Apply server side binding to the value property of it.

I used jquery to change the name attribute of the radio button to make them grouped. (you can used you own java script code to do that)

$(document).ready(function() {
$(".rbclass").attr("name", "groupname");

});

When I want the selected value at time of the postback I used request.form["group name"].

string radiovalue = Convert.ToString(Request.Form["groupname"]);

ExecuteScalar function with Generic Data Type

2010-07-06T14:55:00.000+05:30

Here is the static function which will Generic Data Type to get the scalar value from the query passed to the ExecuteScalar function of the SqlCommand object.

You have to pass the query and the connection string as parameter to it.

public static T ExecuteScalar<T>(string query, string strConnection)
{
            SqlConnection con = new SqlConnection(strConnection);

            SqlCommand sc = new SqlCommand();
            sc.CommandText = query;
            sc.Connection = con;
            try
            {
                con.Open();
                return (T)(sc.ExecuteScalar());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
                con.Dispose();
                sc.Dispose();
            }
        }

Convert Generic List to CSV

2010-05-17T13:16:00.000+05:30

In my recent development with c#, I have to code for the functionality to Convert one Generic list of class XYZ to CSV downloadable File with dynamically suppress some of the column and different descriptive headers then the properties name for the column.

So I develop one Generic function which will convert List to CSV and return the string, which will then wrapped to Http Response to available as downloadable file.

Here is a Function which will convert List of Generic type T to CVS format string with 2 arguments. First Argument is List of objects to be converted into CSV and second is the 2 dimensional string array with the name of properties of object to be include in conversion with the Header Text for that properties to use while it is converting into CSV.

private static string ListToCsv(ref List<T> list, string[,] HeaderAndColumns)

{

if (list == null || list.Count == 0) return "";

Type t = typeof(T);

int lenght = HeaderAndColumns.GetLength(0);

StringWriter sw = new StringWriter();

// Create Header Row..

for (int l = 0; l < lenght; l++)

{

sw.Write(HeaderAndColumns[l, 0].Replace(',', ' '));

if (l < lenght - 1)

sw.Write(",");

}

sw.Write(sw.NewLine);

//this acts as datarow

foreach (T item in list)

{

for (int i = 0; i < lenght; i++)

{

string whatToWrite =

Convert.ToString(item.GetType().GetProperty(HeaderAndColumns[i, 1]).GetValue(item, null)).Replace(',', ' ');

if (i < lenght - 1)

whatToWrite += ",";

sw.Write(whatToWrite);

}

sw.Write(sw.NewLine);

}

return sw.ToString();

}

If we have class XYZ as follow

public class XYZ

{

public string prop1 { get; set; }

public string prop2 { get; set; }

}

And we want to convert list of XYZ's object (List<XYZ>) to CSV we have to call the function like following

// 2D string arry , 1st is header , 2nd is Property name

string[,] HeaderAndColumns = new string[,] {

{"Header 1", "prop1"},

{"Header 2","prop2"}

};

string strCSV = ListToCsv(ref list, HeaderAndColumns);

To warp is with Http Response you can use following code. This will help you to through the converted CSV string as downloadable file.

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.AddHeader(

"content-disposition", string.Format("attachment; filename={0}", filename));

HttpContext.Current.Response.ContentType = "application/ms-excel";

using (StringWriter objSw = new StringWriter())

{

string[,] HeaderAndColumns = new string[,] {

{"Header 1", "prop1"},

{"Header 2","prop2"}

};

objSw.Write(ListToCsv(ref list, HeaderAndColumns));

HttpContext.Current.Response.Write(objSw.ToString());

HttpContext.Current.Response.End();

}

How to set culture of asp.net page

2010-03-24T16:20:00.002+05:30

Here I show you how to set the culture of your asp.net page through code.

To do that you have to over ride InitializeCulture mthod of page. And Set the UICultuer and Culture properties of page for the specified culture like 'en-US', 'en-GB' etc.

For example

this.UICulture = “en-GB”;

this.Culture = “en-GB”;

This set you page culture to English UK (GB for grate brighten).

Now all you need is list of cultures available in .net to get that we use following code which will retrieve the list of culture available with the .net.

CultureInfo[] cultures = System.Globalization.CultureInfo.GetCultures(CultureTypes.SpecificCultures);

cultures = cultures.OrderBy(c=>c.EnglishName).ToArray();

Now you can bind these values with the drop down list.

foreach(CultureInfo c in cultures)

{

ddlCulture.Items.Add(new ListItem(c.EnglishName + " : " + c.NumberFormat.CurrencySymbol, c.Name));

}

Get the selection from user and set the Session variable or any other way to set the culture of your page.

DNN Modules - Google Analytic Dashboard

2010-02-27T08:14:00.011+05:30

This is my first DNN related post in this post. Here is a Google Analytic Dashboard DNN Module which contain following sub modules.

Visitors Overview
World Map Overlay
Traffic Sources Overview

Click here to download Installable and source.

After installing the module you will find listed modules into your module drop down list.Drop module on to the page and then done following setting through setting page of the module.

Google Analytic Email id - your Google analytic accounts email id.
Google Analytic password - password for the analytic account.
Google Analytic Profile id - this is your Google analytic profile id for which you want to display charts.
Width and Height - optional.

Note : For the detail of how to get profile id click here and see the bottom parts of the post.

Save this setting and enjoy this module.

There Date range selector which set the date range for the charts, set them to your desire period and click on apply. you can see the result for that date range.

Out puts

Following are the screen shots of the modules out put.

Google Analytic Helper Class ..

2010-02-20T18:25:00.003+05:30

Google analytic is very powerful and handy utility provided by the Google to track your web site traffic from all over the word.

To use this Google analytic with our asp.net page we have to put one java script code into the page based on the WebPropertyId of the analytic profile from which we track our site.

Following are the some ready made methods of helper class which help you to play with google analytic into your asp.net page

Please download following assembly to use the helper class methods

Download - "Google Analytics Desbord Controls.dll"

1) getTrackerCode

GADCAPI.GADCAPIHelper.getTrackerCode(string WebPrppertyId)

This method return the java script which used to place into the page to activate google analytic tracker on that particular page.

Output:

var gaJsHost = ((""https:"" == document.location.protocol) ? ""https://ssl."" : ""http://www."");
document.write(unescape(""%3Cscript src='"" + gaJsHost + ""google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E""));

try {
var pageTracker = _gat._getTracker(""U-XXXXXXXX-X"");
pageTracker._trackPageview();
} catch(err) {}

(script tags are omitted because of post rendering made them activate)

2) getProfilesList

public static List getProfilesList(string EmailAddress, string Password)

This method get your analytic account user name and password and return generic List of Class ProfileInfo.

ProfileInfo is class which have following properties

1) Url - profile url

2) WebPropertyId - U-XXXXXXXX-X like unique code for profile given by the

analytic

3) ProfileId - this is profile id which is used to get profile data into the Google Analytic Dashboard Controls

Output:

URL	WebPropertyId	ProfileId
jigneshsuvariya.blogspot.com/	UA-11462261-1	23177177

To find more utility control please refer the post Google Analytic Dashboard Controls into the category web control

Google Analytic Dashboard Controls

2010-01-12T16:26:00.005+05:30

"Google Analytic Dashboard Controls" is costume controls library which contain ASP.NET costume controls which generate different types of charts like Google analytic dashboard using Google analytic data export api. Its include following controls.

Visitors overviews

Word map overview

Traffic source overview

Content overview

Followings are the images of the resulting graphs using them

Visitors Overview

Traffic Source Overview

Word Map Overview

Content Visits Overview

To use this controls into your ASP.NET projects follow the below steps.

1. Download "Google Analytics Desbord Controls.dll"

2. Add reference of "Google Analytics Desbord Controls.dll" to your project.

3. In toolbox add controls by Right Click -> Choose Items -> browse dll.

4. Now Drag and drop control to your .aspx file.

5. Set Properties GAEmailAddress to your Google Analytic account email id, GAPassword to password , GAProfileId to analytic profile id for which you want to show report, FromDate to start date, ToDate to end date.

Following is the example code for VisitorOverview control.

In .aspx file

<cc1:VisitorsOverview ID="VisitorsOverview1" runat="server">
cc1:VisitorsOverview>

In .aspx.cs file

VisitorsOverview1.GAEmailAddress = "EmailAddress";

VisitorsOverview1.GAPassword = "Password";
VisitorsOverview1.AnalyticsProfileId = "23177177";
VisitorsOverview1.FromDate = new DateTime(2009, 11, 1);
VisitorsOverview1.ToDate = new DateTime(2010, 1, 8);

I found that many user use the Web Property ID (UA-XXXXXXXX-X) as AnaliticsProfileId and get error.

Following are the step to get your desire profile id from your analytic account

1) Go to the edit profile on analytic home page after login.

2) the page display your profile detail and you get your profile id over here

Use this id with the AnalyticsProfileId property of control to display the data.

Get Tables and Columns Names by LINQ

2009-11-13T13:30:00.004+05:30

Here I am explaining one of the tricks to get all table name list along with column of it from your DataContext.

I am using the System.Data.Linq.Mapping.MetaModel to get information about tables and it have much more database related information.

Following are the code to list all table name along with column from your DataContext.

//DataContext object.

DataClassesDataContext DB = new DataClassesDataContext();

//String variable to stor html to render.

string strHtmlToLoad = "";

//Heading

strHtmlToLoad = "<-h2->Table Names<-/h2-><-ol->";

//Loop through tables add name to string

foreach (var mTable in DB.Mapping.GetTables())

{

strHtmlToLoad += "<-li->" + mTable.TableName + "<-ul->";

//Loop through table's columns add name to string

foreach (var mColumn in mTable.RowType.DataMembers)

strHtmlToLoad += "<-li->" + mColumn.MappedName + "<-/li->";

strHtmlToLoad += "<-/ul-><-/li->";

}

//Reander HTML

Response.Write(strHtmlToLoad + "<-/ol->");

Please remove "-" from above code. I have to add it because of HTML rendring of this post made that element active and mesh up the post formate.

Dynamic columns in Gridview

2009-11-12T12:25:00.003+05:30

There are many types of column field are are available for grid view like

BoundField
ButtonField
CheckBoxField
CommandField
HyperLinkField
ImageField
TemplateField

Here I explain how to add dynamically Bound Field and then Template Field into grid view. First we look how to add Bound Field into Grid view and then Template Field.

First of all make your AutoGenerateColumns property to false.

Prepare your data source which will you going bind with grid view. it will be Data Table or Generic List of class type or structure type any thing or Table Class of your Linq dbml data contexts class.

Here we are going to use Data Table as follow.

DataTable dt = new DataTable("ItemMaster");

dt.Columns.Add(new DataColumn("ItemId",typeof(Int32)));
dt.Columns.Add(new DataColumn("ItemName", typeof(String)));
dt.Columns.Add(new DataColumn("Price", typeof(Decimal)));

for (int i = 0; i < 10; i++)
{
     DataRow dr = dt.NewRow();
     dr[0] = i + 1;
     dr[1] = "Name " + i.ToString();
     dr[2] = i * 0.5 + 1;
     dt.Rows.Add(dr);
}

For each column of table we have to add one BoundField into gridview following is code for that

foreach (DataColumn dc in dt.Columns)
{
     BoundField bf = new BoundField();
     bf.DataField = dc.ColumnName;
     bf.HeaderText = dc.ColumnName;
     GridView1.Columns.Add(bf);
}

Now you grid view is ready to bind DataTable.

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

This type of dynamic generated column is useful when we want custom css and style depend on some logic. and we want to show hide some column dynamically.

To add Template Field dynamically you have to create one class which inherit ITemplate interface. Here in example we create one hyperlink template field class which inherit ITemplate interface then we bind that field to our grid view using data table.

public class HyperLinkTemplate : ITemplate

{

private DataControlRowType TemplateType;

private string ColumnName;

private string NavigateUrl;

private string Text;

public HyperLinkTemplate(DataControlRowType TemplateType, string ColumnName, string NavigateUrl, string Text)

{

this.TemplateType = TemplateType;

this.ColumnName = ColumnName;

this.NavigateUrl = NavigateUrl;

this.Text = Text;

}

public void InstantiateIn(System.Web.UI.Control container)

{

switch (TemplateType)

{

case DataControlRowType.Header:

Literal lc = new Literal();

lc.Text = ColumnName;

container.Controls.Add(lc);

break;

case DataControlRowType.DataRow:

HyperLink objHyperLink = new HyperLink();

objHyperLink.Target = "_blank";

objHyperLink.DataBinding += new EventHandler(objHyperLink_DataBinding);

container.Controls.Add(objHyperLink);

break;

default:

break;

}

void objHyperLink_DataBinding(object sender, EventArgs e)

{

HyperLink objHyperLink = sender as HyperLink;

GridViewRow row = (GridViewRow)objHyperLink.NamingContainer;

objHyperLink.NavigateUrl = NavigateUrl;

objHyperLink.Text = DataBinder.Eval(row.DataItem, Text).ToString();

}

To bind this HyperLinkTemplate to oure grid view use following code. Here we bind Item name column to this template field with editpage.aspx url. this code display both boud field and template field adding.

foreach (DataColumn dc in dt.Columns)

{

if (dc.ColumnName != "ItemName")

{

BoundField bf = new BoundField();

bf.DataField = dc.ColumnName;

bf.HeaderText = dc.ColumnName;

GridView1.Columns.Add(bf);

}

else

{

TemplateField tf = new TemplateField();

tf.HeaderTemplate = new HyperLinkTemplate(DataControlRowType.Header, dc.ColumnName, "", "");

tf.ItemTemplate = new HyperLinkTemplate(DataControlRowType.DataRow, dc.ColumnName, "~/editpage.aspx", dc.ColumnName);

GridView1.Columns.Add(tf);

}

Get website's base URL..

2009-11-06T10:32:00.002+05:30

Following function is help you to get root path or site base URL of your web application.
Like if your page URL like "http://www.blogger.com/post-create.g?blogID=5406317769839137062"
this function return base URL like "http://www.blogger.com".

public static string GetApplicationPath()
{
     string appPath = null;

     //Getting the current context of HTTP request
     HttpContext context = HttpContext.Current;

     //Checking the current context content
     if (context != null)
     {
                //Formatting the fully qualified website url/name
                appPath = string.Format("{0}://{1}{2}{3}",
                context.Request.Url.Scheme,
                context.Request.Url.Host,
                context.Request.Url.Port == 80 ? string.Empty : ":" + context.Request.Url.Port,
                context.Request.ApplicationPath);
     }
     return appPath;
}

Better One

public static string GetApplicationPath()
{

var request = HttpContext.Current.Request;
var appUrl = HttpRuntime.AppDomainAppVirtualPath;

if (!string.IsNullOrWhiteSpace(appUrl) && appUrl != "/")
    appUrl += "/";

var baseUrl = string.Format("{0}://{1}{2}", request.Url.Scheme, request.Url.Authority, appUrl);

return baseUrl;

}

Message Panel

2009-11-05T11:15:00.001+05:30

This in post show you how effectively you can show you messages and error regarding the user events using the Message Panel control. following are the step by step description of how to create and use Message panel.

Create Message panel

In your application add folder App_Code.
To do that right clicking on Web project select Add Asp.net folder >> App_Code

Add one class file name MessagePanel.cs and copy pest following code into it.

using System;

using System.Web.UI;
using System.Web.UI.WebControls;

namespace Controls
{

// TODO: add clear link (display: none;) plus requried js

   [ToolboxData("<{0}:MessagePanel runat=\"server">")]
    public class MessagePanel : Panel, INamingContainer
    {

private const string VSKEY_MESSAGE = "Message";

        private const string VSKEY_ERROR = "Error";

        bool _showMessagePanel;
        bool _showErrorPanel;

        string _messageCssClass;
        string _errorCssClass;
        string _messageIconUrl;
        string _errorIconUrl;

public MessagePanel()

        {
            ViewState[VSKEY_MESSAGE] = String.Empty;
            ViewState[VSKEY_ERROR] = String.Empty;
        }

#region Accessors

        public string Message
        {
            get { return (string)ViewState[VSKEY_MESSAGE]; }
            set { ViewState[VSKEY_MESSAGE] = value; }
        }

        public string Error
        {
            get { return (string)ViewState[VSKEY_ERROR]; }
            set { ViewState[VSKEY_ERROR] = value; }
        }

        public bool ShowMessagePanel
        {
            get { return _showMessagePanel; }
            set { _showMessagePanel = value; }
        }

        public bool ShowErrorPanel
        {
            get { return _showErrorPanel; }
            set { _showErrorPanel = value; }
        }

        public string MessageCssClass
        {
            get
            {
                if (this._messageCssClass == null)
                {
                    this._messageCssClass = "MessagePanel";
                }
                return _messageCssClass;
            }
            set { _messageCssClass = value; }
        }

        public string ErrorCssClass
        {
            get
            {
                if (this._errorCssClass == null)
                {
                    this._errorCssClass = "ErrorPanel";
                }
                return _errorCssClass;
            }
            set { _errorCssClass = value; }
        }

        public string MessageIconUrl
        {
            get
            {
                if (_messageIconUrl == null)
                {
                    _messageIconUrl = "~/Resources/images/messagebox_info.gif";
                }
                return _messageIconUrl;
            }
            set { _messageIconUrl = value; }
        }

        public string ErrorIconUrl
        {
            get
            {
                if (_errorIconUrl == null)
                {
                    _errorIconUrl = "~/Resources/images/messagebox_critical.gif";
                }
                return _errorIconUrl;
            }
            set { _errorIconUrl = value; }
        }

        #endregion

protected override void Render(HtmlTextWriter writer)

        {
            if (null != Page)
                Page.VerifyRenderingInServerForm(this);

            if (this.ShowErrorPanel)
            {
                Panel errorPanel = BuildPanel(this.Error, this.ErrorCssClass, ErrorIconUrl);
                this.Controls.Add(errorPanel);
            }

            if (this.ShowMessagePanel)
            {
                Panel messagePanel = BuildPanel(this.Message, this.MessageCssClass, MessageIconUrl);
                this.Controls.Add(messagePanel);
            }

            base.Render(writer);
        }

protected virtual Panel BuildPanel(string messageText, string cssClass, string imageUrl)

        {
            Panel result = new Panel();

            if (null != imageUrl && cssClass.Length > 0) result.CssClass = cssClass;

            if (null != imageUrl && imageUrl.Length > 0)
            {
                System.Web.UI.WebControls.Image image = new System.Web.UI.WebControls.Image();
                image.ImageUrl = imageUrl;
                result.Controls.Add(image);
            }

            Panel message = new Panel();
            message.Controls.Add(new LiteralControl(messageText));
            result.Controls.Add(message);

            return result;
        }

public void ShowMessage(string message)

        {
            ShowMessage(message, true);
        }

        public void ShowMessage(string message, bool clearExistingMessages)
        {
            if (clearExistingMessages)
                this.Message = message;
            else
                this.Message += " " + message;

            this.ShowMessagePanel = true;
            this.Visible = true;
        }

public void ShowError(string message)

        {
            ShowError(message, true);
        }

        public void ShowError(string message, bool clearExistingMessages)
        {
            if (clearExistingMessages)
                this.Error = message;
            else
                this.Error += " " + message;

            this.ShowErrorPanel = true;
            this.Visible = true;
        }

public void Clear()

        {
            this.Visible = false;
        }

}

Add following CSS code in your .css file and put proper images at path shown into the code

/* Start: Message/Error Display CSS*/
div.MessagePanel {
/*background:#EEEEEE none repeat scroll 0%;*/
border:1px dashed #0BAF4D;
color:#0BAF4D;
font-weight:bold;
/*padding:5px;*/
font-size:13px;
margin-bottom:10px;
}

div.ErrorPanel {
/*background:#FFFFCC none repeat scroll 0%;*/
border:1px dashed red;
color:red;
font-weight:bold;
font-size:13px;
margin-bottom:10px;
}

div.ErrorPanel img, div.MessagePanel img {
float:left;
}

div.ErrorPanel div, div.MessagePanel div {
margin-left:32px;
padding-top:8px;
padding-bottom:8px;
text-align:left;
}
/* End: Message/Error Display CSS*/

How to put Message panel into .ASPX or .ASCX file

Add following into the web.config

<system.web>

<add tagPrefix="Controls" namespace="Controls"/>
controls>
pages>

system.web>

Add following in your .ASPX or .ASCX file where you want to show message panel.

<Controls:MessagePanel ID="msgPanel" runat="server">
Controls:MessagePanel>

How to code with Message panel

In codebehind file use following methods to show and display messages and errors

To clear message

msgPanel.Clear();

To show message

msgPanel.ShowMessage("Meesage");

To show error

msgPanel.ShowError("Error");

Out put of message panel is like bellow

Message

Error

Export gridview data to csv file..

2009-10-28T17:28:00.002+05:30

Following is the function in c# which will export passed gridview to csv file. Note that this function not work if gridview have Autogeneratedcolumn property to true, to make it dynamic you have to add column through code, how to do that see category Gridview posts.

public static void ExportToCsv(string fileName, GridView gv,string Title)
{
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
            HttpContext.Current.Response.ContentType = "application/ms-excel";

            using (StringWriter objSw = new StringWriter())
            {

                // Create a table to contain the grid
                Table table = new Table();

                // include the gridline settings
                table.GridLines = gv.GridLines;
                objSw.Write("Report: " + Title + "");
                objSw.Write(objSw.NewLine);
                objSw.Write("Report Date: "+DateTime.Now.ToString());
                objSw.Write(objSw.NewLine);
                objSw.Write(objSw.NewLine); objSw.Write(objSw.NewLine);

                // add the header row to the table
                int NoOfColumn = gv.Columns.Count;
                //Create Header
                for (int i = 0; i < NoOfColumn; i++)
                {
                    objSw.Write(gv.Columns[i].HeaderText);
                    //check not last column
                    if (i < NoOfColumn - 1)
                    {
                        objSw.Write(",");
                    }
                }

                objSw.Write(objSw.NewLine);

                //Create Data
                foreach (GridViewRow dr in gv.Rows)
                {
                    for (int i = 0; i < NoOfColumn; i++)
                    {
                        objSw.Write(PrepareControlForExportToCsv(dr.Cells[i]).Replace(",",""));

                        if (i < NoOfColumn - 1)
                        {
                            objSw.Write(",");
                        }
                    }
                    objSw.Write(objSw.NewLine);
                }

                // render the htmlwriter into the response
                HttpContext.Current.Response.Write(objSw.ToString());
                HttpContext.Current.Response.End();
            }
}

private static string PrepareControlForExportToCsv(Control control)
{
            for (int i = 0; i < control.Controls.Count; i++)
            {
                Control current = control.Controls[i];
                if (current is Literal)
                {
                    return (current as Literal).Text;
                }
                else if (current is Label)
                {
                    return (current as Label).Text;
                }

                if (current.HasControls())
                {
                    GridViewExportUtil.PrepareControlForExportToCsv(current);
                }
            }
            if (control is TableCell)
                return (control as TableCell).Text;
            else
                return "";
}

Disable submit on return keypress..

2009-10-21T18:26:00.001+05:30

Following are the code to disable enter key or return key submit behaviour of Asp.net page.

Override page OnInitComplete event and add this code.

protected override void OnInitComplete(EventArgs e)
{
           base.OnInitComplete(e);
           string script = "function DisableEnterKey(){" +
                                 "if(event.keyCode == 13){return false;}" +
                     "else{return true;}}";

           Page.ClientScript.RegisterStartupScript(this.GetType(), "page", script, true);

           Page.Form.Attributes.Remove("onkeypress");
           Page.Form.Attributes.Remove("onkeydown");
           Page.Form.Attributes.Add("onkeypress", "return DisableEnterKey()");
           Page.Form.Attributes.Add("onkeydown", "return DisableEnterKey()");
}

XML data access through Linq..

2009-10-21T17:16:00.002+05:30

Following are the setp to read data from XML file using linq query

1st : Add following name spaces by using

using System.Xml;
using System.Xml.Linq;

2nd : Create XDocument object and load XML file

XDocument objXDocument = XDocument.Load(Server.MapPath("~/App_Data/XYZ.xml"));

3rd : Write following linq query to read data from XDcument object

var q = from c in loaded.Descendants("Iteams")
                    select c.Elements("Item");

You can also specify where condition like following

var q = from c in loaded.Descendants("Items")
                    where c.Attribute("id").Value = "id1"
                    select c.Elements("Item");

4th : Check for null and then convert var object 'q' to List

List<XElement> objElem = q.ToList()[0].ToList();

Following is the structuer of the XML file used for this code

<? xml version="1.0" encoding="utf-8" ?>
<Items>
<Item id="id1">
...
Item>
<Item id="id2">
...
Item>
<Item id="id3">
...
Item>
Items>

Ordering columns of GridView by code..

2009-10-21T15:38:00.002+05:30

Following are the step to change order of your grid view column by code..

1st : make DataControlFieldCollection clone to your gridview columns

DataControlFieldCollection gvdcfCollection = grid.Columns.CloneFields();

2nd : clear the grid columns

grid.Columns.Clear();

3rd : Itreate through the clone copy and based on logic add or insert DataControlField into grid columns collection

grid.Columns.Add(gvdcfCollection[0]);

or

grid.Columns.Insert(0,gvdcfCollection[0]);

Note: If you have template column in your grid view then you have to make EnableViewState property of grid view to false.