Click here to Skip to main content
15,884,472 members
Home / Discussions / Database
   

Database

 
AnswerRe: Generate Insert method for my View-adapter Pin
Sylvester george23-Feb-07 3:01
Sylvester george23-Feb-07 3:01 
GeneralRe: Generate Insert method for my View-adapter Pin
anderslundsgard23-Feb-07 3:37
anderslundsgard23-Feb-07 3:37 
QuestionSQL Report Error Message Pin
navhob@yahoo.com22-Feb-07 21:19
navhob@yahoo.com22-Feb-07 21:19 
QuestionHow to query all the tables in a database with shcema name Pin
NK722-Feb-07 18:52
NK722-Feb-07 18:52 
AnswerRe: How to query all the tables in a database with shcema name Pin
Hesham Amin22-Feb-07 22:28
Hesham Amin22-Feb-07 22:28 
QuestionNull parent row parameter for addRow method, using typed dataset Pin
hoonzis22-Feb-07 13:41
hoonzis22-Feb-07 13:41 
AnswerRe: Null parent row parameter for addRow method, using typed dataset Pin
Mark J. Miller23-Feb-07 3:51
Mark J. Miller23-Feb-07 3:51 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
hoonzis25-Feb-07 10:36
hoonzis25-Feb-07 10: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 20:34
hoonzis25-Feb-07 20:34 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
Mark J. Miller26-Feb-07 2:01
Mark J. Miller26-Feb-07 2:01 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
hoonzis26-Feb-07 23:22
hoonzis26-Feb-07 23:22 
Questiontsql table alias - performance? Pin
matthew.rowe22-Feb-07 13:25
matthew.rowe22-Feb-07 13:25 
AnswerRe: tsql table alias - performance? Pin
Colin Angus Mackay22-Feb-07 13:41
Colin Angus Mackay22-Feb-07 13:41 
AnswerRe: tsql table alias - performance? Pin
Pete O'Hanlon22-Feb-07 22:56
mvePete O'Hanlon22-Feb-07 22:56 
Questionconvert database Pin
shereem khaleel22-Feb-07 13:08
shereem khaleel22-Feb-07 13:08 
AnswerRe: convert database Pin
PSmith99927-Feb-07 9:32
PSmith99927-Feb-07 9:32 
Questionhow to combine column values Pin
tvfoto22-Feb-07 9:27
tvfoto22-Feb-07 9:27 
AnswerRe: how to combine column values Pin
Hesham Amin22-Feb-07 10:08
Hesham Amin22-Feb-07 10:08 
AnswerRe: how to combine column values Pin
tvfoto22-Feb-07 12:02
tvfoto22-Feb-07 12:02 
GeneralRe: how to combine column values Pin
tvfoto23-Feb-07 3:51
tvfoto23-Feb-07 3:51 
QuestionMany : Many Pin
lost in transition 22-Feb-07 7:05
lost in transition 22-Feb-07 7:05 
AnswerRe: Many : Many Pin
Hesham Amin22-Feb-07 9:55
Hesham Amin22-Feb-07 9:55 
GeneralRe: Many : Many Pin
lost in transition 22-Feb-07 11:34
lost in transition 22-Feb-07 11:34 
GeneralRe: Many : Many Pin
Colin Angus Mackay22-Feb-07 13:23
Colin Angus Mackay22-Feb-07 13:23 
AnswerRe: Many : Many Pin
Colin Angus Mackay22-Feb-07 13:20
Colin Angus Mackay22-Feb-07 13: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.