Connect to MSSQL and display SELECT query in datagridview
Budget: $10 – $30 USD
IMPORTANT: My budget is very limited
This task is super basic: Connect to MSSQL database and display a sample SELECT query results in a datagridview
You only have to connect to my MSSQL. Then fetch data with this query:
SELECT TOP (1000) [SiteID]
,[ResourceID]
,[ItemNmbr]
,[QtyOnHand]
,[StockDT]
FROM [AIMS].[dbo].[TrxDailyStock]
Then display it in a datagridview (attached image).
I will provide access to the VPS that has the database and also the C# project.
This task is super basic: Connect to MSSQL database and display a sample SELECT query results in a datagridview
You only have to connect to my MSSQL. Then fetch data with this query:
SELECT TOP (1000) [SiteID]
,[ResourceID]
,[ItemNmbr]
,[QtyOnHand]
,[StockDT]
FROM [AIMS].[dbo].[TrxDailyStock]
Then display it in a datagridview (attached image).
I will provide access to the VPS that has the database and also the C# project.