Latkoski

gridview c#

Jun 16th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 3.63 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data.SqlClient;
  8. using System.Configuration;
  9. using System.Data;
  10.  
  11. public partial class Pregled : System.Web.UI.Page
  12. {
  13.     List<string> lista;
  14.     protected void Page_Load(object sender, EventArgs e)
  15.     {
  16.         if (!IsPostBack)
  17.         {
  18.             ispolniCustomers();
  19.         }
  20.  
  21.        
  22.     }
  23.  
  24.     protected void ispolniCustomers()
  25.     {
  26.         SqlConnection konekcija = new SqlConnection();
  27.         konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["mojaKonekcija"].ConnectionString;
  28.         string sqlString = "SELECT * FROM Customers";
  29.         SqlCommand komanda = new SqlCommand(sqlString, konekcija);
  30.         SqlDataAdapter adapter = new SqlDataAdapter(komanda);
  31.         DataSet ds = new DataSet();
  32.  
  33.         try
  34.         {
  35.             konekcija.Open();
  36.             adapter.Fill(ds);
  37.             gvCustomers.DataSource = ds;
  38.             gvCustomers.DataBind();
  39.             ViewState["dataset"] = ds;
  40.  
  41.          
  42.         }
  43.         catch(Exception err)
  44.         {
  45.             lblPoraka.Text = err.Message;
  46.         }
  47.         finally
  48.         {
  49.             konekcija.Close();
  50.         }
  51.  
  52.     }
  53.  
  54.  
  55.  
  56.     protected void gvCustomers_PageIndexChanging(object sender, GridViewPageEventArgs e)
  57.     {
  58.         gvCustomers.SelectedIndex = -1;
  59.         gvCustomers.PageIndex = e.NewPageIndex;
  60.         DataSet ds = (DataSet)ViewState["dataset"];
  61.         gvCustomers.DataSource = ds;
  62.         gvCustomers.DataBind();
  63.         gvOrders.Visible = false;
  64.     }
  65.  
  66.  
  67.     protected void ispolniOrders()
  68.     {
  69.         SqlConnection konekcija = new SqlConnection();
  70.         konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["mojaKonekcija"].ConnectionString;
  71.         string sqlString = "SELECT Customers.CompanyName, Products.ProductName, Products.UnitPrice, Orders.OrderID, OrderDate FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN Products ON [Order Details].ProductID = Products.ProductID WHERE Customers.CustomerID=@CustomerID";
  72.         SqlCommand komanda = new SqlCommand(sqlString, konekcija);
  73.         komanda.Parameters.AddWithValue("@CustomerID", gvCustomers.DataKeys[gvCustomers.SelectedIndex].Value);
  74.         SqlDataAdapter adapter = new SqlDataAdapter(komanda);
  75.         DataSet ds = new DataSet();
  76.  
  77.         try
  78.         {
  79.             konekcija.Open();
  80.             adapter.Fill(ds);
  81.             gvOrders.DataSource = ds;
  82.             gvOrders.DataBind();
  83.             gvOrders.Visible = true;
  84.          
  85.         }
  86.         catch (Exception err)
  87.         {
  88.             lblPoraka.Text = err.Message;
  89.         }
  90.         finally
  91.         {
  92.             konekcija.Close();
  93.         }
  94.     }
  95.  
  96.     protected void gvCustomers_SelectedIndexChanged(object sender, EventArgs e)
  97.     {
  98.         ispolniOrders();
  99.     }
  100.  
  101.     protected void btnPayment_Click(object sender, EventArgs e)
  102.     {
  103.         if (gvOrders.SelectedIndex != -1)
  104.         {
  105.             string produkt = gvOrders.SelectedRow.Cells[2].Text;
  106.             if (Session["smetka"] == null)
  107.             {
  108.                 lista = new List<string>();
  109.                 lista.Add(produkt);
  110.                 Session["smetka"] = lista;
  111.             }
  112.             else
  113.             {
  114.                 lista = (List<string>)Session["smetka"];
  115.                 lista.Add(produkt);
  116.                 Session["smetka"] = lista;
  117.             }
  118.         }
  119.  
  120.         Response.Redirect("Payment.aspx");
  121.     }
  122. }
Add Comment
Please, Sign In to add comment