Saturday, June 28, 2008

How to get back Aircel duplicate SIM for our lost Aircel SIM


Dear Aircel customers just do simple steps to bring our lost Aircel SIM back, there are two ways.

First way to get back our SIM:

If possible directly go to the following Aircel Region head offices with needed documents at
The Aircel Chennai Office:
The Aircel Cellular Limited, 5th Floor, Spencer Plaza, 769, Anna Salai, Chennai - 600 002.

Phone No.: 91 - 44 - 2849 0849
Fax no.: 91 - 44 - 2849 6769

The Aircel Cellular Limited, No301 (Old No: 193), Poonamallee High road, Kilpauk, Chennai 600 010.

Phone no.: 91 – 44 – 25324141
Fax no.: 91 – 44 – 25323131


Aircel Madurai Office:
The Aircel limited, Aparna towers, 3rd floor, #2/3, By pass road, Madurai - 625 010.

Aircel Coimbatore Office:
The Aircel limited, Arthanari Towers, 3rd floor, No.114, Race course road, Coimbatore - 641018.

Aircel Trichy Office:
The Aircel limited, Lakshmi Complex, 2nd floor, 73B/1, Salai Road, Thillai Nagar, Trichy - 620 018.

Aircel Salem Office:
The Aircel limited, Blossom Plaza, 2nd floor, Four Roads, Salem - 636 007.

Aircel Pondicherry Office:
The Aircel limited, Ajitraj Building, 1st floor, 13, 2nd cross, Anna Nagar, Pondicherry - 605 005.

Second way to get SIM back:

Sent the needed documents to the following address, they will send back your duplicate Aircel SIM.

The Aircel Limited, Codissia Towers, #5, T.B.Road (Huzur Road), Coimbatore-641018

Needed Documents we have to provide:

1. DD for amount RS. 102 /-
2. Request Letter with your address and Photo
2. Valid Photo Id Proof with Address Proof
4. Information related to our SIM
Such as Sim number, Last recharge date/amount, your plan, add-on numbers, if possible photo copy of new SIM package with sim and serial number.

That’s enough; they will send back our sim to our given address. By the second way i got my sim back. Enjoy every moment with Aircel

Friday, June 13, 2008

Dynamically Adding multiple row header to a datagrid

To add a row to a datagrid header dynamically use following code. Here we just adding new cells to the the datagrid at header ItemDataBound Event.

#VB.Net code:

Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal ev As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid.ItemDataBound ' Add a second header on a datagrid
If ev.Item.ItemType = ListItemType.Header Then ' Get the collection of cells from the datagrid
Dim totCells As TableCellCollection
' Get the collection of existing cells so we can get a count
totCells = ev.Item.Cells
' Create a new datagrid header object
Dim dgHeader As New DataGridItem(0, 0, ListItemType.Header) ' Add the created cell to the header
Dim vblCount As Integer
Dim vblCounter As Integer
vblCount = totCells.Count
vblCounter = 0
While vblCount > 0

'Creation of a new cell for datagrid
Dim CreatedCell As New TableCell
'To skip first cell of our grid
If vblCounter > 1 Then
CreatedCell.Text = "Text for New Cell"
End If

dgHeader.Cells.Add(CreatedCell)

vblCounter = vblCounter + 1
vblCount = vblCount - 1

End While
'While Closes here

dgHeader.Visible = True ' Add the header to the datagrid
DataGrid.Controls(0).Controls.Add(dgHeader)
End If
' If ends here
End Sub ' ItemDataBound Ends here

Thursday, June 5, 2008

Internet Explorer ( IE ) Shortcuts for Latest Version

Keyboard shortcuts

To Open links in a new tab in the background CTRL+click
To Open links in a new tab in the foreground CTRL+SHIFT+click
To Open a new tab in the foreground CTRL+T
To Open a new tab from the Address bar ALT+ENTER
To Open a new tab from the search box ALT+ENTER
To Open Quick Tabs (thumbnail view) CTRL+Q
To Switch between tabs CTRL+TAB/CTRL+SHIFT+TAB
To Switch to a specific tab number CTRL+n (n can be 1-8)
To Switch to the last tab CTRL+9
To Close current tab CTRL+W
To Close all tabs ALT+F4
To Close other tabs CTRL+ALT+F4



Mouse shortcuts

To Open a link in a background tab - Click the middle mouse button on a link
To Open a new tab - Double-click the empty space to the right of the last tab
To Close a tab - Click the middle mouse button on the tab

Wednesday, April 30, 2008

Adding Empty Row to a Data Grid

How to add empty row in a datagrid.

* Create and add an empty Row for a Data Table.
* Assign the Datatable as dataSource for the datagrid.
* Bind the datagrid.

#VB.NET

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim dt as new DataTable
dt.rows.add(dt.NewRow())
DataGrid1.DataSource = dt
DataGrid1.DataBind()

End Sub



If we need just a template of a datagrid at runtime means, just bind an empty DataTable like below

#VB.NET

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim dt as new DataTable
DataGrid1.DataSource = dt
DataGrid1.DataBind()

End Sub

Compare two Dates in SQL Server

The below QUERY can compare two dates in sql server. In that query CONVERT() function is exist. Date value is changed into varchar data type by using CONVERT() function . Here we change the DATETIME data type into varchar. So we got exact date alone. The query as follows....

SELECT *
FROM Login_Attendance
WHERE (DATEDIFF(day, CONVERT(varchar(10), currdate, 101), CONVERT(varchar(10), '4/25/2008', 101)) = 0)

Here,

101----> denotes the required format(mm/dd/yyyy) of the date

For eg:
currdate='4/25/2008 2:23:34 PM'