3 – ASP.NET & ADO.NET

ברוכים הבאים לעולם של 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