Click here to Skip to main content
15,900,378 members
Home / Discussions / C#
   

C#

 
QuestionC# Media Library Help ! Pin
O.Calderbank27-Apr-12 2:27
O.Calderbank27-Apr-12 2:27 
AnswerRe: C# Media Library Help ! Pin
Richard MacCutchan27-Apr-12 2:42
mveRichard MacCutchan27-Apr-12 2:42 
AnswerRe: C# Media Library Help ! Pin
Wes Aday27-Apr-12 10:03
professionalWes Aday27-Apr-12 10:03 
QuestionDocument opening/saving idiom Pin
Orjan Westin27-Apr-12 1:07
professionalOrjan Westin27-Apr-12 1:07 
AnswerRe: Document opening/saving idiom PinPopular
Pete O'Hanlon27-Apr-12 1:57
mvePete O'Hanlon27-Apr-12 1:57 
AnswerRe: Document opening/saving idiom Pin
PIEBALDconsult27-Apr-12 3:22
mvePIEBALDconsult27-Apr-12 3:22 
AnswerRe: Document opening/saving idiom Pin
Eddy Vluggen27-Apr-12 7:04
professionalEddy Vluggen27-Apr-12 7:04 
AnswerRe: Document opening/saving idiom Pin
OriginalGriff27-Apr-12 9:29
mveOriginalGriff27-Apr-12 9:29 
NewsExpand the text in the RichTextBox. Pin
nqs_vn27-Apr-12 0:10
nqs_vn27-Apr-12 0:10 
AnswerRe: Expand the text in the RichTextBox. Pin
VJ Reddy27-Apr-12 1:16
VJ Reddy27-Apr-12 1:16 
GeneralRe: Expand the text in the RichTextBox. Pin
nqs_vn27-Apr-12 16:40
nqs_vn27-Apr-12 16:40 
QuestionSave List with BinaryReader Pin
larsp77726-Apr-12 23:22
larsp77726-Apr-12 23:22 
AnswerRe: Save List with BinaryReader Pin
Wayne Gaylard26-Apr-12 23:44
professionalWayne Gaylard26-Apr-12 23:44 
QuestionWindow Service didn’t run when SQL Server is on Remote Database Pin
masterprogrammertech26-Apr-12 23:17
masterprogrammertech26-Apr-12 23:17 
AnswerRe: Window Service didn’t run when SQL Server is on Remote Database Pin
PIEBALDconsult27-Apr-12 3:24
mvePIEBALDconsult27-Apr-12 3:24 
AnswerRe: Window Service didn’t run when SQL Server is on Remote Database Pin
charlybones7-May-12 22:17
charlybones7-May-12 22:17 
Questionimpresiones en c# Pin
samuelalvarito26-Apr-12 6:42
samuelalvarito26-Apr-12 6:42 
AnswerRe: impresiones en c# Pin
phil.o26-Apr-12 6:48
professionalphil.o26-Apr-12 6:48 
AnswerRe: impresiones en c# Pin
Abhinav S26-Apr-12 7:02
Abhinav S26-Apr-12 7:02 
AnswerRe: impresiones en c# Pin
jschell28-Apr-12 7:44
jschell28-Apr-12 7:44 
Questionspooler en c# Pin
samuelalvarito26-Apr-12 6:40
samuelalvarito26-Apr-12 6:40 
Questioncomo usar el evento drag&drop para cargar documentos office en un formulario de c# Pin
samuelalvarito26-Apr-12 6:39
samuelalvarito26-Apr-12 6:39 
AnswerRe: como usar el evento drag&drop para cargar documentos office en un formulario de c# Pin
Abhinav S26-Apr-12 6:45
Abhinav S26-Apr-12 6:45 
AnswerRe: como usar el evento drag&drop para cargar documentos office en un formulario de c# Pin
Bernhard Hiller26-Apr-12 21:52
Bernhard Hiller26-Apr-12 21:52 
QuestionReleaseComObject() or not? Pin
__John_25-Apr-12 23:09
__John_25-Apr-12 23:09 
How do I know whether or not to call ReleaseComObject()?

For example in the following code I call ReleaseComObject() on the Worksheet, it works fine, but I dont rearly know if this is correct or not. How would I know? Is there a rule that I need to follow?
try
{

    Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();

    string strWorkBook = @"C:\zz\Book1.xlsx";

    Workbook workBook = excelApp.Workbooks.Open(strWorkBook,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing);


    int nSheets = workBook.Sheets.Count;
                
    Worksheet sheet = (Worksheet)workBook.Sheets[1];


    // Do somthing with the Worksheet...


    Marshal.ReleaseComObject(sheet);

    workBook.Close(false, strWorkBook, null);
    Marshal.ReleaseComObject(workBook);
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}

“If I had asked people what they wanted, they would have said faster horses.”
― Henry Ford

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.