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); }