Click here to Skip to main content
15,123,118 members
Home / Discussions / Database
   

Database

 
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 
GeneralRe: Null parent row parameter for addRow method, using typed dataset Pin
hoonzis25-Feb-07 21:34
Memberhoonzis25-Feb-07 21: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 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 
GeneralRe: Many : Many Pin
lost in transition 23-Feb-07 4:08
Member lost in transition 23-Feb-07 4: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.