Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    Technologies

    Uploaded by

    indra
    This C# program uses .NET and SQL Server technologies to build an inventory control system. It displays a menu allowing the user to view, add, update, or delete inventory items stored in a database table. The ViewInventory method retrieves item data from the database and displays it. AddItem allows adding a new item by name and quantity via an INSERT query. DeleteItem deletes an item by ID with a DELETE query.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Technologies

    Uploaded by

    indra
    27 views4 pages
    This C# program uses .NET and SQL Server technologies to build an inventory control system. It displays a menu allowing the user to view, add, update, or delete inventory items stored in a database table. The ViewInventory method retrieves item data from the database and displays it. AddItem allows adding a new item by name and quantity via an INSERT query. DeleteItem deletes an item by ID with a DELETE query.

    Original Description:

    Original Title

    c#

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This C# program uses .NET and SQL Server technologies to build an inventory control system. It displays a menu allowing the user to view, add, update, or delete inventory items stored in a database table. The ViewInventory method retrieves item data from the database and displays it. AddItem allows adding a new item by name and quantity via an INSERT query. DeleteItem deletes an item by ID with a DELETE query.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    27 views4 pages

    Technologies

    Uploaded by

    indra
    This C# program uses .NET and SQL Server technologies to build an inventory control system. It displays a menu allowing the user to view, add, update, or delete inventory items stored in a database table. The ViewInventory method retrieves item data from the database and displays it. AddItem allows adding a new item by name and quantity via an INSERT query. DeleteItem deletes an item by ID with a DELETE query.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 4

    C# AND .

    NET
    TECHNOLOGIES
    using System;
    using System.Data;
    using System.Data.SqlClient;
    class InventoryControlSystem
    {
    sta c string connec on_String";

    sta c void Main()


    {
    DisplayMenu();
    }

    sta c void DisplayMenu()


    {
    while (true)
    {
    Console.WriteLine("1. View Inventory");
    Console.WriteLine("2. Add Item");
    Console.WriteLine("3. Update Item");
    Console.WriteLine("4. Delete Item");
    Console.WriteLine("5. Exit");

    Console.Write("Enter your choice: ");


    int choice = int.Parse(Console.ReadLine());

    }
    }

    sta c void ViewInventory()


    {
    using (SqlConnec on connec on = new SqlConnec on(connec onString))
    {
    connec on.Open();

    string query = "SELECT * FROM Inventory";


    SqlDataAdapter adapter = new SqlDataAdapter(query, connec on);

    DataSet dataSet = new DataSet();


    adapter.Fill(dataSet, "Inventory");

    DataTable table = dataSet.Tables["Inventory"];

    foreach (DataRow row in table.Rows)


    {
    Console.WriteLine($"ID: {row["ID"]}, Name: {row["Name"]}, Quan ty:
    {row["Quan ty"]}");
    }
    }
    }

    sta c void AddItem()


    {
    Console.Write("Enter item name: ");
    string name = Console.ReadLine();

    Console.Write("Enter quan ty: ");


    int quan ty = int.Parse(Console.ReadLine());

    using (SqlConnec on connec on = new SqlConnec on(connec onString))


    {
    connec on.Open();

    string query = "INSERT INTO Inventory (Name, Quan ty) VALUES (@Name,
    @Quan ty)";
    SqlCommand command = new SqlCommand(query, connec on);
    command.Parameters.AddWithValue("@Name", name);
    command.Parameters.AddWithValue("@Quan ty", quan ty);

    int rowsAffected = command.ExecuteNonQuery();

    if (rowsAffected > 0)
    Console.WriteLine("Item added successfully!");
    else
    Console.WriteLine("Failed to add item.");
    }
    }

    sta c void UpdateItem()


    {
    }

    sta c void DeleteItem()


    {
    Console.Write("Enter the ID of the item to delete: ");
    int itemId = int.Parse(Console.ReadLine());

    using (SqlConnec on connec on = new SqlConnec on(connec onString))


    {
    connec on.Open();

    string query = "DELETE FROM Inventory WHERE ID = @ID";


    SqlCommand command = new SqlCommand(query, connec on);
    command.Parameters.AddWithValue("@ID", itemId);

    int rowsAffected = command.ExecuteNonQuery();

    if (rowsAffected > 0)
    Console.WriteLine("Item deleted successfully!");
    else
    Console.WriteLine("Failed to delete item.");
    }
    }
    }

    You might also like