Sometimes we need to run *.sql script from our application for installing data base. SqlCommand is not right for running installation script because installation script consists of DDL and GO command. Here we use smo library for executing *.sql script.
For doing above operation we need to add following references
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.
When we need to transfer our object through internet or need to write in a file then it is necessary to convert it to XML. We can convert object to XML using XML Serialization. In this article we will discuss about how to convert object (It may be entity/ Data Container/ DTO) to XML.
Here we will use XML Serialization & Deserialization for converting our object to XML and XML to Object.
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;
It is easy to run your asp.net web application without installing any web server. For running your application without IIS you have to use Cassini Desktop Adapter.
Features of Cassini Desktop Adapter
* Standalone Web Applications – now on the Desktop
* 100% Embedded Web server
* No Installation or GAC Required
* No Administrator Privileges Required
* No XML / Configuration Files
* Cassini On-Demand
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];
This article is provide a basic idea how we can send Emails from a C# Windows Application.
Here I have described how we can send mail with Attachment and HTML body.
If we want to send mail then we need to know following things
1. SMTP Server address
2. Port No
Here I have used gmail as a SMTP Server
for gmail account
SMTP Server: smtp.gmail.com
SMTP port : 465 or 587
your account Name:###
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];
object values = new object[props.Count];
foreach (t item in data)
for (int i = 0; i < values.Length; i++)
values[i] = props[i].GetValue(item);
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();
After logging out we can prevent getting previous page or information by doing following things.
Add Code to Page Load event:
Or We can use following code