West Wind Web Toolkit for ASP.NET
Class DataUtils
Class DataUtils
public static class DataUtils : object
| Member | Description | |
|---|---|---|
  |
MemberAccess | |
|
MemberPublicInstanceAccess | |
|
MinimumSqlDate | The default SQL date used by InitializeDataRowWithBlanks. Considered a blank date instead of null. |
 |
CloseConnection | Closes a connection public static void CloseConnection(SqlCommand Command);
|
|
CopyDataRow | Copies the content of a data row to another. Runs through the target's fields and looks for fields of the same name in the source row. Structure must mathc or fields are skipped. public static bool CopyDataRow(DataRow source,
DataRow target); |
|
CopyObjectData | Copies the content of one object to another. The target object 'pulls' properties of the first. public static void CopyObjectData(object source,
object target); public static void CopyObjectData(object source,
object target, BindingFlags memberAccess); public static void CopyObjectData(object source,
object target, string excludedProperties); public static void CopyObjectData(object source,
object target, string excludedProperties, BindingFlags memberAccess); |
|
CopyObjectFromDataRow | public static void CopyObjectFromDataRow(DataRow row,
object targetObject); |
|
CopyObjectToDataRow | Copies the content of an object to a DataRow with matching field names. Both properties and fields are copied. If a field copy fails due to a type mismatch copying continues but the method returns false public static bool CopyObjectToDataRow(DataRow row,
object target); |
|
DataReaderToObject | public static void DataReaderToObject(IDataReader reader,
object instance, string fieldsToSkip, Dictionary<String,PropertyInfo> piList); |
|
DataReaderToObjectList<TType> | public static List<TType> DataReaderToObjectList<TType>(IDataReader reader,
string fieldsToSkip, Dictionary<String,PropertyInfo> piList); |
|
DbTypeToDotNetType | Maps a DbType to a .NET native type public static Type DbTypeToDotNetType(DbType sqlType);
|
|
DotNetTypeToDbType | Converts a .NET type into a DbType value public static DbType DotNetTypeToDbType(Type type);
|
|
DotNetTypeToSqlType | Converts a .NET type into a SqlDbType. public static SqlDbType DotNetTypeToSqlType(Type type);
|
|
GenerateUniqueId | public static string GenerateUniqueId(int stringSize);
|
|
GenerateUniqueNumericId | public static long GenerateUniqueNumericId();
|
|
GetDataTable | Returns a DataTable from a Sql Command string passed in. public static DataTable GetDataTable(string Tablename,
string ConnectionString, string Sql, SqlParameter[] Parameters); |
|
GetSqlCommand | Creates a Command object and opens a connection public static SqlCommand GetSqlCommand(string ConnectionString,
string Sql, SqlParameter[] Parameters); |
|
GetSqlDataReader | Returns a SqlDataReader object from a SQL string. public static SqlDataReader GetSqlDataReader(string ConnectionString,
string Sql, SqlParameter[] Parameters); |
|
InitializeDataRowWithBlanks | Initializes a Datarow containing NULL values with 'empty' values instead. Empty values are: String - "" all number types - 0 or 0.00 DateTime - Value of MinimumSqlData (1/1/1900 by default); Boolean - false Binary values and timestamps are left alone public static void InitializeDataRowWithBlanks(DataRow row);
|
|
SqlTypeToDotNetType | Maps a SqlDbType to a .NET type public static Type SqlTypeToDotNetType(SqlDbType sqlType);
|
