internal connection fatal error in c#

R.D Ip

5y5.7k.NET

I am using thread because when open a form the fill the background data in combobox and store procedure combobox data successfully but issue is when I open a form and immediately I press the close button then give an

error like:

internal connection fatal error

connection close

I am trying but not able to solve this error

please help

myform.cs

public void ShowForm()
{
this.Show(); //here open a form
WorkerSetControl(() => Load_Datas()); //call a thread
}

Thread ObjThreads;

private void WorkerSetControl(Action methodName)
{
ObjThreads = new Thread(new ThreadStart(() => methodName()));
//ObjThread.IsBackground = true;
//ObjThread.SetApartmentState(ApartmentState.STA);
ObjThreads.Start();
//if (!ObjThread.Join(TimeSpan.FromSeconds(30)))
//{
// ObjThread.Abort();
// throw new Exception("More than 30 secs.");
//}
}
public void Load_Datas()
{
_product.FillForCombo(_prdcode, _prdtype, UltCmbprdType.Text);
_product.SetColumn(_PrdMast.TableNameProductList, "CODE,DESC,RG", "90,100,200");
_product._SetDataBinding(_ProdDS, TableNameProductList, true);
}
protected override void OnFormClosing(FormClosingEventArgs e) //Here I am closing a form
{
this.Enabled = false; // or this.Hide()
//ObjThreads.IsBackground = false;
//Thread.Sleep(1);
//_product.ds = null;
this.Hide();
}

_Prod.cs

public DataSet DS
{
get { return _DS; }
set { _DS = value; }
}
public void FillForCombo(string pStrCompCode, string pMast_Type, string pStsOrdType = "")
{
Ope.Clear();
Ope.AddParams("Cmp_Code", pStrCompCode);
Ope.AddParams("M_Type", pMast_Type);
Ope.AddParams("P_TYPE", pStsOrdType);
//if(ConnectionState.Open != ConnectionState.Closed)
//{
//if (Ope.IsConnectionCheck(Ope.EnumServer.servername) == true)
//Ope.OpenConnection(Ope.EnumServer.servername);
Ope.FillDataSet(Ope.EnumServer.servername, DS, TableNameProductList, Spp.usp_PrdsFillForCombo, Ope.GetParams());
//here give an error internal connection fatal error / connection closed error when open a form and immidiately i close a form then give an error
}

OperationSql

namespace DataLib
{
public class OperationSql : GlobalSql
{
public static CultureInfo CultureInfoUS;
public static Hashtable HTParam;
public static int IntParamCount;
public OperationSql();
public static void CCon(EnumServer ServerCon);
public static void CCon(SqlConnection pConn);
public static void Clear();
public static void CloseConnection(EnumServer ServerCon);
public static void ClsRed(SqlDataReader pReader);
public static bool OpenConnection(EnumServer ServerCon);
public static void FillDataSet(EnumServer ServerConn, DataSet pDataSet, string pTableName, string pProcedureName, SqlParameter[] pParamList, bool pSetTime = false, bool pBlnCatch = true);
public enum EnumServer
{
servername = 1,
servernamesd = 2
}
}

when i open a form and after sometime I press close button then not give an error but when I open a form and suddenly press a button then give an error

internal connection fatal error / connection close error / object referance not set to an object

I know why give an error because thread running in background and I press the close button quickly when open a form that is problem

please help

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

R.D Ip5y ago
trying and trying but not solve the error

it is not sql syntax that is issue
Amit Gupta5y ago
The error clearly specifies that you don't have an open connection to perform your query.

Goto their definition and check the connection is opened/closed, perform it accordingly, as we can't help when you share limited resources with us
R.D Ip5y ago
yes give an error see below image

OperationSql.cs

public static bool OpenWebConnection(EnumServer ServerCon);
public static bool OpenConnection(EnumServer ServerCon);
public static bool ReadDatabaseSettingBranch(EnumServer pEnumServerName);
public static bool IsConnectionCheck(EnumServer ServerCon);

I have no idea which command is use to open the connection because here not sqlconnection related syntax
that is issue

can you more help
Amit Gupta5y ago
Make sure to close the connection properly after its usage.

As you are closing the form immediately while the work is in progress, it must fall in try catch block (that I mentioned) as a ignoring or logged message.

Morover, try to avoid static functions as much as you can because it holds the memory until your application closes
R.D Ip5y ago
hello amit i put try and catch

give this error in catch block

when I debug first time then give this error : Internal connection fatal error. Error state: 15, Token : 54

when I debug second time then give this error :Invalid attempt to call Read when reader is closed.
Amit Gupta5y ago
1. public void Load_Datas()
2. {
3. try
4. {
5. _product.FillForCombo(_prdcode, _prdtype, UltCmbprdType.Text);
7. _product.SetColumn(_PrdMast.TableNameProductList, "CODE,DESC,RG", "90,100,200");
8. _product._SetDataBinding(_ProdDS, TableNameProductList, true);
9. }
10. catch(Exception ex)
11. {
12. //log your exception here
13. }
14. }

R.D Ip5y ago

Hi Amit

I know what is issue

but how to solve I have no idea

Amit Gupta5y ago

You can get out from there by using the try catch block as you already know the reason of it