Click here to Skip to main content
15,070,511 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Server login problem Pin
Vimalsoft(Pty) Ltd27-Aug-09 0:04
professionalVimalsoft(Pty) Ltd27-Aug-09 0:04 
AnswerRe: SQL Server login problem Pin
cdpace28-Aug-09 11:33
Membercdpace28-Aug-09 11:33 
AnswerRe: SQL Server login problem Pin
mlowry29-Aug-09 6:32
Membermlowry29-Aug-09 6:32 
Questionxml schema Pin
Ebube25-Aug-09 6:19
MemberEbube25-Aug-09 6:19 
AnswerRe: xml schema Pin
Henry Minute25-Aug-09 6:56
MemberHenry Minute25-Aug-09 6:56 
QuestionCreating the XML Schema Pin
Ebube25-Aug-09 1:15
MemberEbube25-Aug-09 1:15 
AnswerRe: Creating the XML Schema Pin
David Mujica25-Aug-09 3:13
MemberDavid Mujica25-Aug-09 3:13 
QuestionADO.NET / Update Column in memory Pin
Sebastian Br.24-Aug-09 23:42
MemberSebastian Br.24-Aug-09 23:42 
Okay, I'm new to the whole ADO.NET stuff, so don't punish me to hard if I ask a total bullshit question...

First, here's a piece of code (assume, aDataSet is already initialized and the table "aTable" also exists):
Dim aRow As DataRow
aDataSet.Tables("aTable").Columns.Add("isParent", System.Type.GetType("System.Boolean"))
For Each aRow In Me.mDataSet.Tables("aTable").Rows
    aRow.Item("isParent") = True
Next


What I wanna do: Add the new column "isParent" to "aTable" (okay, I managed this), and initialize it with a standard value (I do this in the for-next-loop). But I thought, there must be a more elegant way to do this, without picking every single cell in a loop. Anyone know a good solution?

I don't need to write in a database, 'cause my aDataSet is build on the fly, without database representation.
AnswerRe: ADO.NET / Update Column in memory Pin
N a v a n e e t h25-Aug-09 2:05
MemberN a v a n e e t h25-Aug-09 2:05 
GeneralRe: ADO.NET / Update Column in memory Pin
Sebastian Br.25-Aug-09 2:55
MemberSebastian Br.25-Aug-09 2:55 
QuestionCHECKING NULL VALUES Pin
dotnetcsharpdev24-Aug-09 23:31
Memberdotnetcsharpdev24-Aug-09 23:31 
AnswerRe: CHECKING NULL VALUES Pin
dotnetcsharpdev25-Aug-09 0:19
Memberdotnetcsharpdev25-Aug-09 0:19 
GeneralRe: CHECKING NULL VALUES Pin
Ashfield26-Aug-09 1:43
MemberAshfield26-Aug-09 1:43 
Questionregarding foreignkey data Pin
kheer24-Aug-09 23:12
Memberkheer24-Aug-09 23:12 
AnswerRe: regarding foreignkey data Pin
dotnetcsharpdev24-Aug-09 23:33
Memberdotnetcsharpdev24-Aug-09 23:33 
GeneralRe: regarding foreignkey data Pin
kheer24-Aug-09 23:58
Memberkheer24-Aug-09 23:58 
GeneralRe: regarding foreignkey data Pin
dotnetcsharpdev25-Aug-09 0:16
Memberdotnetcsharpdev25-Aug-09 0:16 
GeneralRe: regarding foreignkey data Pin
Ashfield26-Aug-09 1:44
MemberAshfield26-Aug-09 1:44 
GeneralRe: regarding foreignkey data Pin
kheer26-Aug-09 22:01
Memberkheer26-Aug-09 22:01 
QuestionMerging multi results into one row Pin
Wouter Coinless24-Aug-09 9:12
MemberWouter Coinless24-Aug-09 9:12 
AnswerRe: Merging multi results into one row Pin
Luc Pattyn24-Aug-09 9:39
sitebuilderLuc Pattyn24-Aug-09 9:39 
AnswerRe: Merging multi results into one row Pin
Eddy Vluggen24-Aug-09 9:51
professionalEddy Vluggen24-Aug-09 9:51 
AnswerRe: Merging multi results into one row Pin
Wouter Coinless24-Aug-09 9:54
MemberWouter Coinless24-Aug-09 9:54 
QuestionXML Save and Load to SQL Server 2005 database. Pin
ashwath197924-Aug-09 1:55
Memberashwath197924-Aug-09 1:55 
AnswerRe: XML Save and Load to SQL Server 2005 database. Pin
Henry Minute24-Aug-09 2:18
MemberHenry Minute24-Aug-09 2:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.