.net DataTable 取值辅助类

浏览数：61 / 时间：2015年06月09日

DataTableCommon类主要是帮助取值

方法列表：

public static string GetCellString(DataTable dt,int row, int column)

public static string GetCellString(DataTable dt,int row, string columnName)

public static int GetCellInt(DataTable dt, int row, int column)

public static int GetCellInt(DataTable dt, int row, string columnName)

public static decimal GetCellDecimal(DataTable dt, int row, int column)

public static decimal GetCellDecimal(DataTable dt, int row,string columnName)

public class DataTableComon
    {
        public static string GetCellString(DataTable dt,int row, int column)
        {
            string strValue = string.Empty;
            try
            {
                if (dt == null || dt.Rows.Count == 0)
                    return null;
                object objValue=dt.Rows[row][column];
                if (objValue == null || Convert.IsDBNull(objValue))
                    return null;
                strValue = objValue.ToString();
            }
            catch (Exception)
            {
            }
            return strValue;
        }
        public static string GetCellString(DataTable dt, int row, string columnName)
        {
            string strValue = string.Empty;
            try
            {
                if (dt == null || dt.Rows.Count == 0)
                    return null;
                object objValue = dt.Rows[row][columnName];
                if (objValue == null || Convert.IsDBNull(objValue))
                    return null;
                strValue = objValue.ToString();
            }
            catch (Exception)
            {
            }
            return strValue;
        }
        public static int GetCellInt(DataTable dt, int row, int column)
        {
            int intValue = 0;
            try
            {
                if (dt == null || dt.Rows.Count == 0)
                    return 0;
                object objValue = dt.Rows[row][column];
                if (objValue == null || Convert.IsDBNull(objValue))
                    return 0;
                intValue = Convert.ToInt32(objValue);
            }
            catch (Exception)
            {
            }
            return intValue;
        }
        public static int GetCellInt(DataTable dt, int row, string columnName)
        {
            int intValue = 0;
            try
            {
                if (dt == null || dt.Rows.Count == 0)
                    return 0;
                object objValue = dt.Rows[row][columnName];
                if (objValue == null || Convert.IsDBNull(objValue))
                    return 0;
                intValue = Convert.ToInt32(objValue);
            }
            catch (Exception)
            {
            }
            return intValue;
        }

        public static decimal GetCellDecimal(DataTable dt, int row, int column)
        {
            decimal intValue = 0;
            try
            {
                if (dt == null || dt.Rows.Count == 0)
                    return 0;
                object objValue = dt.Rows[row][column];
                if (objValue == null || Convert.IsDBNull(objValue))
                    return 0;
                intValue = Convert.ToDecimal(objValue);
            }
            catch (Exception)
            {
            }
            return intValue;
        }
        public static decimal GetCellDecimal(DataTable dt, int row, string columnName)
        {
            decimal intValue = 0;
            try
            {
                if (dt == null || dt.Rows.Count == 0)
                    return 0;
                object objValue = dt.Rows[row][columnName];
                if (objValue == null || Convert.IsDBNull(objValue))
                    return 0;
                intValue = Convert.ToDecimal(objValue);
            }
            catch (Exception)
            {
            }
            return intValue;
        }
    }