Check Data Before Adding New Row [Answered]RSS

3 replies

Last post Nov 15, 2019 04:12 AM by samwu

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

Gopi.MCA

Member

202 Points

477 Posts

Check Data Before Adding New Row

Nov 13, 2019 05:01 PM|Gopi.MCA|LINK

Hello

This is my aspx code

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="TESTFile.aspx.cs" Inherits="TESTFile" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <asp:gridview ID="Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false">

        <Columns>

        <asp:BoundField DataField="RowNumber" HeaderText="Row Number" />

        <asp:TemplateField HeaderText="Belongs">

            <ItemTemplate>

                <asp:DropDownList ID="D1" runat="server">
                                 <asp:ListItem Text="AA"></asp:ListItem>
                                 <asp:ListItem Text="BB"></asp:ListItem>
                                 </asp:DropDownList>

            </ItemTemplate>

        </asp:TemplateField>
        
        <asp:TemplateField HeaderText="Item Code">
                                 <ItemTemplate>
                                    <asp:TextBox ID="TextBox1" runat="server" Text='C004'></asp:TextBox>
                                </ItemTemplate>
                                  
        </asp:TemplateField>
                            
                            

        <asp:TemplateField HeaderText="Enter AA Data">

            <ItemTemplate>

                <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

            </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Enter BB Data">

            <ItemTemplate>

                 <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

            </ItemTemplate>

            <FooterStyle HorizontalAlign="Right" />

            <FooterTemplate>

             <asp:Button ID="ButtonAdd" runat="server" Text="Add New Row" />

            </FooterTemplate>

        </asp:TemplateField>

        </Columns>

</asp:gridview>
</asp:Content>

This is my code behind

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Specialized;
using System.Text;
using System.Drawing;
using System.IO;
using System.Net;
using System.Net.Mail;
using System.Net.Configuration;
public partial class TESTFile : System.Web.UI.Page
{


    private void SetInitialRow()
    {

        DataTable dt = new DataTable();

        DataRow dr = null;

        dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));

        dt.Columns.Add(new DataColumn("Column0", 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)));

        dr = dt.NewRow();

        dr["RowNumber"] = 1;

        dr["Column0"] = string.Empty;

        dr["Column1"] = string.Empty;

        dr["Column2"] = string.Empty;

        dr["Column3"] = string.Empty;

        dt.Rows.Add(dr);

        //dr = dt.NewRow();



        //Store the DataTable in ViewState

        ViewState["CurrentTable"] = dt;



        Gridview1.DataSource = dt;

        Gridview1.DataBind();

    }


    private void AddNewRowToGrid()
    {

        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++)
                {

                    //extract the TextBox values

                    DropDownList box0 = (DropDownList)Gridview1.Rows[rowIndex].Cells[1].FindControl("D1");

                    TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("TextBox1");

                    TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("TextBox2");

                    TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3");



                    drCurrentRow = dtCurrentTable.NewRow();

                    drCurrentRow["RowNumber"] = i + 1;



                    dtCurrentTable.Rows[i - 1]["Column0"] = box0.Text;

                    dtCurrentTable.Rows[i - 1]["Column1"] = box1.Text;

                    dtCurrentTable.Rows[i - 1]["Column2"] = box2.Text;

                    dtCurrentTable.Rows[i - 1]["Column3"] = box3.Text;



                    rowIndex++;

                }

                dtCurrentTable.Rows.Add(drCurrentRow);

                ViewState["CurrentTable"] = dtCurrentTable;



                Gridview1.DataSource = dtCurrentTable;

                Gridview1.DataBind();

            }

        }

        else
        {

            Response.Write("ViewState is null");

        }



        //Set Previous Data on Postbacks

        SetPreviousData();

    }


    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 box0 = (DropDownList)Gridview1.Rows[rowIndex].Cells[1].FindControl("D1");

                    TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("TextBox1");

                    TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[3].FindControl("TextBox2");

                    TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3");



                    box0.Text = dt.Rows[i]["Column0"].ToString();

                    box1.Text = dt.Rows[i]["Column1"].ToString();

                    box2.Text = dt.Rows[i]["Column2"].ToString();

                    box3.Text = dt.Rows[i]["Column3"].ToString();



                    rowIndex++;

                }

            }

        }

    }


    protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {

            SetInitialRow();

        }


    }

    protected void ButtonAdd_Click(object sender, EventArgs e)
    {

        AddNewRowToGrid();

    }

}

on page run

1) if user select AA data from dropdownlist and missed entering number in BBdata column textbox i want to show alert "You have selected BB but you have not entered any data in BB data textbox please enter data" make empty to that textbox so that user can enter data again

2) Same if user select BB data from dropdownlist and missed entering number in AA data column textbox i want to show alert "You have selected AA but you have not entered any data in AA data textbox please enter data" make empty to that textbox so that user can enter data again

How to do so using javascript or jquery without postback

Thanking You

samwu

Contributor

2180 Points

872 Posts

Re: Check Data Before Adding New Row

Nov 14, 2019 10:55 AM|samwu|LINK

Hi Gopi.MCA,

Gopi.MCA

