Hey people, I have a problem with connect to MS Access database...

I use C#.NET and MS Access 2002-2003

Here is my code:

...
using System.Data.OleDb;

namespace Потсетник
{
    public partial class Form1 : Form
    {
        public OleDbConnection database;

        public Form1()
        {
            InitializeComponent();

            string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=zapis.mdb";
            try
            {

                database = new OleDbConnection(connectionString);
                database.Open();

                string queryString = "SELECT ID, Име, Презиме, Ник, Мобилен, Мобилен2, e-Mail, e-Mail2, Type FROM Table1 WHERE Table1.ID = Table1.ID";
                loadDataGrid(queryString);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return;
            }
        }
...

And now, when I start the application I get message „No value given for one or more required parameters“.

Where I wrong ?
Thanks...

Recommended Answers

All 5 Replies

Is this statement "SELECT ID, Име, Презиме, Ник, Мобилен, Мобилен2, e-Mail, e-Mail2, Type FROM Table1 WHERE Table1.ID = Table1.ID" valid?

Is this statement "SELECT ID, Име, Презиме, Ник, Мобилен, Мобилен2, e-Mail, e-Mail2, Type FROM Table1 WHERE Table1.ID = Table1.ID" valid?

If you mean for unicode/encode... this is not problem, I'm sure for that.

I had some problems with using cyrilic letters with SQL a while back, try reverting to latin? Just for test

I had some problems with using cyrilic letters with SQL a while back, try reverting to latin? Just for test

I did not have a problem with the cyrillic when i made my first program Home DVD (if you understand macedoninan :)).

Here is the code for my first program:

string queryString = "SELECT movieID, Наслов, Издавач, Гледан, Година, Type FROM movie,movieType WHERE movietype.typeID = movie.typeID";
string queryString = "SELECT movieID, Наслов, Издавач, Гледан, Година, Type FROM movie,movieType WHERE movietype.typeID = movie.typeID";
//Sure you mean
string queryString = "SELECT movieID, Наслов, Издавач, Гледан, Година, Type FROM movie,movieType WHERE movietype.typeID =" movie.typeID;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.