private void getdata()
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=tomzcj;Password=tomzcj;Data Source=uws ";
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.Connection = conn;
comm.CommandText = "select * from tomzcj.uws_job_offer";
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
da.SelectCommand = comm;
table = new DataTable();
da.Fill(table);
conn.Close();
} private void frmJobOffer_Load(object sender, EventArgs e)
{
getdata();
dataGridView1.DataSource = table;
this.dataGridView1.Columns["Dept_Id"].DataPropertyName = "DEPT_ID";
this.dataGridView1.Columns["Job_Title"].DataPropertyName = "JOB_TITLE";
this.dataGridView1.Columns["Job_Addr"].DataPropertyName = "JOB_ADDR";
this.dataGridView1.Columns["Job_Type"].DataPropertyName = "JOB_TYPE";
this.dataGridView1.Columns["Job_Offer"].DataPropertyName = "OFFER_NUMBER";
} 一个datagridview控件,绑定了“DEPT_ID”等5列数据。在这5列后面我又添加了一列headertext叫“操作”,name叫“btnEdit”,text叫“编辑”。我想点“编辑”的时候,把对应行的数据添加到另外一个编辑的界面进行操作。 遇到的问题是:不知道怎么调用这个btnEdit。试过btnEdit_Click方法,没用。求高手解答。
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=tomzcj;Password=tomzcj;Data Source=uws ";
conn.Open();
OleDbCommand comm = new OleDbCommand();
comm.Connection = conn;
comm.CommandText = "select * from tomzcj.uws_job_offer";
OleDbDataAdapter da = new OleDbDataAdapter();
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);
da.SelectCommand = comm;
table = new DataTable();
da.Fill(table);
conn.Close();
} private void frmJobOffer_Load(object sender, EventArgs e)
{
getdata();
dataGridView1.DataSource = table;
this.dataGridView1.Columns["Dept_Id"].DataPropertyName = "DEPT_ID";
this.dataGridView1.Columns["Job_Title"].DataPropertyName = "JOB_TITLE";
this.dataGridView1.Columns["Job_Addr"].DataPropertyName = "JOB_ADDR";
this.dataGridView1.Columns["Job_Type"].DataPropertyName = "JOB_TYPE";
this.dataGridView1.Columns["Job_Offer"].DataPropertyName = "OFFER_NUMBER";
} 一个datagridview控件,绑定了“DEPT_ID”等5列数据。在这5列后面我又添加了一列headertext叫“操作”,name叫“btnEdit”,text叫“编辑”。我想点“编辑”的时候,把对应行的数据添加到另外一个编辑的界面进行操作。 遇到的问题是:不知道怎么调用这个btnEdit。试过btnEdit_Click方法,没用。求高手解答。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货