private void button1_Click(object sender, EventArgs e)
{
Clientes_agr clie = new Clientes_agr();
clie.Show();
this.Hide();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Clientes_agr clie = new Clientes_agr();
if (dataGridView1.SelectedRows.Count > 0)
{
////registro externo
//clie.textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
//clie.textBox9.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
//clie.textBox2.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
//clie.textBox3.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
//clie.textBox10.Text = dataGridView1.SelectedRows[0].Cells[5].Value.ToString();
//clie.textBox11.Text = dataGridView1.SelectedRows[0].Cells[7].Value.ToString();
//clie.textBox4.Text = dataGridView1.SelectedRows[0].Cells[6].Value.ToString();
//clie.textBox5.Text = dataGridView1.SelectedRows[0].Cells[8].Value.ToString();
//clie.textBox6.Text = dataGridView1.SelectedRows[0].Cells[9].Value.ToString();
//registro interno
textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
textBox9.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
textBox2.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
textBox3.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
textBox10.Text = dataGridView1.SelectedRows[0].Cells[5].Value.ToString();
textBox11.Text = dataGridView1.SelectedRows[0].Cells[7].Value.ToString();
textBox4.Text = dataGridView1.SelectedRows[0].Cells[6].Value.ToString();
textBox5.Text = dataGridView1.SelectedRows[0].Cells[8].Value.ToString();
textBox6.Text = dataGridView1.SelectedRows[0].Cells[9].Value.ToString();
}
}
private void button2_Click(object sender, EventArgs e)
{
textBox7.Enabled = true;;
sqlconn.Open();
Clientes_agr clie = new Clientes_agr();
sqlcomm = new SqlCommand();
string sql;
DataTable dt = new DataTable();
sql = selec +
" where" + " ID_CLIENTE = " + textBox8.Text;
sqlcomm.Connection = sqlconn;
sqlcomm.CommandText = sql;
sqlcomm.CommandType = CommandType.Text;
sqlcomm.ExecuteNonQuery();
sqlda = new SqlDataAdapter(sql, sqlconn);
sqlda.Fill(dt);
sqlconn.Close();
textBox7.Text = textBox8.Text;
textBox7.Enabled = false;
textBox1.Text = dt.Rows[0][1].ToString();
textBox9.Text = dt.Rows[0][2].ToString();
textBox2.Text = dt.Rows[0][3].ToString();
textBox3.Text = dt.Rows[0][4].ToString();
textBox10.Text = dt.Rows[0][5].ToString();
textBox4.Text = dt.Rows[0][6].ToString();
textBox11.Text = dt.Rows[0][7].ToString();
textBox5.Text = dt.Rows[0][8].ToString();
textBox6.Text = dt.Rows[0][9].ToString();
dataGridView1.DataSource = dt;
}
private void button3_Click(object sender, EventArgs e)
{
sqlconn.Open();
sqlcomm = new SqlCommand();
string sql;
DataTable dt = new DataTable();
Clientes_agr clie = new Clientes_agr();
sql = "update" +
" CLIENTE " +
"set " +
"CL_NOMBRE = '" + clie.textBox1.Text + "', " +
"CL_CEDULA = '" + clie.textBox9.Text + "', " +
"CL_APELLIDO = '" + clie.textBox2.Text + "'," +
"CL_APELLIDO_MATERNO = '" + clie.textBox3.Text + "'," +
"CL_EMAIL = '" + clie.textBox10.Text + "'," +
"CL_TELEFONO = '" + clie.textBox4.Text + "'," +
"CL_EDAD = '" + clie.textBox11.Text + "'," +
"CL_USUARIO = '" + clie.textBox5.Text + "'," +
"CL_PASSWORD = '******'" +
" where" + " ID_CLIENTE = " + textBox8.Text;
sqlcomm.Connection = sqlconn;
sqlcomm.CommandText = sql;
sqlcomm.CommandType = CommandType.Text;
sqlcomm.ExecuteNonQuery();
sqlconn.Close();
sql = selec;
sqlconn.Open();
sqlda = new SqlDataAdapter(sql, sqlconn);
sqlda.Fill(dt);
sqlconn.Close();
dataGridView1.DataSource = dt;
textBox8.Text = "";
}
private void registroToolStripMenuItem_Click(object sender, EventArgs e)
{
Clientes_agr agr = new Clientes_agr();
agr.Show();
}