private void DeleteCl_Click(object sender, EventArgs e)
{
using (SqlConnection Conect = new SqlConnection(@"Data Source=DESKTOP-78L61PQ\SQLEXPRESS;
Initial Catalog=Sistema de Prestamos; Integrated Security=True;"))
{
Conect.Open();
SqlCommand cmd = new SqlCommand("DeleteClients", Conect);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nombre", SearchBar.Text);
cmd.ExecuteNonQuery();
SearchBar.Clear();
}
}
private void button4_Click(object sender, EventArgs e)
{
showData($"select * from cliente where id = {int.Parse(SearchBar.Text)}");
SearchBar.Clear();
}
/// <summary>
/// fill the search box and click search button
/// </summary>
/// <param name="propertyName"></param>
void FillSearchBoxAndCLickSearch(string propertyName)
{
SearchBar.Clear();
SearchBar.SendKeys(propertyName);
SearchButton.Click();
}