Click here to Skip to main content
15,894,907 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to Implement Private methods in an Interface Pin
Keith Barrow11-Oct-10 3:34
professionalKeith Barrow11-Oct-10 3:34 
GeneralRe: How to Implement Private methods in an Interface Pin
Pete O'Hanlon11-Oct-10 3:42
mvePete O'Hanlon11-Oct-10 3:42 
AnswerRe: How to Implement Private methods in an Interface Pin
Bernhard Hiller11-Oct-10 3:29
Bernhard Hiller11-Oct-10 3:29 
QuestionSQL Sever 2005 is not working on 64bit Win7 Pin
Said Ali Jalali10-Oct-10 21:57
Said Ali Jalali10-Oct-10 21:57 
AnswerRe: SQL Sever 2005 is not working on 64bit Win7 Pin
jschell11-Oct-10 8:10
jschell11-Oct-10 8:10 
AnswerRe: SQL Sever 2005 is not working on 64bit Win7 Pin
AspDotNetDev12-Oct-10 13:28
protectorAspDotNetDev12-Oct-10 13:28 
AnswerRe: SQL Sever 2005 is not working on 64bit Win7 Pin
Alonso Calle17-Dec-10 20:21
Alonso Calle17-Dec-10 20:21 
QuestionGenerate files using Macros in Excel Pin
NarVish10-Oct-10 21:22
NarVish10-Oct-10 21:22 
Hi,
Hope this is the right place to post this issue. If not, please let me know the correct place.
I've an excel sheet, where I have both table structure and table data. I need to write a macro which generates two different files (one for create statement and one for insert statement). To give more details,

ExcelSheet1
SNO COLUMN Data Type Remarks
1 Award_Id integer PK
2 AAI_ID Integer
3 Award_Short_Name varchar Abbreviated Award Name


AWARD_ID AAI_ID AWARD_SHORT_NAME
3000 2001 B.Tech
3001 2003 B.Tech
3002 2001 B.Tech

The macro for this excel sheet should generate, the below files

1. DEMAT_REQUEST.dat
INSERT INTO DEMAT_REQUEST(Award_Id, AAI_ID, Award_Short_Name)
VALUES (3000,2001,'B.Tech');

INSERT INTO DEMAT_REQUEST(Award_Id, AAI_ID, Award_Short_Name)
VALUES (3001,2003,'B.Tech');

INSERT INTO DEMAT_REQUEST(Award_Id, AAI_ID, Award_Short_Name)
VALUES (3002,2001,'B.Tech');

2. DEMAT_REQUEST.sql

CREATE TABLE TXN_DEMAT_REQUEST
(
Award_Id INTEGER(20) NOT NULL,
AAI_ID INTEGER(10) NOT NULL,
Award_Short_Name VARCHAR(10) NOT NULL
PRIMARY KEY(Award_Id)
};

Thanks alot in advance
AnswerRe: Generate files using Macros in Excel Pin
Richard MacCutchan11-Oct-10 0:26
mveRichard MacCutchan11-Oct-10 0:26 
GeneralRe: Generate files using Macros in Excel Pin
NarVish11-Oct-10 19:16
NarVish11-Oct-10 19:16 
QuestionBinary to hex Conversion ? Pin
deadlyabbas10-Oct-10 20:19
deadlyabbas10-Oct-10 20:19 
AnswerRe: Binary to hex Conversion ? Pin
Khaniya10-Oct-10 20:25
professionalKhaniya10-Oct-10 20:25 
GeneralRe: Binary to hex Conversion ? Pin
deadlyabbas10-Oct-10 22:55
deadlyabbas10-Oct-10 22:55 
AnswerRe: Binary to hex Conversion ? Pin
DaveyM6910-Oct-10 21:42
professionalDaveyM6910-Oct-10 21:42 
GeneralRe: Binary to hex Conversion ? Pin
deadlyabbas10-Oct-10 22:54
deadlyabbas10-Oct-10 22:54 
GeneralRe: Binary to hex Conversion ? Pin
DaveyM6910-Oct-10 23:59
professionalDaveyM6910-Oct-10 23:59 
AnswerRe: Binary to hex Conversion ? Pin
Luc Pattyn11-Oct-10 1:13
sitebuilderLuc Pattyn11-Oct-10 1:13 
QuestionProgram hangs... Pin
ayandelhi10-Oct-10 19:33
ayandelhi10-Oct-10 19:33 
AnswerRe: Program hangs... Pin
ScottM110-Oct-10 20:55
ScottM110-Oct-10 20:55 
AnswerRe: Program hangs... Pin
Rajesh Anuhya10-Oct-10 21:37
professionalRajesh Anuhya10-Oct-10 21:37 
AnswerRe: Program hangs... Pin
Harvey Saayman11-Oct-10 1:07
Harvey Saayman11-Oct-10 1:07 
AnswerRe: Program hangs... Pin
Luc Pattyn11-Oct-10 1:17
sitebuilderLuc Pattyn11-Oct-10 1:17 
AnswerRe: Program hangs... Pin
#realJSOP11-Oct-10 2:38
mve#realJSOP11-Oct-10 2:38 
AnswerCode... Pin
ayandelhi11-Oct-10 4:44
ayandelhi11-Oct-10 4:44 
GeneralRe: Code... Pin
ayandelhi11-Oct-10 6:25
ayandelhi11-Oct-10 6: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.