Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Answer
Importing Excell Sheet Which Include Check Boxes
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Hari babu
11y
854
1
Reply
Dear Sir/Madam,
I am planning to import Excel 2007 data into my Database. As of initial work I am reading excel sheet data into DataTable using
OleDbDataAdapter
. But the problem is I am unable to read CheckBox controls data into my dataset. It is showing empty values for check box fields . I am sharing lines of code I am using.
DataTable dtTrainers;
dadVET = new OleDbDataAdapter("Select * From [SheetName$]", myConnection);
dtTrainers = new DataTable("TrainersAndAdminStaff");
dadVET.FillSchema(dtTrainers, SchemaType.Source);
dadVET.Fill(dtTrainers);
Please if you have any idea update solution asap.
Thanks & Regards,
T.Hari babu
E-Mail :
[email protected]
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
How to populate dropdownlist and add values to database.
Data Binding in C#