PDA

View Full Version : خطای string or binary data would be truncate در متد SubmitChange



Saeed-CANcel
پنج شنبه 23 آبان 1392, 23:40 عصر
من بعد از کلی کد نویسی تو بانکم به یه مشکل بر خوردم...
حالا هر کاری میکنم این ارور موقع نوشتن کد زیر میاد..
dbm.SubmitChanges();
اروری که میده اینه:

Saeed-CANcel
جمعه 24 آبان 1392, 00:21 صبح
privatevoid btn_ok_Click(object sender, EventArgs e)
{
myDataClasses_LinqDataContext dbm = newmyDataClasses_LinqDataContext();
myDataClasses_LinqDataContext dbp = newmyDataClasses_LinqDataContext();
if (rdo_main.Checked == true)
{
string sh_shenase = txtshenase.Text;
string name = txtname.Text;
string family = txtfamily.Text;
string sh_shenasname = txtshenasname.Text;
string sh_meli = txtshmeli.Text;
string tt_ruz = cmbroz.Text;
string tt_mah = cmbmah.Text;
string tt_sal = cmbsal.Text;
string loc_tavalod = cmbshahr.Text;
string name_pedar = txtfathername.Text;
string vaz_tahol = cmbvaztahol.Text;
string sh_pishtel = txtshPtamas.Text;
string sh_tel = txtshtamas.Text;
string mobile = txtshmobile.Text;
string email = txtemail.Text;
string address = txtaddres.Text;
string mov_nazari = txtmovazafi_nazari.Text;
string mov_amali = txtmovazafi_amali.Text;

MemoryStream ms = newMemoryStream();
pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);
byte[] arrpic = ms.GetBuffer();
tbl_pro_main tbl = newtbl_pro_main()
{
address = address,
birth_date = tt_ruz,
birth_loc = loc_tavalod,
birth_month = tt_mah,
birth_year = tt_sal,
bound_a = mov_amali,
bound_n = mov_nazari,
email = email,
family = family,
id = sh_shenasname,
m_status = vaz_tahol,
mobile_num = mobile,
n_cod = sh_meli,
name = name,
name_father = name_pedar,
phone_num = sh_tel,
phone_pnum = sh_pishtel,
pic = arrpic,
username = sh_shenase
};
dbm.tbl_pro_mains.InsertOnSubmit(tbl);
dbm.SubmitChanges();
MessageBox.Show("اطلاعاتباموفقیتثبتشد", "ثبت", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
elseif (rdo_public.Checked ==true)
{
string sh_shenase = txtshenase.Text;
string name = txtname.Text;
string family = txtfamily.Text;
string sh_shenasname = txtshenasname.Text;
string sh_meli = txtshmeli.Text;
string tt_ruz = cmbroz.Text;
string tt_mah = cmbmah.Text;
string tt_sal = cmbsal.Text;
string loc_tavalod = cmbshahr.Text;
string name_pedar = txtfathername.Text;
string vaz_tahol = cmbvaztahol.Text;
string sh_pishtel = txtshPtamas.Text;
string sh_tel = txtshtamas.Text;
string mobile = txtshmobile.Text;
string email = txtemail.Text;
string address = txtaddres.Text;
string mov_nazari = txtmovazafi_nazari.Text;
string mov_amali = txtmovazafi_amali.Text;

MemoryStream ms = newMemoryStream();
pictureBox1.Image.Save(ms, pictureBox1.Image.RawFormat);
byte[] arrpic = ms.GetBuffer();

tbl_pro_public tbl = newtbl_pro_public()
{
address = address,
birth_date = tt_ruz,
birth_loc = loc_tavalod,
birth_month = tt_mah,
birth_year = tt_sal,
bound_a = mov_amali,
bound_n = mov_nazari,
email = email,
family = family,
id = sh_shenasname,
m_status = vaz_tahol,
mobile_num = mobile,
n_cod = sh_meli,
name = name,
name_father = name_pedar,
phone_num = sh_tel,
phone_pnum = sh_pishtel,
pic = arrpic,
username = sh_shenase
};
dbp.tbl_pro_publics.InsertOnSubmit(tbl);
dbp.SubmitChanges();

MessageBox.Show("اطلاعاتباموفقیتثبتشد", "ثبت", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

}
else
MessageBox.Show("نوعاستادرامشخصکنید!", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Warning);

}

amkherad
جمعه 24 آبان 1392, 00:28 صبح
داخل بانک ميخوای ذخيره بکنی؟
اگه آره طول عکسی که ميخوای درج کنی رو چک کن بيشتر از طول فيلد نباشه.

Saeed-CANcel
جمعه 24 آبان 1392, 00:32 صبح
طول فیلد درسته....نوعش varbinery(max) گذاشتم
تو تصویرم معلومه...
تو کد آخری ایراد میگیره!!!

amkherad
جمعه 24 آبان 1392, 00:47 صبح
فيلدهای متنی رو هم چک کن ببين از اونا نيست؟