110,530
社区成员
发帖
与我相关
我的任务
分享
using( System.Data.SqlClient.SqlConnection sqlConn = new System.Data.SqlClient.SqlConnection( "Data Source=.;Initial Catalog=NorthWind;Integrated Security=True" ) )
{
System.Data.SqlClient.SqlCommand sqlCmd = new System.Data.SqlClient.SqlCommand( "SELECT * FROM Orders " , sqlConn );
System.Data.SqlClient.SqlDataAdapter sqlDapter = new System.Data.SqlClient.SqlDataAdapter( sqlCmd );
DataSet ds = new DataSet( );
sqlDapter.Fill( ds );
Response.Write( "Orders 表是否存在列名OrderDate:" + ds.Tables[0].Columns.Contains( "OrderDate" ) );
Response.Write("<br />");
Response.Write( "Orders 表是否存在列名OrderDates1:" + ds.Tables[0].Columns.Contains( "OrderDates" ) );
}
Orders 表是否存在列名OrderDate:True
Orders 表是否存在列名OrderDates1:False