2
Answers

How to validate number in asending order in datatable column

Raja

Raja

8y
198
1
in data table particular column is have only ascending order numbers.this is strictly start from 1,2,3,4,5
 
i validate unique of the column but now i want to validate only start from 1 and ascending order if
data table row have 10 rows the number is 1,2,3,4,5,6,7,8,9,10. how to do it.
 
if (ds.Tables[s].Rows[2][2].ToString().Trim() == "")
{

}

This is my code for validate empty rows .please find the attachment 
Answers (2)
2
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 8y
Try like below:
  1. DateTime dateTimeObj = DateTime.ParseExact(tbxFromDate.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture);  
  2.   
  3. if (tbxFromDate.Value != "" && dateTimeObj > DateTime.Today)         
  4. {        
  5.        Messagebox.Show("From Date should be earlier or equal To Today Date", MessageHelper.MessageType.Warning);  
  6. }  
 
Accepted
2
Amresh S

Amresh S

NA 528 4.1k 8y
Hi Raja,
 
You have to parse the date value before validation. Use the below code:
  1. DateTime date = DateTime.ParseExact(this.myTextBox.Text, "dd/MM/yyyy"null);  
Here you can send the  text value entered by the user or a value picked up from your datePicker control. The next key thing is to format your Date to be parsed and if time doesn't bother you, pass the "null" value.
 
Hope this helps.
 
Regards,
Amresh S. 
1
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 8y
What is the value you are getting in tbxFromDate.Value?
0
Raja

Raja

NA 1.7k 45.2k 8y

Manas Mohapatra

Amresh S

Thank You so much!
0
Raja

Raja

NA 1.7k 45.2k 8y

Manas Mohapatra

22/11/2016