本文整理汇总了C#中DbHelper.ExecuteDataTable方法的典型用法代码示例。如果您正苦于以下问题：C# DbHelper.ExecuteDataTable方法的具体用法？C# DbHelper.ExecuteDataTable怎么用？C# DbHelper.ExecuteDataTable使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbHelper的用法示例。
在下文中一共展示了DbHelper.ExecuteDataTable方法的10个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetTriggerName
/// summary
/// �������ݿ������еĴ�����
/// trigger_body������
/// /summary
/// returns
/// ���ص�DataTable��
/// TriggerName ����������
/// TableName ���������ڱ���
/// /returns
public override DataTable GetTriggerName()
{
string selectCommandText = @"
select trigger_name as TriggerName,table_name as TableName from user_triggers
";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例2: GetViewNames
/// summary
/// ������ݿ������е��û���ͼ
/// /summary
/// returns��DataTable������ͼ������/returns
public override DataTable GetViewNames()
{
string selectCommandText = "SELECT VIEW_NAME as Name FROM USER_VIEWS ORDER BY VIEW_NAME";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例3: GetTableComments
/// summary
/// ��������б��ע��
/// /summary
/// returns��DataTable���ر��ע��/returns
public override DataTable GetTableComments()
{
string selectCommandText = @"
select table_name,comments
from user_tab_comments
";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例4: GetTableNames
/// summary
/// ������ݿ������еı�
/// /summary
/// returns��DataTable���ر������/returns
public override DataTable GetTableNames()
{
string selectCommandText = "SELECT TABLE_NAME FROM USER_TABLES";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例5: GetProcedureNames
/// summary
/// ������ݿ������е��û��洢����
/// /summary
/// returns��DataTable���ش洢���̵�����/returns
public override DataTable GetProcedureNames()
{
string selectCommandText = "select object_name as Name from user_objects where object_type='PROCEDURE' order by object_name";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例6: GetProcedureText
/// summary
/// ���ָ���洢���̵�����
/// /summary
/// param name="procedureName"�洢������/param
/// returns/returns
public override string GetProcedureText(string procedureName)
{
string selectCommandText = string.Format(@"
select text from USER_SOURCE where type='PROCEDURE' and name=upper('{0}')",
procedureName);
DbHelper helper = new DbHelper();
DataTable table = helper.ExecuteDataTable(selectCommandText);
string ret = "create or replace ";
for(int i = 0; i < table.Rows.Count; i++)
{
ret += table.Rows[i][0].ToString()+ " ";
}
return ret;
}示例7: GetPKConstraint
/// summary
/// ������ݿ������е�����
/// /summary
/// returns
/// ����DataTable��������
/// PKTable ������
/// PKConstraint������
/// KeyCol1�������ֶ�
////returns
public override DataTable GetPKConstraint()
{
string selectCommandText = @"
select table_Name as PKTable,constraint_name as PKConstraint,'' as KeyCol1 from user_constraints where Constraint_type='P'
";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例8: GetFunctionNames
/// summary
/// ������ݿ������е��û�����
/// /summary
/// returns��DataTable���غ���������/returns
public override DataTable GetFunctionNames()
{
string selectCommandText = "select object_name as Name from user_objects where object_type='FUNCTION' order by object_name";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例9: GetFieldNames
/// summary
/// ���ָ�����е������ֶ�����
/// /summary
/// param name="TableName"ָ���ı���/param
/// returns��DataTable�����ֶε�����/returns
public override DataTable GetFieldNames(string tableName)
{
string selectCommandText = string.Format("SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = '{0}'", tableName);
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(selectCommandText);
}示例10: GetFieldComments
/// summary
/// ����������ֶε�ע��
/// /summary
/// returns��DataTable�����ֶε�ע��/returns
public override DataTable GetFieldComments(string tableName)
{
string selectCommandText = @"
select table_name,column_name,
nvl(comments ,column_name) as comments
from user_col_comments
where
table_name = '{0}'
";
DbHelper helper = new DbHelper();
return helper.ExecuteDataTable(string.Format(selectCommandText,tableName));
}