1) if user select AA data from dropdownlist and missed entering number in BBdata column textbox i want to show alert "You have selected BB but you have not entered any data in BB data textbox please enter data" make empty to that textbox so that user can enter data again

2) Same if user select BB data from dropdownlist and missed entering number in AA data column textbox i want to show alert "You have selected AA but you have not entered any data in AA data textbox please enter data" make empty to that textbox so that user can enter data again

How to do so using javascript or jquery without postback

If you want without postback, you can put the button in the updatepanel control.

The code:

<script>
        function pageLoad() {
            $("#Gridview1_ButtonAdd").click(function () {
                if ($("#Gridview1_D1_0").val() == "AA" & $("#Gridview1_TextBox2_0").val().length == 0) {
                    alert("You have selected AA but you have not entered any data in AA data textbox please enter data");
                    $("#Gridview1_TextBox3_0").val('');

                }
                else if ($("#Gridview1_D1_0").val() == "BB" & $("#Gridview1_TextBox3_0").val().length == 0) {
                    alert("You have selected BB but you have not entered any data in BB data textbox please enter data");
                    $("#Gridview1_TextBox2_0").val('');
                }
            });
        };
    </script>

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <asp:GridView ID="Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="RowNumber" HeaderText="Row Number" />
                <asp:TemplateField HeaderText="Belongs">
                    <ItemTemplate>
                        <asp:DropDownList ID="D1" runat="server">
                            <asp:ListItem Text="AA"></asp:ListItem>
                            <asp:ListItem Text="BB"></asp:ListItem>
                        </asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateField>

                <asp:TemplateField HeaderText="Item Code">
                    <ItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='C004'></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>

                <asp:TemplateField HeaderText="Enter AA Data">
                    <ItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>

                <asp:TemplateField HeaderText="Enter BB Data">
                    <ItemTemplate>
                        <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                    </ItemTemplate>
                    <FooterStyle HorizontalAlign="Right" />
                    <FooterTemplate>
                        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                            <ContentTemplate>
                                <asp:Button ID="ButtonAdd" runat="server" Text="Add New Row"/>
                            </ContentTemplate>
                        </asp:UpdatePanel>
                        
                    </FooterTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>

The result:

Best regards,

sam

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

- Reply
Gopi.MCA
Member

202 Points

477 Posts

Re: Check Data Before Adding New Row

Nov 14, 2019 06:28 PM|Gopi.MCA|LINK

Hello

Javascript not working from my side

Can we have using Code behind C# on button click check

Thanking You

samwu

Contributor

2180 Points

872 Posts

Re: Check Data Before Adding New Row

Nov 15, 2019 04:12 AM|samwu|LINK

Hi Gopi.MCA,

Gopi.MCA
Javascript not working from my side

Can you tell me what problems have you encountered by using Javascript?

Gopi.MCA
Can we have using Code behind C# on button click check

If you want do that in code behind, you can try to below code:

  <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
            <ContentTemplate>
                <asp:GridView ID="Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false">
                    <Columns>
                        <asp:BoundField DataField="RowNumber" HeaderText="Row Number" />
                        <asp:TemplateField HeaderText="Belongs">
                            <ItemTemplate>
                                <asp:DropDownList ID="D1" runat="server">
                                    <asp:ListItem Text="AA"></asp:ListItem>
                                    <asp:ListItem Text="BB"></asp:ListItem>
                                </asp:DropDownList>
                            </ItemTemplate>
                        </asp:TemplateField>

                        <asp:TemplateField HeaderText="Item Code">
                            <ItemTemplate>
                                <asp:TextBox ID="TextBox1" runat="server" Text='C004'></asp:TextBox>
                            </ItemTemplate>
                        </asp:TemplateField>

                        <asp:TemplateField HeaderText="Enter AA Data">
                            <ItemTemplate>
                                <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                            </ItemTemplate>
                        </asp:TemplateField>

                        <asp:TemplateField HeaderText="Enter BB Data">
                            <ItemTemplate>
                                <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                            </ItemTemplate>
                            <FooterStyle HorizontalAlign="Right" />
                            <FooterTemplate>
                                <asp:Button ID="ButtonAdd" runat="server" Text="Add New Row" OnClick="ButtonAdd_Click" />
                            </FooterTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
            </ContentTemplate>
        </asp:UpdatePanel>


protected void ButtonAdd_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < Gridview1.Rows.Count; i++)
            {
                DropDownList ddl = (DropDownList)Gridview1.Rows[i].FindControl("D1");
                TextBox Ta = (TextBox)Gridview1.Rows[i].FindControl("TextBox2");
                TextBox Tb = (TextBox)Gridview1.Rows[i].FindControl("TextBox3");
                if (ddl.Text == "AA" & Ta.Text == "")
                {

                    ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You have selected AA but you have not entered any data in AA data textbox please enter data');", true);
                    Tb.Text = null;
                    return;
                }
                else if (ddl.Text == "BB" & Tb.Text == "")
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('You have selected BB but you have not entered any data in BB data textbox please enter data');", true);
                    Ta.Text = null;
                    return;
                }


            }
            AddNewRowToGrid();
        }

The result:

Best regards,

sam

‹ Previous Thread|Next Thread ›