Click here to Skip to main content
15,125,584 members
Home / Discussions / Database
   

Database

 
AnswerRe: Generate Insert method for my View-adapter Pin
Sylvester george23-Feb-07 4:01
MemberSylvester george23-Feb-07 4:01 
GeneralRe: Generate Insert method for my View-adapter Pin
anderslundsgard23-Feb-07 4:37
Memberanderslundsgard23-Feb-07 4:37 
QuestionSQL Report Error Message Pin
navhob@yahoo.com22-Feb-07 22:19
Membernavhob@yahoo.com22-Feb-07 22:19 
QuestionHow to query all the tables in a database with shcema name Pin
NK722-Feb-07 19:52
MemberNK722-Feb-07 19:52 
AnswerRe: How to query all the tables in a database with shcema name Pin
Hesham Amin22-Feb-07 23:28
MemberHesham Amin22-Feb-07 23:28 
QuestionNull parent row parameter for addRow method, using typed dataset Pin
hoonzis22-Feb-07 14:41
Memberhoonzis22-Feb-07 14:41 
AnswerRe: Null parent row parameter for addRow method, using typed dataset Pin
Mark J. Miller23-Feb-07 4:51
MemberMark J. Miller23-Feb-07 4:51 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
hoonzis25-Feb-07 11:36
Memberhoonzis25-Feb-07 11:36 
Thanks for answer,
the DataSet is generated from the database using the VisualStudio so there is a DataRelation between those 2 tables already. So I can simply erase this relation and I guess it is gonna work fine after that. The problem that I don't understand,is however, little more general.
The generated addRow method parameters looks something like this:

ticketsTable.addTicketsRow(DateTime ticket_date,string ticket_title,....,MyDataSet.usersRow user_id)

and I know that in the database running on SQL Server, the field user_id in table tickets allows Nulls(and also in the generated DataSet). So when Visual Studio created the DataSet for me with this wonderful method, what parameter should I supply to this method for the usersRow, so the field in the database would be Null? When I supply null, which was my first idea, I just get "object reference not set to instance..." exception.

Honga
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
hoonzis25-Feb-07 21:34
Memberhoonzis25-Feb-07 21:34 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
Mark J. Miller26-Feb-07 3:01
MemberMark J. Miller26-Feb-07 3:01 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
hoonzis27-Feb-07 0:22
Memberhoonzis27-Feb-07 0:22 
Questiontsql table alias - performance? Pin
matthew.rowe22-Feb-07 14:25
Membermatthew.rowe22-Feb-07 14:25 
AnswerRe: tsql table alias - performance? Pin
Colin Angus Mackay22-Feb-07 14:41
MemberColin Angus Mackay22-Feb-07 14:41 
AnswerRe: tsql table alias - performance? Pin
Pete O'Hanlon22-Feb-07 23:56
mvePete O'Hanlon22-Feb-07 23:56 
Questionconvert database Pin
shereem khaleel22-Feb-07 14:08
Membershereem khaleel22-Feb-07 14:08 
AnswerRe: convert database Pin
PSmith99927-Feb-07 10:32
MemberPSmith99927-Feb-07 10:32 
Questionhow to combine column values Pin
tvfoto22-Feb-07 10:27
Membertvfoto22-Feb-07 10:27 
AnswerRe: how to combine column values Pin
Hesham Amin22-Feb-07 11:08
MemberHesham Amin22-Feb-07 11:08 
AnswerRe: how to combine column values Pin
tvfoto22-Feb-07 13:02
Membertvfoto22-Feb-07 13:02 
GeneralRe: how to combine column values Pin
tvfoto23-Feb-07 4:51
Membertvfoto23-Feb-07 4:51 
QuestionMany : Many Pin
lost in transition 22-Feb-07 8:05
Member lost in transition 22-Feb-07 8:05 
AnswerRe: Many : Many Pin
Hesham Amin22-Feb-07 10:55
MemberHesham Amin22-Feb-07 10:55 
GeneralRe: Many : Many Pin
lost in transition 22-Feb-07 12:34
Member lost in transition 22-Feb-07 12:34 
GeneralRe: Many : Many Pin
Colin Angus Mackay22-Feb-07 14:23
MemberColin Angus Mackay22-Feb-07 14:23 
AnswerRe: Many : Many Pin
Colin Angus Mackay22-Feb-07 14:20
MemberColin Angus Mackay22-Feb-07 14:20 

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.