Click here to Skip to main content
15,899,026 members
Search within:


how can add dynamically row in datalist without post back
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
ASP.NET
dear all
how can add dynamically row in datalist without post back
Posted
Add a Solution
Comments
Herman<T>.Instance 15-Jul-11 9:16am    
use javascript

4 solutions

This is a great example that i have used once.It is using jquery to add a row dynamically without post back :

http://dotnetunplugged.com/2010/02/02/asp-net-gridview-edit-records-using-jquery-dialog/[^]

in this article they are adding to gridview.But it does not differ that much to do it for datalist.Just follow the instructions.

Good luck !
 
Share this answer
 
Posted
Comments
Tech Code Freak 19-Jan-12 8:17am    
5up!
XML
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:Button ID="btnsaveinfo" runat="server" Text="Save info" OnClick="btnsaveinfo_Click"
                Visible="false" />
        </div>
        <div>
            <asp:GridView ID="Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false"
                GridLines="None">
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <table>
                                <tr>
                                    <td>
                                        <asp:Label ID="Label1" runat="server" Text="Qualification"></asp:Label>
                                    </td>
                                    <td>
                                        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
                                </tr>
                                <tr>
                                    <td>
                                        <asp:Label ID="Label2" runat="server" Text="Batch"></asp:Label>
                                    </td>
                                    <td>
                                        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
                                </tr>
                                <tr>
                                    <td>
                                        <asp:Label ID="Label3" runat="server" Text="Branch"></asp:Label>
                                    </td>
                                    <td>
                                        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td>
                                </tr>
                                <tr>
                                    <td>
                                        <hr />
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                        <FooterStyle HorizontalAlign="Right" />
                        <FooterTemplate>
                            <asp:Button ID="ButtonAdd" runat="server" OnClick="ButtonAdd_Click" Text="Add New Row" />
                            <asp:LinkButton ID="LinkButton1" Visible="false" runat="server" OnClick="LinkButton1_Click">Remove</asp:LinkButton>
                        </FooterTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
        </div>
        <div>
            <table>
                <asp:GridView ID="gvqualification" runat="server" AutoGenerateColumns="false">
                    <Columns>
                        <asp:TemplateField HeaderText="Qualification">
                            <ItemTemplate>
                                <%# Eval("qualification")%>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="Batch">
                            <ItemTemplate>
                                <%# Eval("batch")%>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="Branch">
                            <ItemTemplate>
                                <%# Eval("branch")%>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
            </table>
        </div>
        <div>
            <asp:LinkButton ID="lnkshowall" runat="server" OnClick="lnkshowall_Click" Text="Show All"></asp:LinkButton>
        </div>
    </form>
</body>
</html>


-----------Code File (.cs)------------

