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

Dim AD as New OdbcDAtaAdapter("SELECT ResumeID, Resumes From Professions", myConnection)

while (reader.Read())
           {
               c.ID = reader.GetInt32(0);
               c.Category.ID = reader.GetInt32(1);
               c.Subject = reader.GetString(2).Trim();
               c.Body = reader.GetString(3).Trim();
               c.SourceVideoClip = reader.GetString(4).Trim();
               c.StillImage = reader.GetString(5).Trim();
               c.Notes = reader.GetString(6).Trim();
               c.UploadTime = reader.GetDateTime(7);
               c.AdID = reader.GetInt32(8);
               c.ValidAfter = reader.GetDateTime(9);
               c.InvalidAfter = reader.GetDateTime(10);
               c.BillingCode = reader.GetInt32(11);
               c.Name= reader.GetString(12).Trim();
               c.Birth = reader.GetDateTime(13);
               c.Category.Name = reader.GetString(14);
           }