StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow do I store source code lines in SQL Server Database and access it via DataSet
primarykey
Id
5155386
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2011-03-01T13:51:20.347
FavoriteCount
0
LastActivityDate
2011-03-02T08:10:59.683
LastEditDate
2011-03-01T16:59:04.923
LastEditorUserId
502926
OwnerUserId
502926
ParentId
0
PostTypeId
1
Score
1
ViewCount
921
LastEditorDisplayName
text
Body
I want to store the following code into the database: <pre><code>fun(...); int main() { fun(3, 7, -11.2, 0.66); return 0; } fun(...) { va_list ptr; int num; va_start(ptr, n); num = va_arg(ptr, int); printf("%d", num); } </code></pre> and then get it back in the dataset and display on a page. As of now I have successfully stored the questions with <code>varchar(MAX)</code> datatype but when I try to get it in the dataset i get the following error: <code>Failed To Enable Constraints. One Or More Rows Contain Values Violating Non-null, Unique, Or Foreign-key Constraints.</code> I am doing this in a ASP.NET web application. EDIT: Here is the Table definition of the table I am inserting the data into <img src="https://i.stack.imgur.com/ocksk.png" alt="Database Definition"> The query I am using to insert the data into the table: <pre><code>con.ConnectionString = constr; cmd.Connection = con; cmd.CommandText = "insert into QuesTable values(@D1,@D2,@D3,@D4,@D5,@D6,@D7, NULL)"; cmd.Parameters.Add("@D1", SqlDbType.Int).Value = txtQID.Text; cmd.Parameters.Add("@D2", SqlDbType.VarChar).Value = txtques.Text; cmd.Parameters.Add("@D3", SqlDbType.VarChar).Value = txtansa.Text; cmd.Parameters.Add("@D4", SqlDbType.VarChar).Value = txtansb.Text; cmd.Parameters.Add("@D5", SqlDbType.VarChar).Value = txtansc.Text; cmd.Parameters.Add("@D6", SqlDbType.VarChar).Value = txtansd.Text; cmd.Parameters.Add("@D7", SqlDbType.VarChar).Value = txtcorr.Text; con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); </code></pre> And finally the code by which I am extracting the data from the dataset <pre><code>DataSet1.QuesTableDataTable dt = new DataSet1.QuesTableDataTable(); DataSet1TableAdapters.QuesTableTableAdapter adp = new DataSet1TableAdapters.QuesTableTableAdapter(); dt = adp.GetData(); DataTable dtUser = dt.Clone(); </code></pre> Hope the information is helpful.
Tags
<c#><asp.net><dataset>
Title
How do I store source code lines in SQL Server Database and access it via DataSet
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPiyush
UserOwnerUserId
1. USPiyush
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
 POHow do I store source code lines in SQL Server Database and access it via DataSet
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.