.cs:
ds
=
null
;
ds = MFService.listAllCode( "" , " 000092 " );
row = ds.Tables[ 0 ].NewRow();
row[ " CODEDESP " ] = " Select " ;
ds.Tables[ 0 ].Rows.InsertAt(row, 0 );
this .ddl_sourceCode.DataSource = ds;
this .ddl_sourceCode.DataValueField = " CODE " ;
this .ddl_sourceCode.DataTextField = " CODEDESP " ;
this .ddl_sourceCode.DataBind();
ds = MFService.listAllCode( "" , " 000092 " );
row = ds.Tables[ 0 ].NewRow();
row[ " CODEDESP " ] = " Select " ;
ds.Tables[ 0 ].Rows.InsertAt(row, 0 );
this .ddl_sourceCode.DataSource = ds;
this .ddl_sourceCode.DataValueField = " CODE " ;
this .ddl_sourceCode.DataTextField = " CODEDESP " ;
this .ddl_sourceCode.DataBind();
Procedure:
SELECT
code,
SUBSTR (cd_desc, 1 , 40 ) cd_desc,
code || ' ----- ' || cd_desc codedesp
FROM
TBMF_CODE_MASTER
code,
SUBSTR (cd_desc, 1 , 40 ) cd_desc,
code || ' ----- ' || cd_desc codedesp
FROM
TBMF_CODE_MASTER