Professional Web Applications Themes

How to the get to number of retrieved columns? - ASP.NET Data Grid Control

Hello everyone, i just implement an own search site in MS CRM 1.2, which searches in a MS-SQL database. My question is, how to get the number of retrieved columns by a SQL-query?? Any suggestions for me? Thx... Greets, Roman...

  1. #1

    Default How to the get to number of retrieved columns?

    Hello everyone,

    i just implement an own search site in MS CRM 1.2, which searches in a
    MS-SQL database.

    My question is, how to get the number of retrieved columns by a SQL-query??

    Any suggestions for me?

    Thx...


    Greets,

    Roman
    Roman Klimkowicz Guest

  2. #2

    Default Re: How to the get to number of retrieved columns?

    Roman Klimkowicz wrote:
    > i just implement an own search site in MS CRM 1.2, which searches in a
    > MS-SQL database.
    >
    > My question is, how to get the number of retrieved columns by a SQL-query??
    >
    > Any suggestions for me?
    Roman, I am not familiar with MS CRM at all, so this is a shot in the
    dark. There's basically two approaches you can use:

    (1) Run a SQL query to determine the number of results, i.e.:

    SELECT COUNT(*) FROM TableName WHERE ...


    (2) Once you have the data back in a DataTable or DataSet, use the
    apporpriate properties. For example, the DataTable's Rows collection
    has a Count property that specifies how many rows are contained in the
    DataTable. I'm not certain what ADO.NET object you are using to
    retrieve the data for CRM, so I don't know if this second approach will
    be helpful or not.

    Thanks

    --

    Scott Mitchell [ASP.NET MVP]
    [email]mitchell4GuysFromRolla.com[/email]
    [url]http://www.4GuysFromRolla.com/ScottMitchell[/url]
    Scott Mitchell [MVP] Guest

Similar Threads

  1. Restricting number of columns in grid
    By rahma123 in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: November 22nd, 11:14 AM
  2. How to get the number of retrieved columns when doing a SQL Query
    By Roman Klimkowicz in forum ASP.NET Data Grid Control
    Replies: 4
    Last Post: September 16th, 01:15 PM
  3. Variable number of columns -> problem Update Command
    By Radu Colceriu in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: March 2nd, 02:58 PM
  4. number of columns
    By atse in forum ASP
    Replies: 16
    Last Post: October 8th, 03:32 AM
  5. Unknow number of columns in repeater
    By Antonio Maciel in forum ASP.NET General
    Replies: 3
    Last Post: July 2nd, 09:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139