access database

[sarabonn]

hallo everyone,

Iam using access database and visual c# 2008. Iam tried to insert data into table with lot of method but nothing works, i dont know what is wrong. here is my codes

private void button1_Click(object sender, EventArgs e)
        {
            //txt1 = textBox1.Text;
            //txt2 = textBox2.Text;
            //String connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Userinfo.accdb";
            //OleDbConnection cnJetDB = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Userinfo.accdb");
            //cnJetDB.Open();
 
            CreateCustomerAdapter();
           // cnJetDB.Open();
           // OleDbDataAdapter oleDa = new OleDbDataAdapter();
           // OleDbCommand cmdInsert = new OleDbCommand("INSERT INTO userinfo (Username, Pwd,Openid,ServerUrl)"+"VALUES (?,?,?,?)",cnJetDB);
           //// cmdInsert.CommandText = "INSERT INTO userinfo (Username, Pwd,Openid,ServerUrl)"+"VALUES (?,?,?,?)";
           //     //"INSERT INTO userinfo (Username,Pwd,Openid,ServerUrl) VALUES (?,?,?,?)";
           //// cmdInsert.Connection = cnJetDB;
           // //cmdInsert.Parameters.Add(new OleDbParameter("Username", OleDbType.VarChar, 40, textBox1.Text));
           // //cmdInsert.Parameters.Add(new OleDbParameter("Pwd", OleDbType.VarChar, 40, textBox2.Text));
           // //cmdInsert.Parameters.Add(new OleDbParameter("Openid",OleDbType.VarChar,40,null));
           // //cmdInsert.Parameters.Add(new OleDbParameter("ServerUrl",OleDbType.VarChar,40,null));
           // cmdInsert.Parameters.Add(textBox1.Text, OleDbType.VarChar, 40, "Username");
           // cmdInsert.Parameters.Add(textBox2.Text, OleDbType.VarChar, 40, "Pwd");
           // cmdInsert.Parameters.Add("null", OleDbType.VarChar, 40, "Openid");
           // cmdInsert.Parameters.Add("null", OleDbType.VarChar, 40, "ServerUrl");
 
           // oleDa.InsertCommand = cmdInsert;
           // //DataTable dtTest = new DataTable();
           // //oleDa.Fill(dtTest);
           // cmdInsert = null;
           //  cnJetDB.Close();
           //  cnJetDB = null;
 
 
 
             //using (OleDbConnection connection = new OleDbConnection(connectionString))
             //{
             //    OleDbCommand command = new OleDbCommand();
             //    command.CommandType = CommandType.TableDirect;
             //    command.CommandText = "INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)";
             //    command.Connection = connection;
 
             //    connection.Open();
             //    OleDbDataReader reader = command.ExecuteReader();
 
 
             //    reader.Close();
             //    connection.Close();
 
             //}
 
           // OleDbConnection connection = new OleDbConnection(connectionString);
           // OleDbDataAdapter adapter = new OleDbDataAdapter();
 
 
           // OleDbCommand command = new OleDbCommand();
           // // Create the InsertCommand.
 
           // command.CommandType = CommandType.Text;
           // command.CommandText = "INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)";
 
           // command.Connection = connection;
           // //command.Parameters.Add("txt1", OleDbType.Char, 5, "Username");
           // //command.Parameters.Add("txt2", OleDbType.VarChar, 10, "Pwd");
 
           //// adapter.InsertCommand = command;
 
           // connection.Open();
 
           // command.ExecuteNonQuery();
           // connection.Close();
 
            //txt1 = textBox1.Text;
            //txt2 = textBox2.Text;
            login.ActiveForm.Visible = false;
            _form.Show();
            _form.newop();
 
        }
        private static OleDbDataAdapter CreateCustomerAdapter()
        {
            OleDbConnection cnJetDB = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Userinfo.accdb");
            cnJetDB.Open();
            OleDbDataAdapter oleDa = new OleDbDataAdapter();
            OleDbCommand cmdInsert = new OleDbCommand("INSERT INTO userinfo (Username, Pwd,Openid,ServerUrl)" + "VALUES (?,?,?,?)", cnJetDB);
 
            cmdInsert.Parameters.Add("txt", OleDbType.VarChar, 40, "Username");
            cmdInsert.Parameters.Add("Text", OleDbType.VarChar, 40, "Pwd");
            cmdInsert.Parameters.Add("null", OleDbType.VarChar, 40, "Openid");
            cmdInsert.Parameters.Add("null", OleDbType.VarChar, 40, "ServerUrl");
 
            oleDa.InsertCommand = cmdInsert;
            //DataTable dtTest = new DataTable();
            //oleDa.Fill(dtTest);
            cmdInsert = null;
            cnJetDB.Close();
            cnJetDB = null;
            return oleDa;
        }
 

The above code has all the method i have tried. sorry if there is lot of code in there. The lines which are commented are the one which i have tried. First time when i tried to insert i open the access it gave me an popup "certain content in the database has been disabled", even when i enable that content and enable macro no use.Any help is highly appreciable. struggling with this small problem for 2 days.

Thank you.

regards,
Dinesh.

[r035198x]

Under HowTos, go to Browse all HowTos and check the .NET HowTos. You should find two articles called "How to use a database in your program".

[sarabonn]

Under HowTos, go to Browse all HowTos and check the .NET HowTos. You should find two articles called "How to use a database in your program".

yes admin, i already looked at it but nothing other than what i have used.

Thank you.

[r035198x]

Your current uncommented code doesn't have the execute part so statements are issued to the database.

[sarabonn]

Your current uncommented code doesn't have the execute part so statements are issued to the database.

hallo admin,

Thank you for your reply. I have used the cmdInsert.ExecuteNonQuery() but it gives me a error "Parameter ?_1 has no default value." in that line. Have any idea?..

thank you.
Dinesh.