110,534
社区成员
发帖
与我相关
我的任务
分享
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
string cmdStr = "insert into imageinfo (imagename,imagestore,waiguanbi,xzyz,pianxinlv) values (@imagename,@imagestore,@waiguanbi,@xzyz,@pianxinlv)";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(cmdStr, conn);
try
{
MemoryStream ms = new MemoryStream();
pbxselect.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
byte[] mydata = new byte[ms.Length];
ms.Position = 0;
ms.Read(mydata, 0, Convert.ToInt32(ms.Length));
ms.Close();
SqlParameter imagestore = new SqlParameter("@imagestore", mydata);
SqlParameter imagename = new SqlParameter("@imagename", tbxname.Text.ToString());
SqlParameter waiguanbi = new SqlParameter("@waiguanbi", tbxwgb.Text.ToString());
SqlParameter xzyz = new SqlParameter("@xzyz", tbxxzyz.Text.ToString());
SqlParameter pianxinlv = new SqlParameter("@pianxinlv", tbxpxl.Text.ToString());
if (tbxname.Text.ToString() == "" || tbxwgb.Text.ToString() == "" ||tbxxzyz.Text.ToString() == "" || tbxpxl.Text.ToString() == "")
{
MessageBox.Show("请输入图像名称并计算出形状特征后再存储!", this.Text, MessageBoxButtons.OK);
}
else
{
conn.Open();
cmd.Parameters.Add(imagestore);
cmd.Parameters.Add(imagename);
cmd.Parameters.Add(waiguanbi);
cmd.Parameters.Add(xzyz);
cmd.Parameters.Add(pianxinlv);
cmd.ExecuteNonQuery();
MessageBox.Show("图像和特征值上传成功!", this.Text, MessageBoxButtons.OK);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string cmdStr = null;
if (radioButton1.Checked == true)
{
querystr = "select * from imageinfo where waiguanbi = '" + tbxwgb.Text + "'";
}
if (radioButton2.Checked == true)
{
querystr = "select * from imageinfo where xzyz = '" + tbxxzyz.Text + "'";
}
if (radioButton3.Checked == true)
{
querystr = "select * from imageinfo where pianxinlv = '" + tbxpxl.Text + "'";
}
cmdStr = querystr;
SqlCommand cmd = new SqlCommand(cmdStr, conn);
SqlDataReader dr = null;
DataTable dt = new DataTable();
try
{
conn.Open();
dr = cmd.ExecuteReader();
dt.Load(dr);
if (dt.Rows.Count == 0)
{
MessageBox.Show("数据库中没有该内容的图像!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
tbxname.Text = dt.Rows[0]["imagename"].ToString();
tbxwgbend.Text = dt.Rows[0]["waiguanbi"].ToString();
tbxxzyzend.Text = dt.Rows[0]["xzyz"].ToString();
tbxpxlend.Text = dt.Rows[0]["pianxinlv"].ToString();
object obj = dt.Rows[0]["imagestore"];
byte[] mybyte = (byte[])obj;
MemoryStream ms = new MemoryStream(mybyte,false);
pbxend.Image = Image.FromStream(ms);
ms.Close();