عدم برقراری ارتباط با دیتا بیس [بسته شده]

Question

با سلام

در قسمت فرم لود مشکلی نداره و به دیتابیس وصل میشه ولی وقتی add رو میزم ایراد زیر رو میگیره

لطفا راهنمایی بفرمایید

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;

namespace WindowsFormsApp3
{
    public partial class Form1 : Form
    {
        OleDbConnection objConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DBES.mdb");
        OleDbDataAdapter objDataAdaptor = new OleDbDataAdapter();
        DataSet objDataSet = new DataSet();
        OleDbCommand objCommand = new OleDbCommand();

        public Form1()
        {
            InitializeComponent();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            objDataAdaptor.SelectCommand = new OleDbCommand();
            objDataAdaptor.SelectCommand.Connection = objConnection;
            objDataAdaptor.SelectCommand.CommandText = "select code, name, tell from anbarha";
            objDataAdaptor.SelectCommand.CommandType = CommandType.Text;

            objConnection.Open();
            objDataAdaptor.Fill(objDataSet, "ali");
            objConnection.Close();


            grdFirst.AutoGenerateColumns = true;
            grdFirst.DataSource = objDataSet;
            grdFirst.DataMember = "ali";

            objDataSet = null;
            objConnection = null;
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            objDataAdaptor.SelectCommand = new OleDbCommand();
            objDataAdaptor.SelectCommand.Connection = objConnection;
            objDataAdaptor.SelectCommand.CommandText = "select code, name, tell from anbarha";
            objDataAdaptor.SelectCommand.CommandType = CommandType.Text;

            objCommand.Parameters.Clear();
            objCommand.CommandText = "insert into anbarha(code, name, tell)values(@c, @n, @t)";
            objCommand.Parameters.AddWithValue("@c", txtCode.text);
            objCommand.Parameters.AddWithValue("@n", txtName.text);
            objCommand.Parameters.AddWithValue("@t", txtTell.text);

            objConnection.Open();
            objCommand.ExecuteNonQuery();
            objConnection.Close();
            MessageBox.Show(txtName.Text + " ثبت شد! ");


            objDataAdaptor.SelectCommand.Connection = objConnection;
            objDataAdaptor.SelectCommand.CommandText = "select * from anbarha";
            objDataAdaptor.SelectCommand.CommandType = CommandType.Text;

            objConnection.Open();
            objDataAdaptor.Fill(objDataSet, "ali");
            objConnection.Close();

            grdFirst.AutoGenerateColumns = true;
            grdFirst.DataSource = objDataSet;
            grdFirst.DataMember = "ali";

            
        }
    }
}

 

Answer 1

سلام، کدهاتونو با لینک زیر مقایسه کنید ببینید ایراد کار از کجاست

http://www.w3-farsi.com/%d8%a7%d9%86%d8%ac%d8%a7%d9%85-%d8%b9%d9%85%d9%84%db%8c%d8%a7%d8%aa-%d9%87%d8%a7%db%8c-%d8%a7%d9%86%d8%aa%d8%ae%d8%a7%d8%a8-%d8%8c-%d8%af%d8%b1%d8%ac-%d8%8c-%d8%ad%d8%b0%d9%81-%d9%88-%d9%88%db%8c/