C#
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["MyConnection"].ToString());
    SqlCommand cmd = new SqlCommand();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ViewState["PreviousTable"] = null;
            SetInitialRow();
        }
    }
    private void SetInitialRow()
    {
        DataTable dt = new DataTable();
        DataRow dr = null;
        dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));
        
        dt.Columns.Add(new DataColumn("Column1", typeof(string)));
        dt.Columns.Add(new DataColumn("Column2", typeof(string)));
        dt.Columns.Add(new DataColumn("Column3", typeof(string)));

        dt.Columns.Add(new DataColumn("Column4", typeof(string)));
        dt.Columns.Add(new DataColumn("Column5", typeof(string)));
        dt.Columns.Add(new DataColumn("Column6", typeof(string)));

        dr = dt.NewRow();
        
        dr["Column1"] = string.Empty;
        dr["Column2"] = string.Empty;
        dr["Column3"] = string.Empty;

        dr["Column4"] = "Qualification";
        dr["Column5"] = "Branch";
        dr["Column6"] = "Batch";
        
        dt.Rows.Add(dr);
        //dr = dt.NewRow();
        //Store the DataTable in ViewState

        ViewState["CurrentTable"] = dt;
        Gridview1.DataSource = dt;
        Gridview1.DataBind();
    }

    private void SetPreviousDB()
    {
        int rowIndex = 0;
        if (ViewState["PreviousTable"] != null)
        {
            DataTable dt = (DataTable)ViewState["PreviousTable"];
            if (dt.Rows.Count > 0)
            {
                Response.Write(Gridview1.Rows.Count);
               
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
                    TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
                    TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");

                    Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
                    Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
                    Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");

                    box1.Text = dt.Rows[i]["qualification"].ToString();
                    box2.Text = dt.Rows[i]["batch"].ToString();
                    box3.Text = dt.Rows[i]["branch"].ToString();

                    lbl4.Text = "Qualification";
                    lbl5.Text = "Branch";
                    lbl6.Text = "Batch";

                    rowIndex++;
                }
            }
        }
        DataTable dt1 = (DataTable)ViewState["PreviousTable"];
        if (dt1.Rows.Count > 1)
        {
            //GridView1.FooterRow.FindControl("txtFooter1") as TextBox;
            LinkButton LinkButton1 = Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
            LinkButton1.Visible = true;
        }
    }
    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++)
                {
                    TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
                    TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
                    TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");

                    Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
                    Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
                    Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");

                    box1.Text = dt.Rows[i]["Column1"].ToString();
                    box2.Text = dt.Rows[i]["Column2"].ToString();
                    box3.Text = dt.Rows[i]["Column3"].ToString();

                    lbl4.Text = "Qualification";
                    lbl5.Text = "Branch";
                    lbl6.Text = "Batch";

                    rowIndex++;
                }
            }
        }
        DataTable dt1 = (DataTable)ViewState["CurrentTable"];
        if (dt1.Rows.Count > 1)
        {
            //GridView1.FooterRow.FindControl("txtFooter1") as TextBox;
            LinkButton LinkButton1= Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
            LinkButton1.Visible = true;
        }
    }
    private void AddNewRowToGrid()
    {
        int rowIndex = 0;

        if (ViewState["PreviousTable"] != null)
        {
            DataTable dtCurrentTable = (DataTable)ViewState["PreviousTable"];
            DataRow drCurrentRow = null;
            if (dtCurrentTable.Rows.Count > 0)
            {
                for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
                {
                    //extract the TextBox values
                    TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
                    TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
                    TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");

                    Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
                    Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
                    Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");

                    drCurrentRow = dtCurrentTable.NewRow();

                    dtCurrentTable.Rows[i - 1]["qualification"] = box1.Text;
                    dtCurrentTable.Rows[i - 1]["batch"] = box2.Text;
                    dtCurrentTable.Rows[i - 1]["branch"] = box3.Text;

                    dtCurrentTable.Rows[i - 1]["qualification1"] = "Qualification";
                    dtCurrentTable.Rows[i - 1]["batch1"] = "Branch";
                    dtCurrentTable.Rows[i - 1]["branch1"] = "Batch";

                    rowIndex++;
                }
                dtCurrentTable.Rows.Add(drCurrentRow);
                ViewState["PreviousTable"] = dtCurrentTable;

                Gridview1.DataSource = dtCurrentTable;
                Gridview1.DataBind();
                SetPreviousDB();
            }
        }
        else 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++)
                {
                    //extract the TextBox values
                    TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
                    TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox2");
                    TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox3");

                    Label lbl4 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label1");
                    Label lbl5 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label2");
                    Label lbl6 = (Label)Gridview1.Rows[rowIndex].Cells[0].FindControl("Label3");

                    drCurrentRow = dtCurrentTable.NewRow();
                    
                    dtCurrentTable.Rows[i - 1]["Column1"] = box1.Text;
                    dtCurrentTable.Rows[i - 1]["Column2"] = box2.Text;
                    dtCurrentTable.Rows[i - 1]["Column3"] = box3.Text;

                    dtCurrentTable.Rows[i - 1]["Column4"] = "Qualification";
                    dtCurrentTable.Rows[i - 1]["Column5"] = "Branch";
                    dtCurrentTable.Rows[i - 1]["Column6"] = "Batch";

                    rowIndex++;
                }
                dtCurrentTable.Rows.Add(drCurrentRow);
                ViewState["CurrentTable"] = dtCurrentTable;

                Gridview1.DataSource = dtCurrentTable;
                Gridview1.DataBind();
                //Set Previous Data on Postbacks
                SetPreviousData();
              }
        }
        else
        {
            Response.Write("ViewState is null");
        }             
    }
    protected void ButtonAdd_Click(object sender, EventArgs e)
    {
        AddNewRowToGrid();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        LinkButton lb = (LinkButton)sender;
        GridViewRow gvRow = (GridViewRow)lb.NamingContainer;
        int rowID = gvRow.RowIndex + 1;
        if (ViewState["PreviousTable"]!=null)
        {
            DataTable dt = (DataTable)ViewState["PreviousTable"];
            if (dt.Rows.Count > 1)
            {
                if (gvRow.RowIndex < dt.Rows.Count - 1)
                {
                    //Remove the Selected Row data
                    dt.Rows.Remove(dt.Rows[dt.Rows.Count-1]);
                }
            }
            ViewState["PreviousTable"] = dt;
            //Re bind the GridView for the updated data
            Gridview1.DataSource = dt;
            Gridview1.DataBind();
            int rowIndex = 0;
            foreach (GridViewRow row in Gridview1.Rows)
            {
                TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
                TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
                TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;

                TextBox1.Text = dt.Rows[rowIndex]["qualification"].ToString();
                TextBox2.Text = dt.Rows[rowIndex]["batch"].ToString();
                TextBox3.Text = dt.Rows[rowIndex]["branch"].ToString();
                rowIndex++;
            }
            if (dt.Rows.Count > 1)
            {
                LinkButton LinkButton1 = Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
                LinkButton1.Visible = true;
            }
        }
        else if (ViewState["CurrentTable"] != null)
        {
            DataTable dt = (DataTable)ViewState["CurrentTable"];
            if (dt.Rows.Count > 1)
            {
                if (gvRow.RowIndex < dt.Rows.Count - 1)
                {
                    //Remove the Selected Row data
                    dt.Rows.Remove(dt.Rows[dt.Rows.Count-1]);
                }
            }
            ViewState["CurrentTable"] = dt;
            //Re bind the GridView for the updated data
            Gridview1.DataSource = dt;
            Gridview1.DataBind();
            int rowIndex = 0;
            foreach (GridViewRow row in Gridview1.Rows)
            {
                TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
                TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
                TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;

                TextBox1.Text = dt.Rows[rowIndex]["Column1"].ToString();
                TextBox2.Text = dt.Rows[rowIndex]["Column2"].ToString();
                TextBox3.Text = dt.Rows[rowIndex]["Column3"].ToString();
                rowIndex++;
            }
            if (dt.Rows.Count > 1)
            {
                LinkButton LinkButton1 = Gridview1.FooterRow.FindControl("LinkButton1") as LinkButton;
                LinkButton1.Visible = true;
            }
        }
    }
    protected void btnsaveinfo_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in Gridview1.Rows)
        {
            TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
            TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
            TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;

            con.Open();
            cmd.Connection = con;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "insert into qualification values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "') ";
            cmd.ExecuteNonQuery();
            con.Close();
        }
        BindGrid();
    }
    private void BindGrid()
    {
        DataTable dt = new DataTable();
        con.Open();
        cmd.Connection = con; ;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "select * from qualification";
        cmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(cmd);

        da.Fill(dt);

        if (dt.Rows.Count > 0)
        {
            gvqualification.DataSource = dt;
            gvqualification.DataBind();
        }
        else
        {
            gvqualification.DataSource = null;
            gvqualification.DataBind();
        }        
        con.Close();
    }
    protected void lnkshowall_Click(object sender, EventArgs e)
    {
        int rowIndex = 0;
        DataTable dt = new DataTable();
        con.Open();
        cmd.Connection = con; ;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "select qualification,batch,branch,qualification1,batch1,branch1 from qualification";
        cmd.ExecuteNonQuery();
        SqlDataAdapter da = new SqlDataAdapter(cmd);

        da.Fill(dt);

        if (dt.Rows.Count > 0)
        {
            Gridview1.DataSource = dt;
            Gridview1.DataBind();

            foreach (GridViewRow row in Gridview1.Rows)
            {
                TextBox TextBox1 = row.FindControl("TextBox1") as TextBox;
                TextBox TextBox2 = row.FindControl("TextBox2") as TextBox;
                TextBox TextBox3 = row.FindControl("TextBox3") as TextBox;

                TextBox1.Text = dt.Rows[rowIndex]["qualification"].ToString();
                TextBox2.Text = dt.Rows[rowIndex]["batch"].ToString();
                TextBox3.Text = dt.Rows[rowIndex]["branch"].ToString();
                rowIndex++;
            }
            ViewState["PreviousTable"] = dt;
        }
        else
        {
            Gridview1.DataSource = null;
            Gridview1.DataBind();
        }
        con.Close();
    }


