GetSchema
来源:互联网 发布:phpexcel导出大量数据 编辑:程序博客网 时间:2024/06/01 08:19
using DoBon.Service;
using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
namespace DoBon.View
{
public partial class SchemaFrm : Form
{
private OleDBCn cn = new OleDBCn();
public SchemaFrm()
{
InitializeComponent();
}
private void BtnOk_Click(object sender, EventArgs e)
{
try
{
cn.oleDbConnection.Open();
DataTable schema = cn.oleDbConnection.GetSchema();
this.dgv.DataSource = schema;
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cn.oleDbConnection.Close();
}
}
private void BtnTable_Click(object sender, EventArgs e)
{
try
{
cn.oleDbConnection.Open();
DataTable schema = cn.oleDbConnection.GetSchema("Tables");
this.dgv.DataSource = schema;
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cn.oleDbConnection.Close();
}
}
private void BtnGo_Click(object sender, EventArgs e)
{
try
{
cn.oleDbConnection.Open();
DataTable schema = cn.oleDbConnection.GetSchema("Tables", new string[] { null, null, "Oder" });
this.dgv.DataSource = schema;
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cn.oleDbConnection.Close();
}
}
}
}
using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
namespace DoBon.View
{
public partial class SchemaFrm : Form
{
private OleDBCn cn = new OleDBCn();
public SchemaFrm()
{
InitializeComponent();
}
private void BtnOk_Click(object sender, EventArgs e)
{
try
{
cn.oleDbConnection.Open();
DataTable schema = cn.oleDbConnection.GetSchema();
this.dgv.DataSource = schema;
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cn.oleDbConnection.Close();
}
}
private void BtnTable_Click(object sender, EventArgs e)
{
try
{
cn.oleDbConnection.Open();
DataTable schema = cn.oleDbConnection.GetSchema("Tables");
this.dgv.DataSource = schema;
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cn.oleDbConnection.Close();
}
}
private void BtnGo_Click(object sender, EventArgs e)
{
try
{
cn.oleDbConnection.Open();
DataTable schema = cn.oleDbConnection.GetSchema("Tables", new string[] { null, null, "Oder" });
this.dgv.DataSource = schema;
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
cn.oleDbConnection.Close();
}
}
}
}
阅读全文
0 0
- GetSchema
- 使用 GetSchema 方法
- GetSchema 参数解析
- 获取数据库模式信息 GetSchema
- 获取数据库架构信息,SqlConnection.GetSchema()
- request.getSchema()+"://"+request.getServerName()+":"+request.getServerPort+path+"/"
- 使用GetSchema()方法判断数据库中表的存在
- 关于jsp中request.getContextPath()、request.getSchema()、request.getCookies()的意思
- request.getSchema(),request.getServerName(),request.getServerPort(),request.getContextPath()的含义及使用
- 深度好文《武侠小说写作指南》 作者为起点副总编ZENK(上)
- DOM节点层次图
- jdk-CyclicBarrier(一)
- 23种设计模式全解析--设计模式看这一篇就够了
- Android增量更新
- GetSchema
- 深度好文《武侠小说写作指南》(下)
- ArrayList取值
- 作业1:提交ORACLE连接配置的实验报告
- 欢迎使用CSDN-markdown编辑器
- 希尔排序相关
- tomcat的优化(内存,缓存,线程数(并发),IO,)
- js小知识
- day02