StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14934005
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-18T10:22:37.790
FavoriteCount
0
LastActivityDate
2013-02-18T10:22:37.790
LastEditDate
LastEditorUserId
0
OwnerUserId
1978171
ParentId
14931747
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
<p>Okay so what you are looking to do is insert to a database and not read from it so you therefore have to simply execute an sql query on the database and not read any data selected from it. For this you need to use the ExecuteNonQuery statement rather than the sqlDataReader. The result would look something like this</p> <pre><code>public static bool saveToDb(string name1, string nam2, DateTime dat) { bool ok = false; string sqlQuery = "INSERT INTO NumbersTable VALUES (@name1, @nam2, @dat)"; //This is the sql query we will use and by placing the @ symbol in front of words //Will establish them as variables and placeholders for information in an sql command //Next we create the sql command SqlCommand cmd = new SqlCommand(sqlQuery, con); //Here we will insert the correct values into the placeholders via the commands //parameters cmd.Parameters.AddWithValue("name1", name1); //This tells it to replace "@name1" with the value of name1 cmd.Parameters.AddWithValue("nam2", nam2); cmd.Parameters.AddWithValue("dat", dat); //Finally we open the connection con.Open(); //Lastly we tell the sql command to execute on the database, in this case inserting //the values int i = cmd.ExecuteNonQuery(); //Here we have the results of the execution stored in an integer, this is because //ExecuteNonQuery returns the number of rows it has effected, in the case of this //Insert statement it would effect one row by creating it, therefore i is 1 //This is useful for determining if your sql statement was successfully executed //As if it returns 0, nothing has happened and something has gone wrong con.Close(); } </code></pre> <p>I hope this has helped, if you need anything else feel free to ask.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POInsert values into SQL Server table using SqlDataReader
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USRyoku
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.