.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Insert Ignored When Time Field Populated (MaskedEditExtender & MaskedEditValidator)

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :ASP.Net

I have a C#/ASP.NET web application that utilizes the Entity Framework and pages with DetailsView controls that provide CRUD operations through EntityDataSource objects. The fields in the DetailsView control are template fields with various standard ASP.NET web controls. I have a table that contains various fields with different data types, including time(7). However, the controls for the time fields also have the AJAX MaskedEditExtender and MaskedEditValidator controls attached to them.

Everything works great, until a record is inserted where a value is specified for a time field. When that happens, it acts like it's inserting, posts back, executes statements, etc. but no record is inserted. No statement is sent to SQL (as seen by a SQL trace), no exception is thrown, nothing... it acts as if everything went perfectly, it just doesn't insert the record.

Since no exception is thrown and the code being executed is inside the EF, I'm kind of at a loss as to where to track this down. I have "Enable .NET Framework Source Stepping" enabled, but it doesn't step into the EF code. Can someone help?

View Complete Post

More Related Resource Links

How to insert the Current date and time in to SQL Table..

Hello Members,              I have create the table as per the following ..create table company(  empname varchar(30),  empid int,  joindate smalldatetime)I tried,insert into table values('Kumar',202, ??????)I want to insert Current date and time into table Company.....Please give me the solution...Thanks.. 

Use Sharepoint Calendar Start Time field in calculated column

I'm trying to limit the calendar view to current week using the Sharepoint defined field Start Time. However, when I display the serial number behind the Start Time it looks like it is actually giving me the serial number for the Created Date field. I believe it is because the appointment is reoccurring but I'm hoping there is a way around it. I created a new testdate field and manually entered the date and set those appointments as all day events however they are not reocurring appointments. The testdate returns the correct serial number however the start time returns an incorrect serial number. SerialNumber1=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])) SerialNumber2=DATE(YEAR([testdate]),MONTH([testdate]),DAY([testdate])) Start Time  SerialNumber1 Testdate  SerialNumber2 8/31/2010 40420 8/31/2010 40421 8/31/2010* 40405    9/1/2010* 40405    9/2/2010* 40405    9/7/2010 40427 9/7/2010 40428 9/13/2010* 40405    9/14/2010 40434 9/14/2010 40435 9/14/2010* 40405    9/15/2010* 40405    *These are reoccurring appointments scheduled as all day events. The others were entered as one time appointments scheduled as all day events.

update/insert parent child at the same time

Hi Al, Is there a way to create a contact form that takes the name. address and other info for the master record; Then, somehow, on the same page, allow the user to enter multiple contact info as chid records (i.e. phone, email, etc.) All this using the Objec DataSource or SQL DataSource (which ever is easy) and doesn't require writing too much code. Any reference material welcomed. Thanks, rod.

How do I format a date time field in a CQWP to YY-MM-DD ?

Hi. I have been trying to get the date-time to look good for some time now, but have failed. I have a Content Query web part that picks up article pages from a page library. The pages contains a field called 'article date'. I want to show just the 'Title' and the 'Article date'. Doing this default gives me: My title 10-09-03 00:00:00 I want it to be: My title 10-09-03 Is this possible? I'm starting to realize that I probably have to edit the xsl styles for this webpart but if thats the answer, how do I do that? ThanksThomas Balkeståhl - Technical Specialist - SharePoint

Insert picture from sharepoint disabled in editor field

Hi, When I create an announcement list, the body is a" multiple lines of text" field with then enchanded rich text editor mode enabled. When I add a new item, I can open the tab insert and click on picture. There I get 3 options: from computer / from address / from sharepoint The option "from sharepoint" is disabled (grayed out). I looked on the forum here and google, and all I could find was that the SharePoint Server Publishing should be enabled, but that is already the case on my site, and still the option is disabled. I tried with a custom list, but it gives the same problem. When I add a content editor web part on one of my pages, the option to insert a picture from sharepoint is enabled. So it's only happening when trying this inside a listitem. How can I browse for a picture inside SharePoint from the editor inside a listitem ?

Custom Contact List: has to be auto-populated with users and manually insert others contact

Hi All, is it possible to create a custom contact list that automatically insert user as contact? I have to use it to send auto-email to the people in the contact list... (ant they can be user or not) Thanks All Vit

Multiple insert at the same time

Hi all, I have 6 pc which is connected to the sqlserver. I have a table call tbl_seat with column (id, name, schedule, status) <-- the bold and underline is the primary key So when there is 2 pc choose the same seat at the same time, there cause an xLock and it will hang all my other process... so is there anyway i can stop it?? like there only 1 sql statement at a time... i hope everyone here know what i mean with my bad english.. and thanks in advance for any answer =) btw.. my insert statement is as below ( 2 pc execute the insert statement together) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A01', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A02', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A03', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A04', 2231, 2) INSERT INTO tbl_seat(name, schedule, status) VALUES ('A05', 2231, 2)

How to insert a name field on an InfoPath path that allows you to insert names from the AD directory

How can I set up a field on an Infopath form so that when I click on a "Check Names" button, (exactly the same way it works on a SharePoint point Name field), the name is checked against the AD directory? I am not trying to control user access to sections of the form - I am simply adding names to the form that is collecting data on a task - such as Delivery Lead, Designer, etc.

SSRS 2005 Render Format Excel Issue with Time Field


