Comments by 143Deepak (Top 35 by date)

Not me sir well done u,thanks a lot.

Final code:-


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Text;
using System.Windows.Forms;

namespace Images
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button3_Click(object sender, EventArgs e)
{
using (SqlConnection connection2 = new SqlConnection("Data Source=.;Initial Catalog=users;Integrated Security=True"))
{
string q = "select photo from images where Id=@EMPID";
connection2.Open();
using (SqlCommand cmd = new SqlCommand(q, connection2))
{
cmd.Parameters.AddWithValue("@EMPID", textBox1.Text);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] byteBLOBData = (byte[])reader["Photo"];
image2.Image = ToImage(byteBLOBData);
}
}
}
}
}
///

/// Gets the Image from a byte array
///

/// <param name="data"></param>
/// <returns>
public static Image ToImage(byte[] Data)
{
if (Data == null)
{
return null;
}
Image img;
using (MemoryStream stream = new MemoryStream(Data))
{
using (Image temp = Image.FromStream(stream))
{
img = new Bitmap(temp);
}
}
return img;
}
string filename;
byte[] piture;
private void button1_Click(object sender, EventArgs e)
{

OpenFileDialog Open = new OpenFileDialog();
Open.Filter = "Image Files(*.jpeg; *.jpg; *.bmp)|*.jpeg; *.jpg; *.bmp";
if (Open.ShowDialog() == DialogResult.OK)
{
image2.Image = new Bitmap(Open.FileName);
piture = System.IO.File.ReadAllBytes(Open.FileName);
}


}

SqlConnection connection2 = new SqlConnection("Data Source=.;Initial Catalog=users;Integrated Security=True");
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text != null)
{
string Query = "Insert into images (Id,Photo)values(@id,@pic)";
connection2.Open();
SqlCommand cmd = new SqlCommand(Query, connection2);
cmd.Parameters.AddWithValue("@id",textBox1.Text);
cmd.Parameters.AddWithValue("@pic",piture);
int added = cmd.ExecuteNonQuery();
if (added > 0)
{

MessageBox.Show("Data have been saved.");

}
}

}




}
}

oh sorry sir i got my answer.

Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks......

lots of thanks sir every thing is working fine. code can save and display the image perfectly.

sir one thing i want to know at beigning my code was "string q = "select photo from employeeDetails where EmployeeId='" + textBox4.Text + "'";
connection2.Open();
SqlCommand cmd = new SqlCommand(q, connection2);
SqlDataReader reader = cmd.ExecuteReader();"

this code also work fine for inserting data then why u have changed to this " string q = "select photo from employeeDetails where EmployeeId=@EMPID";
connection2.Open();
using (SqlCommand cmd = new SqlCommand(q, connection2))
{
cmd.Parameters.AddWithValue("@EMPID", textBox4.Text);
using (SqlDataReader reader = cmd.ExecuteReader())
{"

Why we use parameter?

sir this is my new save code:-



string filename;
byte[] piture;
private void button1_Click(object sender, EventArgs e)
{

OpenFileDialog Open = new OpenFileDialog();
Open.Filter = "Image Files(*.jpeg; *.jpg; *.bmp)|*.jpeg; *.jpg; *.bmp";
if (Open.ShowDialog() == DialogResult.OK)
{
image2.Image = new Bitmap(Open.FileName);
piture = System.IO.File.ReadAllBytes(filename);
}


}

SqlConnection connection2 = new SqlConnection("Data Source=.;Initial Catalog=users;Integrated Security=True");
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text != null)
{
string Query = "Insert into images (Id,Photo)values(@id,@pic)";
connection2.Open();
SqlCommand cmd = new SqlCommand(Query, connection2);
cmd.Parameters.AddWithValue("@id",textBox1.Text);
cmd.Parameters.AddWithValue("@pic",piture);
int added = cmd.ExecuteNonQuery();
if (added > 0)
{

MessageBox.Show("Data have been saved.");

}
}

}



but there is an error is generated by this line "piture = System.IO.File.ReadAllBytes(filename);" when i am selecting the image from button1.
"Path cannot be null.
Parameter name: path"

and when i remove error giving line than new error is generated by this line int added = cmd.ExecuteNonQuery(); "The parameterized query '(@id nvarchar(1),@pic nvarchar(4000))Insert into images (Id,Phot' expects the parameter '@pic', which was not supplied."



one more thing sir,this is not my code i have just tried from some where else i think it will work after some edition done by u.

aha! sir u have done GNIIT and I am Doing GNIIT.

lots of thanks sir,really i am very very happy.

ok lets we start.

thanks sir.

no sir, my problem did not solved,and i dont want to make u angry. because i am new in IT field, i could not understand your coded language.

sorry sir i could not understand.And very-very thanks for your help.

the things which i could not understand that is "what is updated in that code."

once again thank u......

private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text != null)
{
string Query = "Insert into images (Id,Photo)select '" + textBox1.Text + "','" + image2.BackgroundImage + "'";
connection2.Open();
SqlCommand cmd = new SqlCommand(Query, connection2);
int added = cmd.ExecuteNonQuery();
if (added > 0)
{
MessageBox.Show("Data have been saved.");

}
}

}

sir this is my code for save button.

sir,when i save the image using the above (2 day ago comment)code it is again saving the image in hexa format it means that the code needs to change something.

Great sir,know please tell what to change i should make in my code.

sir in database it is saved like this:-

id photo
1 0x53797374656D2E44726177696E672E4269746D6170

sir, i have changed img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); to img.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp); but altough it is giving the same problem please help sir.

sir, what about is the problem in the code?

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.Data.SqlClient;

