关于读取DataGridView控件上单元格的值 然后在数据库里找到对应的emappic 把这个图片用PictureBox显示
代码如下
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms; namespace emap
{
public partial class emap : Form
{
public emap()
{
InitializeComponent();
} private void emap_Load(object sender, EventArgs e)
{
//定义连接字符串
SqlConnection conn = new SqlConnection("server=.\\SQLEXPRESS;database=evip;uid=sa;pwd=evip"); //DataGridView控件dgv_AreaList绑定数据
string SQLcmdtext1 = "select emapname from emap where parentid=0";
SqlDataAdapter da = new SqlDataAdapter(SQLcmdtext1, conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.dgv_AreaList.DataSource = ds.Tables[0];
string _emapname = this.dgv_AreaList.CurrentCell.Value.ToString();
string SQLcmdtext2 = string.Format("select emappic from emap where emapname={0}", _emapname);
using (conn)
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(SQLcmdtext2, conn))
{
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.NextResult())
{
for (int i = 0; i < dr.FieldCount; i++)
{
string sUrl = dr.GetValue(i).ToString();
pb_MainPic.Image = System.Drawing.Image.FromFile(sUrl); //imageList.Images.Add(Image.FromFile(sUrl));
}
}
} }
}
}
//pb_MainPic.Image = System.Drawing.Image.FromFile(@"C:\Program Files\EVIP Server\maps\104.jpg");
}
}
} 提示 列名‘Area1’无效 Area1正是DataGridView的的单元格值 这是怎么回事 代码应该怎么改 请达人赐教
代码如下
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms; namespace emap
{
public partial class emap : Form
{
public emap()
{
InitializeComponent();
} private void emap_Load(object sender, EventArgs e)
{
//定义连接字符串
SqlConnection conn = new SqlConnection("server=.\\SQLEXPRESS;database=evip;uid=sa;pwd=evip"); //DataGridView控件dgv_AreaList绑定数据
string SQLcmdtext1 = "select emapname from emap where parentid=0";
SqlDataAdapter da = new SqlDataAdapter(SQLcmdtext1, conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.dgv_AreaList.DataSource = ds.Tables[0];
string _emapname = this.dgv_AreaList.CurrentCell.Value.ToString();
string SQLcmdtext2 = string.Format("select emappic from emap where emapname={0}", _emapname);
using (conn)
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(SQLcmdtext2, conn))
{
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.NextResult())
{
for (int i = 0; i < dr.FieldCount; i++)
{
string sUrl = dr.GetValue(i).ToString();
pb_MainPic.Image = System.Drawing.Image.FromFile(sUrl); //imageList.Images.Add(Image.FromFile(sUrl));
}
}
} }
}
}
//pb_MainPic.Image = System.Drawing.Image.FromFile(@"C:\Program Files\EVIP Server\maps\104.jpg");
}
}
} 提示 列名‘Area1’无效 Area1正是DataGridView的的单元格值 这是怎么回事 代码应该怎么改 请达人赐教
string SQLcmdtext2 = string.Format("select emappic from emap where emapname='{0}'", _emapname);