Utility library for common data operations.

Member	Description
Constructor
MemberAccess
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 );
CopyObjectFromDataRow	public static void CopyObjectFromDataRow( DataRow Row, object TargetObject );
CopyObjectToDataRow	public static void CopyObjectToDataRow( DataRow Row, object Target );
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 );

Class Information

Assembly: wwappconfiguration.dll
Namespace: Westwind.Tools

System.Object Westwind.Tools.wwDataUtils