Related questions

C#: How to cast a value from a database field to an explicit typed variable

2018-10-11 18:57 Valeriy imported from Stackoverflow

In fact, I've already found the answer to my question, here at stackoverflow. But because of my low reputation, I can't give thank to the person (Richard Petheram) who gave me the hint. So please add me the votes to 15 so I could at least thank helping people. Thanks in advance )

Here is the question and the answer helped me

and here is my function

    public static T NvlO<T>(object a, T b)
    {
        if (a == null)
            return b;
        else
        {
            var lSrcType = a.GetType();
            var lDestType = typeof(T);

            if (lDestType.IsValueType && lDestType.IsAssignableFrom(lSrcType))
                return (T)a;
            var lDestTC = TypeDescriptor.GetConverter(typeof(T));
            if (lDestTC.CanConvertFrom(lSrcType))
                return (T)lDestTC.ConvertFrom(a);
            else
            {
                var lSrcTC = TypeDescriptor.GetConverter(lSrcType);
                String lTmp = lSrcTC.ConvertToInvariantString(a);
                return (T)lDestTC.ConvertFromInvariantString(lTmp);
            }
        }
    }

example of using

long _userID = Utils.NvlO(dr["UserID"], 0);

and if you think that the function does not match the correct programming patterns, write why you think so.

See also questions close to this topic

  • How to check all previous values in an SQL Server table via c# or SQL code

    I have a table to record staffs enter and exit times. I want to implement this logic: when they enter their code in a text box, the code should go through all previous values, if that name has a clockIn time value but no ClockOut time value, the system should record the time in the ClockOut column.

    But if there is no clockIn and no ClockOut for that name, the system should record time and store it in ClockIn column (and if there is clockIn and clockout values presented before in the table for that name then system should start a new row with that name, and record the time in clockIn column).

    Why do I say it should check all of the previous records? Because there are several employees who would enter their code in the program in the morning in any order and at night all of them will enter their code not in a predetermined order. So the system should figure it out who has clockedIn before to Clock it out and who has not done anything before to clock it in.

    what I want presented in another way: lets assume this is my table:

    [memberCode] | [name] | [ClockIn]| [ClockOut]

    In the morning Alex comes and clocks in

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          Alex     09:00:00

    Jaimy comes and clocks in

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          Alex     09:00:00  
    122          jamy     09:00:20

    Neo comes and clocks in

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          alex     09:00:00  
    122          jamy     09:00:20
    123          Neo      09:00:25

    Neo Leaves:

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          alex     09:00:00  
    122          jamy     09:00:20
    123          Neo      09:00:25   13:00:00

    Neo Comes

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          Alex     09:00:00  
    122          Jamy     09:00:20
    123          Neo      09:00:25   13:00:00
    123          Neo      18:00:00

    At night, Jamie leaves:

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          Alex     09:00:00  
    122          Jamy     09:00:20   22:00:00
    123          Neo      09:00:25   13:00:00
    123          Neo      18:00:00

    Neo Leaves:

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          Alex     09:00:00  
    122          Jamy     09:00:20   22:00:00
    123          Neo      09:00:25   13:00:00
    123          Neo      18:00:00   23:00:00

    Alex Leaves:

    [memberCode] | [name] | [ClockIn]| [ClockOut]
    121          Alex     09:00:00   00:00:00
    122          Jamy     09:00:20   22:00:00
    123          Neo      09:00:25   13:00:00
    123          Neo      18:00:00   23:00:00

    Ofcource I need a date column as well but I omited it due to simplicity. This is my idea for an attendance sheet. If you want to add something to make it better, I would appreciate it.

  • How to return grid value from database from Business layer of c#?

    I am returning data from database to business layer but my data is not returning this project is based on C# and angular 4. Any help would be helpful. Thank You! 

            List<AccountType> ListAccounType = new List<AccountType>();
        ListAccounType = AccountTypeRepository.GetAllData().ToList();

        List<Account> ListAccount = new List<Account>();
        ListAccount = AccountRepository.GetAllData().ToList();

        List<AccountTransactionValue> ListAccountTransactionValue = new List<AccountTransactionValue>();
        ListAccountTransactionValue = accValueRepository.GetAllData().Where(o => o.Date >= FromDate && o.Date <= ToDate).ToList();

        var ListAccountTransaction = from v in ListAccountTransactionValue
                                     join atr in lisAccountTransaction on v.AccountTransactionId equals atr.Id
                                     join a in ListAccount on v.AccountId equals a.Id
                                     select new { v.Id, Name = a.Name, v.AccountTransactionId, VoucherNo = atr.Name.Substring(atr.Name.IndexOf("[")), AccountTransactionType = atr.Name.Substring(0, atr.Name.IndexOf("[")), atr.Amount, SourceAccountTypeId = atr.SourceAccountTypeId, Description = atr.Description, DebitAmount = v.Debit, CreditAmount = v.Credit, v.Date };

        var ListScreenAccountType = ListAccountTransaction.Select(o => new { o.AccountTransactionId, o.Amount, o.Name, o.CreditAmount, o.DebitAmount, o.VoucherNo, o.Date, o.AccountTransactionType }).Distinct().ToList();

        List<AccountScreen> listAccountScreen = new List<AccountScreen>();
        foreach (var accounttransaction in ListScreenAccountType)
        {
            AccountScreen obAccountScreen = new AccountScreen();
            obAccountScreen.Id = accounttransaction.AccountTransactionId;
            obAccountScreen.VDate = accounttransaction.Date.ToShortDateString();
            obAccountScreen.Name = accounttransaction.Name;
            obAccountScreen.VoucherNo = accounttransaction.VoucherNo;
            var objscreens = ListAccountTransaction.Where(o => o.VoucherNo == accounttransaction.VoucherNo);
            List<ScreenOrderDetails> ListScreenOrderDetails = new List<ScreenOrderDetails>();
            foreach (ScreenOrderDetails screenvalue in objscreens)
            {
                ScreenOrderDetails objScreenOrderDetails = new ScreenOrderDetails();
                objScreenOrderDetails.Id = screenvalue.Id;
                objScreenOrderDetails.Qty = screenvalue.Qty;
                objScreenOrderDetails.UnitPrice = screenvalue.UnitPrice;
                objScreenOrderDetails.TotalAmount = screenvalue.TotalAmount;
                ListScreenOrderDetails.Add(objScreenOrderDetails);
            }
            listAccountScreen.Add(obAccountScreen);
        }
        return listAccountScreen;
  • Check and replace the values in each cell of a DataTable using ItemArray

    I have a datatable with 10 columns. I have to check if the cell values in each of the columns contains value A or D, if so I have to replace 'A' with '150' and 'D' with '250' respectively.

    I am trying with this ::

    foreach (DataRow dr in dt.Rows) 
{
    foreach(var item in dr.ItemArray)
        {
            if( item.ToString()=="A")
            {
                item.ToString().Replace("A", "150");
            }
            if (item.ToString() == "D")
            {
                item.ToString().Replace("A", "250");
            }
        }
}

    but the values are not replaced. Why is it so? What is the error with this code ?