Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / DataGrid / April 2007

Tip: Looking for answers? Try searching our database.

sql build cmd uses [ and ] but I need "

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Beemer Biker - 26 Apr 2007 23:19 GMT
Was wondering if there is some setting in VS2005 where it can build my sql
commands using that postgresql quote instead of brackets.

Createing a SqlDataSource and using this bible reference:
http://www.123aspx.com/redir.aspx?res=35840

I checked the "Generate INSERT, UPDATE dn DELETE statements from my SELECT
sql code:  SELECT * from "Users"
the " is needed as there is mixed case in postgresql

OK - VS2005 generated the following code that is close but does not win the
prize:

====as generate by gatesware====
UPDATE [Users] SET [lastLogin] = ?, [administrator] = ?, [files_path_prefix]
= ? WHERE [id] = ? AND [authString] = ? AND [realName] = ?
=====end of was generated for me, thanks====

Problem 1.
   I need to go in and replace each and every [ and ] with "
   This is certainly do-able but I got a lot of code to write. Is there
some customization setting in VS2005 where I can re-define those sql
delimiters or whatever they are called?   Maybe if we had bought MS SQL this
would not be a problem?

Problem 2
   The WHERE is misplaced.  I made everything readonly except
   realName as that is all that is allowed to be changed.  Again, I
  can mod the code from the above auto-generated to ...

  UPDATE "Users" SET "realName" = ? where "id" = ?

WILL THIS EVEN WORK?

  I am a newbie on using gridview on web pages,  I got the EDIT button to
work and after making my changes I click on UPDATE and discovered that I was
supposed to have generated the update command during design mode.  Sooo ...
is gridview smart enough to see UPDATE "Users" SET "realName"=? where "id"=?
and substitute the correct field info into the ? before executing the query?

Signature

======================================================================
Joseph "Beemer  Biker" Stateson
http://TipsForTheComputingImpaired.com
http://ResearchRiders.org     Ask about my 99'R1100RT
======================================================================

Beemer Biker - 28 Apr 2007 15:28 GMT
This is a known bug.  Unfortunately, it was "closed" by micro$haft in 2006
as shown here.

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID
=104770


If you can find it in your heart to join "microsoft connect" and give them
your email, please add a comment to the above case asking them to fix it.

Signature

=======================================================================
Joseph "Beemer  Biker" Stateson
http://TipsForTheComputingImpaired.com
http://ResearchRiders.org     Ask about my 99'R1100RT
=======================================================================


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.