<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<asp:HiddenField ID="hdnDeptcode" runat="server" />
<asp:HiddenField ID="hdnFlag" runat="server" />
Dept Name
<asp:TextBox ID="txtDeptname" runat="server" Enabled="False"></asp:TextBox>
&nbsp; Dept Short Name
<asp:TextBox ID="txtDeptshortname" runat="server" Enabled="False"></asp:TextBox>
&nbsp; Company Name
<asp:DropDownList ID="ddlCocode" runat="server" DataSourceID="SqlDataSource1"
    DataTextField="coname" DataValueField="cocode" Enabled="False">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
    SelectCommand="SELECT cocode, coname FROM company UNION SELECT NULL AS Expr1, '---Select ----' AS Expr2 ORDER BY cocode">
</asp:SqlDataSource>

        <asp:GridView ID="GridView1" runat="server" ShowFooter="True" AutoGenerateColumns="False"
             Style="text-align: left" Enabled="False"
         onrowdeleting="GridView1_RowDeleting" Width="40%" >
            <Columns>
                <asp:TemplateField HeaderText="SNo.">
                    <ItemTemplate>
                        <%# Container.DataItemIndex + 1 %>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Agenda Name">
                    <ItemTemplate>
                        <asp:DropDownList ID="ddlAgendacode" runat="server"
                            DataSourceID="SqlDataSource1" DataTextField="agendaname"
                            DataValueField="agendacode">
                            <asp:ListItem>Select</asp:ListItem>
                        </asp:DropDownList>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server"
                            ControlToValidate="ddlAgendacode" ErrorMessage="RequiredFieldValidator"
                            InitialValue="Select"></asp:RequiredFieldValidator>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                            ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
                            SelectCommand="SELECT agendacode, agendaname FROM agenda UNION SELECT NULL AS Expr1, '---Select ----' AS Expr2 ORDER BY agendacode">
                        </asp:SqlDataSource>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:Button ID="ButtonAdd" runat="server"
                            Text="Add New Row" onclick="ButtonAdd_Click" />
                    </FooterTemplate>
                    <FooterStyle HorizontalAlign="Right" />
                </asp:TemplateField>
                <asp:CommandField ShowDeleteButton="True" />
            </Columns>
        </asp:GridView>

    <asp:Button ID="btnNew" runat="server" onclick="btnNew_Click"
    Text="New" />
    <asp:Button ID="btnSave" runat="server" Text="Save" Enabled="False"
    onclick="btnSave_Click"  />
    <asp:Button ID="btnDelete" runat="server" Enabled="False" Text="Delete"
    onclick="btnDelete_Click" />
    <asp:Button ID="btnEdit" runat="server" Enabled="False" Text="Edit"
    onclick="btnEdit_Click" />

</asp:Content>

