Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
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 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
hoonzis25-Feb-07 20:34
hoonzis25-Feb-07 20:34 
Thanks for your answer,
The DataSet is generated from Visual Studion from SQL Server so there already is a DataRelation between those 2 tables "tickets" and "users". So I guess that when I delete this Relation it is gonna work fine. The problem I don't understand is however more general.
My addRow method on table "tickets" looks something like this:

myDataSet.ticketsTable.addTicketsRow(string ticket_title,DateTime ticket_created,...,MyDataSet.usersRow parentusersRowbyFK_ticket_users)

In the DataSet the FK_tickets_users is set to "Relation only". In the database there is field user_id of type int and this field I'm setting by the MyDataSet.usersRow parentusersRowbyFK_ticket_users parameter.
This field user_id allows Nulls. So my question is what parameter should I provide to the addTicketsRow method so the field user_id in the database would be Null?
As I said before, null was my first try, but than I'm getting NullReferenceObjectException.
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
subeditorPete 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 
GeneralRe: Many : Many Pin
lost in transition 23-Feb-07 3:08
lost in transition 23-Feb-07 3:08 

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.