najmehdj
پنج شنبه 21 بهمن 1389, 14:39 عصر
من یک در فرم اصلی کلید edit دارم و با زدن اینکلید و انخاب سطر مورد نظر در صفحه دیگه داده ها باید در textbox قرار گیرند اما ارور میده و من نمیدونم مشکل از کجاست
لطفا راهناییم کنید
private void btnedit_Click(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\store.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
con.Open();
cmd.Connection = con;
DataTable dt = new DataTable();
dt= getdata("select * from Insurance where PKCodeInsurance=" + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString());
EditInsurance eins = new EditInsurance(dt);
eins.ShowDialog();
}
در فرم دوم
public partial class EditInsurance : Form
{
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
public EditInsurance(DataTable dt)
{
txtcode.Text = dt.Rows[0]["PKCodeInsurance"].ToString();
txtname.Text = dt.Rows[0]["NameInsurance"].ToString();
txtpercent.Text = dt.Rows[0]["InsurancePercent"].ToString();
txtstart.Text = dt.Rows[0]["StartDate"].ToString();
txtend.Text = dt.Rows[0]["EndDate"].ToString();
InitializeComponent();
}
private void btnok_Click(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\store.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
con.Open();
cmd.CommandText="UPDATE Insurance SET NameInsurance =@NameInsurance, InsurancePercent =@InsurancePercent, StartDate =@StartDate, EndDate =@EndDate where PKCodeInsurance =@PKCodeInsurance";
cmd.Parameters.AddWithValue("NameInsurance", txtname.Text.Trim());
cmd.Parameters.AddWithValue("InsurancePercent", txtpercent.Text.Trim());
cmd.Parameters.AddWithValue("StartDate",txtstart.Text.Trim());
cmd.Parameters.AddWithValue("EndDate",txtend.Text.Trim());
cmd.ExecuteNonQuery();
con.Close();
this.Close();
}
لطفا راهناییم کنید
private void btnedit_Click(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\store.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
con.Open();
cmd.Connection = con;
DataTable dt = new DataTable();
dt= getdata("select * from Insurance where PKCodeInsurance=" + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString());
EditInsurance eins = new EditInsurance(dt);
eins.ShowDialog();
}
در فرم دوم
public partial class EditInsurance : Form
{
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
public EditInsurance(DataTable dt)
{
txtcode.Text = dt.Rows[0]["PKCodeInsurance"].ToString();
txtname.Text = dt.Rows[0]["NameInsurance"].ToString();
txtpercent.Text = dt.Rows[0]["InsurancePercent"].ToString();
txtstart.Text = dt.Rows[0]["StartDate"].ToString();
txtend.Text = dt.Rows[0]["EndDate"].ToString();
InitializeComponent();
}
private void btnok_Click(object sender, EventArgs e)
{
con.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\store.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
con.Open();
cmd.CommandText="UPDATE Insurance SET NameInsurance =@NameInsurance, InsurancePercent =@InsurancePercent, StartDate =@StartDate, EndDate =@EndDate where PKCodeInsurance =@PKCodeInsurance";
cmd.Parameters.AddWithValue("NameInsurance", txtname.Text.Trim());
cmd.Parameters.AddWithValue("InsurancePercent", txtpercent.Text.Trim());
cmd.Parameters.AddWithValue("StartDate",txtstart.Text.Trim());
cmd.Parameters.AddWithValue("EndDate",txtend.Text.Trim());
cmd.ExecuteNonQuery();
con.Close();
this.Close();
}