本文整理汇总了C#中DataTable类的典型用法代码示例。如果您正苦于以下问题:C#DataTable类的具体用法?C#DataTable怎么用?C#DataTable使用的例子?这里精选的类代码示例或许可以为您提供帮助。
示例1:getTotalCount
protectedintgetTotalCount()
{
SqlConnectionconnection=newSqlConnection(GetConnectionString());
DataTabledt=newDataTable();
try
{
connection.Open();
stringsqlStatement="SELECT*FROMtblContact";
SqlCommandsqlCmd=newSqlCommand(sqlStatement,connection);
SqlDataAdaptersqlDa=newSqlDataAdapter(sqlCmd);
sqlDa.Fill(dt);
}
catch(System.Data.SqlClient.SqlExceptionex)
{
stringmsg="FetchError:";
msg+=ex.Message;
thrownewException(msg);
}
finally
{
connection.Close();
}
returndt.Rows.Count;
}
原文链接:
http://www.jxszl.com/biancheng/C/556885.html