hi, how to validate gridview databound textbox value to check null and duplicate entry.

Question

0.00/5 (No votes)

See more:

Hi,
How to jquery validate gridview inside databound textbox value to check null and duplicate entry?

I am try this way:

how to loop to gridview have 15 records and to check only modulename not null and no duplicate modulename?

jquery:

C#

<head  runat="server">
<script type="text/jscript">
   $(document).ready(function () {
        function validate() {
            alert("please enter the module name1");

            //if ($(".validationClass" == ''))
            //    alert("please enter the module name3");
           //}


            var iVal = $('#gdvCRLevels_ctl03_txtModuleName').val();
                if (iVal == 0) {
                    alert("please enter 3");
            }


        });
    </script>
</head>

asp.net

C#

<table><tr>
<td id="tdRowGrid" style="width: 75pc" valign="top" align="center"  runat="server">
	<asp:GridView ID="gdvCRLevels" runat="server" BorderWidth="0px" CellPadding="3" CellSpacing="1"
		Visible="true" CssClass="DataGrid" OnRowDataBound="gdvCRLevels_RowDataBound"
		AllowPaging="false" AutoGenerateColumns="false" Width="100%" AlternatingRowStyle-CssClass="alternateItem">
		<RowStyle CssClass="NormalItem" VerticalAlign="Top" />
		<HeaderStyle CssClass="CellHeaderEven" HorizontalAlign="Left" />
		<PagerStyle CssClass="CellHeaderEven" HorizontalAlign="Center" />
		<Columns>
			<asp:BoundField DataField="Module Title">
				<ControlStyle Width="300px" />
				<HeaderStyle HorizontalAlign="Center" />
				<ItemStyle ForeColor="#009900" Font-Bold="True" />
			</asp:BoundField>
			<asp:BoundField DataField="CRModuleId"></asp:BoundField>
			<asp:TemplateField>
				<HeaderStyle HorizontalAlign="Center" />
				<ControlStyle Width="200px" />
				<ItemTemplate>
					<asp:TextBox ID="txtModuleName" runat="server" CssClass="validationClass" />
				</ItemTemplate>
			</asp:TemplateField>
			<asp:TemplateField>
				<HeaderStyle HorizontalAlign="Center" />
				<ControlStyle Width="300px" />
				<ItemTemplate>
					<asp:TextBox ID="txtReferenceCourseName" runat="server" />
				</ItemTemplate>
			</asp:TemplateField>
			<asp:TemplateField>
				<HeaderStyle HorizontalAlign="Center" />
				<ControlStyle Width="100px" />
				<ItemTemplate>
					<asp:TextBox ID="txtModuleCode" runat="server" />
				</ItemTemplate>
			</asp:TemplateField>
		</Columns>
	</asp:GridView>
</td></tr>
</table>

c#
.cs

C#

protected void gdvCRLevels_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //Variables
        if ((e.Row.RowType == DataControlRowType.Header) || (e.Row.RowType == DataControlRowType.DataRow))
        {
            e.Row.Cells[1].Visible = false;

            e.Row.Cells[0].Width = Unit.Percentage(200);
            e.Row.Cells[2].Width = Unit.Percentage(100);
            e.Row.Cells[3].Width = Unit.Percentage(200);
            e.Row.Cells[4].Width = Unit.Percentage(50);
        }
        if (e.Row.RowType == DataControlRowType.Header)
        {
            e.Row.Cells[0].Text = "Module Title";
            e.Row.Cells[2].Text = "Module Name";
            e.Row.Cells[3].Text = "Reference Course Name";
            e.Row.Cells[4].Text = "Module Code";
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            TextBox objtextBox1 = (TextBox)e.Row.Cells[2].FindControl("txtModuleName");
            objtextBox1.Text = DataBinder.Eval(e.Row.DataItem, "Module Name").ToString();

            TextBox objtextBox2 = (TextBox)e.Row.Cells[3].FindControl("txtReferenceCourseName");
            objtextBox2.Text = DataBinder.Eval(e.Row.DataItem, "Reference Course Name").ToString();

            TextBox objtextBox3 = (TextBox)e.Row.Cells[4].FindControl("txtModuleCode");
            objtextBox3.Text = DataBinder.Eval(e.Row.DataItem, "Module Code").ToString();
        }
    }

