When similar data is obtained, different methods are used to invoke the various SPS, but it is necessary to determine if the column name exists when using the same method to read data with Iidatareader or SqlDataReader.

<summary>
Checks Clumn Name
</summary>
<param name= "Reader" >IDataReader</param>
<param name= "ColumnName" >column name</param>
<returns>bool</returns>
private bool Checkcolumnname (IDataReader Reader, String columnName)
{
BOOL result = FALSE;
DataTable dt = reader. GetSchemaTable ();

foreach (DataRow dr in Dt. Rows)
{
if (dr["ColumnName"]. ToString () = = ColumnName)
result = true;
}

return result;
}

When similar data is obtained, different methods are used to invoke the various SPS, but it is necessary to determine if the column name exists when using the same method to read data with Iidatareader or SqlDataReader.