ASP.NET

Trying to use ASP.NET Custom validator for conditional validation

9-Dec-13 13:08

Take a look at Thatja's solution[^].

I found this with a simple search query on Google, try doing some research before asking a question.

Never underestimate the power of human stupidity
RAH

Member 104518047-Dec-13 13:06

Member 10451804

7-Dec-13 13:06

Hello,

I have a radio button list control on my ASP.NET web form for selecting the payment method (Credit Card, Cheque or Cash),

And a credit card detail submission area for entering the credit card details if the user chose Credit Card as the payment method.
The credit card detail entering area has a radio button list control for selecting Credit Card type (AMEX, Master or VISA), a text box for entering the credit card number and a drop down list for selecting the credit card expiry month as shown below

ASP.NET

<!-- Radio button list control for selecting the payment method -->

<asp:RadioButtonList ID="rdPaymentMethod" runat="server">
     <asp:ListItem Value="CC"> Credit Card</asp:ListItem>
     <asp:ListItem Value="Cheque"> Cheque</asp:ListItem>
     <asp:ListItem Value="Cash"> Cash / Other</asp:ListItem>
</asp:RadioButtonList>


<!-- Credit card details entering area -->

<asp:RadioButtonList ID="rdCCType" runat="server">
     <asp:ListItem Value="AMEX"> American Express</asp:ListItem>
     <asp:ListItem Value="Master"> Master Card</asp:ListItem>
     <asp:ListItem Value="VISA"> VISA</asp:ListItem>
</asp:RadioButtonList>


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


<asp:DropDownList ID="ddlCCExpiryMonth" runat="server">
     <asp:ListItem Selected="True">Month</asp:ListItem>
     <asp:ListItem Value="01">01</asp:ListItem>
     <asp:ListItem Value="02">02</asp:ListItem>
     <asp:ListItem Value="03">03</asp:ListItem>
     <asp:ListItem Value="04">04</asp:ListItem>
     <asp:ListItem Value="05">05</asp:ListItem>
     <asp:ListItem Value="06">06</asp:ListItem>
     <asp:ListItem Value="07">07</asp:ListItem>
     <asp:ListItem Value="08">08</asp:ListItem>
     <asp:ListItem Value="09">09</asp:ListItem>
     <asp:ListItem Value="10">10</asp:ListItem>
     <asp:ListItem Value="11">11</asp:ListItem>
     <asp:ListItem Value="12">12</asp:ListItem>
</asp:DropDownList>

I am trying to validate my webform so that,

IF and ONLY IF the user select the first option (Credit Card) for payment type,

Then the user must ALSO select the credit card type (rdCCType), then enter credit card number (txtCCNumber) and also select credit card expiry month (ddlCCExpiryMonth)

I have absolutely no idea how to accomplish this and where to start.

Please show me how to do this using ASP.NET validation controls.

Thank you.

Re: Trying to use ASP.NET Custom validator for conditional validation

jkirkerx7-Dec-13 13:38

jkirkerx

7-Dec-13 13:38

You make validation groups, and assign the controls in the credit card code to use the validation group for it. Then assign the submit button that triggers the validation group with the same group.

Example:
http://www.aspsnippets.com/Articles/Validate-Multiple-Validation-Groups-with-one-Button-in-ASPNet.aspx[^]

modified 8-Dec-13 18:50pm.

Re: Trying to use ASP.NET Custom validator for conditional validation

joginder-banger12-Dec-13 6:26

joginder-banger

12-Dec-13 6:26

you can make the validation group in every radio button and also with in Drop down list.
IF you when submit button click check the every validation group, if any validation throw false your button not working.
I hope Validation Group help solve your problem.

Sql and asp.net

Otekpo Emmanuel7-Dec-13 11:28

7-Dec-13 11:28

