C#.NET ASP.NET Articles CSHARP VBNET Tutorials Code Examples Samples

Export Crystal Reports To PDF Word Excel In Asp.Net

2012-01-30T14:01:00.004+05:30

Export or save crystal reports to pdf,ms word,excel programmatically in asp.net In this post i'm explaining how to export or save crystal reports to pdf,word or excel programmatically in button click event. For this Example i have used Northwind Database and Employees table. Read Crystal reports in ASP.NET to know how to create crystal reports in asp.net. After you have finished creating

Asp.Net AdRotator With Timer Example To Rotate Ads Without Refresh

2012-01-28T16:35:00.003+05:30

AdRotator Control With timer Example to rotate advertisements without refreshing the page in asp.net and Ajax. AdRotator control in asp.net is used to display advertisements on asp.net website. Ads are rotated when user reload or refresh the page, but using ajax and timer we can rotate ads without refreshing the page. Create a new website in visual studio and add a new folder named Ads and

Download File From Server In Asp.Net

2012-01-27T14:28:00.003+05:30

Download files from server or hyperlink in asp.net In this post i'm explaining how to download a file from server in asp.net and display Save As dialog box when a link is clicked on the site. For this example i have created a folder named Files on the server and stored Some sample files to download. First we need to write code to display names of all the file saved in Files folder as

AspNet CompareValidator With Date Example

2012-01-26T16:20:00.005+05:30

Asp.Net CompareValidator Example to compare dates or textbox values In this post i'm going to explain how to use CompareValidator to compare different values or dates. For example We can use comparevalidator to compare values entered in password and confirm password textboxes which needs to be same, and using comparevalidator we don't need to wtite any code to check whether password in both

Create User Registration Form In AspNet

2012-01-25T18:33:00.005+05:30

Creating user registration form example in asp.net In this post i am explaining how to create user registration or signup form in asp.net with sql server database using C# and VB.NET. For this first of all we need to create a table in sql server database to store user registration data. I have created a table named Users for this example with columns shown in image below. Place

Visual Studio Remove Unused References With Organize Usings

2012-01-24T11:46:00.000+05:30

Remove unused references in visual studio by organize usings command When we create a new website or project in visual studio, several namespace references are added in code behind by default. It's always advisable to remove all unused usings and references from code behind for better performance. We can follow steps mentioned below to remove all unused usings and references. FOR C#

Get RowIndex In GridView RowCommand Event Using DataKey CommandArgument

2012-01-20T22:07:00.001+05:30

Get RowIndex In GridView RowCommand Event Using DataKey or CommandArgument in asp.net In this post i am showing how to get RowIndex of gridview row in RowCommand Event through DataKey property or commandArgument. RowCommand event is raised when a button inside gridview is clicked. Method 1. To get gridview rowindex through DataKey property we can use code as mentioned below. For this we need

Save Store Files In SqlServer Database AspNet

2012-01-20T12:20:00.003+05:30

Upload and Save Or Store Files In Ms Sql Server Database using fileupload control in Asp.Net. In this post i'm explaining how to save or store and retrieve pdf,word,excel,jpeg,gif,png files in MS sqlserver database using fileupload in asp.net. I'll also explain how to retrieve files from sql database for users to download. For this example i have created a sample database with table name

Nested GridView In Asp.Net Or GridView Inside GridView(Master Detail)

2012-01-17T18:48:00.003+05:30

Gridview inside gridview or nested gridview in Master Detail or Parent Child scenario in asp.net In this post i am explaining how to create gridview inside gridview or nested gridview to show master detail or Parent Child data in asp.net. For this i have used northwind database and customers and Orders table to display data. Drag SqlDataSource1 on page and configure it to fetch data Customers

Add License Agreement In Visual Studio Setup Project

2012-01-16T13:35:00.004+05:30

Add License Agreement In Setup Project using Visual Studio In this post i am explaining steps to add license agreement dialog in visual studio setup project. Read Create Setup And Deployment Project in Visual Studio 2008/2010 to know how to create setup for your winforms or asp.net applications. step 1. First of all we need to create a licence agreement file, for this open wordpad and

Ajax Asp.Net PasswordStrength Example

2012-01-06T17:25:00.003+05:30

PasswordStrength Example using Ajax In Asp.Net. In this example i'm explaining how to use PasswordStrength Control of AjaxControlToolkit for asp.net 3.5. For this Add latest version of AjaxControlToolkit.dll in BIN folder of application and place one textbox and passwordstrength control on the aspx page. Add below mentioned CSS style in stylesheet.css for strength bar to show up. CSS

Invalid Formatetc Structure Ajax Asp.Net Error

2012-01-05T22:11:00.001+05:30

Invalid FORMATETC structure Ajax Asp.Net Error If you are getting "The operation could not be completed. Invalid Formatetc Structure" error while using Asp.Net Ajax controls in Visual studio 2008 then this error occurs because of version conflict of System.web.extensions assembly installed in GAC. To fix this problem try any of the following solutions. 1st Method. Visual studio 2008 uses .NET

