none
RE: multiple grid population from clicking on a grid RRS feed

  • Question

  • I am getting this error:

     

    An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

    Additional information: System error.

     

    When I click on the “DG_items” grid.

    The “DG_items” grid should populate 5 more grids. I could not get past the 2nd grid because of the error.

    Here are the details:

    1. This is the table where the 1st grid gets populated from:

    Field

    Type

    Length

    RowID

    bigint

    8

    ItemCode

    char

    10

    Start_Date

    datetime

    8

    End_Date

    datetime

    8

    SellingPrice

    money

    8

    CreateDate

    datetime

    8

    UpdateDate

    datetime

    8

    LastUser

    char

    8

    2. This is the StoredProcedure of the 1st grid:

    CREATE PROCEDURE ItemPriceHist_Show

    @ItemCode varchar(10)

    as

    SELECT   P.Rowid,

             P.ItemCode, rtrim(P.ItemCode) +'--'+ I.ItemDesc [ItemDesc],

             P.Start_Date, P.End_Date, P.SellingPrice,

             P.CreateDate, P.UpdateDate, P.LastUser

     

    FROM   NewScores..ItemPrice P

           LEFT OUTER JOIN NewScores..Item I on P.ItemCode = I.ItemCode

               

    WHERE  P.ItemCode = @ItemCode

     

    ORDER BY I.ItemDesc

    GO

    3. This is the table where the 2nd grid gets populated from:

     

    Monday, December 17, 2007 7:43 AM