请问各位怎样将下列代码写成一个通用的方法?
private void dgvPxxx_RowEnter(object sender, DataGridViewCellEventArgs e)
{
ConnectionStringSettings pxxx_pubDGV=ConfigurationManager.ConnectionStrings["conn"];
SqlConnection pxxx_conDGV = new SqlConnection(pxxx_pubDGV.ConnectionString);
pxxx_conDGV.Open();
SqlCommand pxxx_cmdDGV = new SqlCommand();
pxxx_cmdDGV.Connection = pxxx_conDGV;
if(dgvPxxx.SelectedRows.Count>0)
{
int pxxx_colRYID = Convert.ToInt32(dgvPxxx.SelectedRows[0].Cells["pxxxColRYID"].FormattedValue);
int pxxx_colJLID = Convert.ToInt32(dgvPxxx.SelectedRows[0].Cells["pxxxColJLID"].FormattedValue);
pxxx_cmdDGV.CommandText = "select * from T_A11_pxxx where ry_id="+pxxx_colRYID+" and ID="+pxxx_colJLID+"";
SqlDataReader pxxx_dr = pxxx_cmdDGV.ExecuteReader();
if(pxxx_dr.Read())
{
tbpxxx_RYID.Text = pxxx_dr["ry_id"].ToString();
tbpxxx_JLID.Text = pxxx_dr["ID"].ToString(); mtbpxxx_qsrq.Text = pxxx_dr["pxqsrq"].ToString();
mtbpxxx_jsrq.Text = pxxx_dr["pxjsrq"].ToString();
tbpxxx_pxbmc.Text = pxxx_dr["pxbmc"].ToString();
cbbpxxx_pxblb.Text = pxxx_dr["pxblb"].ToString();
tbpxxx_zbdw.Text = pxxx_dr["zbdw"].ToString();
tbpxxx_gb.Text = pxxx_dr["gb"].ToString();
}
pxxx_dr.Close();
}
pxxx_conDGV.Close();
}
private void dgvPxxx_RowEnter(object sender, DataGridViewCellEventArgs e)
{
ConnectionStringSettings pxxx_pubDGV=ConfigurationManager.ConnectionStrings["conn"];
SqlConnection pxxx_conDGV = new SqlConnection(pxxx_pubDGV.ConnectionString);
pxxx_conDGV.Open();
SqlCommand pxxx_cmdDGV = new SqlCommand();
pxxx_cmdDGV.Connection = pxxx_conDGV;
if(dgvPxxx.SelectedRows.Count>0)
{
int pxxx_colRYID = Convert.ToInt32(dgvPxxx.SelectedRows[0].Cells["pxxxColRYID"].FormattedValue);
int pxxx_colJLID = Convert.ToInt32(dgvPxxx.SelectedRows[0].Cells["pxxxColJLID"].FormattedValue);
pxxx_cmdDGV.CommandText = "select * from T_A11_pxxx where ry_id="+pxxx_colRYID+" and ID="+pxxx_colJLID+"";
SqlDataReader pxxx_dr = pxxx_cmdDGV.ExecuteReader();
if(pxxx_dr.Read())
{
tbpxxx_RYID.Text = pxxx_dr["ry_id"].ToString();
tbpxxx_JLID.Text = pxxx_dr["ID"].ToString(); mtbpxxx_qsrq.Text = pxxx_dr["pxqsrq"].ToString();
mtbpxxx_jsrq.Text = pxxx_dr["pxjsrq"].ToString();
tbpxxx_pxbmc.Text = pxxx_dr["pxbmc"].ToString();
cbbpxxx_pxblb.Text = pxxx_dr["pxblb"].ToString();
tbpxxx_zbdw.Text = pxxx_dr["zbdw"].ToString();
tbpxxx_gb.Text = pxxx_dr["gb"].ToString();
}
pxxx_dr.Close();
}
pxxx_conDGV.Close();
}
解决方案 »
- c#下载资料,下载不下来,急急急!
- 在C#(winform)里面调用存储过程
- 请问用IDataAdapter来构造适配器,怎样定义ds中的表表名?
- dataGridView中如何删除行,非绑定
- 请问如何读取xml文件并按照xml文件的格式完整输出/?/?
- 请问如何动态的在WinForm里面添加一个Button?
- Microsoft SUN IBM Oracle Borland 五公司同时开发一种新型语言:MSIOB
- AutoScrollPosition的问题,高手们快来帮忙啊!!!!!!!!!!!!!!!!!!!!!
- 怎么获取mp3播放的时间
- 向论坛内的各位兄弟姐妹们求助:操作两个数据库的问题!!!
- 请问这是什么加密方式?
- C# class library的问题
因为你的里面还有 tbpxxx_RYID.Text = pxxx_dr["ry_id"].ToString();
tbpxxx_JLID.Text = pxxx_dr["ID"].ToString(); mtbpxxx_qsrq.Text = pxxx_dr["pxqsrq"].ToString();
mtbpxxx_jsrq.Text = pxxx_dr["pxjsrq"].ToString(); 等控件。你要学学 SqlHelper.cs 这对你帮助会很大的。这是在下的个人建议。
就是数据操作层?
sqlhelper.cs