protected void Link_OnClick(object sender, EventArgs e)
{
// lSuccessMsg.Text = "";
int CustomerId = Convert.ToInt32((sender as LinkButton).CommandArgument);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("ViewByID", connection);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@CustomerId", CustomerId);
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
connection.Close();
GridCustomerDetails.DataSource = dataTable;
GridCustomerDetails.DataBind();
HiddenFieldId.Value = CustomerId.ToString();
txtCustomerName.Text = dataTable.Rows[0]["CustomerName"].ToString();
txtCustomerFN.Text = dataTable.Rows[0]["CustomerFirstName"].ToString();
txtCustomerLN.Text = dataTable.Rows[0]["CustomerLastName"].ToString();
txtCustomerPhone.Text = dataTable.Rows[0]["CustomerPhoneNumber"].ToString();
txtCustomerAddress.Text = dataTable.Rows[0]["CustomerAddress"].ToString();
txtCustomerEmailId.Text = dataTable.Rows[0]["CustomerEmailId"].ToString();
btnAdd.Text = "Update";
btninput = btnAdd.Text;
btnDelete.Enabled = true;
}
void FillingGrid()
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("CustomerView", connection);
sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
connection.Close();
GridCustomerDetails.DataSource = dataTable;
GridCustomerDetails.DataBind();
connection.Close();
}
}
