retriveving excel data in to grid view

Question

hi friends  please help me in retrieving the excel data in to grid view... the excel containing info like ----------- regd no name branch address fee-particulars so the data in the above columns has to be displayed in the grid view.. thanks in advance......

Koteswararao Mallisetti · Answer

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} this is the provider settings or sqlconnection settings for ms excel once we complete this every this is common like sqlcommanddatasetdataadapter sqlconnection con= new sqlconnectio(provider=Microsoft.Jet.OLEDB.4.0;Data Source='Your Filename';Extended Properties=Excel 8.0;) but select statement is sytanx is some differ like this way ample Select sql sqlcommand cmd = new sqlcommand(select * from [Sheet1$] where conditioncon); if it satisfies you accept this answer by clicking thumb up symbol

Satyapriya Nayak · Answer

Hi chiranjeevi This is a simple application i did of your requirements.Run the attachments. Thanks If it helps you plz mark the answer as Accepted answer

Sam Hobbs · Answer

Also look at the articles in this web site about Excel.