StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POread xls with c# only getting part of data
primarykey
Id
18527651
data
AcceptedAnswerId
18528065
AnswerCount
2
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2013-08-30T07:48:30.217
FavoriteCount
0
LastActivityDate
2013-08-30T08:13:23.703
LastEditDate
2013-08-30T07:59:27.810
LastEditorUserId
1182885
OwnerUserId
1182885
ParentId
0
PostTypeId
1
Score
1
ViewCount
469
LastEditorDisplayName
text
Body
Im using c# to read data from an xls spreadsheet. it reads if fine but for some reason its missing the end off the content on some of the long data cells. below is some of my code <pre><code>string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=W:\translations-mk2.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(excelConnectionString)) { //List columns you need from the Excel file System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand("Select * FROM [phrases$]", connection); connection.Open(); // Create DbDataReader to Data Worksheet using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader()) { if (dr.HasRows) { int x = 1; while (dr.Read()) { //Response.Write(dr[1].ToString() + " : " + dr[6].ToString() + "&nbsp;&nbsp;"); string dbId = dr[0].ToString(); string htmlControl = dr[1].ToString(); string eng = dr[2].ToString(); string german = dr[4].ToString(); string greek = dr[6].ToString(); if (dbId == "65") { Response.Write("greek: " + dr[6].ToString()); } </code></pre> the content is in greek so what should be in the string is Καλωσορίσατε στον ιστότοπο της ADHD Alliance for Change (Συμμαχία για Αλλαγή στη ΔΕΠΥ). Η εκστρατεία ADHD Alliance for Change (Συμμαχία για Αλλαγή στη ΔΕΠΥ) είναι ένα ευρωπαϊκό έργο που τελεί υπό την καθοδήγηση μιας Συντονιστικής Επιτροπής Ανεξάρτητων Ευρωπαίων Εμπειρογνωμόνων σε θέματα ΔΕΠΥ (Διαταραχή Ελλειμματικής Προσοχής και Υπερκινητικότητας), το οποίο υλοποιείται με την υποστήριξη ομάδων υπεράσπισης ασθενών και αναπτύσσεται και χρηματοδοτείται από τη φαρμακευτική εταιρεία Shire. but what is in the string is this Καλωσορίσατε στον ιστότοπο της ADHD Alliance for Change (Συμμαχία για Αλλαγή στη ΔΕΠΥ). Η εκστρατεία ADHD Alliance for Change (Συμμαχία για Αλλαγή στη ΔΕΠΥ) είναι ένα ευρωπαϊκό έργο που τελεί υπό την καθοδήγηση μιας Συντονιστικής Επιτροπής Ανεξάρτητων Ευρ
Tags
<c#><asp.net>
Title
read xls with c# only getting part of data
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USandrew slaughter
UserOwnerUserId
1. USandrew slaughter
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POread xls with c# only getting part of data
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POread xls with c# only getting part of data
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTApproveEditSuggestion
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.