MVC :: Use TextBoxFor With A DateTime Field (in Particular - Add HtmlAttributes)?
Apr 9, 2010
I'm having a problem understanding how to use TextBoxFor with a DateTime field (in particular how to add htmlAttributes). MVC has helpfully scaffolded the following for me:
[Code]....
I now want to add an htmlAttribute to this, to make the rendered <input> element read-only, for example:
new {@readonly="true"} The problem I have, is that the MSDN documentation for TextBoxFor (see [URL] says only allows two arguments are allowed, the LINQ expression, and a dictionary or object containing the htmlAttributes. So I have two questions:
1. What is the role of "String.Format("{0:g}", Model.LastPolled)" in the scaffolded version? This obviously works, but doesn't seem to be an htmlAttribute.
2. How should I modify the scaffolded version so that the readonly attribute will be used?
Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
I retrieve the date & time from datetime field in sql using a reader:
[Code]....
This value returns e.g. 15/04/2010 8:00:00 but I would like to split the day value (15), month value (4) etc from the overall datetime value, so I can assign dropdowns with corresponding (preselected) day, hour selection ..I know the dropdown assignment process, but I can't get the datetime field/value split ..
I am using and EntityDateSource and I add where condition to filter the data at runtime and then bind the grid to the dataSource, but I am getting following error:-
The argument types 'Edm.DateTime' and 'Edm.String' are incompatible for this operation.
I want to fetch date from a datetime field, when i select this field in database i get the result as 'yyyy-mm-dd hh:mm:ss' i want the result to be like dd/mm/yyyy
I am developing website using ASP.net C# using Mysql.query i have made is:
//***to get next date string nextdatequery = "SELECT next_dt FROM testcase.heardt where fil_no=? and next_dt>?;";
how do i display a datefield field e.g. 07/27/2010 08:00:00 as Tuesday, July 27, 2010? (i want the time part but i couldnt find any fucntions that display the date in text mode?)
I am creating a SQL procedure and need to read the data back into a gridview in that format.
I have a textbox that I use to gather a date. I would like to have the database store a null if this field is left blank by the user when submitting. I am using the following on my aspx page:
I'm looping through an ArrayList and creating a column in a DataTable from each field. One of my fields is a DateTime field, and I've noticed that when I create the columns, it's being changed to a String, but I need it to still be a DateTime field for sorting. I'm trying to do this, but it's not quite working.
I've heard from a couple of different sources that when using HTML helpers in ASP.NET MVC2, one can create custom attributes with dashes in them (e.g. <a data-rowId="5">) by using an underscore in place of the dash, and when the HTML is written to the page the underscores will be replaced by dashes.
So, something like this:
<%= HtmlActionLink(Model.Name, "MyView", null, new {data_rowId = Model.id}) %>
should render as
<a data-rowId="0" href="myURL">Row Name</a>
But... it's not. I think that maybe this feature is only enabled in the MVC3 Beta preview (as it's mentioned in the MVC3 preview release notes), but this thread is about the same thing, and it's regarding MVC2.
I know I can use the other solution presented in that thread, but I'd rather not have to resort to using the dictionary if a more elegant solution exists.
how do i insert date and time together ? what is the format for this. i tried like this but its not working.
string startDtime = TextFromDate.Text + " " + Stime; sql_comm.Parameters.AddWithValue("@StartDate", DateTime.Parse(startDtime)); is this the right way ? dd/mm/yyy +" "+ 00:00 or i need to make a string that contain this : dd/mm/yyy00:00 its not writing any eror it just do nothing .
I have a date field in a typed dataset that created from database.
I get an NULL Value exception when I try to enter some null value. I am not able to set the Nullvalue property of the DateTime field in XSD to other value other than Throw Exception.
Was RouteValueDictionary intended for use with htmlAttributes? Is there an alternative? The only 'feature' RouteValueDictionary looks like its got is it has a constructor which accepts an object.
I need to format this date time into the format Day/Month/Year on the same template field.
I am avoiding doing this under SQL server because that will mean changing my data type in my dataset to string instead of data time which i do not want.
