public void ThiHanh(SqlCommand command)
{
if (m_Connection == null || m_Connection.State == ConnectionState.Closed)
{
try
{
strConn = KetNoi("KetNoi").Replace("Initial Catalog=QLKTX;", "");;
m_Connection = new SqlConnection(strConn);
m_Connection.Open();
}
catch (Exception e)
{
ToanCuc.TaoKetNoi ketnoi = new QLKTX.ToanCuc.TaoKetNoi();
ketnoi.ShowDialog();
strConn = KetNoi("KetNoi").Replace("Initial Catalog=QLKTX;", "");
m_Connection = new SqlConnection(strConn);
m_Connection.Open();
}
}
m_Command = command;
m_Command.Connection = m_Connection;
m_Command.CommandText = "use master";
m_Command.ExecuteNonQuery();
m_Command = command;
m_Command.ExecuteNonQuery();
}
public void Load(SqlCommand command)
{
if (m_Connection == null || m_Connection.State == ConnectionState.Closed)
{
try
{
strConn = KetNoi("KetNoi");
m_Connection = new SqlConnection(strConn);
m_Connection.Open();
}
catch (Exception e)
{
ToanCuc.TaoKetNoi ketnoi = new QLKTX.ToanCuc.TaoKetNoi();
ketnoi.ShowDialog();
strConn = KetNoi("KetNoi");
m_Connection = new SqlConnection(strConn);
m_Connection.Open();
}
}
m_Command = command;
m_Command.Connection = m_Connection;
m_DataAdapter = new SqlDataAdapter(m_Command);
this.Clear();
m_DataAdapter.Fill(this);
}
