reza69
جمعه 15 دی 1391, 16:53 عصر
سلام وقتی من داده ها رو وارد access می کنم رکورد وارد شده جای اولین رکورد رو میگیره و رکورد قبلی حذف میشه.مشگل این کد کجاست؟
private void btninsert_Click(object sender, EventArgs e)
{
string myconstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\mydb.accdb";
OleDbConnection connection = new OleDbConnection (myconstring);
OleDbCommand cmd;
connection.Open();
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "insert into mytable(name,family,birthday,regcode,mobile,pictur e)values(@name,@family,@birthday,@regcode,@mobile, @picture)";
cmd.Parameters.AddWithValue("@name", txtname.Text);
cmd.Parameters.AddWithValue("@family", txtfamily.Text);
cmd.Parameters.AddWithValue("@birthday", txtbirthday.Text);
cmd.Parameters.AddWithValue("@regcode", txtregcode.Text);
cmd.Parameters.AddWithValue("@mobile", txtmobile.Text);
cmd.Parameters.AddWithValue("@picture", pictureBox1.Image);
cmd.ExecuteNonQuery();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
connection.Close();
MessageBox.Show("Done");
}
private void btninsert_Click(object sender, EventArgs e)
{
string myconstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\mydb.accdb";
OleDbConnection connection = new OleDbConnection (myconstring);
OleDbCommand cmd;
connection.Open();
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "insert into mytable(name,family,birthday,regcode,mobile,pictur e)values(@name,@family,@birthday,@regcode,@mobile, @picture)";
cmd.Parameters.AddWithValue("@name", txtname.Text);
cmd.Parameters.AddWithValue("@family", txtfamily.Text);
cmd.Parameters.AddWithValue("@birthday", txtbirthday.Text);
cmd.Parameters.AddWithValue("@regcode", txtregcode.Text);
cmd.Parameters.AddWithValue("@mobile", txtmobile.Text);
cmd.Parameters.AddWithValue("@picture", pictureBox1.Image);
cmd.ExecuteNonQuery();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
connection.Close();
MessageBox.Show("Done");
}