Create User Programmatically Using Membership In Asp.Net

2012-01-02T19:47:00.003+05:30

Create User Programmatically using Membership In Asp.Net To create users or new accounts programmatically using membership provider in asp.net we need to use CreateUser Method of membership class. For this i have placed textbox controls and requiredFieldValidators to validate respective textboxes. Read CreateUserWizard Email Verification Or Confirmation In Asp.NET to know how to create user

CreateUserWizard Email Verification Or Confirmation In Asp.NET

2011-12-31T16:14:00.007+05:30

CreateUserWizard Email Verification Or Confirmation In Asp.NET. In this example i am explaining how to create new user using createnewuserwizard with membership provider and sending verification or confirmation link in Email using C# or VB in ASP.NET. Read Login Page Using Login Control to know how to create login page in asp.net and setup membership provider to use with login control. For

Login Page Example Using Login Control In Asp.Net

2011-12-27T17:38:00.007+05:30

Creating Login Page In Asp.Net using Login Control And Membership Provider DataBase ASPNETDB.MDF. In this post i'm explaining how to create login page in asp.net using Login COntrol and membership provider database ASPNETDB.MDF. Create a new website and add new web form in the solution, name it Login.aspx, Place a Login control on this Login.aspx page from toolbox in visual studio.

Set Session TimeOut In Asp.Net Using WebConfig IIS

2011-12-23T21:34:00.005+05:30

Set Or Manage Session TimeOut In Asp.Net Using Web.Config and IIS In this post i'm explaining how to set or increase session timeout value in web.config or IIS in Asp.Net. Read Detecting Session Timeout and Redirect to Login Page in ASP.NET to know how to detect Session TimeOut. 1. Set session timeout in IIS. Open IIS manager by typing inetmgr in Start > run in windows. Right click on

Remove Delete Duplicate Rows/Records From DataTable

2011-12-22T10:31:00.005+05:30

Remove/Delete Duplicate Rows/Records From Datatable. Here i'm describing how to remove or delete duplicate rows or duplicate records from datatable using C# or VB.NET in Asp.Net. My table in database contains duplicate records as shown in image and i want to remove those duplicate records temporaryly efore displaying them in gridview. For this purpose i'm filling records in DataTable and

DropDownList In DetailsView EditItemTemplate

2011-12-21T11:20:00.006+05:30

DropDownList And RadioButtonList In EditItemTemplate Of DetailsView In Asp.Net. In This Example i'm going to explain how to put dropdownlist and radiobutton control in EditItemTemplate of DetailsView and Edit or Update Records of DetailsView in asp.net. For this i have used SqlDataSource To fetch records from database and populate and update detailsview. HTML SOURCE OF ASPX PAGE

A Potentially Dangerous Request.Form Value Was Detected From Client

2011-12-19T20:19:00.002+05:30

A potentially dangerous Request.Form value was detected from the client. This A potentially dangerous Request.Form value was detected from the client error occurs when user enter any script tag <> like or any html <> tag like etc in taxtbox. Reason for this is asp.net prevent any attempt to compromise the security of application by script injection like cross site scriptiong etc through

Write Modify Web.Config Programmatically At Run Time

2011-12-19T14:49:00.004+05:30

Write or Modify Web.Config ConnectionString Programmatically At Run Time In Asp.Net In this post I'm going to explain how to write or modify CnnectionStrings and AppSettings programmatically at run time in Web.Config file in Asp.Net. To write or modify web.config programmatically we need to use ebConfigurationManager Class in System.Web.Configuration namespace. We can add write or modify any

GridView XML Edit Delete Insert Update

2011-12-15T13:29:00.000+05:30

GridView XML Edit Delete Insert Update. In this post i'm explaining how to Edit Delete Insert and update XML file data in GridView using C# and VB.Net in Asp.Net. Read GridView XMLDataSource Example to know how to use XMLDataSource in GridView with XSLT schema. For this example i have created a XML file with three fields Firstname,LastName and Location and XML file looks like mentioned below.

Upload And Read Excel File In Asp.Net

2011-12-12T21:28:00.004+05:30

Upload and Read Excel File In Asp.Net In this post i'm explaining how to upload and read excel file data using fileUpload and dispplay in gridview using C# and VB.NET in asp.net. First of all put a fileUpload control, and a GridView in design view of aspx page to upload and display excel file data. Now place a button on the page, in click even of this button we will be uploading the excel file

VisualStudio SetupProject Updates Version Already Installed Error

2011-12-08T16:19:00.001+05:30

Visual Studio WindowsForms or WinForms Setup Project Updates Another Version Of This Product Is Already Installed Error. When we make changes or update in windows forms or winforms application and create setup project to reinstall the application, we get below mentioned error. Another version of this product is already installed. Installation of this version can not continue. To configure or

Read CSV File And Save To SQL Server In ASP.NET C# VB.NET

2011-12-07T20:09:00.003+05:30

