Click here to Skip to main content
15,917,481 members
Home / Discussions / C#
   

C#

 
AnswerRe: Sharepoint Gridview Pin
Richard MacCutchan14-Mar-14 0:21
mveRichard MacCutchan14-Mar-14 0:21 
AnswerRe: Sharepoint Gridview Pin
DipsMak14-Mar-14 0:35
professionalDipsMak14-Mar-14 0:35 
GeneralRe: Sharepoint Gridview Pin
Richard MacCutchan14-Mar-14 1:35
mveRichard MacCutchan14-Mar-14 1:35 
Questionhow to have Pin
jojoba201113-Mar-14 19:14
jojoba201113-Mar-14 19:14 
AnswerRe: how to have Pin
BillWoodruff13-Mar-14 23:00
professionalBillWoodruff13-Mar-14 23:00 
AnswerRe: how to have Pin
Pete O'Hanlon13-Mar-14 23:11
mvePete O'Hanlon13-Mar-14 23:11 
QuestionRe: how to have Pin
jojoba201113-Mar-14 23:23
jojoba201113-Mar-14 23:23 
AnswerRe: how to have Pin
Eddy Vluggen13-Mar-14 23:30
professionalEddy Vluggen13-Mar-14 23:30 
AnswerRe: how to have Pin
Pete O'Hanlon13-Mar-14 23:57
mvePete O'Hanlon13-Mar-14 23:57 
AnswerRe: how to have Pin
Ravi Bhavnani14-Mar-14 6:41
professionalRavi Bhavnani14-Mar-14 6:41 
QuestionHelp Please Pin
Member 1045276713-Mar-14 10:38
Member 1045276713-Mar-14 10:38 
AnswerRe: Help Please Pin
Richard Andrew x6413-Mar-14 11:33
professionalRichard Andrew x6413-Mar-14 11:33 
GeneralRe: Help Please Pin
Member 1045276713-Mar-14 23:35
Member 1045276713-Mar-14 23:35 
QuestionDLL Existance Test Pin
Stephen Wickland13-Mar-14 8:08
Stephen Wickland13-Mar-14 8:08 
AnswerRe: DLL Existance Test Pin
Eddy Vluggen13-Mar-14 8:39
professionalEddy Vluggen13-Mar-14 8:39 
GeneralRe: DLL Existance Test Pin
Stephen Wickland13-Mar-14 9:25
Stephen Wickland13-Mar-14 9:25 
AnswerRe: DLL Existance Test Pin
Abhinav S15-Mar-14 21:35
Abhinav S15-Mar-14 21:35 
QuestionRead Excel C# windows form using OleDB Connection Pin
Zeyad Jalil12-Mar-14 23:08
professionalZeyad Jalil12-Mar-14 23:08 
AnswerRe: Read Excel C# windows form using OleDB Connection Pin
Bernhard Hiller13-Mar-14 1:10
Bernhard Hiller13-Mar-14 1:10 
GeneralRe: Read Excel C# windows form using OleDB Connection Pin
Zeyad Jalil13-Mar-14 1:56
professionalZeyad Jalil13-Mar-14 1:56 
AnswerRe: Read Excel C# windows form using OleDB Connection Pin
Richard MacCutchan13-Mar-14 2:20
mveRichard MacCutchan13-Mar-14 2:20 
GeneralRe: Read Excel C# windows form using OleDB Connection Pin
Zeyad Jalil13-Mar-14 2:26
professionalZeyad Jalil13-Mar-14 2:26 
Hi ,

this is my code, please let me know if there is any problem in it.

string conString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=filepath;Extended Properties=Excel 12.0 XML;HDR=Yes;IMEX=1;MaxScanRows=0;";
OleDbConnection con=new OleDbConnection(conString);
con.open();
OleDbCommand command = new OleDbCommand("select * from [sheet1$]", con);
OleDbDataReader reader = command.ExecuteReader();
DataTable dt=new DataTable();
dt.load(reader);
con.close();
GeneralRe: Read Excel C# windows form using OleDB Connection Pin
Richard MacCutchan13-Mar-14 2:44
mveRichard MacCutchan13-Mar-14 2:44 
AnswerRe: Read Excel C# windows form using OleDB Connection Pin
OriginalGriff13-Mar-14 2:59
mveOriginalGriff13-Mar-14 2:59 
GeneralRe: Read Excel C# windows form using OleDB Connection Pin
Eddy Vluggen13-Mar-14 3:59
professionalEddy Vluggen13-Mar-14 3:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.