private void FrmServicios_Load(object sender, EventArgs e)
{
lista = FuncionesServicios.Mostrar();
dtservicios.DataSource = lista;
if (dtservicios.Rows.Count != 0)
{
dtservicios.Columns["idservicio"].Visible = false;
}
}
//SqlConnection coneccion = new SqlConnection("server=FEDERICO-PC\\SQLEXPRESS ; database=prueba ; integrated security = true");
/* public void autocompletarcli(TextBox cajaTexto, string idcli)
* {
* try
* {
* con.Open();
* SqlCommand cmd = new SqlCommand("SELECT nombre from cliente ", con);
*
* SqlDataReader dr;
*
* dr = cmd.ExecuteReader();
*
* while (dr.Read())
* {
* cajaTexto.AutoCompleteCustomSource.Add(dr["Nombre"].ToString());
* }
* dr.Close();
*
*
*
* }
* catch (Exception ex)
*
* {
* throw ex;
* }
* finally
* {
* con.Close();
* }
* }
*
* public void autocompletarserv(TextBox cajaTexto)
* {
* try
* {
* coneccion.Open();
* SqlCommand cmd = new SqlCommand("SELECT nomcorto from servicio ", coneccion);
*
* SqlDataReader dr;
*
* dr = cmd.ExecuteReader();
*
* while (dr.Read())
* {
* cajaTexto.AutoCompleteCustomSource.Add(dr["nomcorto"].ToString());
*
* }
* dr.Close();
*
*
*
* }
* catch (Exception ex)
*
* {
* throw ex;
* }
* finally
* {
* coneccion.Close();
* }
* }*/
private void FrmNotaPedido_Load(object sender, EventArgs e)
{
// autocompletarcli(txtclientenom);
// autocompletarserv(txttiposerv);
SqlCommand cm = new SqlCommand("select * from cliente", con);
con.Open();
SqlDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr.GetString(1));
}
con.Close();
lista = FuncionesServicios.Mostrar();
dtservicios.DataSource = lista;
if (dtservicios.Rows.Count != 0)
{
dtservicios.Columns["idservicio"].Visible = false;
}
}
