StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14748023
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-07T09:46:27.080
FavoriteCount
0
LastActivityDate
2013-02-07T09:46:27.080
LastEditDate
LastEditorUserId
0
OwnerUserId
837194
ParentId
14718971
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
So, the first problem you have is that your code is not doing what you think it does.The big problem is that you are reading in all the text and then only ever selecting the first three values of it.You don't give the format of your data, but suppose it looks like this: <pre><code>Scotland*Edinburgh*Midlothian* Scotland*Perth*Perthshire* </code></pre> Your code <pre><code>string groups = File.ReadAllText(ofdFile.FileName); </code></pre> Reads the whole file into one string, such that it will look like this <pre><code>Scotland*Edinburgh*Midlothian*\r\nScotland*Perth*Perthshire* </code></pre> So splitting it using the following <pre><code>string[] parts = groups.Split(new char[] { '*' }, StringSplitOptions.RemoveEmptyEntries); </code></pre> gives you a string array of 6 parts. Inserting multiple lines from this is doable but won't be very neat. You'd be much better to read your text files in by lines, and then iterate over the array of lines, splitting each one as you go and then adding the relevant parts to SQL. Something like <pre><code>string[] lines = System.IO.File.ReadAllLines(ofdFile.FileName); foreach (var line in lines) { string[] parts = line.Split('*'); AddtoSQL(parts[0], parts[1]); } </code></pre> That should insert all the data, but as an aside, if you are looking to execute numerous inserts at once, I'd recommend housing those inserts inside of a SQL Transaction. I'd direct you to have a look at <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqltransaction.aspx" rel="nofollow">this MSDN article on the SqlTransaction Class</a> The gist of it is that you declare a transaction first, then loop over your inserts executing those against the transaction. Finally, when you commit your transaction the queries are all written to the database en mass. The reason I'd do this is that it will be much quicker and safer.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAdding Multiple values to SQL Server table
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMartin McGirk
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. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.