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

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

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("");
                }

                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);
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rocky Rocky13y ago
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("");
                }

                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);
}
}