private bool IsvalidUser(string userName, string password) { BD.ProyectoDataClassesDataContext context = new ProyectoDataClassesDataContext(); var q = from p in context.TBusers where p.Usuario == textBox1.Text && p.Pass == textBox2.Text select p; if (q.Any()) { return(true); } else { return(false); } }
private void button2_Click(object sender, EventArgs e) { BD.ProyectoDataClassesDataContext busers = new ProyectoDataClassesDataContext(); var count = from rango in busers.TBusers select rango; var cantidad = count.Count(); int i = cantidad; i = i + 1; try { busers.Insertar_User("TEMP" + i.ToString(), textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, Convert.ToInt32(textBox5.Text), textBox6.Text, 1, "JUBN3", 2); MessageBox.Show("Se ha añadido un invitado", "Información"); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; textBox1.Focus(); } catch (Exception err) { MessageBox.Show(err.Message); } }