public void Delete(bll_PopulationInfo bllcreate)
    {
        try
        {
            cmd = "EXEC Delete_populationInfo '" + bllcreate.PIID + "'";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
            //Use label to print an error >> lbl.text = e.Message;
        }
    }
    public void Insert(bll_PopulationInfo bllcreate)
    {
        try
        {
            cmd = "EXEC Insert_populationInfo '" + bllcreate.STATIONNAME + "' ,'"
                  + bllcreate.POPULATION + "' ,'"
                  + bllcreate.LITERATE + "' ,'"
                  + bllcreate.TAKEPALO + "' ,'"
                  + bllcreate.REGULAR + "','"
                  + bllcreate.FLOATING + "','"
                  + bllcreate.AUDITUSER + "' ,'"
                  + bllcreate.CREATEDATE + "' ";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
        }
    }