Read CSV File or Data In ASP.NET using C# VB.NET And save to MS SQL Server. In this post i'm going to explain how to read CSV file and save the data to sql server In ASP.NET using C# or VB.NET. My sql table has 3 columns FirstName,LastName and Department. and i m using datatable to read Data from CSV file and temporarily storing in datatable. First of all you need to add reference to

GridView XMLDataSource Example

2011-12-06T18:31:00.003+05:30

GridView XMLDataSource Example In this post i'm going to explain how to use XML file or XML data as XMLDataSource to populate GridView in Asp.Net 2.0,3.5,4.0. For this example i have created a simple xml file and added it in App_Data Folder of Asp.Net application. The data in XML file look like shown below. Amit Jain Mumbai user

Add Controls Dynamically WinForms WindowsFroms C# VB.NET

2011-12-05T17:58:00.004+05:30

Add controls dynamically In winforms Or windows froms Using C# And VB.NET In this post i'm going to explain how to add controls dynamically in winforms and windows forms using C# and VB.NET. For this i have used northwind database and Employees table to populate combobox and dataGridView. First of all place two buttons on the form to add combobox and datagridview on button click and write

DataBinder.Eval Container.DataItem Performance Asp.Net

2011-11-20T11:47:00.004+05:30

DataBinder.Eval Container.DataItem Method Performance In Asp.Net. Using DataBinder.Eval method Slow down the performance of Asp.Net website or application noticeably. It is mentioned in MSDN site as - "Because this method performs late-bound evaluation, using reflection at run time, it can cause performance to noticeably slow compared to standard ASP.NET data-binding syntax." So one should

AllowDefinition MachineToApplication Beyond Application Level Error

2011-11-16T01:00:00.006+05:30

It is an error to use a section registered as allowDefinition ='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. This error is caused mainly for two reasons. 1. Virtual directory not configured in IIS. If you have not Configured your application to run on IIS then Create a virtual directory and

Remove Delete Duplicate Records Or Rows - Sql Server

2011-11-14T20:04:00.005+05:30

Remove or Delete duplicate records or rows from ms sql server database table. In this post i am going to describe different methods of deleting duplicate records or rows from sql server database table. I am using Employees table with FirstName and Department columns. First Method. Delete duplicate records/rows by creating identity column. duplicate records in table looks like shown in

jQuery Fixed Header Scrollable GridView

2011-11-12T12:50:00.007+05:30

Fixed Header Scrollable Gridview Using jQuery in ASP.NET. In this example im going to describe how to create fixed header scrollable gridview using jquery. I have used northwind database to populate gridview and jquery fixed header plugin. Read Scrollable GridView With Fixed Headers Using CSS if you want to create scrollable fixed header gridview without using jQuery or JavaScript.

Export Selected GridView Rows To Excel

2011-11-06T14:00:00.002+05:30

Export Selected GridView Rows To Excel in asp.net 2.0,3.5,4.0 using C# and VB.NET. In this post i am going to explain how to export selected gridview rows to ms excel in asp.net. I have used northwind database and customers table to populate gridview. read how to install northwind database for northwind database installation in sql server 2008. in one of my previous posts Export Gridview

Numeric Number Only TextBox JavaScript RegularExpression Validator

2011-10-23T12:35:00.006+05:30

Numeric or Number Only TextBox Using JavaScript or RegularExpressionValidator. In this example i am going to decsribe how create Numeric or Number only textbox using javascript or regular expression Validator which accept only numbers in asp.net web page. 1. Number only textbox using javascript. Go to html source of aspx page and write below mentioned script in head section of page.

ErrorProvider In WinForms And Windows Forms

2011-10-22T03:59:00.005+05:30

ErrorProvider In WinForms or Windows Forms application using C# and VB.NET In this post i am going to describe how to use error provider control in winforms or windows forms application using C# and VB.NET. I am using error provider control to display warning or tick icon depending on data entered in textbox so that user can find out text entered is correct or incorrect. in first textbox i

Windows AppFabric Caching for SessionState Provider ASP.NET

2011-10-19T03:30:00.007+05:30

Using Windows Server AppFabric Caching for Asp.NET Session state provider. In ASP.NET 4 we have following options to choose and use for managing session state, 1. In-Proc 2. SQL Server Mode 3. Custom We can use custom session state mode to store session state in AppFabric cache. To use AppFabric cache for session state we need to configure our application's web.config file according to

Sql Query Optimization

2011-10-17T13:50:00.008+05:30

Sql Query Optimization in MS SQL Server To Improve Performance of ASP.NET web applications. Data retrieval FROM database in asp.net applications is a most common task and writing optimized queries can have a huge impact on perfirmance of application if database is huge or containing thousands of records in table. Here i am mentioning few tips to remeber while writing sql queries for

Install Configure Windows Server AppFabric

2011-10-15T14:06:00.005+05:30

Install,Configure Windows Server AppFabric cache services in asp.net 3.5 and 4.0. Here i am explaining steps to install and configure windows server appfabric cache services in asp.net 3.5 and 4.0. 1. Download and run windows server appfabric from this link Select the features you want to install, Confirm the next screen and finish the installation. After installation is finished, Go

