Click here to Skip to main content
15,119,637 members
Home / Discussions / Database
   

Database

 
GeneralRe: ODBC Pin
A kamath23-Feb-07 21:03
MemberA kamath23-Feb-07 21:03 
QuestionGenerate Insert method for my View-adapter Pin
anderslundsgard23-Feb-07 0:07
Memberanderslundsgard23-Feb-07 0:07 
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 
Hello,
We're developing this small helpdesk application in we run into this problem:

I have a table of tickets and table of user, each ticket has in the database the field user_id where nulls are allowed. I'm using typed dataset generetad using the Visual Studio, so there is also the relation FK_users_tickets generated.So in my myDataSet.tickets table a method addTicketsRow() was created with several arguments, one of them being of type myDataSet.usersRow. I know that's the parent usersRow, so it's ok, the problem is when i want to add the new row with the user_id field null.
How to provide usersRow parameter which is gona be null? Well ofcourse i tried providing the null parameter but im just getting nullreference exception. I also tried to find some constructor or method to create empty usersRow, but i found just the method myDataSet.users.newUsersRow(), but this one will just create another new usersRow and will set it's id, because there is autoincrement on the user_id field and obviously i don't want to do that.

Looks litle confused, but hope the explanation is understoodable.

Actually I'm almost sure it should work with the null parameter, because i had a piece of code like this before and that time it worked, but now i've already spend two days on solving and googling and still didn't come up with answear...so any help would be realy appriciated.

thnx Honga


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 
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 

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.