Re: Tabs, Comboxes and ADO.Net Problems
- From: "Steve B." <SteveB@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 21 Nov 2005 14:05:04 -0800
Thank You Bart. I was hoping SQL Server might solve problem 1. I do start a
thread when the program starts to tell the user if the program is already
running but anyways thank you for you time.
Steve
"Bart Mermuys" wrote:
> Hi,
>
> "Steve B." <SteveB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:8C603717-4E1A-448E-91DE-FEA76B6AD8E0@xxxxxxxxxxxxxxxx
> > Thanks Bart. I tried to be brief below
> >
> > I'm using VS for development. My local application is described as a top
> > level simple form with dropdown menus. The items in the menu link to
> > internal MS-Office network share drive documents or web pages. A couple
> > of
> > these menu items link to an ADO.Net Interface in which the underlying dB
> > is
> > MS-Access. The Interfaces provides Add, Delete, Change, DataGrid/dB
> > functionality. The adjacent bound DG ComboBoxes on the form display's the
> > "selected" row in the DG
> >
> > One of these Interfaces is quite complex containing approx 110 string
> > fields
> > in the Main table of the dB. The ADO.Net interface that addresses this
> > Main
> > table is modeled after a simpler Interface of 15 fields that works fine.
> > Both the simple and complex ADO.Net Interfaces utilize a common inherited
> > Interface file/class containing all the common ADO.Net methods.
> >
> > Problem #1
> > FYI, the VS DataAdapter wizard limits itself to 100 fields. So I said O'K,
> > let's do 90 fields and worry about the other ones later and get 90 working
> > and loaded. The 90 fields loaded into the DG and associated CB's fine.
> > Here's the problem, I can't manipulate the data. If I try to change a
> > field
> > in one of the 90 fields of the DG and try to save this Update to the dB I'll
> > get a "Expression is to Complex" error message. I haven't bther tring the
> > other functionalities.
> >
> > Proposed Solution #1
> > I'm going to strip the DA and DS from the automatically generated
> > InitializeComponent() code and put it all manually in my code. I hope
> > this
> > stops the error and allows me to add the 110 fields. I'm doing that now.
> > Comments? Let me also say I recognize dB Normalization.
>
> You're getting "Expression is to Complex" because the generated update query
> checks whether the old values are still the same to provide optimistic
> concurrency, but this causes a lot of AND's in the WHERE clause and the
> number is limited with Jet to 40. You could create your own query whithout
> checking the old values (no ANDs) but then you loose optimistic concurrency
> control. I've never dealt with that many columns.
>
> >
> > Problem #2
> > The complex Interface discussed above is a dll which is developed/debugged
> > on my machine and then the whole application is Released compiled to the
> > network. The problem is that sometimes and only sometimes the dll won't
> > close(). I don't know if a user doesn't close it properly but I can't
> > trace
> > the problem. There's only one thread in the program and I've tried stuff
> > like GC. All I know is when I try to Release compile I get an error
> > message
> > saying basically that can't compile that portion of the application
> > because
> > that file is open and the file is definitely not open at 5:30am.
> >
> > Fix #2
> > I have to get the IT guy, go to the server open all the running process on
> > the server, find my running database dll process and close it. I can't
> > see
> > it locally on my machine. After that I can Release compile fine. Why
> > doesn't the dll close?
>
> No idea why the dll remains open. If you are using threads then makes sure
> they end when the program gets closed. If non-background threads aren't
> ended they keep your program running.
>
> >
> > Problem #3 (BUG?)
> > When the program is not running and if I click on a Tab full of bound CB's
> > and have focus on a Tab and then try to close VS I get the following error
> > massage: "The following exception has occurred, DataBinding could not
> > find a
> > row in the list suitable for all bindings"..Is this a bug or a sign of the
> > stability of my program?
>
> That sounds like a bug.
>
> >
> > Will SQL Server help me in general?
>
> There is a lot of difference between sqlserver and access, first of all
> access is a file database while sql server is a server database. A lot of
> people don't consider access a "real" database. But you should be able to
> find lots of information (about the differences) on the internet.
>
> Sorry i couldn't be more helpfull, maybe someone else might still help.
>
> Greetings
>
> > My next step is contacting MS for assistance.
> >
> > Steve
>
>
>
.
- References:
- Re: Tabs and ComboBoxes Repost
- From: Bart Mermuys
- Re: Tabs and ComboBoxes Repost
- From: Bart Mermuys
- Re: Tabs and ComboBoxes Repost
- From: Steve B.
- Re: Tabs and ComboBoxes Repost
- From: Bart Mermuys
- Re: Tabs, Comboxes and ADO.Net Problems
- From: Bart Mermuys
- Re: Tabs and ComboBoxes Repost
- Prev by Date: Re: Move a data column in a datatable
- Next by Date: online/offline status
- Previous by thread: Re: Tabs, Comboxes and ADO.Net Problems
- Next by thread: Re: Tabs and ComboBoxes Repost
- Index(es):
Relevant Pages
|
