بفرمایید:
من یک پروژه جدید درست می کنم این مشکل وجود نداره ولی تو پروژه خودم متاسفانه تو همه فرم هام روی متد پارامتر خطا میده
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Threading.Tasks;
using System.Windows;
namespace _program
{
public partial class kargah_edit : Form
{
public kargah_edit()
{
InitializeComponent();
}
private void button3_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
oleDbCommand1.Parameters.Clear();
oleDbCommand1.CommandText = "update narmafzar set SAL=@1,OSTAN=@2,GOSTARE=@3 where keyy=@0";
oleDbCommand1.Parameters.AddWithValue("@1", textBox1.Text);
oleDbCommand1.Parameters.AddWithValue("@2", comboBox2.Text);
oleDbCommand1.Parameters.AddWithValue("@3", comboBox1.Text);
oleDbCommand1.Parameters.AddWithValue("@0", label12.Text);
oleDbConnection1.Open();
oleDbCommand1.ExecuteNonQuery();
oleDbConnection1.Close();
MessageBox.Show("عملیات ویرایش با موفقیت انجام شد");
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter();
adp.SelectCommand = new OleDbCommand();
adp.SelectCommand.Connection = oleDbConnection1;
adp.SelectCommand.CommandText = "select * from narmafzar";
adp.Fill(ds, "t1");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "t1";
}
private void kargah_edit_Load(object sender, EventArgs e)
{
textBox1.Text = axIRShamsiDate1.ShowDateModel1;
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter();
adp.SelectCommand = new OleDbCommand();
adp.SelectCommand.Connection = oleDbConnection1;
adp.SelectCommand.CommandText = "select * from narmafzar";
adp.Fill(ds, "t1");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "t1";
DataTable dt = new DataTable();
dt = ds.Tables["t1"];
label12.Text = dt.Rows[0]["keyy"].ToString();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
label12.Text = dataGridView1.SelectedCells[0].Value.ToString();
textBox1.Text = dataGridView1.SelectedCells[1].Value.ToString();
comboBox2.Text = dataGridView1.SelectedCells[2].Value.ToString();
comboBox6.Text = dataGridView1.SelectedCells[3].Value.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
oleDbCommand1.Parameters.Clear();
oleDbCommand1.CommandText = "delete * from narmafzar where keyy=@0";
oleDbCommand1.Parameters.AddWithValue("@0", label12.Text);
oleDbConnection1.Open();
oleDbCommand1.ExecuteNonQuery();
oleDbConnection1.Close();
MessageBox.Show("عملیات حذف با موفقیت انجام شد", "حذف");
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter();
adp.SelectCommand = new OleDbCommand();
adp.SelectCommand.Connection = oleDbConnection1;
adp.SelectCommand.CommandText = "select * from narmafzar";
adp.Fill(ds, "t1");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "t1";
}
private void dataGridView1_KeyDown(object sender, KeyEventArgs e)
{
label12.Text = dataGridView1.SelectedCells[0].Value.ToString();
textBox1.Text = dataGridView1.SelectedCells[1].Value.ToString();
comboBox2.Text = dataGridView1.SelectedCells[2].Value.ToString();
comboBox6.Text = dataGridView1.SelectedCells[3].Value.ToString();
}
private void dataGridView1_KeyUp(object sender, KeyEventArgs e)
{
label12.Text = dataGridView1.SelectedCells[0].Value.ToString();
textBox1.Text = dataGridView1.SelectedCells[1].Value.ToString();
comboBox2.Text = dataGridView1.SelectedCells[2].Value.ToString();
comboBox6.Text = dataGridView1.SelectedCells[3].Value.ToString();
}
private void kargah_edit_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter)
{
e.Handled = true;
SendKeys.Send("{TAB}");
if (textBox1.TextLength < 10)
{
MessageBox.Show("فرمت تاریخ را صحیح وارد کنید");
}
}
}
private void button4_Click(object sender, EventArgs e)
{
//ijad keyy jadid
dateTimePicker1.ResetText();
string str = axIRShamsiDate1.ShowDateModel1.ToString();
string str1 = str.Substring(0, 4); str1 = str1 + str.Substring(5, 2); str1 = str1 + str.Substring(8, 2);
string str2 = dateTimePicker1.ToString();
string str3 = str2.Substring(55, 2); str3 = str3 + str2.Substring(58, 2); str3 = str3 + str2.Substring(61, 2);
label12.Text = str1 + str3;
////////////////
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter();
adp.SelectCommand = new OleDbCommand();
adp.SelectCommand.Connection = oleDbConnection1;
adp.SelectCommand.CommandText = "select * from narmafzar where keyy=@0 or sal=@1";
adp.SelectCommand.Parameters.AddWithValue("@0", label12.Text);
adp.SelectCommand.Parameters.AddWithValue("@1", textBox1.Text);
adp.Fill(ds, "t1");
DataTable dt = new DataTable();
dt = ds.Tables["t1"];
if (dt.Rows.Count == 0)
{
oleDbCommand1.Parameters.Clear();
oleDbCommand1.CommandText = "insert into narmafzar(keyy,SAL,OSTAN,GOSTARE)values(@0,@1,@2,@ 3)";
oleDbCommand1.Parameters.AddWithValue("@0", label12.Text);
oleDbCommand1.Parameters.AddWithValue("@1", textBox1.Text);
oleDbCommand1.Parameters.AddWithValue("@2", comboBox2.Text);
oleDbCommand1.Parameters.AddWithValue("@3", comboBox1.Text);
oleDbConnection1.Open();
oleDbCommand1.ExecuteNonQuery();
oleDbConnection1.Close();
MessageBox.Show("ثبت شد");
DataSet dss = new DataSet();
OleDbDataAdapter adpp = new OleDbDataAdapter();
adpp.SelectCommand = new OleDbCommand();
adpp.SelectCommand.Connection = oleDbConnection1;
adpp.SelectCommand.CommandText = "select * from narmafzar";
adpp.Fill(dss, "t1");
dataGridView1.DataSource = dss;
dataGridView1.DataMember = "t1";
}
else MessageBox.Show("در این تاریخ قبلا یک سابقه ثبت کرده اید");
}
}
}