My Short Note

Use Asp.net Session from Class Library (or Class Library Project) Add First we need to add System.Web as a reference on our project. System.Web.HttpContext.Current.Session[“MyVariable”]; System.Web.HttpContext.Current.Session(“MyVariable”); How to write connection string in web.config file At first we need to add following namespace using System.Collections.Generic; using System.Web.Configuration; Now use following code to write on web.config file Configuration […]

Clearing all TextBoxes text from a Form using C#

When we develop any application form, then there will be a new button where we need to perform clear operation. We can clear all the TextBox texts from a Form or a Control like panel, tabe pages using following code foreach (Control c in this.Controls) { if (c is TextBox) { c.Text = string.Empty; } […]

Select Distinct Record from DataTable

If it is necessary to select distinct record from Data Table, then we can use following method. public DataTable SelectDistinct(DataTable SourceTable, string FieldName) { DataTable dt = new DataTable(); dt = SourceTable.Clone(); object LastValue = null; foreach (DataRow dr in SourceTable.Select(“”, FieldName)) { if (LastValue == null || !(ColumnEqual(LastValue, dr[FieldName]))) { LastValue = dr[FieldName]; dt.ImportRow(dr); […]

Converting List to DataTable in C#

There is no built in method for converting list to data table in C#. So we can implement following method for converting List to DataTable in C#. public DataTable ToDataTable(IList data) { PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(t)); DataTable table = new DataTable(); for (int i = 0; i < props.Count; i++) { PropertyDescriptor prop = props[i]; […]

Converting DataView to DataTable in C#

Consider following code for converting DataView to DataTable in C# DataTable dt = dv.ToTable();// dv = Data View Consider following example public DataTable GetFilterData(DataTable dt) { if (dt != null) { DataView dataView = dt.DefaultView; dataView.RowFilter = filterCondition; //some condition like”: ColumnName like ‘%this%’; dt = dataView.ToTable(); } return dt; }

Preventing / Blocking Page Review after Logout with Forms Authentication

After logging out we can prevent getting previous page or information by doing following things. Add Code to Page Load event: —————————– Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1)); Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetNoStore(); Or We can use following code Page.Response.AppendHeader(“Cache-Control”, “no-store, no-cache, must-revalidate, post-check=0, pre-check=0”); Add Code to Log out Button: —————————– Session.Abandon(); //Session[“IsLogedIn”] = “0”; //set your session status //Response.Redirect(“set your log […]

Export to pdf ( Create pdf on fly ) using ASP.net and C#

Consider following code for creating pdf document on fly using ASP.net in C#. using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.IO; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; namespace WebApplication1 { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) […]

How to enable Paging in GridView in ASP.net or Grid View Paging doesn’t work

Do Following steps. –> Set EnablePaging and Sorting Callback = True from Propertise. Set your data source as general way. Now do another extra job for working paging Write down the following code under PageIndexGhanging Event protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) { //Create your data set or table as u did GridView1.PageIndex = e.NewPageIndex; […]