namespace Virtual_School_Manager
{
public partial class frmEmployee : Form
{
public frmEmployee()
{
InitializeComponent();
}

SqlConnection connection = new SqlConnection("Data Source=.;Initial Catalog=VSM;Integrated Security=True");

private void butSave_Click(object sender, EventArgs e)
{
try
{

string Query = "Insert into EmployeeDetails (EmployeeId,Photo)select '" + txtEmployeeId.Text + "','" + pictureBoxEmployee.Image + "'";
connection.Open();
SqlCommand cmd = new SqlCommand(Query, connection);
int added = cmd.ExecuteNonQuery();
if (added > 0)
{
this.Close();
DialogResult result = MessageBox.Show("Data have been saved. Do you want to save another data.", "Employee Detail", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
frmEmployee emp = new frmEmployee();
emp.Show();
}
else
this.Close();
}


}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
}

private void butCancel_Click(object sender, EventArgs e)
{
this.Close();
}

private void butBrowes_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog Open = new OpenFileDialog();
Open.Filter = "Image Files(*.jpeg; *.jpg; *.bmp)|*.jpeg; *.jpg; *.bmp";
if (Open.ShowDialog() == DialogResult.OK)
{
pictureBoxEmployee.Image = new Bitmap(Open.FileName);
}
}
catch (Exception)
{
throw new ApplicationException("Image loading error...");
}
}
public byte[] ImageToByteArray(Image img)
{
System.IO.MemoryStream ms = new System.IO.MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
return ms.ToArray();
}
}
}


sir this is the code for adding image i used.

sir but the code is still giving error "Parameter is not valid." in line using (Image temp = Image.FromStream(stream))

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Text;
using System.Windows.Forms;

namespace Images
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button3_Click(object sender, EventArgs e)
{
using (SqlConnection connection2 = new SqlConnection("Data Source=.;Initial Catalog=VSM;Integrated Security=True"))
{
string q = "select photo from employeeDetails where EmployeeId=@EMPID";
connection2.Open();
using (SqlCommand cmd = new SqlCommand(q, connection2))
{
cmd.Parameters.AddWithValue("@EMPID", textBox1.Text);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] byteBLOBData =(byte[])reader["Photo"];
image2.Image = ToImage(byteBLOBData);
}
}
}
}
}
///

/// Gets the Image from a byte array
///

/// <param name="data"></param>
/// <returns>
public static Image ToImage(byte[] Data)
{
if (Data == null)
{
return null;
}
Image img;
using (MemoryStream stream = new MemoryStream(Data))
{
using (Image temp = Image.FromStream(stream))
{
img = new Bitmap(temp);
}
}
return img;
}
}


}



This is the code is the debugged code.

sir , i did not understand.

sir,please forget the last 2 reply. the code get debugged and know the error is "Parameter is not valid." in line using (Image temp = Image.FromStream(stream))

sir,now using (Image temp = Images.FromStream(stream)) is giving error "Error 1 The type or namespace name 'FromStream' does not exist in the namespace 'Images' (are you missing an assembly reference?)"

sir,then i have to change the name of my namespace?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Text;
using System.Windows.Forms;

namespace Image
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button3_Click(object sender, EventArgs e)
{
using (SqlConnection connection2 = new SqlConnection("Data Source=.;Initial Catalog=VSM;Integrated Security=True"))
{
string q = "select photo from employeeDetails where EmployeeId=@EMPID";
connection2.Open();
using (SqlCommand cmd = new SqlCommand(q, connection2))
{
cmd.Parameters.AddWithValue("@EMPID", textBox1.Text);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] byteBLOBData =(byte[])reader["Photo"];
image2.Image = ToImage(byteBLOBData);
}
}
}
}
}
///

/// Gets the Image from a byte array
///

/// <param name="data"></param>
/// <returns>
public static Image ToImage(byte[] Data)
{
if (Data == null)
{
return null;
}
Image img;
using (MemoryStream stream = new MemoryStream(Data))
{
using (Image temp = Image.FromStream(stream))
{
img = new Bitmap(temp);
}
}
return img;
}
}


}




sir,every thing is totally right i have checked every thing about 50 times.

sir, i have changed that but the error is same "Error 1 'Image' is a 'namespace' but is used like a 'type'"

sir, i am also trying my best but i did not get any result.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

namespace imageact
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button3_Click(object sender, EventArgs e)
{
using (SqlConnection connection2 = new SqlConnection("Data Source=.;Initial Catalog=VSM;Integrated Security=True"))
{
string q = "select photo from employeeDetails where EmployeeId=@EMPID";
connection2.Open();
using (SqlCommand cmd = new SqlCommand(q, connection2))
{
cmd.Parameters.AddWithValue("@EMPID", textBox1.Text);
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
byte[] byteBLOBData =(byte[])reader["Photo"];
image2.Image = ToImage(byteBLOBData);
}
}
}
}
}
///

/// Gets the Image from a byte array
///

/// <param name="data"></param>
/// <returns>
public static Imageact ToImage(byte[] data)
{
if (data == null)
{
return null;
}
Image img;
using (MemoryStream stream = new MemoryStream(data))
{
using (Image temp = Imageact.FromStream(stream))
{
img = new Bitmap(temp);
}
}
return img;
}
}


}



sir i tried much but no drop down button is appearing

public static Image ToImage(byte[] data)

public static Image ToImage(byte[] data)

sir,i have already used using System.Drawing;.

Error 1 'Image' is a 'namespace' but is used like a 'type' E:\Software\Other\Project\Image\Image\Form1.cs 45 23 Image