Hi first of all your code is not safe =)
You have opened it for SQL injections, so i strongly asking you to change sql statement to use sql parameters!!
That was one sugestions.
Another one, as far sa i understand, you don't even try to execute insert operation to DB, since SCon.ReadSql(Sql) -> performs read operation!!!
So change your code to:
try
{
con.Open();
Sql = "insert into BirthDayWish values(@p1,@p2,@p3,@p4,#p5)";
SqlCommand cmd = new SqlCommand(Sql, con);
cmd.Parameters.Add("@p1", SqlDbType.VarChar);
cmd.Parameters["@p1"].Value = txt_name.Text;
DateTime dt;
if(!DateTime.TryParse(FromDate.SelectedDateValue.ToString(),out dt))
{
cmd.Parameters.Add("@p2", SqlDbType.DateTime);
cmd.Parameters["@p2"].Value = dt;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception Ex1)
{
Response.Write(Ex1);
}