gns1497's Profile User Rating: -----

Reputation: 1 Apprentice
Group:
New Members
Active Posts:
11 (0.01 per day)
Joined:
27-June 12
Profile Views:
394
Last Active:
User is offline Nov 13 2013 03:35 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   gns1497 has not set their status

Posts I've Made

  1. In Topic: Having problem reading from sql server view

    Posted 9 Oct 2013

    View Postandrewsw, on 07 October 2013 - 12:32 PM, said:

    The error message should give you some indication of where the error is. I don't use ASP.NET but assume you can press Break, or similar, and it will take you to the error.

    The error message itself suggests that you have a missing, or extra, bracket, or some similar simple syntax error which shouldn't be too difficult to spot.

    BTW What's all this..

             
                       &
    

    Eek! :dontgetit:/> Use css if you want to separate elements.



    The   was auto written using the .net suite. I didnt write that code. This is just page spacing however, and is not of concern. I really dont care about that. My concern is getting the query to work and displaying the datagrid. I can tweak html later if necessary.

    I'm afraid this is more complicated than an extra bracket. This very same query works fine when I run it in SQL Server Management Studio directly against the database. For whatever reason, it doesnt like the line below.

    sqlRead = sqlCmd.ExecuteReader()
  2. In Topic: Having problem reading from sql server view

    Posted 7 Oct 2013

    View Postybadragon, on 07 October 2013 - 09:31 AM, said:

    What is the error you get?


    SqlException was unhandled by user code (title bar of error in debug mode vs.net. "Incorrect syntax near ')'."

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

gns1497 hasn't added any friends yet.

Comments

gns1497 has no profile comments yet. Why not say hello?