[LinuxGold]

Is it possible to use DataGrid without ASP,PHP or etc, I'm running M$ SQL and MySQL. If so, where can I get started? I do not want to use Visual Studio, or any of memory hoggin' programs. I use stripped down html generated by ASP, created my own CSS for applications and a lot of stored procedures. I'm heavy on SQL and would like to use DataGrid for quick access between user and database.

It would be a good way for me to learn DataGrid technology itself and to optimize the way I deem appropriate.

[coderitr]

I've got a program that I wrote that uses an ADO data grid and does runtime binding to manage data in a MS SQL database. Is this the kind of thing you're trying to do?

[LinuxGold]

Originally Posted by coderitr

I've got a program that I wrote that uses an ADO data grid and does runtime binding to manage data in a MS SQL database. Is this the kind of thing you're trying to do?

Yep and to generate reports as well.

[coderitr]

So what's your question? I'm afraid I can't help with the reports (we use Crystal Reports) but I'll do what I can to help you with the datagrid stuff.

[LinuxGold]

SQL (Stored procedure)

SELECT 
	ErrorDate,
	Br.Brand,
	HL.B_order,
	HT.CODE AS 'Hold Type',
	ET.Description AS 'Error Type',
	HL.Comments AS 'Description of Error',
	CASE WHEN HL.Corr=0 Then 'N' ELSE 'Y' END AS Corrected,
	CASE WHEN HL.Hldremvd=0 THEN 'N' ELSE 'Y' END AS 'Hold Removed',
	HL.ONTID AS Operator,
	HL.RNTID AS Reviewer
FROM HoldsLog HL
LEFT JOIN HoldType HT ON HT.Id=HL.HoldID
LEFT JOIN Brands Br ON Br.ID=HL.BrandID
LEFT JOIN Errortypes ET ON ET.ID=HL.ErrorTypeID;

RESULT (delimited by |):

2005-07-29 00:00:00|Basic|246274988|COFN|Error in Name|Ralph s/b Paul|Y|Y|ToniDan|AshleEll
2005-07-28 00:00:00|Basic|246234077|COFN|Error in Name|Douglas s/b rhett|Y|Y|ChantCum|AshleEll

I would like to be able to change Hold Type, Brands or ErrorTypes in drop down menu, delete a record row or toggle Y/N (data 0/1) on Corrected and Hold removed in DataGrid. I do not have ASP.NET, only ASP.