-----------------Create Table for this program-----------------------
SQL
CREATE TABLE qualification
(
	id int IDENTITY(1,1) NOT NULL,
	qualification varchar(100) ,
	batch [varchar](50) ,
	branch [varchar](50) ,
	qualification1 [varchar](50) ,
	batch1 [varchar](50) ,
	branch1 [varchar](50) 
)
 
Share this answer
 
Posted
Updated 19-Jan-12 0:29am
v3
Comments
Anuja Pawar Indore 19-Jan-12 6:30am    
Added proper pre tag
Tech Code Freak 19-Jan-12 8:10am    
5up for complete guidance!
prefer this link for autocomplete search

http://www.aspsnippets.com/Articles/Using-jQuery-AutoComplete-Plugin-in-ASP.Net.aspx[^]
 
Share this answer
 
Posted
v2
Comments
Tech Code Freak 19-Jan-12 8:09am    
Great link for AutoComplete!
(still the question differs :) anyways, 5up!)
you can do it using jquery .


$("#DataList1"> tbody:last").append("<tr><td>Item value...</td></tr>");
 
Share this answer
 
Posted
Comments
Tech Code Freak 19-Jan-12 8:10am    
5up!
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
avoiding post back on datalist dynamic paging
how to add rows in grdview dynamically gridview in datalist control
Gridview and Datalist
How to dynamically add rows to a gridview through a datatable without affecting any table?
How can I limited the datalist rows
Dynamic controls getting lost after post back
How can I add a bitmap to toolbar without using code
Add picture boxes dynamically in row
How To Add Gridview Rows Dynamically
Error in dynamically added datalist in asp.net

Advertise
Privacy
Cookies
Terms of Use
Last Updated 19 Jan 2012
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-05-14:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900