where clause not working with orded by

Modify your query such as,

here read is a variable so you passed its value like this way..

"Select * from callpad_def where read_status=" + read + "ORDER BY time_stamp DESC";

Thanks

Happy coding...

String readValue;
string sql1 = "Select * from callpad_def where read_status=@read ORDER BY time_stamp DESC";
                SqlCommand cmd = new SqlCommand(sql1, con);
                cmd.Parameters.AddWithValue("@read", readValue);
                SqlDataReader sqlReader = cmd.ExecuteReader();
                while (sqlReader.Read())
                {
                    c_address =Convert.ToInt32(sqlReader.GetValue(0).ToString());
                    c_status = sqlReader.GetValue(1).ToString();
                    token_no = (sqlReader.GetValue(2).ToString());
                    if (c_status != null)
                    {
                        status_reader(c_status);
                    }
                }
                sqlReader.Close();

var result = cdo.order_histories
.Where(oh => oh.order_id == 20119)
.OrderByDescending(oh => oh.date_inserted)
.Take(1)
.Select(oh => new {history = oh, order = oh.order}
.Single();




Kishor Makwana
Software Engineer
Insight Softech
www.insightsoftech.com