Click here to Skip to main content
15,868,016 members

Comments by Vinay Indoria (Top 23 by date)

Vinay Indoria 15-Jan-12 5:55am View    
Hi jinzai,
Thanks for your opinion.You are right its not worth the hassle.
Vinay Indoria 6-Jan-12 23:06pm View    
Thanks alot.
Vinay Indoria 4-Jan-12 5:31am View    
Hi RaviShankr,
This is the answer,I combined the various suggestions that _blueaw_ and bluesathish and completed the task that I have to achieve and for a single reference I put my work as an answer.
Thank you for your suggestion
Vinay Indoria 4-Jan-12 2:12am View    
Hurray Im through...
Thanks alot bluesathish it would have been difficult without you.
Dim objCmdSelect As New OleDbCommand("SELECT CId,SrNo,Format(Date,""dd/MM/yyyy""),Name," & aftnam & ",Format(DOB,""dd/MM/yyyy""),Age," & aftdob & " FROM tempcsformat.csv", objConn)
Dim objAdapter1 As New OleDbDataAdapter
objAdapter1.SelectCommand = objCmdSelect
objAdapter1.Fill(objDataset1, "test")
objConn.Close()
Vinay Indoria 4-Jan-12 1:52am View    
ok now I am getting this format function well but if I pass the format in where clause it would return date's with only dd/MM/yyyy format,then what about the other date's of MM/dd/yyyy format.
Can I use convert function means it convert's the entire column in sql like

convert(datetime,Date,105)

where 1st parameter gives the type,2nd the column and 3rd is the format i.e,105 for dd/MM/yyyy
I have used convert in SQL but im not sure about a csv file.