Comments by Hasiya (Top 26 by date)

It's not working dear .i try this code.

public DataTable getTaxStat(String TaxCode)
{

string sql = "SELECT Stat FROM tblTaxTypes WHERE TaxCode= '"+TaxCode+ "'";
DataTable StatList = SQLTrans.executeQuery(sql, "tbl");
return StatList;

}

I check this code VS2010 immediate Window no errors this code

protected void BtnInactive_Click(object sender, EventArgs e)
{

String modee = ViewState["mode"].ToString();

if (modee == "Edit")
{


String procedureName;
CommandType cmdType;
List<sqlparameter> parameters = new List<sqlparameter>();



procedureName = "Add_tblTaxTypes";
cmdType = CommandType.StoredProcedure;
parameters.Add(new SqlParameter("@TaxCode", SqlDbType.Int));//0
parameters.Add(new SqlParameter("@TaxName", SqlDbType.VarChar, 100));//1
parameters.Add(new SqlParameter("@TaxDescription", SqlDbType.VarChar, 100));//2
parameters.Add(new SqlParameter("@EnterdBy", SqlDbType.VarChar, 100));//3
parameters.Add(new SqlParameter("@EnterDate", SqlDbType.Date));//4
parameters.Add(new SqlParameter("@Stat", SqlDbType.Bit));//5
parameters.Add(new SqlParameter("@Status", SqlDbType.Int));//6



String Uname = Session["UN"].ToString();
lbluser.Text = Uname;
if (BAL.UserValidation.F_name != null)
{

Emp_Name = BAL.UserValidation.F_name;

}


parameters[0].Value = 0;
parameters[1].Value = txtTaxname.Text.Trim();
parameters[2].Value = txtTaxDesc.Text.Trim();
parameters[3].Value = lbluser.Text;
DateTime DateTime1 = DateTime.Now;
parameters[4].Value = DateTime.Now;

String TaxCode = GridViewTax.SelectedRow.Cells[1].Text;
dt = AD.getTaxStat(TaxCode);
lblstat.Text = dt.Rows[0][0].ToString();
if (lblstat.Text == "true")
{
Boolean ss = false;
parameters[5].Value = ss.ToString();

// BtnInactive.Text = "Inactive";
}


else if (lblstat.Text == "false")
{
//BtnInactive.Text = "Active";
Boolean ss = true;
parameters[5].Value = ss.ToString();

}

parameters[6].Value = 2;




Boolean status = Common.executeProcedure(procedureName, cmdType, parameters);

if (status == true)
{
string url = "TaxType.aspx";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "load", "runSuccess();", true);
dt = AD.getTaxtypes();
GridViewTax.DataSource = dt;
GridViewTax.DataBind();


}



this.ViewState["mode"] = "View";



}
}