insert into sql query in wpf

Question

Hello everyone i am new in wpf. so i have got problems with it. if you help me, i will be so pleased. thanks everyone in advance.

My problem is, can not insert into name inside database in wpf. how can i fix it? my codes as follows;

private void button1_Click(object sender, RoutedEventArgs e)
{       
    try
    {
     string SqlString = "Insert Into UserInformation(name) Values (?)";
     using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Cell.mdb;Persist Security Info=True"))
     {
      using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
      {
       cmd.CommandType = CommandType.Text;
       cmd.Parameters.AddWithValue("name", textBox1.Text);
       conn.Open();
       cmd.ExecuteNonQuery();

      } 
     }
    }
    catch (Exception ex)
    {  }
}

Answer 1

Try to use cmd.Parameters.AddWithValue("@name", textBox1.Text);

Answer 2

The problem here seams to be the parameter. In the command text you don't specify its name, but when you add it, it has a name. Change command text to :

Insert Into UserInformation(name) Values (@name)

In line: cmd.Parameters.AddWithValue("name", textBox1.Text);

the parameter name should stay without @ .

Answer 3

Is it opening the right database file? As people have suggested in the comments, set Visual Studio to break on first-chance exceptions, or remove the exception handling. The database file needs to exist, and you need the appropriate JET drivers.

I've tried your code and it works without any problems here (in a WPF application or otherwise). Using named parameters instead of a question mark was a good suggestion, but it doesn't appear to be the problem. (I have Office 2007 and .NET 3.5 SP1 installed, but I doubt that matters).

Are you using a WPF browser application (cbap)? Because you won't be able to access the local file system (and thus the database) if you are. WPF browser applications run with isolated permissions, much like a Silverlight browser application.