این عکس فرم برنامه هست:
Capturea.JPG
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Drawing.Imaging;
using System.Data.OleDb;
using EMsgBox;
using System.Reflection;
using System.Diagnostics;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Setad Pishgiry.mdb");
OleDbDataAdapter da;
DataSet ds = new DataSet();
string s1;
private void Btn_Show_Click(object sender, EventArgs e)
{
s1 = "Select * From Tb_Pic Where ID='"+textBox1.Text+"'";
OleDbDataAdapter da = new OleDbDataAdapter(s1, con);
DataSet ds = new DataSet();
da.Fill(ds, "Tb_Pic");
if (textBox1.Text != "")
{
if (ds.Tables["Tb_Pic"].Rows.Count != 0)
{
OleDbDataAdapter da2 = new OleDbDataAdapter("Select * from Tb_Pic", con);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
byte[] b = (byte[])ds2.Tables[0].Rows[Convert.ToInt32(textBox1.Text)][0];
MemoryStream mem = new MemoryStream(b);
Image im = Image.FromStream(mem);
pictureBox1.Image = im;
}
}
else
{
Msg.Show("Please Enter The Pic Number", "Error", MsgIcon.Error, MsgButton.Ok);
}
}
private void Btn_Add_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
Image im = null;
dlg.Filter = "All Pictures |*.bmp;*.gif;*.jpg|Bitmaps|*.bmp";
if (dlg.ShowDialog() == DialogResult.OK)
{
pictureBox1.ImageLocation = dlg.FileName;
textBox3.Text = dlg.FileName;
}
}
private void Btn_Save_Click(object sender, EventArgs e)
{
Image im = null;
if (textBox3.Text != "")
{
s1 = "Select * From Tb_Pic Where ID='" + textBox2.Text + "'";
pictureBox1.ImageLocation = textBox3.Text;
im = new Bitmap(pictureBox1.ImageLocation);
MemoryStream mstr = new MemoryStream();
im.Save(mstr, im.RawFormat);
byte[] arrimage = mstr.GetBuffer();
OleDbDataAdapter da = new OleDbDataAdapter("Select * from Tb_Pic", con);
DataSet ds = new DataSet();
da.Fill(ds);
DataRow dr = ds.Tables[0].NewRow();
dr[0] = arrimage;
dr[1] = textBox2.Text;
ds.Tables[0].Rows.Add(dr);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
da.Update(ds.Tables[0]);
textBox3.Clear();
pictureBox1.BackgroundImage = null;
}
else
{
Msg.Show("Please Enter The Pic ", "Error", MsgIcon.Error, MsgButton.Ok);
}
}
}
}
بانک اطلاعاتی هم با اکسس هست.
اینم یه عکس از بانکمه:
ss.JPG
با تشکر
نوشته شده توسط alexmcse
قوانین ایجاد تاپیک در تالار
پاسخ با نقل قول