Why null value is inserted ?

• • Reply

  14 years ago

  by ledaker

  ledaker

  , Algeria

  Joined 14 years ago
  Why null value is inserted in the table Post(Post_P varchar(255),Post_E varchar(255)) ?
                  MySqlConnection c;
                  c = new MySqlConnection("Database=dbase;Data Source=localhost;User Id=root;Password=rootpass");
                  c.Open();
  
                  MySqlCommand com = new MySqlCommand("select Post_p,Post_E from Post", c);
                  
   MySql.Data.MySqlClient.MySqlDataAdapter   PostAdapter = new MySqlDataAdapter(com);
  
                  PostAdapter.InsertCommand = new MySqlCommand("INSERT INTO Post(Post_P,Post_E) VALUES (@Post_P, @Post_E);", c);
  
                  MySqlParameter p0 = PostAdapter.InsertCommand.Parameters.Add("@Post_P", MySql.Data.MySqlClient.MySqlDbType.VarChar, 255, "Post_P");
                  
                  MySqlParameter p1 = PostAdapter.InsertCommand.Parameters.Add("@Post_E", MySql.Data.MySqlClient.MySqlDbType.VarChar, 255,"Post_E");
  
                  PostAdapter.Fill(ConfigureDataSet, "Post");
  DataRow d=null;
                  d= ConfigureDataSet.Tables["Post"].NewRow();
                  d[0] = "T11";
                  d[1] = "T11";
                 
                  ConfigureDataSet.Tables["Post"].Rows.Add(d);
                 
                  PostAdapter.Update(ConfigureDataSet.Tables["Post"]);
                  c.Close();
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse
• • Reply

  14 years ago

  by ledaker

  ledaker

  , Algeria

  Joined 14 years ago
  I have found where is the problem and the solution,
  the problem is here :
  PostAdapter.InsertCommand = new MySqlCommand("INSERT INTO Post(Post_P,Post_E) VALUES (@Post_P, @Post_E);", c);
  and the solution is:
  
  
  PostAdapter.InsertCommand = new MySqlCommand("INSERT INTO Post(Post_P,Post_E) VALUES (?Post_P, ?Post_E);", c);
  
  
  
  
  Report abuse