ASP Snippets

Categories






Alerts

Free Alerts

Your email will always be
private and will not be shared.




Follow us on twitter.


Welcome to

Welcome to ASP Snippets

Featured Snippet


Excel like AutoFilter Feature in ASP.Net GridView Control
Author:Mudassar Khan

Here Mudassar Ahmed Khan has explained how to add Excel like AutoFilter feature in ASP.Net GridView Control using DropDownList
Here I am explaining how to build a feature similar to Microsoft’s Excel AutoFilter in ASP.Net GridView control. Excel AutoFilter allows user to filter the records using the DropDownList in the header, so lets start with the tutorial   GridView Markup <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns = "false" AllowPaging = "true" PageSize = "10"  Font-Names = "Arial" Font-Size = "11pt" AlternatingRowStyle-BackColor = "#C2D69B"  HeaderStyle-BackColor = "green"  OnPageIndexChanging = "OnPaging"> <Columns>     <asp:BoundField DataField="ContactName" HeaderText="Contact Name" />     <asp:BoundField ... [More]

Posted: Nov 26 2009, 23:03 by Mudassar Khan | Comments(3)RSS comment feed | Filed under : ASP.Net | C# | GridView | VB.Net



Recently Added






Most Viewed


Export GridView To Word/Excel/PDF/CSV in ASP.Net

Here Mudassar Ahmed Khan has explained how to export GridView to Word, Excel, PDF and CSV documents
In this article, I will explain how to export GridView to Word, Excel, PDF and CSV formats. Exporting to Word, Excel and CSV can be easily achieved using ASP.Net without any third party tools, but for exporting GridView to PDF I am using iTextSharp which is a free library for exporting html to PDF.   To start with I have a GridView in which I am showing Customers records from the NorthWind Database. The HTML markup of the GridView is as shown below   <asp:GridView ID="GridView1" runat="server"     AutoGenerateColumns = "false" Font-Names = "Arial"     Font-Size = "11pt" ... [More]

Posted: Mar 14 2009, 23:11 by Mudassar Khan | Comments(185)RSS comment feed | Filed under : ASP.Net | C# | VB.Net | GridView

Save and Retrieve Files from SQL Server Database using ASP.Net

Files can be easily saved in the SQL Server Database Saving it in database makes it easily manageable. Here I will explain how to save and retrieve files from database.   Database Design   Here I have created a Database called dbFiles and it has a table called tblFiles. It has 4 Fields. The complete description is available in the Figure below   As you can see above for the id field I have set Identity Specification true, so that it automatically increments itself.   Field Relevance id Identification Number Name File Name Content ... [More]

Posted: Feb 19 2009, 04:49 by Mudassar Khan | Comments(118)RSS comment feed | Filed under : ADO.Net | C# | SQL Server | VB.Net

Excel like AutoFilter Feature in ASP.Net GridView Control

Here Mudassar Ahmed Khan has explained how to add Excel like AutoFilter feature in ASP.Net GridView Control using DropDownList
Here I am explaining how to build a feature similar to Microsoft’s Excel AutoFilter in ASP.Net GridView control. Excel AutoFilter allows user to filter the records using the DropDownList in the header, so lets start with the tutorial   GridView Markup <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns = "false" AllowPaging = "true" PageSize = "10"  Font-Names = "Arial" Font-Size = "11pt" AlternatingRowStyle-BackColor = "#C2D69B"  HeaderStyle-BackColor = "green"  OnPageIndexChanging = "OnPaging"> <Columns>     ... [More]

Posted: Nov 26 2009, 23:03 by Mudassar Khan | Comments(3)RSS comment feed | Filed under : ASP.Net | C# | GridView | VB.Net

Display Images from Database using ASP.Net

How to retreive images saved in database and display them using ASP.net Image Control
In my previous article I explained Save and Retrieve Files from SQL Server Database using ASP.Net. Here I will explain how to display images that are saved in database.   I have saved images of three different formats i.e. JPEG, GIF and PNG in the Database. Refer figure below. Retreive the Images   To retreive pictures from database I have created a Picture Page. The page will receive ImageID as the ID of the Saved image as QueryString Parameter. Based on the QueryString Parameter, the page will retreive the image and write it to the Response. Refer the Code Below   C# [ImageCSharp.aspx]     protected void Page_Load(object sender, EventArgs ... [More]

Posted: Feb 21 2009, 03:39 by Mudassar Khan | Comments(19)RSS comment feed | Filed under : ADO.Net | C# | SQL Server | VB.Net

Send Email using CSharp

Namespaces The following Namespaces need to be imported in order to send emails using System.Net; using System.Net.Mail; MailMessage Class Properties Following are the required properties of the mail message class. From – Sender’s email address To – Recipient(s) Email Address CC – Carbon Copies BCC – Blind Carbon Copies Subject – Subject of the Email  Body – Body of the Email IsBodyHtml – Specify whether body contains text or HTML mark up. Attachments – Attachments if Any. ReplyTo – ReplyTo Email address. Creating a MailMessage Object MailMessage mm = new MailMessage(); mm.From = new MailAddress("username@gmail.com"); ... [More]

Posted: Feb 01 2009, 04:21 by Mudassar Khan | Comments(3)RSS comment feed | Filed under : C#














Community News





Web Hosting SpotLight


Consulting


For consulting and work related queries click here.



Advertise


Advertise with us. For more details click here.


Suggestions


Please provide your valuable suggesstions here.

This Site is hosted on

Lunarpages.com Web Hosting