نوشته شده توسط
Mahmoud.Afrad
در فارسی ممیز رو با / نمایش میدن. در نمایش فکر نمیکنم مشکلی باشه که / نمایش داده بشه. اما برای ثبت در دیتابیس و یا ویرایش باید کد را طوری بنویسید که مستقل از Culture و فرمت انتخابی در ویندوز ثبت انجام بشه.
کد ثبت و ویرایش رو بزارید.
کد برای ثبت :
con.ExecuteNonQuery("Insert into dbo.Formula values(N'" + TxtSerial.Text + "',N'" + dateTimePickerStart.Text + "'," + "N'" + dateTimePickerEnd.Text + "',N'" + TxtFormul.Text + "',N'" + ComboMahsul.Text + "'" +
",N'" + ComboKala.Text + "',N'" + ComboNoe.Text + "'" +
",N'" + TxtKhoshk.Text + "',N'" + TxtEnergyFa.Text + "'" +
",N'" + TxtCharbi.Text + "',N'" + TxtProtein.Text + "'" +
",N'" + TxtFibr.Text + "',N'" + TxtKhakestar.Text + "'" +
",N'" + TxtKalsium.Text + "',N'" + TxtPhosphor.Text + "'" +
",N'" + TxtPhosphorQ.Text + "',N'" + TxtDryMatter.Text + "'" +
",N'" + TxtEnergyME.Text + "',N'" + TxtEtherExtract.Text + "'" +
",N'" + TxtCrudeProtein.Text + "',N'" + TxtCrudeFiber.Text + "'" +
",N'" + TxtCalcium.Text + "',N'" + TxtTotalPh.Text + "'" +
",N'" + TxtAvaPhosphrous.Text + "',N'" + TxtSodium.Text + "'" +
",N'" + TxtPotassium.Text + "',N'" + TxtChloride.Text + "'" +
",N'" + TxtDCAB.Text + "',N'" + TxtCholine.Text + "'" +
",N'" + TxtLinoleicAcid.Text + "',N'" + TxtLysineTotal.Text + "'" +
",N'" + TxtMethionineTotal.Text + "',N'" + TxtMetCysTotal.Text + "'" +
",N'" + TxtThreonineTotal.Text + "',N'" + TxtTryptophanTotal.Text + "'" +
",N'" + TxtArgenineTotal.Text + "',N'" + TxtIsoleucineTotal.Text + "'" +
",N'" + TxtLeucineTotal.Text + "',N'" + TxtValineTotal.Text + "'" +
",N'" + TxtLysineSID.Text + "',N'" + TxtMethionineSID.Text + "'" +
",N'" + TxtMetCysSID.Text + "',N'" + TxtThreonineSID.Text + "'" +
",N'" + TxtTryptophanSID.Text + "',N'" + TxtArgenineSID.Text + "'" +
",N'" + TxtIsoleucineSID.Text + "',N'" + TxtLeucineSID.Text + "'" +
",N'" + TxtValineSID.Text + "',N'" + TxtAsh.Text + "'" +
",N'" + TxtStarch.Text + "',N'" + TxtSugar.Text + "'" +
",N'" + TxtNFE.Text + "',N'" + TxtTozihKhorak.Text + "'" +
")", 1);
کد برای ویرایش
//ویرایش دیتاگرید
if (RowId != "0")
{
if (
MessageBox.Show("آیا رکورد انتخاب شده ویرایش گردد؟", "ویراش", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
con.ExecuteNonQuery(
"update Formula set Seriall = N'" +
TxtSerial.Text + "', Tarikh_start = N'" +
dateTimePickerStart.Text + "' , Tarikh_End = N'" +
dateTimePickerEnd.Text + "' , Shomare_Furmula = N'" +
TxtFormul.Text + "', Name_Mahsul = N'" +
ComboMahsul.Text + "', Name_Kala = N'" +
ComboKala.Text + "', Noe = N'" +
ComboNoe.Text + "', Madde_khoshk = N'" +
TxtKhoshk.Text + "', Energy_Fa = N'" +
TxtEnergyFa.Text + "', Charbi = N'" +
TxtCharbi.Text + "', Protein = N'" +
TxtProtein.Text + "', Fibr = N'" +
TxtFibr.Text + "', Khakestar = N'" +
TxtKhakestar.Text + "', Kalsiom = N'" +
TxtKalsium.Text + "', Phosphor_Kol = N'" +
TxtPhosphor.Text + "', Phosphor_qabel = N'" +
TxtPhosphorQ.Text + "', Dry_Matter = N'" +
TxtDryMatter.Text + "', Energy_ME = N'" +
TxtEnergyME.Text + "', Ether_Extract = N'" +
TxtEtherExtract.Text + "', Crude_Protein = N'" +
TxtCrudeProtein.Text + "', Crude_Fiber = N'" +
TxtCrudeFiber.Text + "', Calcium = N'" +
TxtCalcium.Text + "', Total_Ph = N'" +
TxtTotalPh.Text + "', Ava_Phosphrous = N'" +
TxtAvaPhosphrous.Text + "', Sodium = N'" +
TxtSodium.Text + "', Potassium = N'" +
TxtPotassium.Text + "', Chloride = N'" +
TxtChloride.Text + "', DCAB = N'" +
TxtDCAB.Text + "', Choline = N'" +
TxtCholine.Text + "', Linoleic_Acid = N'" +
TxtLinoleicAcid.Text + "', Lysine_Total = N'" +
TxtLysineTotal.Text + "', Methionine_Total = N'" +
TxtMethionineTotal.Text + "', Met_Cys_Total = N'" +
TxtMetCysTotal.Text + "', Threonine_Total = N'" +
TxtThreonineTotal.Text + "', Tryptophan_Total = N'" +
TxtTryptophanTotal.Text + "', Argenine_Total = N'" +
TxtArgenineTotal.Text + "', Isoleucine_Total = N'" +
TxtIsoleucineTotal.Text + "', Leucine_Total = N'" +
TxtLeucineTotal.Text + "', Valine_Total = N'" +
TxtValineTotal.Text + "', Lysine_SID = N'" +
TxtLysineSID.Text + "', Methionine_SID = N'" +
TxtMethionineSID.Text + "', Met_Cys_SID = N'" +
TxtMetCysSID.Text + "', Threonine_SID = N'" +
TxtThreonineSID.Text + "', Tryptophan_SID = N'" +
TxtTryptophanSID.Text + "', Argenine_SID = N'" +
TxtArgenineSID.Text + "', Isoleucine_SID = N'" +
TxtIsoleucineSID.Text + "', Leucine_SID = N'" +
TxtLeucineSID.Text + "', Valine_SID = N'" +
TxtValineSID.Text + "', Ash = N'" +
TxtAsh.Text + "', Starch = N'" +
TxtStarch.Text + "', Sugar = N'" +
TxtSugar.Text + "', NFE = N'" +
TxtNFE.Text + "', Molahezat_Khurak = N'" +
TxtTozihKhorak.Text + "' where ID = '" + RowId + "'", 1);
البته این یکی از فرمها هستش 4تا فرم دیگه مثل این موجوده