Hello friends! Please I need your help over this issue. I have asp.net application using sql as backend. In my database, I have two fields(authorName and txtbkTitle) In this application, authors can insert as many textbooks as they want into the database provided the authors name remains unchanged (i.e if John Kyle is an author, all the textbooks he will save, will have John Kyle as their author's name). I know how to search the database for a specific textbook but this is not the way I want it. What I want is that, when the author enter his/her name, all textbooks written by that author should be displayed and bind to datalist control leaving the other authors textbooks behind. Sample codes, links will be welcome. Thanks in advance!!!

Mycroft Holmes7-Dec-13 12:39

7-Dec-13 12:39

You need to decide when you are going to start looking for the books, after the first character, after 2 or 3 characters or when the user presses the search button.

The search requires a round trip to the database and the volume returned will cause a delay, depends on your database size.

Your query would probably look something like

SQL

Select ID,Title,FirstName, Surname from vwBookAuthor where Surname like 'K%' or FirstName like 'K%'

Once you have that from the database you simply filter it in your codebehind or pass the list to the client and filter it based on further input. If the latency on 1 character is too big then wait for 2 or 3 characters to begin the search.

Never underestimate the power of human stupidity
RAH

Otekpo Emmanuel9-Dec-13 12:13

9-Dec-13 12:13

Thanks Mycroft, your reply was helpful. But it only retrieved one record, and I suggest that if I can bind the results found to a datalist, then everything will display. This is what I have tried so far:
Dim cn As new SqlDatasource
Sub Connect()
Try
If cn.State = Data.ConnectionState.Open Then cn.Close()
cn.ConnectionString =ConfigurationManager.ConnectionStrings("infoConnectionString").ConnectionString
cn.Open()
Catch ex As Exception
End Try
End Sub
Protected Sub btnlogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnlogin.Click
Connect()
Dim cmd As New SqlCommand
cmd.Connection = cn
cmd.CommandText = "select * from Bkstbl where Author like txtauthor.Text and Password=@Password
cmd.Parameters.AddWithValue("@author", txtauthor.Text)
cmd.Parameters.AddWithValue("@Password",txtpassword.Text)
Dim dr As SqlDataReader = cmd.ExecuteReader cmd.Parameters.Clear()
If dr.HasRows = True Then
'the aim of this code is to display only the textbooks written by the author
Datalist1.DataSource=dr("Txtbooks")
Datalist1.DataBind
dr.Close()
Else
dr.Close()
Msgbox("Invalid author name or password")
End If
End If
when I clicked on the search button, an error will show. This is the error that shown: InvalidOperationException unhandled user code.
For futher explanation, what I want is; taking for example John has 10 textbooks and James has 6 textbooks stored in database, when John wants to retrieve his textbooks from database, only his textbooks should display on the datalist excluding James textbooks(note: all textbooks saved by John, will have the same author name). Sorry if the request is too big, but please help me out, I am stuck...

Mycroft Holmes9-Dec-13 13:01

9-Dec-13 13:01

Your question indicates a complete lack of knowledge of SQL. I suggest you get a book on SQL or at least some tutorials and work through them to get a basic grounding on the subject otherwise you are going to spend all your time on forums asking simple questions that a little learning will solve for you.

Never underestimate the power of human stupidity
RAH

Otekpo Emmanuel10-Dec-13 11:01

10-Dec-13 11:01

Yes Mycoft, you were right. I don't have to ask questions on forum all the time. But guess what, I congratulate you for saying something that got me thinking and now, I'm proud to generate my own six lines of code to search and display all records of a specific query. Guess what again, this time, I did it on my own without any search or reading of books. Once again, thanks alot!!! But one more thing and I hope you will tell me this time because I have tried but couldn't figure it out. My connection string is Data source=Emmanuel\Okugbe;Initial Catalog=info; user ID=sa; Password=pwd"
when I copied this application to another system, there was build error. Now the question is, how can I modify my web.config and my datasource(connection string) so that it can run in all systems without making any changes in that system? Please help!!!

Solved: Sql and asp.net

Otekpo Emmanuel16-Dec-13 4:46

How to catch up a HTML Control in code?

16-Dec-13 4:46

Yeap, I got it. Thanks Holmes

Member 104545925-Dec-13 3:52

5-Dec-13 3:52

For instance for a HTML control:

HTML

<img  id="img1" src="Images/.../1.jpg" alt="Tile #1" />

How to catch up the img1 in C# code (e.g. img1.src = "xxx";)? Thanks if you can provide your hint.

thatraja5-Dec-13 4:20

thatraja

5-Dec-13 4:20

Did you try Google?
HtmlImage Server Control Declarative Syntax[^]

thatraja

Code converters | Education Needed | Plans

Member 104545925-Dec-13 4:32

5-Dec-13 4:32

I want to catch up the control in C# (e.g. image1.src = "xxxx";). Thanks.

thatraja5-Dec-13 4:35

thatraja

5-Dec-13 4:35

Member 10447319 wrote:
I want to catch up the control in C# (e.g. image1.src = "xxxx";).

That link also with C# code, Re-check.

thatraja

Code converters | Education Needed | Plans

Mycroft Holmes6-Dec-13 13:21

6-Dec-13 13:21

thatraja wrote:
Re-check

Now there is a major assumption!

Never underestimate the power of human stupidity
RAH

Member 104545929-Dec-13 1:42

9-Dec-13 1:42

Thanks. Solved already.

Member 104545929-Dec-13 1:43

9-Dec-13 1:43

Thanks. Solved.

ZurdoDev6-Dec-13 10:18

ZurdoDev

6-Dec-13 10:18

You need to put runat="server" on the tag if you want to access it in C#.

There are only 10 types of people in the world, those who understand binary and those who don't.