Thanks,
Karthikeyan,Bangalore

Posted 26-Mar-14 1:26am

pkarthionline

Updated 26-Mar-14 2:31am

v3

Add a Solution

Comments

ZurdoDev 26-Mar-14 8:57am

This is not clear at all. What is clear is you want to validate your values using jquery.

Look at the source html and see if all the fields you want to validate have something in common, for example, if they all have the same css class or start with a certain name, etc. Then you can use a jquery selector to get them all and use .each() to loop through them all.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-03-26T04:43:00

Solution 1

You have to loop through the Rows of GridView, which is rendered as a Table on Browser.

Then inside the loop, find the input fields containing txtModuleName in the ID attribute by Attribute Contains Selector [name*="value"][^].

JavaScript

var previousModuleName = new Array();
var count = 0;
previousModuleName[count] = "";

function validate() {
    $("#gdvCRLevels tr").each(function () {
        var txtModuleName = $(this).find("input[id*='txtModuleName']");

        if (txtModuleName.length > 0) {
            if (txtModuleName.val().length === 0) {
                alert("You must specify ModuleName");
            }

            if (jQuery.inArray(txtModuleName.val().toLowerCase(), previousModuleName) > -1) {
                alert("Duplicate Entry");
            }
        
            count++;
            previousModuleName[count] = txtModuleName.val().toLowerCase();
        }       
    });
}

Posted 26-Mar-14 4:43am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Updated 26-Mar-14 22:10pm

v4

Comments

pkarthionline 27-Mar-14 0:36am

thanks your helps.it' working good.
and how to check duplicate?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Mar-14 1:03am

What exactly you mean by duplicate? Can you explain with an example?

pkarthionline 27-Mar-14 2:08am

when i am saving (gridview) data should not duplicate.jquery code

example:

Module1
Module2
Module3
module2
module3
Module5
Module6
Module4

Here,

Module2,Module3 duplicate .when i am save time should display msg "duplicate entry"

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Mar-14 2:40am

Okay, check my updated Solution now. :)
Customize according to your requirements.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Mar-14 2:42am

Hold on. I am modifying it again. :)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Mar-14 2:49am

Please check the code now. Updated. Cheers. !!!

pkarthionline 27-Mar-14 3:38am

thanks Tadit Dash.

but get one more error

Module 1
module 1
module 2
Module 2

it is not show duplicate.
how can i check it both are duplicate.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Mar-14 4:11am

Okay, just use toLowerCase(). See updated solution. :)

pkarthionline 27-Mar-14 4:49am

thanks Tadit Dash, saved my life.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Mar-14 5:46am

Most welcome. My pleasure. :)

Please accept this answer, if it has helped you in any way.
This will help others to find the answer in one go and you will also be awarded with some points for this action...

Thanks,
Tadit

pkarthionline 27-Mar-14 7:09am

hi i have some changes extra can update our code

15 records in modulename columns

i am duplicate 5 new (5 old) so records 10 duplicate.error alert msg show 10 times.

note 1: i need to show 1 time only alert "You must specify ModuleName" .if no empty modulename then only show "Duplicate Entry".

note 2:
if alert msg show related control, text box show border color red color border.
example:

module 6 : is empty "You must specify ModuleName" [textbox6] should be red color border.
if enter value is duplicate
module 7 : is "duplicate entry" [textbox7] should be red color border.

save button click

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Mar-14 7:49am

Look, this is not the way we work here. We are here to guide you so that you resolve your issues and go forward. Now, you are just saying your requirements to me. I am not hired by you, am I? So, why should I write codes for you.

Don't misunderstand me. Time is important for everybody. I appreciate your requirements, but if you won't try anything at all and come here and ask me to do this for you, then I can't sorry.

As I have answered your query already, you can mark this as an answer. Let's stop this thread here.

I suggest you to work on your requirements and add more questions, if you face difficulties further in your code.

I hope you understand what I am pointing to.

Thanks,
Tadit