我想实现datagridview动态绑定数据库中的表格。其中EDUBJ_USERS和EDUBJ_INDEX为两个表格。可是实现不了。请帮我改下 public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public DataSet getDs(string strCon)
{
OracleDataAdapter oledbda;
string Connstring = "Data Source=oracle_192.168.3.234;Persist Security Info=True;User ID=edubj;Password=edubj; Unicode=True";
OracleConnection Conn = new OracleConnection(Connstring);
oledbda = new OracleDataAdapter(strCon, Conn);
DataSet ds = new DataSet();
oledbda.Fill(ds);
return ds;
}
private void Form1_Load(object sender, EventArgs e)
{
} private void button1_Click(object sender, EventArgs e)
{
string DtName;
if (comboBox1.Text == "用户数据")
DtName = " EDUBJ_USERS";
else
DtName = "EDUBJ_INDEX";
string Connstring = "Data Source=oracle_192.168.3.234;Persist Security Info=True;User ID=edubj;Password=edubj; Unicode=True";
OracleConnection Conn = new OracleConnection(Connstring);
Conn.Open();
string sql;
sql = String.Format("SELECT * FROM {0}", DtName);
OracleDataAdapter dtAdapter = new OracleDataAdapter(sql, Conn);
OracleCommandBuilder commandbuilder = new OracleCommandBuilder(dtAdapter);
DataSet ds = getDs(sql);
BindingSource bindingsource = new BindingSource();
bindingsource.DataSource = ds.Tables[DtName];
dataGridView1.DataSource = bindingsource;
}
}
{
public Form1()
{
InitializeComponent();
}
public DataSet getDs(string strCon)
{
OracleDataAdapter oledbda;
string Connstring = "Data Source=oracle_192.168.3.234;Persist Security Info=True;User ID=edubj;Password=edubj; Unicode=True";
OracleConnection Conn = new OracleConnection(Connstring);
oledbda = new OracleDataAdapter(strCon, Conn);
DataSet ds = new DataSet();
oledbda.Fill(ds);
return ds;
}
private void Form1_Load(object sender, EventArgs e)
{
} private void button1_Click(object sender, EventArgs e)
{
string DtName;
if (comboBox1.Text == "用户数据")
DtName = " EDUBJ_USERS";
else
DtName = "EDUBJ_INDEX";
string Connstring = "Data Source=oracle_192.168.3.234;Persist Security Info=True;User ID=edubj;Password=edubj; Unicode=True";
OracleConnection Conn = new OracleConnection(Connstring);
Conn.Open();
string sql;
sql = String.Format("SELECT * FROM {0}", DtName);
OracleDataAdapter dtAdapter = new OracleDataAdapter(sql, Conn);
OracleCommandBuilder commandbuilder = new OracleCommandBuilder(dtAdapter);
DataSet ds = getDs(sql);
BindingSource bindingsource = new BindingSource();
bindingsource.DataSource = ds.Tables[DtName];
dataGridView1.DataSource = bindingsource;
}
}
解决方案 »
- c# 电子地图
- 我想请教一个问题 就是关于在WinForm C#里面的一个DataTable的过滤问题
- DataTable和DataGridView绑定,为什么DataTable行的序号改变了,DataGridView没有同时改变?
- 请教同行帮忙,Net中使用Oracle遇到的一个问题(急)
- 很难的SQL,谢谢帮忙!
- 请教在web应用中(.aspx)datagrid嵌套datagrid的问题
- 怎么实现十字型线的绘制?
- DATADRID为什么不显示?
- 小问题不过我一直不会,请帮忙!
- 急急!!!在.net中怎么取得控件的句柄啊,控件的的属性Handle取的是控件所在窗口的句柄
- 问一个比较奇怪的问题,关于.NET 2.0的程序到.NET 3.0占用资源大
- 【求助】通过USB口接收数据
string Connstring = "Data Source=oracle_192.168.3.234;Persist Security Info=True;User ID=edubj;Password=edubj; Unicode=True";
OracleConnection Conn = new OracleConnection(Connstring);
Conn.Open();
string sql;
sql = String.Format("SELECT * FROM {0}", DtName);
OracleDataAdapter dtAdapter = new OracleDataAdapter(sql, Conn);
OracleCommandBuilder commandbuilder = new OracleCommandBuilder(dtAdapter);
后面的:
bindingsource.DataSource = ds.Tables[DtName];
由于你取数据时没有给tablename命名,所以是取不到数据的。
按你这样写都绑定ds.Tables[0]就行了
这样写有错误,我是想动态的绑定表格,那ds.tabels[]里面的表名应该怎么写,才能使动态绑定啊?