ברוכים הבאים לעולם של DOTnet בנושא: ASP.NET ו-ADO.NET, SQL בעמוד הזה יש צילומי מסך עם הסברים שלי בסרטון וידאו לכל צילום וצילום.
להלן סרטון וידאו עם הסבר לכל צילומי מסך שיש בעמוד הזה:
Let's create first XML document
So Catalog.ASPX will be:
Let's add button
Now let's change code
Now let's talk about SQL
Now Let's create in SQL Server Management new User!
For it need login for first time as Windows authorization.
Let's change SELECT:
SELECT [ProductID], [ProductName], [CategoryID], [UnitPrice] FROM [Products]
to
SELECT TOP 10 [ProductID], [ProductName], [CategoryID], [UnitPrice] FROM [Products]
We can see new product with ID 82 was added
Let's add manually in SQL Server Studio
Let's check
Now let's update product
For now we have product with ProductID=84
Let's check it
Let's do it manually in SQL Server Studio
Let's check it
Let's delete some product
Let's delete ProductId=84
Let's check it
Let's do it manually in SQL Server Studio
Let's delete ProductId=83
Let's check it
Now let's get: NameOfTheProduct & Price by ProductId
Let's select ProductId=76
Let's do it manually in SQL Server Studio
Let's get all products