//protected void _CMPlist_SelectedIndexChanged(object sender, EventArgs e)
//{
// Session["CompanyName"] = _CMPlist.SelectedValue;
//}
protected void _BranchList_SelectedIndexChanged(object sender, EventArgs e)
{
Session["BranchId"] = _BranchList.SelectedValue;
SqlDataSourceDepartment.DataBind();
_DepartmentList.DataBind();
_DepartmentList.Items.Insert(0, new ListItem("Please Select", "0"));
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
var userid = GridView1.DataKeys[e.RowIndex].Value.ToString();
var NewData = e.NewValues.Values;
string NewDCode = "", NewDepartment = "";
count = 0;
foreach (var item in NewData)
{
if (count == 0)
{
NewDCode = item.ToString();
count++;
}
else if (count == 1)
{
NewDepartment = item.ToString();
}
}
SqlDataSourceDepartment.UpdateCommand = "UPDATE Department_Table SET DCode=@DCode, Department=@Department WHERE Id=@Id";
SqlDataSourceDepartment.UpdateParameters.Add("ID", userid);
SqlDataSourceDepartment.UpdateParameters.Add("DCode", NewDCode);
SqlDataSourceDepartment.UpdateParameters.Add("Department", NewDepartment);
SqlDataSourceDepartment.Update();
}