一個很小的MySql數據格式轉化方法類，做數據庫相關的開發因該會用到，記下來以備后用：

public static class DbConvert{public static int ToInt32(DataRow dataRow, string columnName){if (dataRow[columnName] != DBNull.Value){return Convert.ToInt32(dataRow[columnName]);}else{return 0;}}public static double ToDouble(DataRow dataRow, string columnName){if (dataRow[columnName] != DBNull.Value){return Convert.ToDouble(dataRow[columnName]);}else{return 0;} }public static int ToInt32(object input){if (input == null){return 0;}return Convert.ToInt32(input);}public static string ToString(DataRow dataRow, string columnName){if (dataRow[columnName] != DBNull.Value){return dataRow[columnName].ToString();}else{return null;}}public static bool ToBoolean(DataRow dataRow, string columnName){if (dataRow[columnName] != DBNull.Value){return Convert.ToBoolean(dataRow[columnName]); }else{return false;}}public static DateTime ToDateTime(DataRow dataRow, string columnName){if (dataRow[columnName] != DBNull.Value){return Convert.ToDateTime(dataRow[columnName]);}else{return DateTime.MinValue;}}}

?

轉載于:https://www.cnblogs.com/Blackeye286/p/3324191.html

總結

以上是生活随笔為你收集整理的DataBase Convert Class的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。