Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Mesa
- (
- cod number(5)not null,
- nome VARCHAR2(20)not null,
- ativa VARCHAR2(20)not null,
- inativa VARCHAR2(20)not null,
- Ativo number(03)not null,
- constraint PK_cod_Mesa PRIMARY KEY(cod)
- );
- public void Gravar()
- {
- string strQuery;
- strQuery = "INSERT INTO Mesa";
- strQuery += (" VALUES(");
- strQuery += ("seq_mesa.NEXTVAL,");
- strQuery += ("'" + _nome + "',");
- strQuery += ("'" + _ativa + "',");--campo onde irei salvar o ativa ou inativa
- strQuery += ("'1'");
- strQuery += (")");
- clnBancoDados ObjClnBancoDados = new clnBancoDados();
- ObjClnBancoDados.ExecutaComando(strQuery);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement