How to validate the date already appered on gridview or not?

Question

Hai friends,

Im creating one application in that using jquery datepicker (calender) my input details are given below:

date:(calender)
from:(textbox)
to:(textbox)
remarks(textbox)
add(button)
after adding the details entire details ll show on Gridview's.

(Ex:
date:02-apr-13,
from:banglore,
to:pune
apply(add)
the details ll show on GridView,now if im choose same in calender ll show error mess" already the date was appeared".)
how to validate the input date and already appread on gridview

Rocky Rocky · Answer

Hai friends I got the answer which is bool readerHasRows = false; string depdate = Datepicker.Text; string commandQuery = "SELECT departuredate FROM onward_journey WHERE departuredate= @depdate"; using (SqlCommand cmd = new SqlCommand(commandQuery, conn)) { conn.Open(); cmd.Parameters.AddWithValue("@depdate", Datepicker.Text); using (SqlDataReader reader = cmd.ExecuteReader()) { // bool initialized above is set here readerHasRows = (reader != null && reader.HasRows ); //&& reader >Datepicker); } } if (readerHasRows) { //email exists in db do something Response.Write(" alert('Departure Date Already Exists!!') "); } else { string sql = "insert into onward_journey(departuredate,from_place,to_place) values(@departuredate,@from,@to)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@departuredate", Datepicker.Text); cmd.Parameters.AddWithValue("@from", TxtFm.Text); cmd.Parameters.AddWithValue("@to", TxtTo.Text); } }