protected void btnReset_Click(object sender, System.EventArgs e)
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
PerformSearch();
PerformDataBind();
}
protected void btnReset_Click(object sender, System.EventArgs e)
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
PerformSearch();
PerformDataBind();
if (this.CheckBox1.Checked)
{
PerformGroupby();
}
else
{
PerformFlat();
}
}
private void PerformGetCusData(string strCommandText)
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
ConnectStr = (new igFunctions.DB().getConStr()); SqlConnection Con = new SqlConnection(ConnectStr);
SqlCommand cmdCusData = new SqlCommand(strCommandText, Con);
SqlDataAdapter Adap = new SqlDataAdapter();
Con.Open();
Adap.SelectCommand = cmdCusData;
Adap.Fill(ds, "CusData");
Con.Close();
UltraWebGrid1.DataSource = ds.Tables["CusData"].DefaultView;
UltraWebGrid1.DataBind();
}
private void PerformCus()
{
UltraWebGrid1.ResetColumns();
UltraWebGrid1.ResetBands();
string strCommandText = " select '' as Chk, country_name as Country, country_code as Code from country_code where elt_account_number=" + elt_account_number.ToString() + " order by country_name";
ConnectStr = (new igFunctions.DB().getConStr());
SqlConnection Con = new SqlConnection(ConnectStr);
SqlCommand cmdCusData = new SqlCommand(strCommandText, Con);
SqlDataAdapter Adap = new SqlDataAdapter();
Con.Open();
Adap.SelectCommand = cmdCusData;
Adap.Fill(ds, "CusData");
Con.Close();
UltraWebGrid1.DataSource = ds.Tables["CusData"].DefaultView;
UltraWebGrid1.DataBind();
}