Programming Help

Web Development



What's Here?

  • Members: 132,688
  • Replies: 471,793
  • Topics: 73,154
  • Snippets: 2,541
  • Tutorials: 667
  • Total Online: 1,273
  • Members: 64
  • Guests: 1,209

Who's Online?

Welcome to Dream.In.Code
Getting C# Help is Easy!

Join 132,688 C# Programmers for FREE! Get instant access to thousands of C# experts, tutorials, code snippets, and more! There are 1,273 people online right now. Registration is fast and FREE... Join Now!




Expression too complex

 
 Reply to this topicStart new topic

Expression too complex
joeyan
post 3 Jun, 2008 - 08:12 PM
Post #1


New D.I.C Head

*
Joined: 3 Jun, 2008
Posts: 1
Hi all,

I am a newbie of .NET c# programming.
I just take over a Data Recording System which use Visual Studio. NET 2002 (C#) to built a PC-based application, and use Ms Access 2000 as database.

I need to enhance a existing Windows Form that add more fields for user to input.

First of all, I add one textbox for testing, it works fine to save and retrieve.
and then I add the second textbox.... it's OK.

But when I add the third one. Error occurs.
When I click the SAVE button. It prompt a error message that "Expression too complex". So that I cannot save and add more input field to this Windows Form.

Do you have any idea and solution of this error.
I really need your help. Thanks.

The application is using OleDbCommandBuilder, DataAdapter.Update() for update, insert, etc.
User is offlineProfile CardPM

Go to the top of the page

baavgai
post 4 Jun, 2008 - 04:07 AM
Post #2


Dreaming Coder

Group Icon
Joined: 16 Oct, 2007
Posts: 1,967



Thanked 96 times

Dream Kudos: 475

Expert In: C, C++, Java, C#, ASP.NET, PHP, Perl, Python, Oracle, SQL Server, MySql, HTML, JavaScript, Lua

My Contributions
If your select uses joins then you usually can't just auto build the adapter. You'll have to hand code the update SQL.

e.g.
CODE

select a.name as dept_name, b.fullname as employee
   from dept a
      inner join employee b on a.dept_id=b.dept_id


So, I change the dept_name in the dataset and try to update it. What does that mean? The computer doesn't know.
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 11/23/08 07:23AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live C# Help!

C# Tutorials

Reference Sheets

C# Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month