ASP.NET

Public Shared Function GetFormattedDate(ByVal strDate As String, _
 Optional ByVal InputFormat As char = "d") As Date
   Dim dtFormat As New DateTimeFormatInfo
   If InputFormat = "d" Then
     dtFormat.ShortDatePattern = "dd/MM/yyyy"
   Else
     dtFormat.ShortDatePattern = "MM/dd/yyyy"
   End If
   Return Date.Parse(strDate, dtFormat)
End Function

Rahul Babu wrote:

OleDbCommand cmd = new OleDbCommand("select * from [chapters$]",conn);

Can anybody tell me how can i select a particular column. For eg: if the column name is like 'chapter_no'

OleDbCommand cmd = new OleDbCommand("select [chapter_no] from [chapters$]",conn);

OleDbCommand cmd = new OleDbCommand("select [chapter no] from [chapters$]",conn);

chanu007 wrote:

just tell me which is best .

Shah_Thought wrote:

But my suggestion is to use anyone from this four.

1)Session
2)QueryString
3)Coockies
4)ViewState