i create a form and every time connection open and close but make a error asp.net

hi kamlesh

try this code


Sqlconnetion con;;
try
{
con=new Sqlconnection("connectiion string");
con.open();
}
catch
{
con.close();
}
finally
{}


If you get your answer then please rating me

:)
thanks

hi kamlesh try this code out
add this namespace first

using System.Data.SqlClient;

sqlconnection con = new sqlconnection();
con.connectionstring="Data Source=.;Initial Catalog=ur database name;Integrated Security=True";
con.Open();
//Actions that u want to perform
con.Close();

use intelliscence help for writing name of the classes

What i feel kamlesh tat u might be closing a connection before any command executes

Please paste the code so that i can look and tell u.

Thanks & Regards
Radix :-\

Check the connection status before opening or closing that. code like below.

Sqlconnetion sqlCon;
try
{
  sqlCon=new Sqlconnection("sql connection string");
  if(con.State!=ConnectionState.Open)
  {
    sqlCon.open();
  }
}
catch
{
  if(con.State!=ConnectionState.Closed)
  {
    sqlCon.close();
  }
}
finally
{
  if(con.State!=ConnectionState.Closed)
  {
    sqlCon.close();
  }
}