I have a report that uses a datetime field but gets populated only with the time. So, in SQL db, it gets stored with a default date value of 1899-12-30 12:01:01 with the correct time filled in. Report in SSRS Preview mode displays the value just fine when I use the Time format in Layout mode. I build and deploy and able to view the report in a web browser with no problem displaying the time field. But when I subscribe to the report and choose Excel render format, when I open up the Excel file from the email that was sent, I get negative decimal values. I have tried every possible Time format in SSRS but I get the same result. I also tried just the default and still gives me negative decimal values that show up as ####### in Excel.

Any help will be greatly appreciated. Thanks

Setting a date time field to now


Hi all

MOSS 2007 - Visual Studio Sequantial Workflow.

I have a field in an item that I want to update within my Workflow code.

Field Definition:

<Field Type="DateTime" DisplayName="Date Approved/Declined" Required="FALSE" Format="DateOnly" ID="{0c1d9bb7-52f9-4b83-8d26-eda6c9879921}" SourceID=

getting time and date from datetime field in javascript


Hello guys, I need to get hours from the difference between two datetime fields. I wrote the javascript which will get the date from datetime field.

But its not getting the correct time that entered on date time field. Its defaultly getting the current time on my system.

So do you guys have any idea. How to get time from date time fields. and how calculate hours between two datetime fields using javascript.

Workflow SPD: Set Today Date+Time to Column-field




I have a little question about settings specific today (Date + Time) value to a field/column within a workflow that is designed by Sharepoint Designer 2007.


I can manage to set the field to today() => but the time is always 00:00 houres.

I would like to set a specific field to the "exact" date+time when the workflow is running. (so choosing a fixed date+fixed Time isn't a solution either)


So I anyone could help me how I can do such "simple" task, I would be very pleased.






Default MaskedEditExtender and MaskedEditValidator CSS Class Location


I am new to using the MaskedEditExtender and MaskedEditValidator controls. When I went to set these up, I found that it entered the CSS class names automatically for the following properties.

OnBlurCssNegative = MaskedEditBlurNegative
OnFocusCssClass = MaskedEditFocus
OnFocusCssNegative = MaskedEditFocusNegative
OnFocusCssClass = MaskedEditError

However, I do not have these CSS classes in my Styles.css file. Where are these CSS classes located? Also, if I do include these same classes in my own stylesheet, will it override whatever the classes state in this default location or do I have to call them something different?

Insert data in parent and child table at the same time


I have two (parent-child) tables that are bound by a primary key (PK)/foreign key (FK) relation.each PK is identity (idStudent and idBac)

to insert data, i'm using an little application in c# i programmed myself where i insert these columns for the Student table: F_Name, L_Name, Age, Mobile, Adresse, City ,and  ( i don't know how to handle the idBac wich is foreign key of the other table wich still not inserted yet)

for the table Bac, i insert section, school, and city.

what i want is when i click on "OK" button, the idBac ,wich is a foreign key of the other table (BAC), receives the same idBac given the moment i inserted the BAC informations too ...

i don't have any problem wich ado.net ...i just want the right query/procedure.

thanks in advance and sorry for my english, it's not my mother tongue.

Time added to Detailsview TextBox Date only field


Does anyone know why a time stamp is added to a textbox field that is bound to a SQL 2008 date datatype field?

I can view the data in the database and, as expected, it only contains a date. When I bind the textbox to the db field it tacks the time '12:00:00 AM' to the end of the date?


Insert on button event is inserting 2 records at a time


I have a form that is doing a simple insert, then a sub insert of a certain drop down selection is made. What i dont get is why the main insert is inserting duplicates and the sub works fine inserting 1 record per text as expected. I click the button 1 time, and when i check the table, there are 2 new records.. As you can see the insert is not wrapped with any conditions, once that is inserted i check if a slection was made and runs the sub insert.

My full code can be found in this post(http://forums.asp.net/t/1608619.aspx), but here is what i have for my button event.

    protected void btnSaveServConfig_Click(object sender, EventArgs e)   
        dac.insertServerConfigintosql(txtEmailLogin, txtEmailPass, Convert.ToInt32(ddlNumEmail.SelectedValue));   
            if (Convert.ToInt32(ddlNumEmail.SelectedValue) > 0)   
                 Dictionary<string, string> camValues = new Dictionary<string, string>();   
                    foreach (HtmlTableRow row in table1.Rows)   
                        foreach (HtmlTableCell cell in row.Cells)   
                            foreach (Control control in cell.Controls)   

Insert ID field into SQL table programatically from Stored Procedure



I have a table in SQL where I insert data (CatCodes) using C# code but I want to insert ID code (DealerID) with it as well. Following is my Stored Procedure and C# code:

PROCEDURE [dbo].[InfoInsert]
	-- Add the parameters for the stored procedure here
	@UserId uniqueidentifier,
	@Title char(32),
	@FirstName char(32),
	@LastName char(32),
	@CompanyName char(32),
	@Email char(32),
	@DealerID int OUTPUT

	INSERT INTO [tblDealers] ([UserId], [Title], [FirstName], [LastName], [CompanyName], Email) 
        VALUES (@UserId, @Title, @FirstName, @LastName, @CompanyName, @Email)
        select @DealerID = SCOPE_IDENTITY()



protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)

            //Insert membership and personal data
            TextBox UserNameTextBox = (TextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("UserName");
            SqlDataSource DataSource = (SqlDataSource)CreateUserWizardStep1.ContentTemplateContainer.FindControl("InsertExtraInfo");


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend