Click here to Skip to main content
15,177,017 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# access a file Pin
classy_dog17-Sep-12 18:02
Memberclassy_dog17-Sep-12 18:02 
GeneralRe: C# access a file Pin
Pete O'Hanlon17-Sep-12 23:05
mvaPete O'Hanlon17-Sep-12 23:05 
AnswerRe: C# access a file Pin
PIEBALDconsult17-Sep-12 18:00
professionalPIEBALDconsult17-Sep-12 18:00 
QuestionInternal connection fatal error!! why?!! Pin
Jassim Rahma17-Sep-12 6:12
MemberJassim Rahma17-Sep-12 6:12 
AnswerRe: Internal connection fatal error!! why?!! Pin
Pete O'Hanlon17-Sep-12 7:09
mvaPete O'Hanlon17-Sep-12 7:09 
GeneralRe: Internal connection fatal error!! why?!! Pin
Andrei Straut17-Sep-12 7:14
MemberAndrei Straut17-Sep-12 7:14 
AnswerRe: Internal connection fatal error!! why?!! Pin
Emmanuel Medina17-Sep-12 8:43
professionalEmmanuel Medina17-Sep-12 8:43 
GeneralRe: Internal connection fatal error!! why?!! Pin
Jassim Rahma17-Sep-12 8:56
MemberJassim Rahma17-Sep-12 8:56 
Hi guys,

no he's right Smile | :)

sorry..

i missed it..

the connection was already closed here:

mark_migrated(Convert.ToInt32(MSSQLreader["file_no"]));


this is the code which closes the connection:

C#
private void mark_migrated(int file_no)
{
    MSSQLconnection_Migrated = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQL"].ConnectionString);
    MSSQLconnection_Migrated.Open();

    // where is_migrated = false;
    MSSQLcommand_Migrated = new SqlCommand("update persons set is_migrated = 1 where file_no = " + file_no, MSSQLconnection_Migrated);
    int MSSQLreader_Migrated = MSSQLcommand_Migrated.ExecuteNonQuery();

    MSSQLcommand_Migrated.Dispose();
    MSSQLconnection_Migrated.Close();
}


I will try checking connection state before closing and revert back if not zsolved.

thanks guys
GeneralRe: Internal connection fatal error!! why?!! Pin
Emmanuel Medina17-Sep-12 9:12
professionalEmmanuel Medina17-Sep-12 9:12 
GeneralRe: Internal connection fatal error!! why?!! Pin
Jassim Rahma17-Sep-12 9:18
MemberJassim Rahma17-Sep-12 9:18 
GeneralRe: Internal connection fatal error!! why?!! Pin
Andrei Straut17-Sep-12 9:25
MemberAndrei Straut17-Sep-12 9:25 
GeneralRe: Internal connection fatal error!! why?!! Pin
PIEBALDconsult17-Sep-12 9:42
professionalPIEBALDconsult17-Sep-12 9:42 
AnswerRe: Internal connection fatal error!! why?!! Pin
PIEBALDconsult17-Sep-12 9:39
professionalPIEBALDconsult17-Sep-12 9:39 
AnswerRe: Internal connection fatal error!! why?!! Pin
jschell17-Sep-12 9:43
Memberjschell17-Sep-12 9:43 
AnswerRe: Internal connection fatal error!! why?!! Pin
Pete O'Hanlon17-Sep-12 10:33
mvaPete O'Hanlon17-Sep-12 10:33 
GeneralRe: Internal connection fatal error!! why?!! Pin
Jassim Rahma17-Sep-12 10:59
MemberJassim Rahma17-Sep-12 10:59 
GeneralRe: Internal connection fatal error!! why?!! Pin
Emmanuel Medina17-Sep-12 11:13
professionalEmmanuel Medina17-Sep-12 11:13 
QuestionInterprocess Communication from C# to HTML page Pin
vjpudelski17-Sep-12 5:53
Membervjpudelski17-Sep-12 5:53 
AnswerRe: Interprocess Communication from C# to HTML page Pin
Eddy Vluggen17-Sep-12 8:16
professionalEddy Vluggen17-Sep-12 8:16 
AnswerRe: Interprocess Communication from C# to HTML page Pin
Abhinav S17-Sep-12 8:59
MemberAbhinav S17-Sep-12 8:59 
QuestionOpen Source Alternatives to Word Library and Word Compnents Pin
ASPnoob17-Sep-12 4:29
MemberASPnoob17-Sep-12 4:29 
AnswerRe: Open Source Alternatives to Word Library and Word Compnents Pin
Andrei Straut17-Sep-12 4:50
MemberAndrei Straut17-Sep-12 4:50 
GeneralRe: Open Source Alternatives to Word Library and Word Compnents Pin
Pete O'Hanlon17-Sep-12 4:55
mvaPete O'Hanlon17-Sep-12 4:55 
GeneralRe: Open Source Alternatives to Word Library and Word Compnents Pin
Andrei Straut17-Sep-12 5:08
MemberAndrei Straut17-Sep-12 5:08 
Question[Solved] Problem #20 Pin
WebMaster17-Sep-12 3:10
MemberWebMaster17-Sep-12 3:10 

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.