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; } }