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

  • C# - How To Mathematical Operations In DataTable

    I have a DataTable and I want to do some mathematical operations before adding them to DataGridView. First one, I want to find maximum number of third column of my DataTable, second one I want to divide all values in third column with this maximum number. After all I want to replace my new values instead old values. My DataTable looks like that;

            Column 1     Column 2     Column 3
     ---------------------------------------
          a             b          2000000
          q             r          250000
          s             t          185000
          m             w          400000
          o             p          750000

    After the operations, my DataTable should look like that;

            Column 1     Column 2     Column 3
     ---------------------------------------
          a             b          1
          q             r          0.125
          s             t          0.0925
          m             w          0.0002
          o             p          0.375

    It's my code;

          connection.Open();
      //Some insignificant operations here.
      for (int q = 0; q < w.Length; q++)
      {
          for (int a = q + 1; a < w.Length; a++)
          {
              string query = ".....";
              SqlDataAdapter myAdapter = new SqlDataAdapter(query, connection);
              DataTable myTable = new DataTable();
              myAdapter.Fill(myTable);
              //I started here for finding maximum number in DataTable.
              int[] myColumn = dt.AsEnumerable().Select(x => x.Field<int>("Column3")).ToArray();
              int myMaximum = myColumn.Max();
              //I don't know what should I do after that.
              foreach (DataRow myRows in myTable.Rows)
              {
                  //Some significant operations again...
                  dgv1.Rows.Add(...);
              }
          }
      }
      connection.Close();
  • SharpDX: Broken UVs (Texture coordinate count higher/lower than vertex count)

    I'm working on a little DX11 engine using SharpDX, and I'm trying to import .CGF 3D models, which look like this:

    Vx: 0.2657574 Vy: 15.89708 Vz: 568.179
Nx: -2130.997 Ny: 0.7095607 Nz: -0.6526076
Vx: 0.2657574 Vy: 7.688416 Vz: 568.179
Nx: -2130.997 Ny: -0.7095606 Nz: -0.6526074

F1: 4 F2: 302 F3: 303
mtl: 0 smgroup: 1
F1: 4 F2: 2897 F3: 2899
mtl: 1 smgroup: 1

U: 0.3642449 V: 0.28958067
U: 0.36424488 V: 0.19414064

    I made a converter to load CGF files, it works for models that have the same amount of vertices and texture coordinates like this one: image

    But if the texture coordinate count is lower or higher than the vertex count, I don't know how to proceed: image

  • How to return null from a method returning Task<IList<ClassType>

    My async method is expected to return IList

    private async Task<IList<MyClassType>> GetTcpDataAsync()
{
    try
    {
        // Do something
        // On Success, return IList<MyClassType> 
    }
    catch (Exception ex)
    {
        // On exception
        return null; // HOW TO RETURN NULL OR EMPTY LIST IN THIS CASE?
    }
}

    Above, in case of an error, I will not have list to return. How do I return null or empty list?