3
Answers

retriveving excel data in to grid view

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......
Answers (3)
1
Koteswararao Mallisetti

Koteswararao Mallisetti

NA 1.1k 468.9k 14y

this is the provider settings or sqlconnection settings for ms excel once we complete this every this is common like sqlcommand,dataset,dataadapter

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 condition",con);


if it satisfies you accept this answer by clicking thumb up symbol

 

0
Satyapriya Nayak

Satyapriya Nayak

NA 53k 8m 14y
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
0
Sam Hobbs

Sam Hobbs

NA 28.7k 1.3m 14y
Also look at the articles in this web site about Excel.