i want to update Customer Information insert work very good but when i use Edit function , i must upload image again or Error Messege
empty path name is not legal and
Compiler tell me that Error Here
byte[] img=null;
FileStream fs = new FileStream(imgLocation1, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
img = br.ReadBytes((int)fs.Length);
What I have tried:
i want to update Customer Information insert work very good but when i use Edit function , i must upload image again or Error Messege
empty path name is not legal and
Compiler tell me that Error Here
byte[] img=null;
FileStream fs = new FileStream(imgLocation1, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
img = br.ReadBytes((int)fs.Length);
My Edit Code Is :
function Image
public static byte[] ImageToByte(Image img)
{
ImageConverter converter = new ImageConverter();
return (byte[])converter.ConvertTo(img, typeof(byte[]));
}
private void btn_Edit_Click_1(object sender, EventArgs e)
{
function save Gender
if (radioButton_Male.Checked == true)
{
gender = "Male";
}
else
{
gender = "Female";
}
Edit Code
if (pictureBox_ForTRAINER.Image != null)
{
if (ID_TextBox.Text == "") return;
string sql = "UPDATE Customers SET Customer_Name=@t1,Phone=@t2,Kind=@t3,Customer_State=@t4,First_Date=@t5,End_Date=@t6," +
"Cost=@t7,Paid=@t8,Remain=@t9,Training_Notes=@t10,Gender=@t11,img=@t12,Date_Paid=@t13 WHERE Customer_Id='" + txt_userId.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(sql, DXL.conn);
cmd.Parameters.AddWithValue("@t1", this.Name_TextBox.Text);
cmd.Parameters.AddWithValue("@t2", phone_TextBox.Text);
cmd.Parameters.AddWithValue("@t3", kind_TextBox.Text);
cmd.Parameters.AddWithValue("@t4", comboBox_ShowState.Text);
cmd.Parameters.AddWithValue("@t5", Convert.ToDateTime(FirstDate_TextBox.Text));
cmd.Parameters.AddWithValue("@t6", Convert.ToDateTime(End_Date.Text));
cmd.Parameters.AddWithValue("@t7", Cost_TextBox.Text);
cmd.Parameters.AddWithValue("@t8", Paid_TextBox.Text);
cmd.Parameters.AddWithValue("@t9", remain_TextBox.Text);
cmd.Parameters.AddWithValue("@t10", NotesAboutTRAINING_TextBox.Text);
cmd.Parameters.AddWithValue("@t11", gender);
cmd.Parameters.Add(new SqlParameter("@t12", ImageToByte(pictureBox_ForTRAINER.Image)));
cmd.Parameters.AddWithValue("@t13", Convert.ToDateTime(Date_Paid.Text));
DXL.conn.Open();
int x = cmd.ExecuteNonQuery();
MessageBox.Show("DONE \r\n" + x.ToString());
DXL.conn.Close();
this.Close();
}
if(pictureBox_ForTRAINER.Image==null)
{
string imgLocation1 = "";
Debugger tell me that Error Here
byte[] img=null;
FileStream fs = new FileStream(imgLocation1, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
img = br.ReadBytes((int)fs.Length);
if (ID_TextBox.Text == "") return;
string sql = "UPDATE Customers SET Customer_Name=@t1,Phone=@t2,Kind=@t3,Customer_State=@t4,First_Date=@t5," +
"End_Date=@t6,Cost=@t7,Paid=@t8,Remain=@t9,Training_Notes=@t10,Gender=@t11,img=@t12,Date_Paid=@t13 WHERE Customer_Id='" +
txt_userId.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(sql, DXL.conn);
cmd.Parameters.AddWithValue("@t1", this.Name_TextBox.Text);
cmd.Parameters.AddWithValue("@t2", phone_TextBox.Text);
cmd.Parameters.AddWithValue("@t3", kind_TextBox.Text);
cmd.Parameters.AddWithValue("@t4", comboBox_ShowState.Text);
cmd.Parameters.AddWithValue("@t5", Convert.ToDateTime(FirstDate_TextBox.Text));
cmd.Parameters.AddWithValue("@t6", Convert.ToDateTime(End_Date.Text));
cmd.Parameters.AddWithValue("@t7", Cost_TextBox.Text);
cmd.Parameters.AddWithValue("@t8", Paid_TextBox.Text);
cmd.Parameters.AddWithValue("@t9", remain_TextBox.Text);
cmd.Parameters.AddWithValue("@t10", NotesAboutTRAINING_TextBox.Text);
cmd.Parameters.AddWithValue("@t11", gender);
cmd.Parameters.Add(new SqlParameter("@t12", img));
cmd.Parameters.AddWithValue("@t13", Convert.ToDateTime(Date_Paid.Text));
DXL.conn.Open();
int x = cmd.ExecuteNonQuery();
MessageBox.Show("DONE \r\n" + x.ToString());
DXL.conn.Close();
this.Close();
}
}
my DataGrid Code
public void GetIDUpdate()
{
string strquery = "SELECT Customer_Name, Phone, Kind , Customer_State, First_Date , End_Date, Cost,Paid, Remain, " +
"Training_Notes, Gender, img, Date_Paid FROM Customers WHERE Customer_Id=N'" + txt_userId.Text + "'";
SqlCommand cmd = new SqlCommand(strquery, DXL.conn);
DXL.conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
Name_TextBox.Text = dr["Customer_Name"].ToString();
phone_TextBox.Text = dr["Phone"].ToString();
kind_TextBox.Text = dr["Kind"].ToString();
comboBox_ShowState.Text = dr["Customer_State"].ToString();
FirstDate_TextBox.Text = dr["First_Date"].ToString();
End_Date.Text = dr["End_Date"].ToString();
Cost_TextBox.Text = dr["Cost"].ToString();
Paid_TextBox.Text = dr["Paid"].ToString();
remain_TextBox.Text = dr["Remain"].ToString();
NotesAboutTRAINING_TextBox.Text = dr["Training_Notes"].ToString();
gender = dr["Gender"].ToString();
Date_Paid.Text = dr["Date_Paid"].ToString();
if (dr["img"] != System.DBNull.Value)
{
byte[] ximg = (byte[])dr["img"];
MemoryStream mms = new MemoryStream(ximg);
pictureBox_ForTRAINER.Image = Image.FromStream(mms);
}
else
{
pictureBox_ForTRAINER.Image = null;
}
}
else if (txt_userId.Text == "")
{
pictureBox_ForTRAINER.Image = null;
}
}
DXL.conn.Close();
}
i want to update Customer Information insert work very good but when i use Edit function , i must upload image again or Error Messege
empty path name is not legal and
Compiler tell me that Error Here
byte[] img=null;
FileStream fs = new FileStream(imgLocation1, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
img = br.ReadBytes((int)fs.Length);