protected void B_Submit_Click(object sender, EventArgs e)
{
if (TB_SQL_Query.Text != "")
{
try
{
string strSQL = TB_SQL_Query.Text.Trim();
if ((strSQL.ToLower().IndexOf("select") >= 0))
{
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
//Database Operations
SqlDataAdapter objAdapter = new SqlDataAdapter(strSQL, objConnection);
DataSet objDataSet = new DataSet();
// OpenConnection
objConnection.Open();
objAdapter.Fill(objDataSet, "ResultSet");
//Load Control
GV_Query.Visible = true;
GV_Query.DataSource = objDataSet;
GV_Query.DataBind();
//Cloase Connection
objConnection.Close();
HF_Query.Value = strSQL;
// Make visibility
B_NewQuery.Visible = true;
B_SaveExcel.Visible = true;
B_Submit.Visible = false;
TB_SQL_Query.Visible = false;
}
}
else// No Sellect Command
{
L_noSelectError.Visible = true;
}
}// Sql Command is not properly Coded
catch (System.Data.SqlClient.SqlException)
{
L_QueryError.Visible = true;
}
catch (Exception Ex)// Some General Exception
{
ErrorLog.WriteErrorLog("Admin-Protected-QueryChecker", Ex);
L_QueryError.Visible = true;
}
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
SqlCommand objCommand = new SqlCommand("Matrimonials_DataBaseDetails", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Database Operations
// Open Connection
objConnection.Open();
SqlDataAdapter objAdapter = new SqlDataAdapter(objCommand);
DataSet objDataSet = new DataSet();
// Close Connection
objConnection.Close();
objAdapter.Fill(objDataSet, "ResultSet");
GV_Query.DataSource = objDataSet;
GV_Query.DataBind();
}
}
catch (Exception Ex)
{
ErrorLog.WriteErrorLog("Admin-Protected-MatrimonialDatabase", Ex);
L_QueryError.Visible = true;
}
}
else
{
try
{
using (SqlConnection objConnection = DBConnection.GetSqlConnection())
{
SqlCommand objCommand = new SqlCommand("Matrimonials_DataBaseDetails", objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Database Operations
// Open Connection
objConnection.Open();
SqlDataAdapter objAdapter = new SqlDataAdapter(objCommand);
DataSet objDataSet = new DataSet();
objAdapter.Fill(objDataSet, "ResultSet");
//Save AS Excel
// Open Connection
objConnection.Close();
DataTable objDataTable = objDataSet.Tables["ResultSet"].Copy();
// DB2Excel all the details to Excel
DB2Excel objExport = new DB2Excel();
objExport.Export(objDataTable, DB2Excel.ExportFormat.Excel, "Query_Results_." + DateTime.Now.ToShortDateString() + ".xls");
}
}
catch (Exception Ex)//Oops Some Error Had Happend
{
ErrorLog.WriteErrorLog("Admin-Protected-Matrimonial Database", Ex);
L_QueryError.Visible = true;
}
}
}
