Comments by Love 2 code (Top 25 by date)

Hi, sure, there is an example with a DataGridView at cp:
http://www.codeproject.com/Tips/581869/Paging-DataGridView-in-Csharp-using-LINQ
hope that helps.

Hi, the ADOX.Catalog could be missing the property 'ActiveConnection', if you are sure, that you can use that property via late binding, you could add

OPTION STRICT OFF

on top of your code file.

You can store and load the image as a byte stream in the database. A possible column type for sql server would be varbinary.
Greets

Maybe you want to try >paging< - this technology gives you the data in defined blocks.

Hi,
the column gamesplayed is unknown at the old level, you can use another subselect:

SELECT NAME, gamesWon, gamesPlayed,
(gamesWon / gamesPlayed) AS winRatio
FROM
(
SELECT
g.gameName AS Name,
(SELECT COUNT(gw.gameId) FROM games gw WHERE g.gameResultOut = 1 AND g.gameWon = 1 AND gw.gameUserID = u.user_id) AS gamesWon,
COUNT(g.gameId) AS gamesPlayed
FROM
games g
INNER JOIN user u ON u.user_id = g.gameUserID
GROUP BY g.gameId, u.user_id
ORDER BY winRatio DESC
LIMIT 1
) t

Hi,
not exactly clear what you want to do. I guess you should use a 'Group By' clause And a 'HAVING' clause like 'HAVING SUM(clear_protect) != paid' .

Hi, you could always edit the fields directly in the datagrid.

Have you tried using an inner joins instead of the left joins?

Have you looked into bulk insert, and there might be another way look here:
http://stackoverflow.com/questions/4883376/how-to-bulk-insert-into-mysql-using-c-sharp

Hi,
an insert statement does not have a where clause, if you want to update existing data use an update statement like
UPDATE mytable SET LATTITUDE = 'abc', LONGITUDE = '123' WHERE CLIENTS_ID = 42;

Hi, the out of the box DateTimePicker control does not allow null values, so you could google for a nullable DateTimePicker control.

Hi,
you could create a Function and use it in the Join clause:

CREATE FUNCTION getOpeningDate (@closingDate datetime)
RETURNS datetime
AS
BEGIN
declare @openingDate datetime
SELECT @openingDate = MAX(pm_date)
FROM prtMonitor
WHERE pm_date < @closingDate
return @openingDate
End
GO

.....

JOIN @prtMonitor AS openMonitor
ON openMonitor.ID_prt = closeMonitor.ID_prt
AND openMonitor.pm_Date = getOpeningDate(closeMonitor.pm_Date)

.....

After inserting a row you can query the id of that new row with "SELECT ID = @@IDENTITY". You can then store this id together with the department in a list, so you can use it when inserting the employees.

You could try using comboBox2.SelectedText instead of comboBox2.SelectedItem, this gives you the id as Text.

Ah, just now I understood your question. Is it possible to store the sold units per date in the database instead of the available units, this would make your query quite easy.

You could 'Group By date' and use SUM(prt_price * (Opening-Closing)) AS TotalPrice as the second result column.

Make sure, that all users have read permission on the list.

If you could use the System.Data.Odbc.OdbcCOnnection to connect to your mysql DB, you could use an System.Data.Odbc.OdbcParameter. If that doesn't work, you need a 3rd party dll, to establish your mysql connection from .NET.

Hi,
i guess, you're digging too deep.
Try
Dim nod As XmlNode = xd.SelectSingleNode("/AdminTools/App")
Greets
T.