испит ит

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;


public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        GridView2.Visible = false;
        if (!IsPostBack) {
            ispolniGrid();

        }
    }

    protected void ispolniGrid()
    {
        SqlConnection konekcija = new SqlConnection();
        konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["mojaKonekcija"].ConnectionString;
        string SQLString = "Select * FROM Suppliers";
        SqlCommand komanda = new SqlCommand(SQLString, konekcija);
        SqlDataAdapter adapter = new SqlDataAdapter(komanda);
        DataSet ds = new DataSet();
        try {
            konekcija.Open();
            adapter.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            ViewState["dataset"] = ds;
            GridView2.Visible = false;
        }


        finally {
            konekcija.Close();
        }
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.SelectedIndex = -1;
        GridView1.PageIndex = e.NewPageIndex;
        DataSet ds = (DataSet)ViewState["dataset"];
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }


    protected void GridView1_PageIndexChanged(object sender, EventArgs e)
    {

    }


    protected void ispolniGrid1() {
        SqlConnection konekcija = new SqlConnection();
        konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["mojaKonekcija"].ConnectionString;
        string SqlString = "SELECT Products.ProductID, Suppliers.SupplierID, Products.ProductName, Products.UnitsInStock, Products.UnitPrice FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID = Products.SupplierID where Products.SupplierID = @SupplierID";
        SqlCommand komanda = new SqlCommand(SqlString, konekcija);
        komanda.Parameters.AddWithValue("@SupplierID", GridView1.DataKeys[GridView1.SelectedIndex].Value);
        SqlDataAdapter adapter = new SqlDataAdapter(komanda);
        DataSet ds = new DataSet();
        try
        {
            konekcija.Open();
            adapter.Fill(ds);
            GridView2.Visible = true;
            GridView2.DataSource = ds;
            GridView2.DataBind();
        }

        catch (Exception err) { }

        finally
        {
            konekcija.Close();
        }



    }


    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        ispolniGrid1();
    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        DataSet ds = (DataSet)ViewState["dataset"];
        GridView1.EditIndex = e.NewEditIndex;
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        DataSet ds = (DataSet)ViewState["dataset"];
        GridView1.EditIndex = -1;
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        SqlConnection konekcija = new SqlConnection();
        konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["mojaKonekcija"].ConnectionString;
        string sqlString = "UPDATE ContactName SET ContactName = @ContactName WHERE CompanyID = @CompanyID";
        SqlCommand komanda = new SqlCommand(sqlString, konekcija);

        TextBox tb = (TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0];
        komanda.Parameters.AddWithValue("@ContactName", tb.Text);


        int efekt = 0;
        try
        {
            konekcija.Open();
            efekt = komanda.ExecuteNonQuery();
        }
        finally
        {
            konekcija.Close();
            GridView1.EditIndex = -1;
        }
        if (efekt != 0)
        {
            ispolniGrid();
        }

    }

    protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
    {
        DataSet ds = (DataSet)ViewState["dataset"];
        GridView2.EditIndex = e.NewEditIndex;
        GridView2.DataSource = ds;
        GridView2.DataBind();
    }




    protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        SqlConnection konekcija = new SqlConnection();
        konekcija.ConnectionString = ConfigurationManager.ConnectionStrings["mojaKonekcija"].ConnectionString;
        string sqlString = "UPDATE Products SET ProductName = @ProductName WHERE ProductID = @ProductID";
        SqlCommand komanda = new SqlCommand(sqlString, konekcija);
        TextBox tb = (TextBox)GridView2.Rows[e.RowIndex].Cells[0].Controls[0];
        komanda.Parameters.AddWithValue("@ProductName", tb.Text);

        int count = 0;
        try
        {
            konekcija.Open();
            count = komanda.ExecuteNonQuery();
        }
        catch (Exception err) { }
        finally {
            konekcija.Close();
            GridView2.EditIndex = -1;
        }
        if (count != 0) {
            ispolniGrid1();
        }

    }



    protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        DataSet ds = (DataSet)ViewState["dataset"];
        GridView2.EditIndex = -1;
        GridView2.DataSource = ds;
        GridView2.DataBind();
    }
}