protected void txtTransCode_TextChanged(object sender, EventArgs e) { string tlcode = txtTransLocCode.Text.Trim() + txtTransSubLocCode.Text.Trim() + txtTransCode.Text.Trim(); if (!myFunc.isTransLocCodeExist(tlcode)) { txtTransLocDesc.Text = ""; txtTransLocDesc.Enabled = true; txtTransLocDesc.Focus(); btnSave.Enabled = true; btnDelete.Enabled = false; //btnSaveBottom.Enabled=true; //btnDeleteBottom.Enabled=false; GridViewTransLocs.Visible = true; SqlDataSourceTransLocations.SelectCommand = "select * from PartsTransLocation where PartsLocCode='" + txtLocCode.Text.Trim() + "' and PartsSubLocCode='" + txtSubLocCode.Text.Trim() + "'"; SqlDataSourceTransLocations.Select(DataSourceSelectArguments.Empty); GridViewTransLocs.Visible = true; GridViewTransLocs.DataBind(); } else { txtTransLocDesc.Text = myFunc.GetTransLocDesc(tlcode); txtTransLocDesc.Enabled = true; btnSave.Enabled = false; btnDelete.Enabled = true; //btnSaveBottom.Enabled = false; //btnDeleteBottom.Enabled = true; GridViewTransLocs.Visible = true; SqlDataSourceTransLocations.SelectCommand = "select * from PartsTransLocation where PartsTransLocCode='" + tlcode + "'"; SqlDataSourceTransLocations.SelectCommand = "select * from PartsTransLocation where PartsLocCode='" + txtLocCode.Text.Trim() + "' and PartsSubLocCode='" + txtSubLocCode.Text.Trim() + "'"; SqlDataSourceTransLocations.Select(DataSourceSelectArguments.Empty); GridViewTransLocs.Visible = true; GridViewTransLocs.DataBind(); } }