private void Form1_Load(object sender, System.EventArgs e)
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\mcTest.MDB";
string strSQL = "SELECT * FROM Developer" ;// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter( strSQL, myConn );myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill( dtSet, "Developer" );
DataTable dt = dtSet.Tables[0];listBox1.Items.Add("Field Name DataType Unique AutoIncrement AllowNull");
listBox1.Items.Add("==================================================================");foreach( DataColumn dc in dt.Columns )
{
listBox1.Items.Add(dc.ColumnName+" , "+dc.DataType +" ,"+dc.Unique +" ,"+dc.AutoIncrement+" ,"+dc.AllowDBNull );
}} 原文连接:
http://www.c-sharpcorner.com/database/table_p.asp
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\mcTest.MDB";
string strSQL = "SELECT * FROM Developer" ;// create Objects of ADOConnection and ADOCommand
OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbDataAdapter myCmd = new OleDbDataAdapter( strSQL, myConn );myConn.Open();
DataSet dtSet = new DataSet();
myCmd.Fill( dtSet, "Developer" );
DataTable dt = dtSet.Tables[0];listBox1.Items.Add("Field Name DataType Unique AutoIncrement AllowNull");
listBox1.Items.Add("==================================================================");foreach( DataColumn dc in dt.Columns )
{
listBox1.Items.Add(dc.ColumnName+" , "+dc.DataType +" ,"+dc.Unique +" ,"+dc.AutoIncrement+" ,"+dc.AllowDBNull );
}} 原文连接:
http://www.c-sharpcorner.com/database/table_p.asp
解决方案 »
- 用C#语言做一个Windows下的应用程序,实现接收外系统传过来的数据(图像),以由下至上滚屏的方式显示(最先传来的数据以行为单位不断消失,最新的图像慢慢显示)
- c# wpf中 熟悉(Lambda表达式)的请进,谢谢
- C#怎么定义api的GetNextWindow?
- C# 时间计算的问题
- 求帮忙,软件测试
- dgv中为何不显示数据
- 一个有点古怪的问题,不懂,请高手指点迷津
- Custom assembly, not a trusted assembly
- 加载设计器时遇到一个或多个错误。这些错误在下面列出。一些错误可通过重新生成项目来修复,而另一些错误则需要更改代码
- C# 多条件查询
- 请高手赐教,,,在线等
- 如何将事件日志写到应用程序日志?安全日志?系统日志中?100分
/// <summary>
/// get the length of m_FieldName where m_FieldName datatype is text
/// </summary>
/// <param name="m_FieldName">Field Name</param>
/// <param name="m_TableName">Table Name</param>
/// <param name="m_PubConn">Connection of database</param>
/// <returns></returns>
public int GetFieldLength(string m_FieldName,string m_TableName,OleDbConnection m_PubConn)
{
DataTable m_SchemaTable = m_PubConn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,new object[]{null,null,m_TableName,m_FieldName});
if(m_SchemaTable.Rows.Count>0)
{
int length = 0;
try
{
length = Convert.ToInt32(m_SchemaTable.Rows[0]["CHARACTER_MAXIMUM_LENGTH"]);
}
catch
{
length =0;
}
return length;
}
else
return 0;
}