Export GridView To Excel ASP.NET

2011-10-12T02:45:00.017+05:30

Export GridView to Excel in asp.net 2.0,3.5 using C# and VB.NET In this post i am going to explian how to export gridview to ms excel using C# and VB.NET. For this i have used northwind database to populate gridview. To learn how to populate gridview read this. Read this post If you want to export gridview to pdf using iText. After populating gridview we have to export gridview to excel

Hide Show Div Using JQuery Asp.Net

2011-09-27T17:02:00.014+05:30

Show hide div using jquery example in asp.net. So many times while developing web application we need to show or hide div or other html elements based on user interaction as shown in picture. we can do this with ease using JQuery. for this first of all we need to add jquery in head section of page. Now write some css for the div and show hide button .button, .button:visited {

Dynamic Buttons Controls Event Handling WinForms Windows Forms

2011-09-24T03:04:00.014+05:30

Dynamic buttons controls Event Handling In windows forms or Winforms applications in .net 2.0,3,5. using C# and VB.NET many times we need to create controls at runtime or through code behind depending on the real time scenario. In this post i am going to explain how to add dynamic buttons at runtime and handle the Button Click event in winforms or windows forms applications. I am creating 3

Context.User.Identity.Name Is Empty Blank

2011-09-23T19:30:00.006+05:30

Context.user.identity.name is empty,blank or Null. If you have set the forms authentication and trying to display logged in user name in your asp.net web application by getting the user name using user.identity.name and this is blank or empty as displayed in image above. Then u might have missed few configuration settings. If yor are getting user identity name null or emplty when u try to

Pass Crystal Report Parameters Programmatically

2011-09-22T18:50:00.004+05:30

Pass crystal report parameters programmatically in Asp.Net 2.0,3.5. In this post i am explaining how to pass parameters to crystal reports programmatically in code behind of asp.net web page. For this i am using northwind database and products table. I have put one text box on the page and report will display details of product based on product id entered by user. To know how to create

Asp.Net QueryString Example

2011-09-20T00:45:00.006+05:30

Using QueryStrings in Asp.Net 2.0, 3.5 and 4.0 Several time in ASP.NET applications we need to transfer data or information provided by user from one aspx page to another. We can achieve this using several methods like Cookies,Session or Crosspage posting In this post i am explaining how to use querystrings. Example url with querystring can be something similar like this http://

Select Find Nth Highest Salary Record In Sql Server

2011-09-15T00:41:00.013+05:30

Find or Select nth highest salary record in ms sql This is most frequentky asked question how to select or get nth highest record or nth row/record from any column of sql table. for example select get or fetch 2nd (second highest) or nth highest salary of employee or 10th highest record from the table. There are various ways to achieve this result, i've mentioned few here. I have

Forms Authentication In Asp.Net

2011-08-29T14:14:00.005+05:30

In examples below i'm explaining how to use forms authentication in Asp.Net and forms authentication tickets in Asp.net. Forms Authentication In Asp.Net 2.0 and 3.5 Forms Authentication in ASP.NET is technique to decide how users can access your web application. Using froms authentication we can decide certain users can access only certain pages or we can control the anonymous

Maintain Scroll Position On After Postback in Asp.Net 2.0 3.5

2011-08-23T01:43:00.009+05:30

Maintain Scroll Position on or After Postback in Asp.Net 2.0 3.5. In this example i'm explaining different methods of maintaining scroll position on/after postback in asp.net 2.0,3.5 web pages or applications. Method 1 . Write below mention directive in page directive section of html source of aspx page to maintain scroll position of only one page or selected pages rather then

Create Setup And Deployment Project in Visual Studio 2008/2010

2011-08-16T18:25:00.010+05:30

In this example i am going to explain how to create setup and deployment project for winforms windows application using visual studio 2005/2008/2010. Similar approach can be applied for creating setup project for web application as well. First of all create any sample windows/web application. Create setup project right click on solution explorer root and select Add > New project

Move Export Facebook Photos Albums To Picasa Or Google Plus

2011-07-21T20:35:00.010+05:30

If you want to move or export your FaceBook photos and albums to Google Plus + or Picasa, then you can do this easily using web utility called MoveYourPhotos available in Chrome web store. Move Your Photos to Google Plus or Picasa Move Your Photos is available as Chrome browser add on, so you need to have Google Chrome browser to use this application. If you have joined Google's newly

Google Plus + Facebook Feeds Integration Extension

2011-07-08T12:54:00.006+05:30

. Integrate,Combine or fetch Facebook feeds in google plus with google+facebook extension. Recently google has launched it's new social networking platform google Plus(google +), and if you want to Integrate your facebook feeds inside it then this extension is for you. . Google+Facebook allows you to see or integrate your Facebook stream inside Google Plus(Google+). Simply Connect to

Add Expires Headers In Asp.NET

2011-07-05T16:48:00.008+05:30

In this example i am Explaining how to add or set expires headers for static files or images in asp.net 2.0, 3.5 Performance is the main concern for any asp.net web application and bit of this can be achieved by setting expires headers for static files and images which doesn't change too often. when expires headers are set for a future date or to never expires then browser fetch these

No Edit Html Option In New Blogspot/Blogger In Draft

2011-06-17T11:25:00.013+05:30

. If you are a blogspot/blogger user, then u may have noticed the blogger have removed the Edit Html Link from new blogger in draft dashboard. This is quite frustrating as u can't not edit html of ur page. But there are still 2 options to go to HTML code of ur template. Please use This FeedBack Form to let blogger team know that you want Edit Html Option in New blogger 1st Option

AutoCompleteExtender Example Ajax

2011-04-29T00:57:00.004+05:30

In this post i m showing some Ajax AutoComplete Extender Examples using ASP.NET C# and VB.NET with Database and WebService. Ajax autocomplete extender textbox in GridView In this example i am implementing the AutoComplete functionality to textbox in the EditItemTemaplate of GridView using AJAX autocomplete extender, for this we need to create a web service which calls the method to fetch

GridView EditItemTemplate Example

2011-04-25T22:05:00.003+05:30

In this post i am listing some GridView EditItemTemplate examples in Asp.Net 2.0,3.5 with Csharp and VB.NET. Ajax autocomplete extender textbox in GridView Example of Ajax Autocomplete Extender TextBox in EditItemTemplate of GridView. Insert Update Edit Delete record in GridView Insert Update Edit and Delete Records In GridView using ItemTemplate and EditItemTemplate. Search

ObjectDataSource Examples With GridView In ASP.NET

2011-04-24T15:25:00.003+05:30

Examples of ObjectDataSource With GridView in Asp.Net 2.0 and 3.5 with ObjectDataSource UpdateMethod, InsertMethod and Select Method using C# csharp and VB.NET. Here i have compiled list of few examples of GridView/DataList with ObjectDataSource i posted earlier in this blog. Hide GridView Columns In ASP.NET Display Images in Gridview/DataList using Objectdatasource

GridView Examples in ASP.NET 2.0 3.5

2011-04-14T03:04:00.020+05:30

Here is the list of some Gridview examples in asp.net 2.0 and 3.5 using c# and vb.net. Merge GridView Header Columns or multiple Headers Search Records In GridView And Highlight Results Using AJAX Export GridView To PDF In ASP.NET Ajax ModalPop Extender In Master Detail Gridview Export paging enabled GridView to pdf using iTextSharp Delete Multiple Rows

GridView Filter Expression with DropDownList ASP.NET

2011-04-08T15:36:00.015+05:30

This example describes how to use GridView Filtering or Filter Gridview with DropDownList FilterExpression and filter paramaters in asp.net 2.0,3.5 with sql server 2008 and SqlDataSource. I m using northwind database and customers table to show data and filter gridview with dropdownlist. First of all open aspx page in design view and place 2 dropdownlist, 1 gridview and 3 SqlDatasource on the

ModalPopUpExtender In Gridview

2011-04-04T14:28:00.036+05:30

Ajax ModalPopUpExtender in master detail grdiview to open popup. In this sample code example i am going to describe how to use Ajax ModalPopUp Extender in Gridview to display master detail or parent child data using sqlDataSource, AjaxControlToolkit,Sql Server 2008 and visual studio 2008. I have used "Orders" and "Customers" table of Northwind database for this example. Read install

Install Northwind pubs database on sql server 2008

2011-04-02T17:46:00.008+05:30

In this post i am going to describe how to install northwind or pubs sample database on sql server 2008. Follow steps mentioned below 1. Download and install SQL2000SampleDb.msi from Microsoft Download center It will be installed in "C:\SQL Server 2000 Sample Databases" folder. Move Northwind and Pubs database files (MDF and LDF files) to your default database file location (C:\Program

Ajax ModalPopUpExtender Example

2011-03-30T09:41:00.016+05:30

In this example i'm going to describe how to implement Ajax Modal PopUp Extender on Mouse Over in ASP.NET using C# and VB.NET For this to work u need to download and install ajaxcontroltoolkit Read ModalPopUpExtender In Gridview To know how to use modalpopup Extender in master detail gridview Create a new website in visual studio and write html markup of aspx page as shown below. Put

Import Gmail Contacts In Asp.Net

2011-01-12T20:19:00.024+05:30

Several times we need to develop web applications which require to import or fetch Gmail Contacts or address book. In this example i'm explaining how to fetch or import Gmail contacts in Asp.net web applications using C# and VB.NET. For getting started we need to download Google Data API and install on the system to get the desired dlls. Create a new website and visual studio and put these 3

Resize Image Before/And Upload To Databse ASP.NET

2010-02-27T00:55:00.017+05:30

In this example i am going to describe how to resize image in ASP.NET before/and upload to ms sql database using C# and Vb.NET. For this i am using FileUpload control to upload the image in datbase after resizing. I am also displaying the Image in Gridviw after uploading to database. To know how to display images in gridview read Display Images In GridView From DataBase ASPX

Sql Server Shared Memory Provider error 233 No process is on the other end of the pipe

2010-01-21T13:44:00.002+05:30

Cannot connect to SQLEXPRESS. A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) If you are getting this erro while connecting to sql express server then you need to make changes mentioned below. 1. Click

Send Email With Attachment in asp.net

2009-10-14T18:48:00.007+05:30

In this example i am going to describe how to send email with attachment in ASP.NET using fileUpload Control. I am saving the uploaded file into memory stream rather then saving it on server. And for this example i m using Gmail SMTP server to send mail, this code also works fine with any SMTP Server. For sending Email in ASP.NET , first of all we need to add Syatem.Net.Mail namespace in

ASP.NET Open PopUp Window Update Refresh Values

2009-09-12T22:13:00.010+05:30

In this example i am going to describe how to open popup window from aspx page with values from parent page, and update or refresh values in parent window from child or popup window using javascript and ClientScript.RegisterStartupScript method in ASP.NET I have added to labels in Default.aspx page and one button to open popup window. I've also added a PopUp.aspx page which is having two

AutoCompleteExtender TextBox CompletionList Width Ajax ASP.NET

2009-09-08T19:42:00.008+05:30

In this example i am going to describe how to set Width of Completion List in Ajax AutoComplete Extender TextBox. The default behavior of completion list takes width equal to the width of textbox. we can change this behavior by applying some CSS style to set the width we want. default width is as shown below in the Image. To read how to implement AutoComplete extender TextBox in GridView , go

Detect Page Refresh In ASP.NET

2009-09-07T19:03:00.010+05:30

If you have created a aspx page using C# and ASP.NET and have put a button on it. And in the Click event of this button if you are inserting some data in database , after click if user refresh the page than click event gets fired again resulting data insertion to database again, to stop events on the page getting fired on browser refresh we need to write bit of code to avoid it In this example

Pass Send GridView Row Value/Data Using Hyperlink in ASP.NET

2009-09-01T11:13:00.013+05:30

In this example i am going to describe how to pass transfer or send GridView data or values from GridView row to Other asp.net page using hyperlink in GridView. I've put a hyperlink column in gridview to pass values through querystring, and using request.querystring on the second page to retrieve values. You would also like to read LinkButton in GridView and QueryString in ASP.NET to pass data

NULL In GridView EVAL Calling Serverside Method In ItemTemplate

2009-08-29T15:28:00.005+05:30

In this example i am going to describe how to handle NULL values from DataBase in Eval method of GridView ItemTemplate or How to call Server side method written in code behind in ItemTemplate of GridView. My Table in database look like as shown in image below, some columns contains NULL values and i'll be showing "No Records Found" instead of NULL values in GridView. To achieve this i've

Send Email Using Gmail in ASP.NET

2009-08-27T00:22:00.006+05:30

If you want to send email using your Gmail account or using Gmail's smtp server in ASP.NET application or if you don't have a working smtp server to send mails using your ASP.NET application or aspx page than sending e-mail using Gmail is best option. you need to write code like this First of all add below mentioned namespace in code behind of aspx page from which you want to send the mail.

RadioButtonList DropDownList In GridView Edit Mode In ASP.NET

2009-08-26T11:08:00.011+05:30

In this example i am going to describe how to implement RadioButtonList and DropDOwnList in Edit mode of GridVIew using EditItemTemaplate in ASP.NET C# and VB.NET. RadioButton and DropDOwnList are selected in edit mode based on value saved in DataBase HTML markup of aspx page is mentioned below

Merge GridView Cells Or Columns in Row ASP.NET C# VB.NET

2009-07-31T22:11:00.017+05:30

In this example i am going to describe how to merge GridView cells or Columns in gridview rows containing same data or content using C# and VB.NET in ASP.NET For this i m using DataBound Event of gridview, counting total rows and then checking each cells value against value of same cell in previous row and then setting the RowSpan of cells. For this i have created a table containing Counties

SubReports in Crystal Reports SubReport

2009-07-23T21:58:00.006+05:30

In this example i am going to describe how to create SubReports in Crystal Reports or Crystal Reports SubReport in ASP.NET. For this i have used two tables from MS SQL database named Employees and Projects. Main Crystal Report is fetching data from both the tables and is grouped by Project Name SubReport is used to display information about respective project and fetching data from Projects

Combine Multiple Columns And Records In MSSQL

2009-07-23T00:28:00.015+05:30

Combine Multiple Columns And Records Into one column in MSSQL Server In this example i am going to describe how to combine multiple columns and records in one column in MS SQL. Here is the scenario I have a table having Employees names and their respective Department names, now i want to show Employees names separated by comma into one column and respective Department name in another column

Running Total In Gridview Footer in ASP.NET C# VB.NET

2009-07-21T10:32:00.008+05:30

In this example i am going to demonstrate how to display running total in footer row or footer template of GridView in ASP.NET using C# and VB.NET. This method works with paging enabled gridview as well. For demo purpose gridview is populated using sqldatasource having table with columns ID ,Name,Amount I m showing total of amount column is gridview footer. for this we need to sum the the

Crystal Reports in Winforms Windows Forms with Parameters

2009-07-14T23:56:00.018+05:30

In this example i am explaining how to create crystal reports in winforms or windows forms windows application with parameters from user to filter report using C#.NET and VB.NET For this i have created two tables in database named Employees and Projects and fetching data from both tables I've grouped results by Department name using group expert in crystal reports and put a dropdown on the

Scrollable GridView With Fixed Headers Asp.Net

2009-07-13T19:30:00.019+05:30

Scrollable gridview with fixed headers in asp.net 2.0 and 3.5. In this example i am going to show how to create scrollable GridView with fixed headers which don't get scrolled with records and stay on the top in asp.net using css, I've tested this code on IE7 and Firefox 2.0 , 3.5. For this we need to add css to headers of gridview to keep them on the top. First of all place a Panel on the

FileUpload Save Images In SqlServer Database in ASP.NET

2009-07-12T14:37:00.017+05:30

Upload Save or store image or images in ms sql server database using file upload control in asp.net. In this example i am Uploading Images using FileUpload Control and saving or storing them in SQL Server database in ASP.NET with C# and VB.NET. Database is having a table named Images with three columns. 1. ID Numeric Primary key with Identity Increment. 2. ImageName Varchar to store Name of

Display Images In GridView From SqlServer DataBase Asp.Net

2009-07-10T18:56:00.025+05:30

In this example i am showing how to display or retrieve images in GridView from Ms Sql Server DataBase in ASP.NET using C#.NET and VB.NET or showing images stored or saved in SQL Server database in gridview,For this i've already stored images in Database. Table schema is shown below, ID column is primary key with Identity increment,datatype of Image column is Image. To know how to save

PageMethods is undefined ASP.NET AJAX

2009-07-09T20:39:00.010+05:30

Well If you are getting PageMethods undefined error while using AJAX in ASP.NET or while using a webservice than you need to check these things to resolve the issue 1. PageMethods needs to be static [WebMethod] public static int MethodName() { } 2. Enable pageMethods in scriptManager

Crystal reports in ASP.NET

2009-07-08T23:20:00.016+05:30

In this example i m going to describe how to create crystal reports in ASP.NET. In this i am generating report by fetching data from two tables and grouping them based on Project Name. Database tables are just for demo purpose you can create your own tables with whatever schema you want Two tables are as shown below. Create a new website and right click on solution explorer > add new Item >

ASP.NET Images in Gridview/DataList using objectdatasource

2009-06-29T11:40:00.012+05:30

In this example i am going to explain how to display Images in GridView or DataList using ObjectDataSource. For this first of all we need to create a Object to populate gridview or DataList. Right click on solution explorer and add new class, name it whatever you want to. In this class write a method to populate GridView, i'm creating a DataTable and adding some records. The C# code behind

Read Write Edit Word Document With FileStream StreamWriter ASP.NET

2009-06-17T19:00:00.008+05:30

In this article i am going to describe how to read and write to ms word file or document in ASP.NET using FileStream, StreamReader and StreamWriter. For this i've added a textbox for input text to be written in word document and a button to write, same for reading text from word file. The word file created is saved in a folder named document in root of application. which can be changed to

ASP.NET Custom MemberShip Provider Database

2009-06-12T14:45:00.004+05:30

Creating or Using Custom MemberShip Provider Database in ASP.NET If you want to use Custom or your own DataBase as membership Provider instead of ASPNETDB.MDF database provided by asp.net membership provider class, than follow the steps mentioned in this article. In this example i m going to describe how to change and use custom Database with Login Control in ASP.NET. First of all you need to

Insert Edit Update GridView with ObjectDataSource

2009-06-09T16:41:00.004+05:30

In this example i am going to describe how to edit and update GridView using ObjectDataSource For this i've created a simple database with a table named Details having 3 columns ID,Name and Location. Open Visual studio and create a new website. Now right click on solution explorer and select add new Item > Sql Database > name it DataBase.mdf Create a table with columns i mentioned above in this

Send Email using Gmail Or SMTP ASP.NET C# VB.NET

2009-06-06T00:01:00.011+05:30

Trace Mobile Number In India

2009-06-05T00:02:00.006+05:30

Trace mobile number in india Enter phone number in textbox and Use the trace button below to trace mobile phone number in india. You can also track operator name and Circle of mobile number. ch_client = "jainamit"; ch_width = 500; ch_height = 250; ch_type = "mpu"; ch_sid = "Chitika Default"; ch_backfill = 1; ch_color_site_link = "#560E00 "; ch_color_title = "#560E00 "; ch_color_border

Unable to debug The binding handle is invalid VS2005

2009-05-30T02:39:00.003+05:30

If you are trying to debug in Visual Studio 2005 and and not able to use breakpoints and getting unable to debug - the binding handle is invalid error in VS 2005 than follow these steps to fix this error. Go control panel of your windows OS Double click on Administrative tools > services Now in services window > look for Terminal Services Right click on it ans select properties > check

AutoNumber Column or Auto Number in GridView or DataList ASP.NET

2009-05-22T22:56:00.005+05:30

Several times we need to display Auto Number or serial number for displaying records in gridview or other similar controls in ASp.NET. We can add AutoNumber column by using Container.DataItemIndex property in html markup of the Gridview. Here's the sample html markup for the page Auto Number Cloumn in GridView

AutocompleteExtender Textbox Loading Progress Image

2009-05-20T20:50:00.012+05:30

Add or show Animated Loading or progress GIF Image in Ajax AutoCompleteExtender textbox using asp.net 2.0 and 3.5. In this example i m going to describe how to add animated Progress Image inside Ajax Auto complete extender textbox to represent loading of data. For achieving this functionality i am using two different approaches for different versions of AjaxControlToolkit.dll If you are

Add Dynamic CheckBox Handle CheckedChanged Event ASP.NET

2009-05-18T15:08:00.008+05:30

Add Dynamic CheckBox And Handle CheckedChanged Event In ASP.NET Several times we need to add dynamic controls in asp.net application using code behind. In this post i am going to describe how to add dynamic CheckBox and assign CheckChanged event in asp.net using C# and VB.NET To add a checkbox when page is loaded we need to write this code in page_Load Event C# Code Behind public partial

Shopping Cart Example Code In ASP.NET GridView DataList

2009-05-16T11:33:00.030+05:30

Creating Shopping cart example source code using asp.net 2.0,3.5 with gridview and datalist C#.NET,VB.NET In this example i'm using GridView and DataList controls to create Products page and Product Details page in online shopping cart example First of all we need to create a ShoppingCart class, for this right click on solution explorer and add new class, name it ShoppingCart.cs Write

Insert Update Edit Delete record in GridView

2009-05-13T19:33:00.013+05:30

In this example i am going to describe how to Insert record or edit or delete record in GridView using SqlDataSource. For inserting record, i've put textboxes in footer row of GridView using ItemTemplate and FooterTemaplete. Go to design view of aspx page and drag a GridView control from toolbox, click on smart tag of GridView and choose new datasource Select Database and click Ok In next

Edit Update Multiple Records/Rows In Gridview With Checkbox ASP.NET

2009-05-05T20:51:00.025+05:30

In this example i am going to explain 2 different approaches to Edit update and delete multiple records or rows in Gridiew with checkboxes to select rows to be edited with delete confirmation using JavaScript. In my previous post i explained how to Delete multiple rows in Gridview with checkbox and delete confirmation Javascript First Method In this GridView is getting populated from

Delete Multiple Rows Records Gridview CheckBox Confirmation

2009-04-30T22:15:00.018+05:30

Several times while developing web applications we need to implement functionality to delete bulk / multiple rows or records in Gridview using checkbox to select rows / records to be deleted with confirmation dialog box. In this example i am showing how to achieve it. You can also read how to Edit or update multiple records/rows in gridview with checkbox using C# I've put a Delete Button in

Export Import Excel Data into Sql Server Using SqlBulkCopy-ASP.NET

2009-04-25T20:50:00.015+05:30

In this example i am going to describe how to Import or insert data into Sql server from Excel spreadsheet using sqlbulkcopy method. First of all create a Excel workbook as shown in image below and insert some data into it. Create a table in SQL database as shown in image Now write this code to insert data into SQL table public partial class _Default : System.Web.UI.Page { string

Find Track mobile phone number location in india

2009-04-22T10:35:00.010+05:30

If you want to find or trace mobile phone number location in India operator or circle name than simple go to link mentioned below Click this link to trace mobile phone location and operator in India Just enter 10 digits phone number in the search box and click on Trace Have fun Related posts: Track Mobile Phone number location and operator in India

Trace Mobile Number Location Operator in India

2009-04-21T21:40:00.042+05:30

Trace Mobile Number in India with Location and Operator Several times we feel the need to trace or track any mobile phone number , it's location and Operator name , for various reasons. If you are one of them then this will definitely help you to find any mobile phone number location and operator in India Enter mobile phone number in the search box and click on Trace. Enter 10

ASP.NET Bypass Forms Authentication Or Skip Authorization

2009-04-17T14:17:00.010+05:30

In my previous articles i explained how to use forms authentication in asp.net 1. C# Forms Authentication using ticket and managing user roles in asp.net 2. ASP.NET 2.0 - Forms Authentication with C# and managing folder lavel access with multiple web.config files And i also explained about how to validate use across pages using session and redirect to login page if user is not logged in User

The backup set holds a backup of a database other than the existing database-Sql Server Error 3154

2009-04-17T00:49:00.006+05:30

If you are getting Error 3154 or The backup set holds a backup of a database other than the existing database error while restoring backup of sql server from one system to another, Than you need use following command to get rid of this error and restore the Sql server database RESTORE DATABASE DataBaseName FROM DISK = 'C:\BackupFileName.bak' WITH REPLACE This will hopefully fix the error and