110,571
社区成员
发帖
与我相关
我的任务
分享
SqlConnection GridViewconn = new SqlConnection("server=.;database=db_csglxt;uid=sa;pwd=123456;");
GridViewconn.Open();
string GridViewstr = "select * from worker_info";
SqlCommand GridViewcmd = new SqlCommand(GridViewstr, GridViewconn);
SqlDataAdapter datapda = new SqlDataAdapter(GridViewcmd);
DataSet Ds = new DataSet();
Ds.Clear();
datapda.Fill(Ds, "worker_info");
dataGridView1.DataSource = Ds;
dataGridView1.DataMember = "worker_info";
dataGridView1.Columns[0].HeaderText = "ID";
dataGridView1.Columns[1].HeaderText = "姓名";
dataGridView1.Columns[2].HeaderText = "电话";
dataGridView1.Columns[3].HeaderText = "地址";
dataGridView1.Columns[4].HeaderText = "备份";
dataGridView1.Columns[4].Width = 150;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[0].DataPropertyName = "id";
private void dataGridView1_Click(object sender, EventArgs e)
{
txt_ID.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["id"].Value.ToString();
txt_name.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["name"].Value.ToString();
txt_addres.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["addres"].Value.ToString();
txt_tel.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["tel"].Value.ToString();
txt_PS.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["PS"].Value.ToString();
//pic_image.image=... 这该怎么写
}
private void dataGridView1_Click(object sender, EventArgs e)
{
txt_ID.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["id"].Value.ToString();
txt_name.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["name"].Value.ToString();
txt_addres.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["addres"].Value.ToString();
txt_tel.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["tel"].Value.ToString();
txt_PS.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["PS"].Value.ToString();
string fullName = "带路径的文件名";
Bitmap bm = new Bitmap(Icon.ExtractAssociatedIcon(fullName).ToBitmap());
pic_image.value = bm ;
}
//顶。。好贴不能沉!
--这是好贴,不能沉啊!