Click here to Skip to main content
15,904,153 members
Home / Discussions / Database
   

Database

 
GeneralRe: Send table name to a stored procedure Pin
Yevgeny Efter1-Apr-08 8:09
Yevgeny Efter1-Apr-08 8:09 
GeneralSQL or XML Pin
Sutheesh chandran1-Apr-08 1:16
Sutheesh chandran1-Apr-08 1:16 
GeneralRe: SQL or XML Pin
Rob Philpott1-Apr-08 1:42
Rob Philpott1-Apr-08 1:42 
Questionhow can i copy a column data to a same column Pin
koolprasad200331-Mar-08 23:58
professionalkoolprasad200331-Mar-08 23:58 
AnswerRe: how can i copy a column data to a same column Pin
Rob Philpott1-Apr-08 1:43
Rob Philpott1-Apr-08 1:43 
AnswerRe: how can i copy a column data to a same column Pin
Ashfield1-Apr-08 2:07
Ashfield1-Apr-08 2:07 
GeneralSQL Query Pin
Ali Rashid31-Mar-08 23:45
Ali Rashid31-Mar-08 23:45 
GeneralRe: SQL Query Pin
Blue_Boy1-Apr-08 3:28
Blue_Boy1-Apr-08 3:28 
GeneralRe: SQL Query Pin
Ali Rashid1-Apr-08 6:01
Ali Rashid1-Apr-08 6:01 
GeneralRe: SQL Query Pin
Ali Rashid1-Apr-08 6:07
Ali Rashid1-Apr-08 6:07 
GeneralRe: SQL Query Pin
Blue_Boy1-Apr-08 9:17
Blue_Boy1-Apr-08 9:17 
GeneralRe: SQL Query Pin
Ali Rashid1-Apr-08 22:05
Ali Rashid1-Apr-08 22:05 
GeneralRe: SQL Query Pin
Blue_Boy2-Apr-08 7:43
Blue_Boy2-Apr-08 7:43 
GeneralRe: SQL Query [modified] Pin
Syed Mehroz Alam2-Apr-08 9:30
Syed Mehroz Alam2-Apr-08 9:30 
GeneralRe: SQL Query Pin
Blue_Boy3-Apr-08 12:14
Blue_Boy3-Apr-08 12:14 
AnswerRe: SQL Query Pin
mushfiqcs2-Apr-08 1:10
mushfiqcs2-Apr-08 1:10 
GeneralRe: SQL Query Pin
mushfiqcs2-Apr-08 1:10
mushfiqcs2-Apr-08 1:10 
QuestionRAM usage Pin
Dobromir Dimitrov31-Mar-08 21:55
Dobromir Dimitrov31-Mar-08 21:55 
GeneralRe: RAM usage Pin
GuyThiebaut31-Mar-08 23:56
professionalGuyThiebaut31-Mar-08 23:56 
GeneralRe: RAM usage Pin
Ali Rashid1-Apr-08 23:28
Ali Rashid1-Apr-08 23:28 
GeneralRe: RAM usage Pin
SimulationofSai2-Apr-08 1:23
SimulationofSai2-Apr-08 1:23 
GeneralMS Acess SQL Query using VS Query Builder and Variable Field Names Pin
Christian Yeates31-Mar-08 21:33
Christian Yeates31-Mar-08 21:33 
I am using the Query Builder in Visual Studio to fill my Dataset but one of the field/column names is unknown until runtime; therefore I wish to specify this on the fly.

My current query is as follows:

SELECT Cards.Id, Cards.Card, Cards.FirstName, Cards.LastName, Cards.AccessLevel, Cards.StartDate, Cards.EndDate, Cards.fTitle, ?,<br />
Photo.Id AS Expr1, Photo.Photo,<br />
AccLevel.AccessLevel AS Expr2, AccLevel.Name AS AccessName<br />
<br />
FROM (Cards<br />
LEFT JOIN Photo ON<br />
Cards.Card = Photo.Id)<br />
LEFT JOIN AccLevel ON<br />
Cards.AccessLevel = AccLevel.AccessLevel


The question mark represents a variable field name. Below is the code which fills the dataset by calling the query above - although for now, I have passed it a fixed string which represents one of the fields in the ‘Cards’ table and should replace the question mark in the query:

cards_Photo_AccessLevelTableAdapter.Fill(MyDataSet.Cards_Photo_AccessLevel, "Cards.fDepartment");

Although my code builds ok, an exception is caused when the Dataset is filled as above.

Any help would be much appreciated!!

Regards,

Christian
Questionhow to save only time in database field Pin
findtango31-Mar-08 19:10
findtango31-Mar-08 19:10 
GeneralRe: how to save only time in database field Pin
pmarfleet31-Mar-08 19:45
pmarfleet31-Mar-08 19:45 
GeneralRe: how to save only time in database field Pin
Ali Rashid31-Mar-08 23:52
Ali Rashid31-Mar-08 23:52 

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.