C#读取access表,并把数据显示在gridcontrol中
//读取标准列表
private void setModelList()
{
OleDbConnection Connection = null;
string tableName = "";
try
{
string strMdb = this.textBox5.Text;//mdb路径
Connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strMdb + "");
Connection.Open();
DataTable schemaTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow dr in schemaTable.Rows)
{
//表名
tableName = dr["TABLE_NAME"].ToString();
//字段名
//DataTable columnTable = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[]
相关文档:
//向数据库中写入
private void button1_Click(object sender, EventArgs e)
{
oracleConnection1.Open();
& ......
初学c#加Oracle编程,看了许多网上教程,都介绍的是ado连接方式,而且采用的都是在后台输入连接字符串的方式。于是萌生了写一个dll文件来代替这个连接字符串,以后每次连接数据库事只要调用这个dll文件就行的想法。闲言少叙,将代码写出, ......
1. 打开新的窗口并传送参数:
传送参数:
response.write("<script>window.open(’*.aspx?id="+this.DropDownList1.SelectIndex+"&id1="+...+"’)</script>")
接收参数:
string a = Request.QueryString("id");
string b = Request.QueryS ......
SQLite 作为一个轻量级嵌入式数据库,还是非常好用的。雨痕极力推荐~~~~~~
今天有个朋友测试 SQLite,然后得出的结论是:SQLite 效率太低,批量插入1000条记录,居然耗时 2 分钟!
下面是他发给我的测试代码。我晕~~~~~~
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
......
HTML clipboard
Revealing the revolutionary fingerprint access clocking in/out system for
businesses. No more cards, no more paperwork, no more hassle! This digital
fingerprint access terminal and data logger registers finger prints for time
management plus also works as an authorized pe ......