Postovani i drage kolege, imam jedan problem...zeleo sam da napravim bazicu u Accessu za potrebe jednog programcica. Elem kada sam pokusao da vezem sa bazom, t.j. kada zelim da upisem nesto u bazu nista se ne dogadja. POsavicu i prilog u vidu mog koda... posto sam napravio bazu probe radi gde ima Id, i Ime kao atributi samo...
Evo jednog koda...
private void button1_Click(object sender, EventArgs e)
{
string putanja = Directory.GetCurrentDirectory();
putanja += "\\App_Data\\Database3.mdb";
//putanja = "c:\\Database3.mdb";
OleDbConnection Veza = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" +
putanja);
OleDbCommand Komanda = Veza.CreateCommand();
Komanda.CommandText = "INSERT INTO aaa ( Ime)VALUES (@Ime)";
Komanda.Parameters.Add("@Ime", OleDbType.LongVarChar).Value = textBox1.Text;
Veza.Open();
OleDbDataReader dr = Komanda.ExecuteReader(); //CommandBehavior.SequentialAccess
dr.Close();
Veza.Close();
Veza.Dispose();
textBox1.Text = "";
A evo i druge varijante sa SQL bazom.. posto i tu nece da radi...
SqlConnection Veza = new SqlConnectiDataSource=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database2.mdf;Integrate" +
"d Security=True;User Instance=True");
SqlCommand Komanda = Veza.CreateCommand();
Komanda.CommandText = "INSERT INTO aaa ( Ime)VALUES (@Ime)";
//OleDbConnection Veza = new OleDbConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database2.mdf;Integrate" +
// "d Security=True;User Instance=True");
//OleDbCommand Komanda = Veza.CreateCommand();
//Komanda.CommandText = "INSERT INTO aaa ( Ime)VALUES (@Ime)";
Komanda.Parameters.Add("@Ime", SqlDbType.NVarChar, 50).Value = textBox1.Text;
Veza.Open();
SqlDataReader dr = Komanda.ExecuteReader(); //CommandBehavior.SequentialAccess
dr.Close();
Veza.Close();
Veza.Dispose();
textBox1.Text = "";
Recite mi gde gresim .. i ispravite kod.. posto ovo kada radi .. meni ne upisuje u bazu ama nista..
Unapred zahvalan.