Strange Error when adding to access mdb file

  • Thread starter Thread starter Brent Starkes
  • Start date Start date
B

Brent Starkes

ok.... this is a strange error and it only happens in 2 instances

1) it happens when the program is first compiled. a restart of the program
solves the problem
2) and when its out of order .... eg ( 12 Mad dog, 34 may and bbb) where bbb
is displayed twice.

this bbb is displayed twice in both instances.

here is the code:
Debug.WriteLine("miAddLCProject_Click (BEFORE) : " +
this.dsProjects.Tables["projects"].Rows.Count.ToString());

System.Data.DataRow newRow = this.dsProjects.Tables["projects"].NewRow();

newRow["projectName"] = curProject.ProjectName.ToString();


this.dsProjects.Tables["projects"].Rows.Add(newRow);

this.daProjects.Update(this.dsProjects, "projects");

this.daProjects.Fill(this.dsProjects, "projects");

Debug.WriteLine("miAddLCProject_Click (AFTER) : " +
this.dsProjects.Tables["projects"].Rows.Count.ToString());



and when the error occurs, the debug lines output say 2 and 4

any ideas what could be causing this error....



Brent
 
Brent,

I believe you posted a few days back and frankly I am most astounded by this
error.

This is something that is EXTREMELY hard to post on Newsgroups, but (no
promises), I'd like to investigate this, time permitting.

Honestly, I am SO DAMNED busy these days that I shouldn't promise you that I
will get time to look at this, but if you get a chance, please send me an
email through my blog, so I can communicate you my real email address. Then
maybe you could zip the contents as a project that I can use to reproduce
this error on my machine and maybe figure out why.

No promises when I'd get to it - a week, maybe more, but I am typing this
message partly because I wish to answer your question, and partly because I
am highly intrigued by this ultra weird error you are getting. :-).

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
 
Back
Top