public bool Action(Classes.ColChooser cc)
{
bool f = false;
try
{
DataTable dt = new DataTable();
cmd = new SqlCommand("sp_ColumnChooser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ColChooser", cc.columne);
cmd.Parameters.AddWithValue("@ColChoosername", null);
cmd.Parameters.AddWithValue("@query", 1);
adpter = new SqlDataAdapter(cmd);
adpter.Fill(dt);
f = true;
}
catch (Exception)
{
f = false;
}
finally
{
}
return(f);
}
public void Dt_AddCol(DataTable dt_ColChooser, Classes.ColChooser cc)
{
DataRow dr = dt_ColChooser.NewRow();
dr["ColumnName"] = cc.Colname;
dr["ColumnWidth"] = cc.colWidth;
dr["IsVisable"] = cc.IsVisable;
dr["ColOrder"] = cc.ColOrder;
dt_ColChooser.Rows.Add(dr);
dt_ColChooser.AcceptChanges();
}
public void Dt_RemoveCol(DataTable dt_ColChooser, Classes.ColChooser cc)
{
// dt_ColChooser.Columns.Add("ColumnName");
// dt_ColChooser.Columns.Add("ColumnWidth");
DataRow dr = dt_ColChooser.NewRow();
dr["ColumnName"] = cc.Colname;
// dr["ColumnWidth"] = cc.colWidth;
dt_ColChooser.Rows.Remove(dr);
dt_ColChooser.AcceptChanges();
dr = dt_ColChooser.NewRow();
dr["ColumnName"] = cc.Colname;
dr["ColumnWidth"] = cc.colWidth;
dr["IsVisable"] = true;
dt_ColChooser.Rows.Add(dr);
}
