本文整理汇总了C#中System.Data.SqlClient.SqlConnection.Dispose方法的典型用法代码示例。如果您正苦于以下问题：C# SqlConnection.Dispose方法的具体用法？C# SqlConnection.Dispose怎么用？C# SqlConnection.Dispose使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlConnection的用法示例。
在下文中一共展示了SqlConnection.Dispose方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SP_Tender_FindRecord
public static string SP_Tender_FindRecord(string ProcessId, ref DataSet ReturnDs)
{
SqlConnection sqlConn = new SqlConnection(); //defines database connection
SqlCommand sqlCmd = new SqlCommand(); //defines what to do
SqlDataAdapter sqlAdap = new SqlDataAdapter();
try
{
sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["AMS_MasterConnectionString"].ToString();
sqlConn.Open();
sqlCmd.CommandText = "SP_Tender_FindRecord";
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Connection = sqlConn;
SqlParameter parm1 = new SqlParameter("@ProcessId", SqlDbType.VarChar);
parm1.Value = ProcessId;
parm1.Direction = ParameterDirection.Input;
sqlCmd.Parameters.Add(parm1);
sqlAdap.SelectCommand = sqlCmd;
sqlAdap.Fill(ReturnDs);
return string.Empty;
}
catch (Exception err)
{
return err.Message;
}
finally
{ sqlConn.Close(); sqlConn.Dispose(); sqlAdap.Dispose(); }
}示例2: getInvoiceInfo
public InvoiceObject getInvoiceInfo(int invoice_Number, string connectionString, UserObject user)
{
DataTable results = new DataTable();
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareReadCommand("GetAnInvoice", conn);
cmdIns.Parameters.Add( new SqlParameter("@Invoice_Number", invoice_Number));
using (conn)
using (cmdIns)
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(cmdIns))
{
dataAdapter.Fill(results);
}
var invoice = populateInvoice(results.Rows[0], connectionString, user);
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
return invoice;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}示例3: btnBookFlight_Click
protected void btnBookFlight_Click(object sender, EventArgs e)
{
SqlConnection objCon = new SqlConnection(strCon);
try
{
objCon.ConnectionString = strCon;
objCon.Open();
}
catch (Exception ex)
{
this.lblConnect.Text = "Unable to connect to database.";
}
if (objCon.State == System.Data.ConnectionState.Open)
{
InsertFlightInfo();
InsertFlightOrder();
objCon.Close();
objCon.Dispose();
}
else
{
lblConnect.Text = "Unable to connect to database.";
objCon.Close();
objCon.Dispose();
}
objCon.Close();
objCon.Dispose();
redirectToNextPage();
}示例4: getAllVehicles
public DataTable getAllVehicles(string connectionString)
{
DataTable results = new DataTable();
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareReadCommand("sp_GetAllVehicles", conn);
using (conn)
using (cmdIns)
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(cmdIns))
{
dataAdapter.Fill(results);
}
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
return results;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}示例5: ExecuteMyQuery
public static void ExecuteMyQuery(string Query)
{
string conString = System.Configuration.ConfigurationManager.ConnectionStrings["constrww"].ToString();
SqlConnection Connection = new SqlConnection(conString);
Connection.Open();
SqlCommand cmdXls = new SqlCommand(Query, Connection);
try
{
cmdXls.ExecuteNonQuery();
}
catch (Exception e)
{
cmdXls.Dispose();
Connection.Dispose();
}
finally
{
cmdXls.Dispose();
Connection.Dispose();
}
}示例6: getAModel
public DataTable getAModel(string connectionString, int modelID)
{
DataTable results = new DataTable();
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareReadCommand("GetAModel", conn);
cmdIns.Parameters.Add(new SqlParameter("@Model_ID", modelID));
using (conn)
using (cmdIns)
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(cmdIns))
{
dataAdapter.Fill(results);
}
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
return results;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}示例7: AddTaskReplyAttachments
public static bool AddTaskReplyAttachments(string taskid, string replyid, List<Attachment> attachments,string userid,string clientid)
{
SqlConnection conn = new SqlConnection(TaskDAL.ConnectionString);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
foreach (var attachment in attachments)
{
if (!TaskDAL.BaseProvider.AddTaskReplyAttachment(taskid,replyid,attachment.Type,
attachment.ServerUrl,attachment.FilePath,attachment.FileName,attachment.OriginalName,attachment.ThumbnailName,attachment.Size,
userid,clientid, tran))
{
tran.Rollback();
conn.Dispose();
return false;
}
}
tran.Commit();
conn.Dispose();
return true;
}示例8: insert
public void insert(UserObject userObj, string connectionString)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertCompany", insertParameters(userObj), conn);
cmdIns.ExecuteNonQuery();
// cmdIns.Parameters.Clear();
// cmdIns.CommandText = "SELECT @@IDENTITY";
// // Get the last inserted id.
// int insertID = Convert.ToInt32(cmdIns.ExecuteScalar());
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}示例9: button1_Click
private void button1_Click(object sender, EventArgs e)
{
try
{
string sConnectionString = "data source=cypress.csil.sfu.ca;" + "initial catalog=hga13354;" + "Trusted_Connection=yes;";
SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();
SqlCommand cmd = new SqlCommand("select s_ID, s_pw from dbo.Student where s_ID= '" + textBox1.Text + "' and s_pw= '" + textBox2.Text + "' ", objConn);
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
if (sdr.HasRows)
{
Form_search f2 = new Form_search();
f2.s_IS = textBox1.Text.ToString();
this.Hide();
f2.Show();
objConn.Close();
objConn.Dispose();
}
else
{
MessageBox.Show("Incorrect Student ID or Password");
objConn.Close();
objConn.Dispose();
}
objConn.Close();
objConn.Dispose();
}
catch (SqlException sqlEx) { MessageBox.Show("SQL Server Error Message:" + sqlEx.Message); }
}示例10: btnAceptar_Click
private void btnAceptar_Click(object sender, EventArgs e)
{
int entero = 0;
cnx = new SqlConnection(cdn);
cmd = new SqlCommand();
cmd.Connection = cnx;
ch = new Configuracion.Core.ConfiguracionHelper();
ch.Command = cmd;
try
{
cnx.Open();
ch.actualizarValorConfiguracion(1, txtCorreoEmisor.Text);
ch.actualizarValorConfiguracion(2, txtPassword.Text);
ch.actualizarValorConfiguracion(3, txtPuerto.Text);
entero = Convert.ToInt32(chkSsl.Checked);
ch.actualizarValorConfiguracion(4, entero.ToString());
ch.actualizarValorConfiguracion(5, txtServidorEnvio.Text);
ch.actualizarValorConfiguracion(6, txtRuta.Text);
cnx.Close();
cnx.Dispose();
this.Dispose();
}
catch (Exception error)
{
MessageBox.Show("Error: Al obtener alguna de las configuraciones.\r\n\r\n" + error.Message, "Error");
cnx.Dispose();
}
}示例11: InsertKeyIntoConfNumTable
protected void InsertKeyIntoConfNumTable(string confnum)
{
string strCon = "Data Source=(local);Initial Catalog=FlightDB;Integrated Security=True";
SqlConnection objCon = new SqlConnection(strCon);
try
{
objCon.ConnectionString = strCon;
objCon.Open();
}
catch (Exception ex)
{
this.lblConnect.Text = "Unable to connect to database.";
}
if (objCon.State == System.Data.ConnectionState.Open)
{
string sql = "INSERT INTO flightconfirmation (confnum) VALUES ('" + confnum + "')";
SqlCommand cmd = new SqlCommand(sql, objCon);
cmd.ExecuteNonQuery();
objCon.Close();
objCon.Dispose();
}
else
{
lblConnect.Text = "Unable to connect to database.";
objCon.Close();
objCon.Dispose();
}
objCon.Close();
objCon.Dispose();
}示例12: borraFalta
private void borraFalta(int fila, int columna)
{
cnx = new SqlConnection(cdn);
cmd = new SqlCommand();
cmd.Connection = cnx;
fh = new Faltas.Core.FaltasHelper();
fh.Command = cmd;
Faltas.Core.Faltas falta = new Faltas.Core.Faltas();
falta.idtrabajador = int.Parse(dgvFaltas.Rows[fila].Cells["idtrabajadorfalta"].Value.ToString());
falta.fechainicio = periodoInicio.Date;
falta.fechafin = periodoFin.Date;
falta.fecha = DateTime.Parse(dgvFaltas.Columns[columna].Name.ToString());
try
{
cnx.Open();
fh.eliminaFaltaExistente(falta);
cnx.Close();
cnx.Dispose();
}
catch (Exception error)
{
MessageBox.Show("Error: \r\n \r\n" + error.Message, "Error");
cnx.Dispose();
}
//if (dgvFaltas.Columns[columna].Name == "falta"){}
}示例13: ExecuteReader
/// <summary>
/// 执行查询语句，返回SqlDataReader ( 注意：使用后一定要对SqlDataReader进行Close )
/// </summary>
/// <param name="strSQL">查询语句</param>
/// <returns>SqlDataReader</returns>
public static SqlDataReader ExecuteReader(string SQLString,params SqlParameter[] cmdParms)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
try
{
PrepareCommand(cmd, connection, null,SQLString, cmdParms);
SqlDataReader myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
connection.Close();
connection.Dispose();
return myReader;
}
catch(System.Data.SqlClient.SqlException e)
{
connection.Close();
connection.Dispose();
throw new Exception(e.Message);
}
// finally
// {
// cmd.Dispose();
// connection.Close();
// }
}示例14: GetActividades
public List<ActividadBE> GetActividades(string periodo)
{
SqlConnection Conn = null;
String sCadenaConeccion;
String sqlUsuarioObtener;
SqlCommand cmdUsuarioObtener = null;
SqlDataReader drUsuarioObtener;
SqlParameter prmCiclo;
try
{
sCadenaConeccion = Settings.Default.csDesarrollo;
Conn = new SqlConnection(sCadenaConeccion);
sqlUsuarioObtener = "usps_Actividad";
cmdUsuarioObtener = Conn.CreateCommand();
cmdUsuarioObtener.CommandText = sqlUsuarioObtener;
cmdUsuarioObtener.CommandType = CommandType.StoredProcedure;
prmCiclo = cmdUsuarioObtener.CreateParameter();
prmCiclo.ParameterName = "@ciclo";
prmCiclo.SqlDbType = SqlDbType.VarChar;
prmCiclo.Value = periodo;
cmdUsuarioObtener.Parameters.Add(prmCiclo);
cmdUsuarioObtener.Connection.Open();
drUsuarioObtener = cmdUsuarioObtener.ExecuteReader();
ActividadBE actividad;
List<ActividadBE> lstactividad = new List<ActividadBE>();
while (drUsuarioObtener.Read())
{
actividad = new ActividadBE();
actividad.id = drUsuarioObtener.GetInt32(drUsuarioObtener.GetOrdinal("id"));
actividad.mensaje = drUsuarioObtener.GetString(drUsuarioObtener.GetOrdinal("mensaje"));
actividad.fecha = drUsuarioObtener.GetString(drUsuarioObtener.GetOrdinal("fecha"));
actividad.titulo = drUsuarioObtener.GetString(drUsuarioObtener.GetOrdinal("titulo"));
actividad.ciclo = drUsuarioObtener.GetString(drUsuarioObtener.GetOrdinal("ciclo"));
lstactividad.Add(actividad);
}
cmdUsuarioObtener.Connection.Close();
cmdUsuarioObtener.Dispose();
Conn.Dispose();
return lstactividad;
}
catch (Exception ex)
{
cmdUsuarioObtener.Dispose();
Conn.Dispose();
throw;
}
}示例15: Peso_Uno
public decimal Peso_Uno(string codigo)
{
SqlConnection Conn = null;
String sCadenaConeccion;
String sqlUsuarioObtener;
SqlCommand cmdUsuarioObtener = null;
SqlDataReader drUsuarioObtener;
SqlParameter prmCodAlumno;
try
{
PromedioxCursoBE Promedio;
sCadenaConeccion = Settings.Default.csDesarrollo;
Conn = new SqlConnection(sCadenaConeccion);
sqlUsuarioObtener = "usps_PesoCurso";
cmdUsuarioObtener = Conn.CreateCommand();
cmdUsuarioObtener.CommandText = sqlUsuarioObtener;
cmdUsuarioObtener.CommandType = CommandType.StoredProcedure;
prmCodAlumno = cmdUsuarioObtener.CreateParameter();
prmCodAlumno.ParameterName = "@Curso_id";
prmCodAlumno.SqlDbType = SqlDbType.Int;
prmCodAlumno.Value = Convert.ToInt32(codigo);
cmdUsuarioObtener.Parameters.Add(prmCodAlumno);
cmdUsuarioObtener.Connection.Open();
drUsuarioObtener = cmdUsuarioObtener.ExecuteReader();
Promedio = new PromedioxCursoBE();
decimal promedio = 0;
while (drUsuarioObtener.Read())
{
promedio = Math.Round(drUsuarioObtener.GetDecimal(drUsuarioObtener.GetOrdinal("promedio")), 2);
}
cmdUsuarioObtener.Connection.Close();
cmdUsuarioObtener.Dispose();
Conn.Dispose();
return promedio;
}
catch (Exception ex)
{
cmdUsuarioObtener.Dispose();
Conn.Dispose();
throw;
}
}