protected void m_cmd_excute_Click(object sender, EventArgs e)
{
try
{
BS_Object v_bs = new BS_Object();
DataSet op_ds = new DataSet();
DataTable v_dt = new DataTable();
op_ds.Tables.Add(v_dt);
op_ds.AcceptChanges();
string v_str_command = "";
if (m_rdb_excute.Checked == true) v_str_command = m_txt_command.Text;
else if (m_rdb_tim_proc.Checked == true) v_str_command =
"SELECT OBJECT_NAME(object_id)as 'procedure',definition as 'Script' FROM sys.sql_modules WHERE objectproperty(object_id,'IsProcedure') = 1 AND definition like '%" + m_txt_command.Text + "%'";
else if (m_rdb_tim_view.Checked == true) v_str_command =
"Select table_name AS 'Table name', VIEW_DEFINITION AS 'Script' From INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME LIKE'%" + m_txt_command.Text + "%'";
else if (m_rdb_tckt.Checked == true)
{
string v_str_cmd = m_txt_command.Text;
SqlCommand i_SelectCmd = new SqlCommand(v_str_cmd);
System.Data.SqlClient.SqlDataAdapter v_da = CProvider.getAdapter();
const int C_COMMAND_TIME_OUT = 5;
// Tạo ra connection
System.Data.SqlClient.SqlConnection v_cn = getConnection();
// Tạo ra adapter
v_da.SelectCommand = i_SelectCmd;
v_da.SelectCommand.Connection = v_cn;
v_da.SelectCommand.CommandTimeout = C_COMMAND_TIME_OUT;
// Lấy dữ liệu từ DB
try
{
v_da.Fill(op_ds, op_ds.Tables[0].TableName);
}
catch (System.Exception v_e)
{
throw v_e;
}
finally
{
v_da = null;
GC.Collect();
}
m_lbl_mess.Text = "Command(s) completed successfully.";
m_grv.DataSource = op_ds.Tables[0];
m_grv.DataBind();
return;
}
SqlCommand v_sql_cmd = new SqlCommand(v_str_command);
v_bs.FillDatasetByCommand(op_ds, v_sql_cmd);
m_lbl_mess.Text = "Command(s) completed successfully.";
m_grv.DataSource = op_ds.Tables[0];
m_grv.DataBind();
}
catch (Exception v_e)
{
m_lbl_mess.Text = "Lỗi: " + v_e.ToString();
m_grv.DataSource = null;
m_grv.DataBind();
}
}
protected void m_cmd_excute_Click(object sender, EventArgs e)
{
try
{
m_ds = new DataSet();
BS_Object v_bs = new BS_Object();
DataTable v_dt = new DataTable();
m_ds.Tables.Add(v_dt);
m_ds.AcceptChanges();
string v_str_command = "";
if (m_rdb_excute.Checked == true) v_str_command = m_txt_command.Text;
else if (m_rdb_tim_proc.Checked == true) v_str_command =
"SELECT OBJECT_NAME(object_id)as 'procedure',definition as 'Script' FROM sys.sql_modules WHERE objectproperty(object_id,'IsProcedure') = 1 AND definition like '%" + m_txt_command.Text + "%'";
else if (m_rdb_tim_view.Checked == true) v_str_command =
"Select table_name AS 'Table name', VIEW_DEFINITION AS 'Script' From INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME LIKE'%" + m_txt_command.Text + "%'";
//else if (m_rdb_tckt.Checked == true)
//{
// string v_str_cmd = m_txt_command.Text;
// SqlCommand i_SelectCmd = new SqlCommand(v_str_cmd);
// System.Data.SqlClient.SqlDataAdapter v_da = CProvider.getAdapter();
// const int C_COMMAND_TIME_OUT = 5;
// // Tạo ra connection
// System.Data.SqlClient.SqlConnection v_cn = getConnection();
// // Tạo ra adapter
// v_da.SelectCommand = i_SelectCmd;
// v_da.SelectCommand.Connection = v_cn;
// v_da.SelectCommand.CommandTimeout = C_COMMAND_TIME_OUT;
// // Lấy dữ liệu từ DB
// try
// {
// v_da.Fill(op_ds, op_ds.Tables[0].TableName);
// }
// catch (System.Exception v_e)
// {
// throw v_e;
// }
// finally
// {
// v_da = null;
// GC.Collect();
// }
// m_lbl_mess.Text = "Command(s) completed successfully.";
// m_grv.DataSource = op_ds.Tables[0];
// m_grv.DataBind();
// return;
//}
List<string> lst_cmd = Regex.Split(v_str_command, "GO").ToList();
foreach (var str_cmd in lst_cmd)
{
SqlCommand v_sql_cmd = new SqlCommand(str_cmd);
m_txt_lst_command.Text = str_cmd
+ Environment.NewLine
+ "------------------------------------------"
+ Environment.NewLine + m_txt_lst_command.Text;
v_bs.FillDatasetByCommand(m_ds, v_sql_cmd);
m_lbl_mess.Text = "Command(s) completed successfully.";
}
//m_grv.DataSource = m_ds.Tables[0];
//m_grv.DataBind();
}
catch (Exception v_e)
{
m_lbl_mess.Text = "Lỗi: " + v_e.ToString();
//m_grv.DataSource = null;
//m_grv.DataBind();
}
}