09178525592
سه شنبه 21 خرداد 1392, 22:58 عصر
سلام دوستان خسته نباشید.
می خواستم ببینید مشکل کد ویرایش زیر چیه ؟
کار نمیکنه؟
try
{
String DataDirectory = Environment.GetFolderPath(Environment.SpecialFolde r.MyDocuments) + @"\Pars Contacts2\DataBase.mdf";
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + DataDirectory + ";Integrated Security=True;User Instance=True";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.CommandText = "update contact set (name,lastname,tel,mobile,web,email,job,address1,a ddress2,note,image,ISfamily,BirthDay) values(@name,@lastname,@tel,@mob,@web,@email,@job, @ad1,@ad2,@note,@img,@isfamily,@birthday), WHERE id= '" + int.Parse(txtUserID.Text);
cmd.Parameters.AddWithValue("@name", txtname.Text);
cmd.Parameters.AddWithValue("@lastname", txtlastname.Text);
cmd.Parameters.AddWithValue("@tel", txttel.Text);
cmd.Parameters.AddWithValue("@mob", txtmob.Text);
cmd.Parameters.AddWithValue("@web", txtweb.Text);
cmd.Parameters.AddWithValue("@email", txte.Text);
cmd.Parameters.AddWithValue("@job", txtjob.Text);
cmd.Parameters.AddWithValue("@ad1", txtad1.Text);
cmd.Parameters.AddWithValue("@ad2", txtad2.Text);
cmd.Parameters.AddWithValue("@note", txtNote.Text);
cmd.Parameters.AddWithValue("@img", ConvertIMGtoByte(pictureBox3.Image));
cmd.Parameters.AddWithValue("@isfamily", ckhFamily.Checked.ToString());
if (chkforgetBirthday.Checked)
{
cmd.Parameters.AddWithValue("@birthday", "False");
}
else
{
cmd.Parameters.AddWithValue("@birthday", dateTimePicker1.Value.ToShortDateString());
}
cmd.ExecuteNonQuery();
con.Close();
this.Close();
MessageBox.Show("مخاطب با موفقیت ویرایش شد ", "New", MessageBoxButtons.OK, MessageBoxIcon.Information);
Application.Restart();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\nPlease try again", "error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.Close();
}
می خواستم ببینید مشکل کد ویرایش زیر چیه ؟
کار نمیکنه؟
try
{
String DataDirectory = Environment.GetFolderPath(Environment.SpecialFolde r.MyDocuments) + @"\Pars Contacts2\DataBase.mdf";
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + DataDirectory + ";Integrated Security=True;User Instance=True";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
cmd.CommandText = "update contact set (name,lastname,tel,mobile,web,email,job,address1,a ddress2,note,image,ISfamily,BirthDay) values(@name,@lastname,@tel,@mob,@web,@email,@job, @ad1,@ad2,@note,@img,@isfamily,@birthday), WHERE id= '" + int.Parse(txtUserID.Text);
cmd.Parameters.AddWithValue("@name", txtname.Text);
cmd.Parameters.AddWithValue("@lastname", txtlastname.Text);
cmd.Parameters.AddWithValue("@tel", txttel.Text);
cmd.Parameters.AddWithValue("@mob", txtmob.Text);
cmd.Parameters.AddWithValue("@web", txtweb.Text);
cmd.Parameters.AddWithValue("@email", txte.Text);
cmd.Parameters.AddWithValue("@job", txtjob.Text);
cmd.Parameters.AddWithValue("@ad1", txtad1.Text);
cmd.Parameters.AddWithValue("@ad2", txtad2.Text);
cmd.Parameters.AddWithValue("@note", txtNote.Text);
cmd.Parameters.AddWithValue("@img", ConvertIMGtoByte(pictureBox3.Image));
cmd.Parameters.AddWithValue("@isfamily", ckhFamily.Checked.ToString());
if (chkforgetBirthday.Checked)
{
cmd.Parameters.AddWithValue("@birthday", "False");
}
else
{
cmd.Parameters.AddWithValue("@birthday", dateTimePicker1.Value.ToShortDateString());
}
cmd.ExecuteNonQuery();
con.Close();
this.Close();
MessageBox.Show("مخاطب با موفقیت ویرایش شد ", "New", MessageBoxButtons.OK, MessageBoxIcon.Information);
Application.Restart();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\nPlease try again", "error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.Close();
}