با سلام
من در این مورد باز به یک مشکلی خوردم
error.png
به (code_meli) گیر میده . من تو دیتا بیس تایپش رو nvchar 50 قرار دادم
نمی دونم این اررور برای چیه؟
کد فرم دیتا گرید
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Windows.Forms;
using Telerik.WinControls;
namespace Matab.bimar
{
public partial class show : Telerik.WinControls.UI.RadForm
{
public show()
{
InitializeComponent();
}
private void sho()
{
dg1.DataSource = dbm.db_bimar.ToList();
// dgw.DataSource = dbm.db_bimar.ToList();
dg1.DataSource = dbm.db_bimar.ToList();
dg1.Columns["code_meli"].HeaderText = "کد ملی";
dg1.Columns["name"].HeaderText = "نام";
dg1.Columns["family"].HeaderText = "نام خانوادگی";
dg1.Columns["bime_name"].HeaderText = "بیمه";
dg1.Columns["birth"].HeaderText = "تاریخ تولد";
dg1.Columns["s_p"].HeaderText = "شماره پرونده";
dg1.Columns["acceptdate"].HeaderText = "ویزیت";
dg1.Columns["phone"].HeaderText = "تلفن";
dg1.Columns["address"].HeaderText = "آدرس";
//-------------------------------------------------
dg1.Columns.Remove("s_bime");
dg1.Columns.Remove("sv_bimar");
dg1.Columns.Remove("email");
dg1.Columns.Remove("birth");
dg1.Columns.Remove("gender");
//************************************************** **********
}
dbmt dbm = new dbmt();
private void show_Load(object sender, EventArgs e)
{
sho();
cs.SelectedIndex=0;
}
private void حذفToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("آیا مایل به حذف می باشید ", "توجه", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string cm =dg1.CurrentRow.Cells[0].Value.ToString();
db_bimar tu = dbm.db_bimar.First(n =>n.code_meli==cm);
dbm.db_bimar.Remove(tu);
dbm.SaveChanges();
dg1.DataSource = dbm.db_bimar.ToList();
}
}
private void radGroupBox1_Click(object sender, EventArgs e)
{
}
private void radTextBox3_TextChanged(object sender, EventArgs e)
{
if (cs.Text == "شماره پرونده")
{
var search = dbm.db_bimar.Where(c => c.s_p.Contains(radTextBox3.Text));
dg1.DataSource = search.ToList();
}
else if (cs.Text == "کد ملی")
{
var search = dbm.db_bimar.Where(c => c.code_meli.Contains(radTextBox3.Text));
dg1.DataSource = search.ToList();
}
else if (cs.Text == "کد ملی")
{
var search = dbm.db_bimar.Where(c => c.family.Contains(radTextBox3.Text));
dg1.DataSource = search.ToList();
}
else if (cs.Text == null)
{
sho();
}
}
edit edit;
private void ویرایشToolStripMenuItem_Click(object sender, EventArgs e)
{
int cud =int.Parse(dg1.CurrentRow.Cells[0].Value.ToString());
db_bimar tu = dbm.db_bimar.FirstOrDefault(c => c.ID == cud);
if (tu != null)
{
edit = new edit(tu);
edit.ShowDialog();
if (edit.DialogResult == DialogResult.OK)
{
dbm.SaveChanges();
}
sho();
}
}
}
}
کد فرم ویرایش
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Telerik.WinControls;
namespace Matab.bimar
{
public partial class edit : Telerik.WinControls.UI.RadForm
{
private db_bimar _objBimar;
public edit(db_bimar bimar)
{
InitializeComponent();
_objBimar = bimar;
sp.Text=_objBimar.s_p;
name.Text = _objBimar.name;
family.Text = _objBimar.family;
nbime.Text = _objBimar.bime_name;
sbime.Text = _objBimar.s_bime;
code_meli.Text = _objBimar.code_meli;
bith.Text = _objBimar.birth;
gr.Text=_objBimar.gender;
tel.Text=_objBimar.phone;
add.Text=_objBimar.address;
em.Text=_objBimar.Email;
sv.Text=_objBimar.sv_bimar;
}
private void radButton1_Click(object sender, EventArgs e)
{
_objBimar.s_p = sp.Text;
_objBimar.name = name.Text;
_objBimar.family = family.Text;
_objBimar.bime_name = nbime.Text;
_objBimar.s_bime = sbime.Text;
_objBimar.code_meli = code_meli.Text;
_objBimar.birth = bith.Text;
_objBimar.gender = gr.Text;
_objBimar.phone = tel.Text;
_objBimar.address = add.Text;
_objBimar.Email = em.Text;
_objBimar.sv_bimar = sv.Text;
this.DialogResult = DialogResult.OK;
this.Close();
}
private void edit_Load(object sender, EventArgs e)
{
}
private void radGroupBox3_Click(object sender, EventArgs e)
{
}
private void bth_TextChanged(object sender, EventArgs e)
{
}
private void radGroupBox2_Click(object sender, EventArgs e)
{
}
}
}