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?
View 8 Replies
Similar Messages:
Jul 14, 2010
I'm have .dbml Linq to SQL class named DExamination.dbml
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Examination")]
public partial class Examination : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _Id;
private string _Title;
private System.Nullable<System.DateTime> _StartDate;
}
...
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_StartDate", DbType="DateTime")]
public System.Nullable<System.DateTime> StartDate
{
get
{
return this._StartDate;
}
set
{
if ((this._StartDate != value))
{
this.OnStartDateChanging(value);
this.SendPropertyChanging();
this._StartDate = value;
this.SendPropertyChanged("StartDate");
this.OnStartDateChanged();
}
}
}
...
Display in Edit
<%: Html.TextBoxFor(model => model.Examination.StartDate)%>
How to format StartDate like "dd/MM/yyyy" I've tried add DisplayFormat above
[global::System.ComponentModel.DataAnnotations.DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_StartDate", DbType="DateTime")]
public System.Nullable<System.DateTime> StartDate
{
get
{
return this._StartDate;
}
set
{
if ((this._StartDate != value))
{
this.OnStartDateChanging(value);
this.SendPropertyChanging();
this._StartDate = value;
this.SendPropertyChanged("StartDate");
this.OnStartDateChanged();
}
}
}
but not working Anyone have solution?
View 3 Replies
Oct 5, 2010
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
View 1 Replies
Apr 7, 2010
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 ..
View 6 Replies
Sep 7, 2010
I need to check the datetime field in my DB to see if the time that's current set is 12hr's past?What's the command to use? Can I just DATEDIFF?
View 4 Replies
Aug 31, 2010
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.
Search condition looks like this:-
it.[MyDate]='8/13/2010 00:00:00'
View 2 Replies
May 11, 2010
I have two fields i.e. StartDate(Datetime) and duration(number)., I am trying following
row["Inspection Time"] = result["StartDate"] + result["Duration"];
View 6 Replies
Nov 28, 2010
I am trying to use ActionLink with routeValues & htmlAttributes
[Code]....
View 3 Replies
Jan 27, 2010
Don't understand htmlAttributes parameters? try this:
[Code]....
[Code]....
How to correct?
[Code]....
View 11 Replies
Sep 18, 2010
I am getting an error message:Conversion from string "mm/dd/yyyy" to type 'Integer' is not valid.
What is best way to format date filed from datatable without showing the time?
ClosingDate is smalldatetime in my SQL DB.
[Code]....
View 2 Replies
Dec 24, 2010
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>?;";
View 2 Replies
Jul 23, 2010
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.
View 10 Replies
Oct 1, 2010
Using SQL Server 2005.
I need to return the year only from a datetime field and then group by that field, does anyone know the syntax for this?
View 2 Replies
May 17, 2010
I have a sharepoint datetime control named date. Now how can i check whether the the field is empty or not;
i have the following code
if(date.ToString() != "")
{
lbl.Text = "Not Empty";
}
i did not enter any date in that field but the above code is always executed.
it always have the current date.
How can i assgin empty string to selectedDate propert of Sharepoint DateTime Control?
View 4 Replies
Dec 23, 2015
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:
<div class="col-md-3">
<strong>Date Submitted to TDI</strong><br />
<asp:TextBox ID="sub_tdi_dt" runat="server" Enabled="true"></asp:TextBox>
<asp:ImageButton ID="sub_tdi_dt_cal_popup" Enabled="false" ImageUrl="Images/calendar.png" ImageAlign="Bottom" runat="server" />
<ajaxToolkit:CalendarExtender runat="server" BehaviorID="sub_tdi_dt_CalendarExtender" PopupButtonID="sub_tdi_dt_cal_popup" TargetControlID="sub_tdi_dt" ID="sub_tdi_dt_CalendarExtender"></ajaxToolkit:CalendarExtender> </div>
I have tried using the following in Page_Load, but it doesn't work - I still get '1/1/1900':
DateTime? sub_tdi_dt = null;
View 1 Replies
Nov 27, 2010
i have one data base field called CreatedDate whos Type is DateTime. Let say i have following Data in this Field
10/7/2010 12:07:57 PM
10/7/2010 12:09:14 PM
10/8/2010 01:02:34 AM
now if i pass date 10/7/2010 to my above table i'll not get any record. what is the best way to query only date portion of DateTime field
View 7 Replies
May 20, 2010
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.
[Code]....
View 3 Replies
Nov 9, 2010
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.
View 2 Replies
Apr 10, 2010
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 .
View 5 Replies
May 16, 2010
I want to filter a datetime field for a date without the time...
I want all fields that contain the selected date regardless of the time.
What should I use as the filter expression?
View 2 Replies
Aug 2, 2010
Could someone giving me the correct T-SQL query to update the Date part from a DateTime field?
To be more clear:
In my table i have 3 Columns, (all are DateTimes):
1. Date
2. StartingHour
3. EndingHour
This is for example one record:
2004-01-26 00:00:00.000
View 1 Replies
Nov 12, 2010
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.
View 1 Replies
Jun 2, 2010
MVC 1.0 source has code like
[Code]....
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.
What should I be using in custom helpers?
View 2 Replies
Jan 29, 2014
My work is done properly all good with this query
View 1 Replies
Jan 13, 2010
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.
<asp:TemplateField HeaderText="Publish Date" SortExpression="PublishDate">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("PublishDate") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("PublishDate") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
View 4 Replies
