I am using calendar extender and time picker control. When I click insert in my application, my date is going into my database but my time is not going from my time picker control into my database.
Do I need another column for my time picker control ?
[Code]....
How to create date time picker control in asp.net application.it does not in asp.net
control ,i need that control for store date and time in my project.
know how to display a empty string in asp.net time picker control?
View 3 RepliesI am having a DOB text box. This text box also allows to enter the date and also to pick the date using ajax CalendarExtender.
I used to set the dirty message when we edit some thing in the page.
When I enter some thing on the text box and click on the cancel button, dirty message will occur.
The problem i am facing is that, in Edit mode, I used to get all the records and assign to the text box. In that scenerio, the dirty message si automatically set since the DOB gets changes.
Please find the below code.
<asp:TextBox onkeyup="SetIsDirty();" TabIndex="4" onclick="ClearErrorMessage();"
ID="txtEndDate" runat="server" CssClass="input-value"></asp:TextBox>
<ajax:MaskedEditExtender ID="MaskedEditExtender1" runat="server" TargetControlID="txtEndDate" Mask="99/99/9999" MaskType="Date">
</ajax:MaskedEditExtender>
[Code] ....
my sql db configured with getdate()
i need insert time manually when i ll need.
created texbox and when i inputing date and time manually in right format its ok.
but i need set default date and value for textbox current date and time.
at the same time when i will need to input time manually i can be.
here is my vb code row for inserting time to sql db
cust.HaberTarih = saat.Text
how can i set text box default value to current date and time. and can change time part when i will need.
I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 RepliesIn short, I have 3 text box fields on an .aspx page named as follows:-
TextBoxIncident
TextBoxDate
TextBoxDescription
in addition a sql datasource is on the page which is connected to the incident table with an insert query which allows the data entered into the fields to be inserted into the database...
The Textboxincident and textboxdescription fields allow the user to enter data into them...
the TextBoxDate field is a read only and the code behind file enables the text box to show the current date and time the code im using is shown below...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim TextBoxDate As TextBox
TextBoxDate = FormView1.FindControl("TextBoxDate")
TextBoxDate.Text = DateTime.Now
End Sub
When run in browser the textboxdate field shows the current date and time...and Once the textbox incident and text box description fields have been filled in and the submit button is clicked, the fields should be bound to MS SQL table called Incident. This did work before, however it as suddenly stopped working and now displays the following message to me:-
Arithmetic overflow error converting expression to data type datetime. The statement has been terminated.
I want to create a reusable user control which contains a date time picker in asp.net. Need to add this user control in a grid view as column.While clicking the column,date time picker has to be displayed.Which is the suitable method,Creating the component or creating the user control. Also want to know, How to add this component in to the toolbox?
View 2 Repliesi used below code for date time picker validation but it's not working.
Actually I want a date time picker which date dd/mm/yyyy format date. With validation for start and end date. Also for manual entry it should take only no. and for date rest like / or, will be auto formatted.means user should not be able to enter it.
I m using c# .net 2008.
[code]....
I need to do an update a field in database every x minutes. ie: a person login and I need to update a field related to they every X minutes until the value reach a value. Like this, this person start a count event from 1 to 10, they log off the web, but this count must remain countting until reachs 10, 1 by 1 every 7 minutes. I cannot do a SQL Job. Should I User a System.Timer??? Should I record the time and value of the last update, when the person log in I cauculate and update the value??
View 4 RepliesIs it possible to add a date time picker to my form view? I use the form view to insert new records into a gridview connected to a Access database.
PS this is on a webpage don't know if that makes a difference
Given a Database that has a table Called [Bid Transactions], which contains records of all available auctions that are currently running on an ASP.net website .. something similar to Ebay.com, when the deadline of the auction passed, I should close that auction, Send a notification message to both the item owner and the bidding winner to inform them.
how should I keep track of all open auctions? how could I monitor all their ending time and update the Auction status to be "Closed" on Real-time basis? ..
(1) Using SQL jobs ? .. that should reduce system performance .. shouldn't it ?
(2) A back-end service that is running on the server and uses Threading ? .. I have no clear background about that solution.
Server Error in '/MedTegraSL.Web' Application.
Could not load file or assembly 'System.Windows, Version=2.0.5.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e' or one of its dependencies. The system cannot find the file specified.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'System.Windows, Version=2.0.5.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e' or one of its dependencies. The system cannot find the file specified.
Source Error:
[Code]....
Source File:
c:ProductiveTeamsMedTegraPresentationMedTegraSLMedTegraSL.WebMainMaster.Master Line: 16 Assembly Load Trace: The following information can be to determine why the assembly 'System.Windows, Version=2.0.5.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e' could not be loaded.
[Code]....
Stack Trace:
[Code]....
I have a series of collapsible panel extenders on my page and each time the page opens or postsback the panels open for a time and then close. Is there a way to prevent this?
View 4 RepliesMy web application has hosted on the canada server but my all clients are indians.So, as I am using System.datetime.Now to store all the dates in application.Obviously, it is displaying the canadian time instead of india time.How can i do it?Is there not any gloabl settings that we can do in our web.config file so that it indicates to the server at run time which time zone to execute..?Or any other suitable alternate?
View 3 Repliesi have to listen my mail server for every 30 min. i have a distribution list and i want to count number of email comes for that distribution list and no of replies goes from the outlook for every 30 minutes. also i need to get the time difference between the replied time with arrived time of the mail. so show me some sample code
View 3 RepliesAnyone know how to format a TIME COLUMN in SQL 08 to regular time and not military time? VB.net
View 2 RepliesI'm trying to add a time to my database that a user picks from a drop down list but it's proving problematic. Below is the code for the drop down list and the Linq code for adding the selected time to the database.
Drop Down List:
<aspropDownList ID="cboTime" runat="server" AutoPostBack="True">
<asp:ListItem>09:30</asp:ListItem>
<asp:ListItem>10:00</asp:ListItem>
<asp:ListItem>10:30</asp:ListItem>
<asp:ListItem>11:00</asp:ListItem>
<asp:ListItem>11:30</asp:ListItem>
[Code]...
The Error I'm Getting:
Value of type 'Integer' cannot be converted to 'System.TimeSpan?
The datatype is Time in the database.
I have a Time(7) feild in my table that needs a default value of 0. How do I set this?
I tried to do it like this:
Dim DFTSVal as Timespan = 0
then insert the new record? But that was a no-go
I created a web application by using ASP.NET Web Application from New project in Visual Studio 2005. I also used Ajax CalendarExtender and ModalPopupExtender, but viewing it in Browser, these Ajax are not appeared! Why???
View 4 RepliesI'm using Telerik's RadScheduler Control with WebService Binding.
I've used RadScheduler with Server Side Binding which has an event called "OnTimeSlotCreated" which fires every time when a particular time slot creates so that i can access the time slot and get the control (HtmlTableCell Control) to modify it according to the requirement.
But now i'm binding it from client side through WebService which has no such "onClientTimeSlotCreated" event, also these time slots are not having any identity at client side to access.
how to suppress the "AM" in the gridview (template Bind("RideTimeMin", "{0:t}")? Don't tell me to use military time because the function is not "time on a clock"; it's how much time is allowed for a task (in this case the min/max hours & minutes that horses have to complete a 20 mile trail; e.g. 05:00, 05:27, etc). I'm currently accomplishing this in the "ondatabound" function by "..RTmin.Replace("AM","")". I have looked and looked at all the websites that talk about datetime formatting but have yet to find a way to do it upfront in the gridview bind statement.
View 6 RepliesI have one SP in sql server which takes the data from user and inserts into three tables. My problem is if multiple users call the same SP in same time it throwing error..(I guess one user at a time can access the table and table will be locked, that is why remaning users getting error)how to handle this situation. it is a web application, so at a time so many people can call the same SP.How can many users insert data in the same table in the same time?
View 5 RepliesI 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 [URL], but here is what i have for my button event.
[Code]....
I have ajax 3.5 dll added to the reference, and I wanted to create the tab container control during run-time. I found this code which it able to define the tab container during run-time.
[Code]....
But I define it, the compiler says the namespaces 'AjaxControlToolkit' could not be found.