Visit 'LiveWorld24.tk' for Live world..............

Duplicacy Check:

private bool mpribIsExists()

        {

            try

            {

                OperationGateway operationGateway = new OperationGateway();

                return operationGateway.mpubiIsExistsRecord("ACC_BRANCH", "BRANCH_ID", txtProjetId .Text .Trim ());

            }

            catch (Exception pexpIsExistsException)

            {

                MessageBox.Show(pexpIsExistsException.Message);

                return false;

            }

        }

Crystal Report:

stringVar NetAmount := ToText ({@Net Total Amount});

numberVar LenthOfNetAmount :=Length (NetAmount) ;

stringVar DecimalPart :=Mid (NetAmount, LenthOfNetAmount-2,LenthOfNetAmount ) ;

numberVar DecimalPartInNumber := ToNumber (DecimalPart);

numberVar NetAmountLessOne :=ToNumber ({@Net Total Amount}-1) ;

if(DecimalPart=".00") then

ProperCase (towords({@Net Total Amount},0))+"     Taka  Only"

else if(DecimalPartInNumber>=0.5) then

ProperCase (ToWords (NetAmountLessOne,0)+"   Taka   And  "+Towords((round({@Net Total Amount},2)-int({@Net Total Amount}))*100,0)+"   Paisa  Only")

else

ProperCase (ToWords ({@Net Total Amount},0)+"   Taka   And  "+Towords((round({@Net Total Amount},2)-int({@Net Total Amount}))*100,0)+"   Paisa  Only")

Combo Box:

DataGridViewComboBoxCell cell = this.dgvMaterialDetails[0, mpriiCurrentRow] as DataGridViewComboBoxCell;

                cell.Value = null;

                cell.Items.Clear();