bind excel sheet data in grid view

See more:

ASP.NET4

Hello

I am binding Excel sheet data in a grid view and it is working fine, but in excel sheet there is a date, which is coming like 7/27/2013 12:00:00 AM but in excel sheet it is 27/07/2013.

I need it in a format, when date field will come it will show in a format don't need time.
My code for bind excel sheet is :-

OleDbConnection oconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file_name + ";Extended Properties=Excel 8.0");
                OleDbCommand ocmd = new OleDbCommand("select * from [Requisition$]", oconn);
                oconn.Open();
                OleDbDataReader odr = ocmd.ExecuteReader();
                GridView1.DataSource = odr;
                GridView1.DataBind();
                oconn.Close();

if any solution then please help.

Thanks..