namespace ReportingSystemasp
{
public partial class gridmultiple : System.Web.UI.Page
{
       SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            FirstGridViewRow();
        }
    }
    private void FirstGridViewRow()
    {
        DataTable dt = new DataTable();
        DataRow dr = null;
        dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
        dt.Columns.Add(new DataColumn("Col1", typeof(string)));

        dr = dt.NewRow();
        dr["RowNumber"] = 1;
        dr["Col1"] = string.Empty;
        dt.Rows.Add(dr);

        ViewState["CurrentTable"] = dt;

        GridView1.DataSource = dt;
        GridView1.DataBind();

        if (Session["flag"] == "2")
        {
            txtDeptname.Enabled = true;
            txtDeptshortname.Enabled = true;
            ddlCocode.Enabled = true;
            GridView1.Enabled = true;
            btnDelete.Enabled = true;
            btnEdit.Enabled = true;
            btnSave.Enabled = true;
            hdnFlag.Value = Session["flag"].ToString();
            CommandField cf = new CommandField();
            cf.ButtonType = ButtonType.Button;
            cf.ShowEditButton = true;
            GridView1.Columns.Add(cf);
            GridView1.DataBind();

            string deptcode = Request.QueryString["deptcode"];
            conn.Open();

            SqlCommand cmd = new SqlCommand(@"select * from dept1 WHERE deptcode=@deptcode", conn);
            SqlDataAdapter dadapter = new SqlDataAdapter();
            dadapter.SelectCommand = cmd;
            cmd.Parameters.Add(new SqlParameter("@deptcode", deptcode));
            SqlDataReader dr1 = cmd.ExecuteReader();
            while (dr1.Read())
            {
                hdnDeptcode.Value = dr1["deptcode"].ToString();
                txtDeptname.Text = dr1["deptname"].ToString();
                txtDeptshortname.Text = dr1["deptshortname"].ToString();
                ddlCocode.SelectedValue = dr1["cocode"].ToString();

            }
            dr1.Close();
            SqlCommand cmd1 = new SqlCommand("Select * from dept2 where deptcode="+ deptcode, conn);
            SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
            DataSet ds1 = new DataSet();
            da1.Fill(ds1);
            int count = ds1.Tables[0].Rows.Count;
            conn.Close();
            if (ds1.Tables[0].Rows.Count > 0)
            {
                GridView1.DataSource = ds1;
                GridView1.DataBind();
            }
            else
            {
                ds1.Tables[0].Rows.Add(ds1.Tables[0].NewRow());
                GridView1.DataSource = ds1;
                GridView1.DataBind();

            }

            conn.Close();
        }


        DropDownList ddl = (DropDownList)GridView1.Rows[0].Cells[1].FindControl("ddlAgendacode");
        ddl.Focus();
        Button btnAdd = (Button)GridView1.FooterRow.Cells[1].FindControl("ButtonAdd");
        Page.Form.DefaultFocus = btnAdd.ClientID;

    }
    private void AddNewRow()
    {
        int rowIndex = 0;
        if (ViewState["CurrentTable"] != null)
        {
            DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
            DataRow drCurrentRow = null;
            if (dtCurrentTable.Rows.Count > 0)
            {
                for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
                {

                    DropDownList ddlAgendacode = (DropDownList)GridView1.Rows[rowIndex].Cells[1].FindControl("ddlAgendacode");
                    drCurrentRow = dtCurrentTable.NewRow();
                    drCurrentRow["RowNumber"] = i + 1;

                    dtCurrentTable.Rows[i - 1]["Col1"] = ddlAgendacode.SelectedValue;
                    rowIndex++;
                }
                dtCurrentTable.Rows.Add(drCurrentRow);
                ViewState["CurrentTable"] = dtCurrentTable;

                GridView1.DataSource = dtCurrentTable;
                GridView1.DataBind();

                DropDownList ddl = (DropDownList)GridView1.Rows[rowIndex].Cells[1].FindControl("ddlAgendacode");
                ddl.Focus();
                // txn.Focus;
            }
        }
        else
        {
            Response.Write("ViewState is null");
        }
        SetPreviousData();

        if (hdnFlag.Value == "2")
        {
            hdnFlag.Value = "4";
            Session["flag"] = hdnFlag.Value;
        }
    }
    private void SetPreviousData()
    {
        int rowIndex = 0;
        if (ViewState["CurrentTable"] != null)
        {
            DataTable dt = (DataTable)ViewState["CurrentTable"];
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    DropDownList ddlAgendacode = (DropDownList)GridView1.Rows[rowIndex].Cells[1].FindControl("ddlAgendacode");
                    // drCurrentRow["RowNumber"] = i + 1;
                    GridView1.Rows[i].Cells[0].Text = Convert.ToString(i + 1);
                    ddlAgendacode.SelectedValue = dt.Rows[i]["Col1"].ToString();
                    rowIndex++;
                }
            }
        }
    }

    protected void ButtonAdd_Click(object sender, EventArgs e)
    {
        AddNewRow();
    }

    private void SetRowData()
    {
        int rowIndex = 0;

        if (ViewState["CurrentTable"] != null)
        {
            DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
            DataRow drCurrentRow = null;
            if (dtCurrentTable.Rows.Count > 0)
            {
                for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
                {

                    DropDownList ddlAgendacode = (DropDownList)GridView1.Rows[rowIndex].Cells[1].FindControl("ddlAgendacode");
                    drCurrentRow = dtCurrentTable.NewRow();
                    drCurrentRow["RowNumber"] = i + 1;
                    dtCurrentTable.Rows[i - 1]["Col1"] = ddlAgendacode.SelectedValue;
                    rowIndex++;
                }

                ViewState["CurrentTable"] = dtCurrentTable;
                //grvStudentDetails.DataSource = dtCurrentTable;
                //grvStudentDetails.DataBind();
            }
        }
        else
        {
            Response.Write("ViewState is null");
        }
        //SetPreviousData();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SetRowData();
        if (ViewState["CurrentTable"] != null)
        {
            DataTable dt = (DataTable)ViewState["CurrentTable"];
            DataRow drCurrentRow = null;
            int rowIndex = Convert.ToInt32(e.RowIndex);
            if (dt.Rows.Count > 1)
            {
                dt.Rows.Remove(dt.Rows[rowIndex]);
                drCurrentRow = dt.NewRow();
                ViewState["CurrentTable"] = dt;
                GridView1.DataSource = dt;
                GridView1.DataBind();

                for (int i = 0; i < GridView1.Rows.Count - 1; i++)
                {
                    GridView1.Rows[i].Cells[0].Text = Convert.ToString(i + 1);
                }
                SetPreviousData();
            }
        }
    }

    protected void btnSave_Click(object sender, EventArgs e)
    {
        conn.Open();
        SqlCommand cmd = new SqlCommand("Insert into dept1 (deptname,deptshortname,cocode ) values (@deptname,@deptshortname,@cocode)", conn);
        cmd.Parameters.AddWithValue("@deptname", txtDeptname.Text);
        cmd.Parameters.AddWithValue("@deptshortname", txtDeptshortname.Text);
        cmd.Parameters.AddWithValue("@cocode", ddlCocode.Text);
        cmd.ExecuteNonQuery();
        SqlCommand cmd1 = new SqlCommand(@"select max(deptcode) as deptcode from dept1", conn);
        SqlDataAdapter dadapter = new SqlDataAdapter();
        // HiddenField detpcode = new HiddenField();
        dadapter.SelectCommand = cmd1;
        // SqlDataReader dr = cmd1.ExecuteReader();
        string deptcode =hdnDeptcode.Value;
        cmd1.Parameters.Add(new SqlParameter("@deptcode", deptcode));
        SqlDataReader dr = cmd1.ExecuteReader();
        while (dr.Read())
        {
            hdnDeptcode.Value = dr["deptcode"].ToString();
        }
        dr.Close();

        SetRowData();
        DataTable table = ViewState["CurrentTable"] as DataTable;

        if (table != null)
        {
            foreach (DataRow row in table.Rows)
            {

                string ddlagenda = row.ItemArray[1] as string;


                if (ddlagenda != null)
                {
                        SqlCommand cmd2 = new SqlCommand("Insert into dept2(deptcode,agendacode) values (@deptcode,@agendacode)", conn);
                        cmd2.Parameters.AddWithValue("@deptcode", hdnDeptcode.Value);
                        cmd2.Parameters.AddWithValue("@agendacode", ddlagenda);
                        cmd2.ExecuteNonQuery();
                }

            }
        }
        btnSave.Enabled = false;
        conn.Close();

    }

    protected void btnNew_Click(object sender, EventArgs e)
    {
        txtDeptname.Enabled = true;
        txtDeptshortname.Enabled = true;
        ddlCocode.Enabled = true;
        GridView1.Enabled = true;
        btnDelete.Enabled = true;
        btnEdit.Enabled = true;
        btnSave.Enabled = true;
        hdnFlag.Value = "1";
        Session["flag"] = hdnFlag.Value;
    }

    protected void btnEdit_Click(object sender, EventArgs e)
    {
        hdnFlag.Value = "2";
        Session["flag"] = hdnFlag.Value;
        Response.Redirect("combo.aspx");

    }

    protected void btnDelete_Click(object sender, EventArgs e)
    {
        hdnFlag.Value = "3";
        Session["flag"] = hdnFlag.Value;
    }

}