Database

Function LoadImage(ByVal PicSave As PictureBox) As Image

                   Dim arrayImage() As Byte = CType(dr.Item("DbFld"), Byte())
                   Dim ms As New MemoryStream(arrayImage)
                   LoadImage = Image.FromStream(ms)

               End If
           End While
           dr.Close()
           Return LoadImage


   End Function

SELECT * FROM Table
WHERE TimeOrder >= @StartOrder

UNION ALL

SELECT * FROM Table
WHERE TimeOrder < @StartOrder

SELECT Id, TimeValue, TimeOrder 
FROM
(
	SELECT Id, TimeValue, TimeOrder, 0 as result 
	FROM #data
	WHERE TimeOrder >= @StartOrder
	UNION ALL
	SELECT Id, TimeValue, TimeOrder, 1 
	FROM #data
	WHERE TimeOrder < @StartOrder
) as t
ORDER BY result ASC, TimeOrder asc

Pankaj18 wrote:

So, is there a way to insert the data in SQL.

// Update the demographics for a store, which is stored 
    // in an xml column. 
    string commandText = "UPDATE Sales.Store SET Demographics = @demographics "
        + "WHERE CustomerID = @ID;";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(commandText, connection);
        command.Parameters.Add("@ID", SqlDbType.Int);
        command.Parameters["@ID"].Value = customerID;

        // Use AddWithValue to assign Demographics.
        // SQL Server will implicitly convert strings into XML.
        command.Parameters.AddWithValue("@demographics", demoXml);

        try
        {
            connection.Open();
            Int32 rowsAffected = command.ExecuteNonQuery();
            Console.WriteLine("RowsAffected: {0}", rowsAffected);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
    }

I are Troll