读取Access数据库中的数据
来源:互联网 发布:培训java费用 编辑:程序博客网 时间:2024/06/05 18:01
public void InitGrid()
{
string connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Exam.mdb";
OleDbConnection conn = new OleDbConnection(connectstring);
string sqlQuery="select * from tb_Exam";
OleDbDataAdapter a = new OleDbDataAdapter(sqlQuery, conn);
//OleDbCommand com = new OleDbCommand(sqlQuery, conn);
DataSet ds = new DataSet();
a.Fill(ds,"yo");
this.GridView1.DataSource = ds.Tables["yo"];
this.GridView1.DataBind();
}
{
string connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Exam.mdb";
OleDbConnection conn = new OleDbConnection(connectstring);
string sqlQuery="select * from tb_Exam";
OleDbDataAdapter a = new OleDbDataAdapter(sqlQuery, conn);
//OleDbCommand com = new OleDbCommand(sqlQuery, conn);
DataSet ds = new DataSet();
a.Fill(ds,"yo");
this.GridView1.DataSource = ds.Tables["yo"];
this.GridView1.DataBind();
}
public void InitGridEx(string b)
{
string connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Exam.mdb";
OleDbConnection conn = new OleDbConnection(connectstring);
conn.Open();
string sqlQuery = "select * from tb_Exam where ID=" + b;
//OleDbDataAdapter a = new OleDbDataAdapter(sqlQuery, conn);
OleDbCommand com = new OleDbCommand(sqlQuery, conn);
//DataSet ds = new DataSet();
//a.Fill(ds, "yo");
OleDbDataReader da = com.ExecuteReader();
//this.GridView1.DataSource = ds.Tables["yo"];
//this.GridView1.DataBind();
while(da.Read())
{
this.TextBox2.Text=da["ID"].ToString();
this.TextBox3.Text = da["ExamContent"].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string a = this.TextBox1.Text;
InitGridEx(a);
}
{
string connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Exam.mdb";
OleDbConnection conn = new OleDbConnection(connectstring);
conn.Open();
string sqlQuery = "select * from tb_Exam where ID=" + b;
//OleDbDataAdapter a = new OleDbDataAdapter(sqlQuery, conn);
OleDbCommand com = new OleDbCommand(sqlQuery, conn);
//DataSet ds = new DataSet();
//a.Fill(ds, "yo");
OleDbDataReader da = com.ExecuteReader();
//this.GridView1.DataSource = ds.Tables["yo"];
//this.GridView1.DataBind();
while(da.Read())
{
this.TextBox2.Text=da["ID"].ToString();
this.TextBox3.Text = da["ExamContent"].ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string a = this.TextBox1.Text;
InitGridEx(a);
}
- 读取Access数据库中的数据
- 读取word文档中的表格数据到access数据库
- java读取access数据库数据
- access数据库读取数据代码
- 读取数据库数据返回OleDbDataReader函数(Access)
- 关于access数据库读取数据问题
- Matlab读取Access数据库的数据01
- MATLAB读取数据库中的数据
- Javascript读取ACCESS数据库
- qt4:读取 access 数据库
- qt4:读取 access 数据库
- php读取Access数据库
- java 读取 access数据库
- asp读取access数据库
- Python读取access数据库
- ___71__OleDbDataReader读取Access数据库
- ASP逐条读取ACCESS数据库里面的数据
- GridView读取数据XLS ACCESS MDB 并写入到数据库
- 漂亮的conky配置
- 数组的总结
- poj3321---Apple Tree
- StringBuffer类的总结
- Random类的总结
- 读取Access数据库中的数据
- 用.htaccess实现二级域名功能
- 自定义泛型总结
- java冒泡排序算法
- vc6.0中用GDIPlus实现加载动态gif图片(非MFC实现)
- silverlight 自定义控件基础篇(仿淘宝评论星级控件)
- linux神奇的系统请求----系统救命草
- Hash表(C++实现)
- linux系统调用的基本原理和技巧