how to insert / upload image in sql using c#| how to insert/update image in c# | c# insert image sql скачать в хорошем качестве

how to insert / upload image in sql using c#| how to insert/update image in c# | c# insert image sql

how to insert image in sql database using c# with source code : all the code in the description box; inventory project in c# ▶️   • How to Create Inventory management system ...   INVENTORY IN VB.NET ▶️   • How to Add, Save,update, Print ,Delete  an...   HOW TO CREATE SIGN UP IN VB.NET ▶️   • How to create a Registration /Sign Up form...   HOW TO MAKE LOGIN IN VISUAL STUDIO ▶️   • How to Create Login System in Visual Basic...   login system with code : ▶️   • How to Create Login System in Visual Basic...   using System.Data.SqlClient; using System.Data.OleDb; using System.IO; namespace Inventory_Mangement_System { public partial class Suppliers : Form { SqlConnection conn = new SqlConnection(); SqlCommand cmd = new SqlCommand(); string Imagename; public Suppliers() { InitializeComponent(); } private void Suppliers_Load(object sender, EventArgs e) { int x = new int(); int y = new int(); x = Screen.PrimaryScreen.WorkingArea.Width - 1050; y = Screen.PrimaryScreen.WorkingArea.Height - 590; this.Location = new Point(x, y); conn.ConnectionString = (@"Data Source=DESKTOP-Q2LL1QQ\MANIDB;Initial Catalog=Inventory_DB;Integrated Security=True"); if (conn.State!= ConnectionState.Open) { conn.Close(); } conn.Open(); } private void button5_Click(object sender, EventArgs e) { DialogResult close; close = MessageBox.Show("Confirm if you want to close", "Inventory Management System", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (close == DialogResult.Yes) { this.Close(); } } private void btnsave_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Please Enter Name","Inventory Management System"); }else if (textBox2.Text == "") { MessageBox.Show("Please Enter Phone", "Inventory Management System"); } else { byte[] Image = null; FileStream stream = new FileStream(Imagename, FileMode.Open,FileAccess.Read); BinaryReader bar = new BinaryReader(stream); Image = bar.ReadBytes((int)stream.Length); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Insert Into Suppliers Values ('"+ textBox9.Text+ "','" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + opeingtxt.Text + "','" + comboBox1.SelectedItem + "','" + dateTimePicker1.Text + "','" + textBox7.Text + "','" + credittxt.Text + "','" + textBox8.Text + "',@Image)"; cmd.Parameters.Add("Image",SqlDbType.Image).Value = Image; cmd.ExecuteNonQuery(); MessageBox.Show("Inseted Seccessfully"); } } private void button1_Click(object sender, EventArgs e) { try { FileDialog fldlg = new OpenFileDialog(); fldlg.InitialDirectory = @":C\"; fldlg.Filter = "Image File(.jpg;*.bmp;*.gif)|*.jpg;*.bmp;*.gif"; if (fldlg.ShowDialog() == DialogResult.OK) { Imagename = fldlg.FileName; Bitmap newing = new Bitmap(Imagename); pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; pictureBox1.Image = (Image)newing; } fldlg = null; } catch(System.ArgumentException ae) { Imagename = ""; MessageBox.Show(ae.Message.ToString()); } } } }