Click here to Skip to main content
15,887,464 members
Home / Discussions / C#
   

C#

 
QuestionPass Excel.Application from Excel 2007 Custom Task Pane to Hosted PowerShell Pin
Uros Calakovic18-Oct-09 4:07
Uros Calakovic18-Oct-09 4:07 
QuestionSubReport in Win Form (RDLC) Pin
Abdul Rahman Hamidy18-Oct-09 3:20
Abdul Rahman Hamidy18-Oct-09 3:20 
AnswerRe: SubReport in Win Form (RDLC) Pin
Christopher Stratmann17-Apr-10 18:22
Christopher Stratmann17-Apr-10 18:22 
QuestionOpen RTF file in MS Word & WordPad Pin
Jassim Rahma18-Oct-09 3:18
Jassim Rahma18-Oct-09 3:18 
AnswerRe: Open RTF file in MS Word & WordPad Pin
0x3c018-Oct-09 3:34
0x3c018-Oct-09 3:34 
AnswerRe: Open RTF file in MS Word & WordPad Pin
DaveyM6918-Oct-09 3:35
professionalDaveyM6918-Oct-09 3:35 
AnswerRe: Open RTF file in MS Word & WordPad Pin
Luc Pattyn18-Oct-09 11:14
sitebuilderLuc Pattyn18-Oct-09 11:14 
QuestionGenerate sql select statement from another select statement Pin
AhmedMasum18-Oct-09 3:02
AhmedMasum18-Oct-09 3:02 
Suppose I got the following sql :

select empno, empname, deptname,sal from emp, dept where emp.did= dept.did


I need the following:
If the column name is empno replace it by eno,
If the table name is emp then replace it by employee,
If the table is dept then replace it by department,
if the column name is did replace it by deptid.

That means after operation my the sql should be as follows:

select eno, empname, deptname, sal from employee,department where employee.deptid=department.deptid

How can I do that? Can I have any sample code for that??? Please help me.
I am stuck on this place. I can't proceed without this.
AnswerRe: Generate sql select statement from another select statement Pin
Not Active18-Oct-09 3:38
mentorNot Active18-Oct-09 3:38 
GeneralRe: Generate sql select statement from another select statement Pin
AhmedMasum18-Oct-09 15:33
AhmedMasum18-Oct-09 15:33 
GeneralRe: Generate sql select statement from another select statement Pin
Luc Pattyn18-Oct-09 16:14
sitebuilderLuc Pattyn18-Oct-09 16:14 
GeneralRe: Generate sql select statement from another select statement Pin
AhmedMasum18-Oct-09 17:09
AhmedMasum18-Oct-09 17:09 
GeneralRe: Generate sql select statement from another select statement Pin
Luc Pattyn18-Oct-09 18:04
sitebuilderLuc Pattyn18-Oct-09 18:04 
GeneralRe: Generate sql select statement from another select statement Pin
AhmedMasum18-Oct-09 18:41
AhmedMasum18-Oct-09 18:41 
GeneralRe: Generate sql select statement from another select statement Pin
Luc Pattyn19-Oct-09 2:08
sitebuilderLuc Pattyn19-Oct-09 2:08 
GeneralRe: Generate sql select statement from another select statement Pin
AhmedMasum19-Oct-09 4:28
AhmedMasum19-Oct-09 4:28 
GeneralRe: Generate sql select statement from another select statement Pin
Luc Pattyn19-Oct-09 4:38
sitebuilderLuc Pattyn19-Oct-09 4:38 
GeneralRe: Generate sql select statement from another select statement Pin
AhmedMasum19-Oct-09 19:22
AhmedMasum19-Oct-09 19:22 
GeneralRe: Generate sql select statement from another select statement Pin
Not Active19-Oct-09 2:08
mentorNot Active19-Oct-09 2:08 
GeneralRe: Generate sql select statement from another select statement Pin
Not Active18-Oct-09 16:24
mentorNot Active18-Oct-09 16:24 
GeneralRe: Generate sql select statement from another select statement Pin
AhmedMasum18-Oct-09 18:34
AhmedMasum18-Oct-09 18:34 
QuestionCode optimization Pin
tvbarnard18-Oct-09 2:14
tvbarnard18-Oct-09 2:14 
AnswerRe: Code optimization [modified] Pin
DaveyM6918-Oct-09 2:32
professionalDaveyM6918-Oct-09 2:32 
GeneralRe: Code optimization Pin
tvbarnard18-Oct-09 3:10
tvbarnard18-Oct-09 3:10 
GeneralRe: Code optimization Pin
DaveyM6918-Oct-09 3:25
professionalDaveyM6918-Oct-09 3:25 

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.