Baza & c#

xardas je 31. dec 2010 ob 10:14 izjavil:

No, pa pojdimo lepo od začetka te naloge. Hvaležen bi bil vsakomur, ki bi nam pomagal dopolnit podatkovni model baze.

primer podatkovne baze

Page_Load ...
this.customersTableAdapter.Fill(this.dataSet1.Customers);
this.productsTableAdapter.FillByCustomerProducts(this.dataSet1.Products, DropDownList3.SelectedValue.ToString());

protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{     
    this.productsTableAdapter.FillByCustomerProducts(this.dataSet1.Products, DropDownList3.SelectedValue.ToString());
}

SELECT        Products.ProductID, Products.ProductName, Products.SupplierID, Products.CategoryID, Products.QuantityPerUnit, Products.UnitPrice, Products.UnitsInStock, 
                         Products.UnitsOnOrder, Products.ReorderLevel, Products.Discontinued, Customers.CustomerID, Orders.CustomerID AS Expr1, Orders.OrderID, 
                         [Order Details].ProductID AS Expr2, [Order Details].OrderID AS Expr3
FROM            Products INNER JOIN
                         [Order Details] ON Products.ProductID = [Order Details].ProductID INNER JOIN
                         Orders ON [Order Details].OrderID = Orders.OrderID INNER JOIN
                         Customers ON Orders.CustomerID = Customers.CustomerID
WHERE        (Customers.CustomerID = @customerID)

public partial class ImeP_Novo: System.Web.UI.Page
{
    DataSet1 dataSet1 = new DataSet1();
    DataSet1TableAdapters.CustomersTableAdapter customersTableAdapter = new DataSet1TableAdapters.CustomersTableAdapter();
    DataSet1TableAdapters.ProductsTableAdapter productsTableAdapter = new DataSet1TableAdapters.ProductsTableAdapter();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        this.customersTableAdapter.Fill(this.dataSet1.Customers);
        this.productsTableAdapter.FillByCustomerProducts(this.dataSet1.Products, DropDownList1.SelectedValue.ToString());
    
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.productsTableAdapter.FillByCustomerProducts(this.dataSet1.Products, DropDownList1.SelectedValue.ToString());
    }
}

SELECT ProductID, ProductName
FROM Products
WHERE Customers.CustomerID=@ AS stranka AND stranka=Orders.CustomerID
Orders.OrderID=[Order Details].OrderID AND 
[Order Details].ProductID=Products.ProductID

// Vaja 30
DataSet1 dataSet1 = new DataSet1();
DataSet1TableAdapters.ZnamkaTableAdapter
znamkaTableAdapter = new
DataSet1TableAdapters.ZnamkaTableAdapter();
// Dodajanje znamke v DataSet
dataSet1.Znamka.AddZnamkaRow(TextBox1.Text);
// Posodobitev podatkovne baze in prikaz uspeha
if (znamkaTableAdapter.Update(dataSet1) == 1)
{
TextBox1.Enabled = false;
Button1.Visible = false;
Label2.Text = "Znamka je bila dodana.";
}
else
{
Label2.Text = "Napaka! Znamka ni bila dodana.";
}