c# 获取oracle 表及表内容

最新推荐文章于 2024-07-23 22:26:15 发布

vbloveshllm

最新推荐文章于 2024-07-23 22:26:15 发布

阅读量865

点赞数 26

文章标签： c# oracle windows

本文链接：https://blog.csdn.net/vbloveshllm/article/details/136448146

版权

该篇文章介绍了如何在C#中使用Oracle数据库，通过`GetTableNameList`和`GetTableContentList`方法获取表名列表和表内容列表，涉及实体类的创建和数据处理.

摘要由CSDN通过智能技术生成

1、

/// <summary>
/// 获取表名列
/// </summary>
/// <param name="owner"></param>
private void GetTableNameList(string owner)
{
TableNameGridList.Clear();
GetTableName(owner);
var list = (from dt in DBHelper.ReturnTableName.AsEnumerable()
select new TableVo()
{
Schema = dt["OWNER"].ToString(),
Name = dt["TABLE_NAME"].ToString(),
Type = dt["TABLE_TYPE"].ToString(),
Comments = dt["COMMENTS"].ToString()
}).ToList();
for (int i = 0; i < list.Count; i++)
{
TableVo tablevo = new TableVo()
{
Schema = list[i].Schema,
Comments = list[i].Comments,
Name = list[i].Name,
Type = list[i].Type
};
TableNameGridList.Add(tablevo);
}
}

2、/// <summary>
/// 获取表内容
/// </summary>
/// <param name="owner"></param>
/// <param name="name"></param>
private void GetTableContentList(string owner, string name)
{
TableContentGridList.Clear();
GetTableContent(owner, name);
var list = (from dt in ReturnTableContent.AsEnumerable()
select new TableVo()
{
Name = dt["COLUMN_NAME"].ToString(),
Type = dt["DATA_TYPE"].ToString(),
Comments = dt["COMMENTS"].ToString(),
Nullable = dt["NULLABLE"].ToString(),
DataLength = dt["DATA_LENGTH"].ToString()
}).ToList();
for (int i = 0; i < list.Count; i++)
{
TableNum tablenum = new TableNum ()
{
Name = list[i].Name,
Type = list[i].Type,
Comments = list[i].Comments,
Nullable = list[i].Nullable,
DataLength = list[i].DataLength
};
TablesList.Add(tablevo);
}
}