Send Email With Attachment in ASP.NET

2009-10-14T18:48:00.005+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

Open PopUp Window Update Refresh Parent Values From Child ASP.NET

2009-09-12T22:13:00.009+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.007+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.000+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.005+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 in ASP.NET

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

In this example i am going to describe how to create SubReports in Crystal Reports 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 Table. Schema for both the

Combine Multiple Records Comma Separated In One Column MSSQL

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

In this example i am going to describe how to combine multiple records in a column in MS SQL into one record comma separated. 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. My table schema is shown in the image below And

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 C#.NET VB.NET

2009-07-14T23:56:00.017+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 in asp.net C# vb.net

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

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 aspx page from thetoolbox. Set height to 200px and width to 200px

FileUpload Save Images in Database in ASP.NET C# VB.NET

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

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 Image. 3. Image Image to store image in binary format. After uploading and saving images in database,

Display Images In GridView From DataBase C# VB.NET

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

In this example i am showing how to display images in GridView from DataBase in ASP.NET using C#.NET and VB.NET or showing images stored 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 or store Images in DataBase visit

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 Login Control with custom membership provider database

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

If you want to use Login Control of ASP.NET with Custom DataBase and custom membership Provider 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 create DataBase schema for membership. For this create a DataBase in sql server with any name you want. Now open Visual

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

C#.NET ASP.NET Articles VB.NET CSHARP code Examples samples tutorials