private void btnAgregar_Click(object sender, System.EventArgs e)
{
try
{
this.objcon.Open();
OleDbDataAdapter da= new OleDbDataAdapter("Select * from CLIENTE",this.objcon);
string Guardar = "INSERT INTO CLIENTE(CARNET DE IDENTIDAD, NOMBRE COMPLETO, NIT, DOMICILIO, SALDO ECONOMICO) values ('" + this.txtCI.Text + "','" + this.txtNombreCompleto.Text + "','" + this.txtNit.Text + "','" + this.txtDireccion.Text + "','" + this.txtMontoSaldo.Text + "')";
OleDbCommand comd = new OleDbCommand(Guardar, this.objcon);
//comd.Parameters.Add(new OleDbParameter("@fecha",OleDbType.Date));
//comd.Parameters["@fecha"].Value = this.txtFecha.Text;
comd.Parameters.Add(new OleDbParameter("@CARNET DE IDENTIDAD",OleDbType.Integer));
comd.Parameters["@CARNET DE IDENTIDAD"].Value=this.txtCI.Text;
comd.Parameters.Add(new OleDbParameter("@NOMBRE COMPLETO",OleDbType.VarChar));
comd.Parameters["@NOMBRE COMPLETO"].Value=this.txtNombreCompleto.Text;
comd.Parameters.Add(new OleDbParameter("@NIT",OleDbType.VarChar));
comd.Parameters["@NIT"].Value=this.txtNit.Text;
comd.Parameters.Add(new OleDbParameter("@DOMICILIO",OleDbType.VarChar));
comd.Parameters["@DOMICILIO"].Value=this.txtDireccion.Text;
comd.Parameters.Add(new OleDbParameter("@SALDO ECONOMICO",OleDbType.Integer));
comd.Parameters["@SALDO ECONOMICO"].Value=this.txtMontoSaldo.Text;
comd.CommandType = CommandType.Text;
MessageBox.Show("Esta guardado");
comd.ExecuteNonQuery();
//comd.ExecuteNonQuery();
DataSet ds = new DataSet();
da.Fill(ds,"CLIENTE");
//dgtabla.DataSource = ds;
//dgtabla.DataMember = "mitabla";
this.objcon.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,("Información"),MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}