Database

'Fill the pending orders that belong to the order ID<br />
   Private Sub FillPendingOrders()<br />
       Try<br />
                     Me.TA_OrderDetails_dsCodeRed1.Fill(Me.DsAddComponetAndEquipment.OrderDetails)<br />
         <br />
           dv = New DataView(Me.DsAddComponetAndEquipment.OrderDetails)<br />
           dv.RowFilter = String.Format("Status = '{0}' AND OrderID = '{1}'", "Ordered", CInt(Me.cboPendingOrders.SelectedValue))<br />
           Me.dgvPendingOrders.AutoGenerateColumns = False<br />
           Me.bsOrderDetailsPending.DataSource = dv.ToTable()<br />
           Me.dgvPendingOrders.DataSource = Me.bsOrderDetailsPending<br />
       Catch ex As Exception<br />
           MsgBox(ex.Message)<br />
       End Try<br />
   End Sub

             Me.bsOrderDetailsPending.EndEdit()<br />
            Me.DsAddComponetAndEquipment.OrderDetails.Merge(DirectCast(Me.bsOrderDetailsPending.DataSource, DataTable), false)<br />
            'Just to check to see if the value is displayed in the source column. This displayed what I value i put into the source cell ok.<br />
            source = DirectCast(Me.bsOrderDetailsPending.Current, DataRowView)("Source").ToString()<br />
<br />
            Me.TA_OrderDetails_dsCodeRed1.Update(Me.DsAddComponetAndEquipment.OrderDetails)

CREATE PROCEDURE uspPaging
@nStartValue INT,
@nEndValue INT
AS
SET NOCOUNT ON

DECLARE @tblTempData TABLE
(
nID INT IDENTITY,
EmployeeID INT,
LastName VARCHAR(50),
FirstName VARCHAR(50),
SupervisorID NCHAR(5)
)

INSERT INTO @tblTempData
(
EmployeeID,
LastName,
FirstName,
SupervisorID
)
SELECT
EmployeeID,
LastName,
FirstName,
ReportsTo
FROM Employees
ORDER BY
EmployeeID,
FirstName

SELECT EmployeeID,
LastName,
FirstName,
SupervisorID
FROM @tblTempData
WHERE nID BETWEEN @nStartValue AND @nEndValue
ORDER BY
nID ASC