String was not recognized as a valid DateTime in asp.net [Resolved]

pls change the function order

filldate();----->1st
fillgrid();------>2nd

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

what is your Label1.Text value?

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

my Label1.value is

2012-04-03 22:44:42.000

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Are you getting error on line no 83..?

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

please go through the code and u get idea,


datetime in Label1 from db, compare the date of Label1(last_datetime) in gridview and View records after the Label1(last_datetime) datetime.

please correct the code,

string CommandText = "SELECT DATE_FORMAT(calldate,'%Y%-%m-%d %H:%I:%s.000') as calldate,userfield FROM data WHERE calldate BETWEEN '" + last_datetime + "' And CURDATE() Order By calldate desc limit 20";


1: filled date in Label1.text in page loag

SqlDataAdapter da = new SqlDataAdapter("select top 1 calldate from data", con);
DataTable dt = new DataTable();
da.Fill(dt);

if (dt.Rows.Count > 0)
{
Label1.Text = String.Format("{0:yyyy-MM-dd HH:mm:ss.fff }", Convert.ToDateTime(dt.Rows[0][0].ToString()));




public void fillgrid()
{
DateTime last_datetime = Convert.ToDateTime(Label1.Text);


string ConnectionString = @"driver={MySQL ODBC 3.51 Driver};server=" + ServerName + ";database=" + databasename + ";uid=" + UserName + "; pwd= " + password + "; ";

string CommandText = "SELECT DATE_FORMAT(calldate,'%Y%-%m-%d %H:%I:%s.000') as calldate,userfield FROM data WHERE calldate BETWEEN '" + last_datetime + "' And CURDATE() Order By calldate desc limit 20";


OdbcConnection myConnection = new OdbcConnection(ConnectionString);
OdbcCommand myCommand = new OdbcCommand(CommandText, myConnection);

myConnection.Open();

GridView1.DataSource = myCommand.ExecuteReader();
GridView1.DataBind();

myConnection.Close();
}


please give the solution for this.

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

why can't you try this to convert and compare date

SELECT * FROM data WHERE cast(calldate as datetime) > '" + last_datetime + "

or

SELECT cast(calldate as datetime) as calldate,userfield FROM data WHERE calldate BETWEEN '" + last_datetime + "' And CURDATE() Order By calldate desc limit 20";

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

i used breakpoint,

DateTime last_datetime = Convert.ToDateTime(Label1.Text);

my first problem is, if i checked ,display last_datetime is " "
but normally
my Label1.value is

2012-04-03 22:44:42.000

string CommandText = "SELECT DATE_FORMAT(calldate,'%Y%-%m-%d %H:%I:%s.000') as calldate,userfield FROM data WHERE calldate BETWEEN '" + last_datetime + "' And CURDATE() Order By calldate desc limit 20";

please give the solution.

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

sorry..Thats not possible..it should display "2012-04-03 22:44:42.000"

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

please give any other solution.

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

pls attach your .cs file..

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

database and examples and i attached csfile


please give the solution.

thanks.
 Download source file

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

Have you got solution?

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

yes , i already rectified that problem,



thank you so much for your help.

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

This is my code
Textboxdata :6/14/2013
I am getting following ERROR:String was not recognized as a valid DateTime.
SqlParameter validUntil = new SqlParameter("@ValidUntil", SqlDbType.Date);
validUntil.Value = DateTime.ParseExact(TextBox2.Text.ToString(), "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);

cmd.Parameters.Add(validUntil);

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

tHIS IS MY CODE
I am inserting date value to database
My database column datatype Date

SqlParameter validUntil = new SqlParameter("@ValidUntil", SqlDbType.Date);
//validUntil.Value = TextBox2.Text.ToString();
validUntil.Value = Convert.ToDateTime(TextBox2.Text.ToString());
cmd.Parameters.Add(validUntil);
I am getting error like this:::String was not recognized as a valid DateTime in asp.net

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator

hi

try this

DateTime date;
string FrDt = "";
if (DateTime.TryParseExact(TxtFr.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out date))
FrDt = date.ToString("yyyy/MM/dd");
}

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Dn2010, if this helps please login to Mark As Answer. | Alert Moderator