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'm passing a model to a view, and the model contains this attribute:
[Required(ErrorMessage = "Please enter a start date")]
[DataType(DataType.DateTime)]
[DisplayName("Start Date")]
public DateTime StartDate { get; set; }
And I have this in my view:
<%: Html.TextBoxFor(m => m.StartDate) %>
When I load the page, the textbox is populated with a date: 1/1/0001 12:00:00 AM
Is there a way to not have this happen, maybe by using metadata?
how to set the autonumber value with one starting value?I want to start the autonumber from 720 for ID field in my table..
View 5 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 want the cursor to appear on the first text box in my screen when user goes to the site I have coded this but no cursor is placed in textbox
<form id="Form1" defaultfocus="TextboxTelephone" method="post" runat="server">
I have to tab to get cursor in first textbox telephone.
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 RepliesI 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]....
I have a simple search page with a drop down list that I would like the value to persist on refresh..basically the user will select their location from the dropdownlist and this will be used to populate a gridview. After this the page is set to refresh at a set interval and use the same location data initially selected by the user. However the initial selection is lost each time the page refreshes.
p.s system is to old for ajax!
<meta http-equiv="Refresh" content="300" />
<script runat="server">
Dim connectionString As String = ConfigurationManager.ConnectionStrings("****").ConnectionString
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Not IsPostBack Then
Dim conn As SqlConnection
conn = New SqlConnection(connectionString)
Dim Locationcommandtext As String
Locationcommandtext = "SELECT * FROM [Location] ORDER BY [Location]"
Dim loccomm As SqlCommand
loccomm = New SqlCommand(Locationcommandtext, conn)
Dim reader As SqlDataReader
Try
conn.Open()
reader = loccomm.ExecuteReader()
Locations.DataSource = reader
Locations.DataValueField = "LocationID"
Locations.DataTextField = "Location"
Locations.DataBind()
Catch ex As SqlException
Response.Write("SQL Error:
" & ex.ToString())
Finally
conn.Close()
End Try
Else
'"Viewstate should kick in here"
End If
End Sub
</script>
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'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 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 am creating a web application.. When a user want to register with that application Local time of that user must be registered in this application.. I tried to get the browser time to register ..It is working ..Now i want to improve this.. The user can have incorrect time in his system.
View 1 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 have a RangeBar chart that will show different schedules and how they overlap. I can't seem to get AxisY (which is really AxisX, but they switch when you use a RangeBar for some reason) to display the hour. It displays a gridline for every hour, but the label is the date, which is not helpful at all.
I tried
asChart.ChartAreas["ChartArea1"].AxisY.CustomLabels.Add(0, DateTimeIntervalType.Hours, string.Format("{0:H}"));
but I get the error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
is it possible to set the height of the grid at run time
if nos of rows is10 & hright of each row is 10px then is it possible to set the height of grid to 100px
I am trying to download byte array (l_attchmntToDownload) using the following code:
try{
Response.Clear();
Response.AppendHeader("Content-Disposition", "attachment; filename="+l_attchmntFileSpec);
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(l_attchmntToDownload);
Response.End();
}
catch (Exception Ex)
{
throw Ex;
}
Is it possible to supply Date/Time of modification for the downloaded file?
I tested "Last-Modified" HTTP header but the file gets saved with the current Date/Time only.
I just recently installed VS 2008 on my workstation. I tried creating a simple web site just to check if the installation was fine. The project compiled without error but when I tried running it, the Macromedia Dreamweaver software is being launch. It tried it several time and it's all the same.I remember during the installation there was an option that was displayed asking me to select Designer or Coder. Since the default is Designer i just click next.
Is there a way to stop launching dreamweaver from VS 2008 every time i try running the web project? Is because I selected "Designer" during the installation?
I need to set a page (unavailable.htm) whenever any user try to access the website from particular time (i.e 1-2 pm). I am using Application_BeginRequest() to check on the hours and redirecting to unavailable.htm. It does not work because it keeps redirecting endlessly to unavailable.htm. Below is my code :
Sub Application_BeginRequest(ByVal sender As Object, ByVal e As EventArgs)
I'm working with ASP.Net web services and am having a problem with a long-running process that takes about 5 minutes to complete, and it's timing out. To fix this, I was able to set the executionTimeout on the server's web.config to 10 minutes, and then set the .Timeout property on the Web Service object to approximately 9 minutes. Now, I'm worried that this may possibly cause some other web service calls to sit there for 10 minutes before they time out rather than the previous 90-100 seconds. I know the default on the client side is 100 seconds, but wasn't sure if updating the server's timeout setting would affect this.
Bottom line is - Is it safe to update the server's timeout setting to a long amount like 10 minutes, and rely on the default timeout on the client, or could this end up causing some problems?
I have got a page in which there is a file upload option where I have to upload/import the csv file. What I want to do is to check if the correct format of file is uploaded for instance if any other than csv file is uploaded, the system should give an error message. Also what I need to do is to check certain fields of the csv file for instance there are some mandatory fields in the csv file which should be there like name , postcode, How can I check that these fields are not empty . After performing these task, the system should automatically upload the csv file onto the sql sever 2008.
View 3 RepliesI need to test the counts shown in SSRS report. The report reads the counts from one of the tables.
I need to verify the counts shown in the report. For this I need to insert bulk records in the table (with different userid, datetime, etc).
How can I do this? I really don't want to do this manually.
In my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?
View 2 RepliesHere is a bunch of code from a certain site;
Code:
<script type="text/javascript">
function ShowTime() {
[Code]....
the ShowTime function returns server time or client's time.However, I know that javascript executes in the client side.
I am trying to implement a license in which we will provide a license file which will be placed on the server root directory.This license file contain encrypted strings which have ServerName, Concurrent Sessions , Timeperiod.n this i have two issue.How could i calculate time as user can change server time.How could i maintain the concurrent login sessions [because i can't catch the event hen user close the browser].I will welcome any tehcnique otehr then javascript solution.[even polling] but i can't save session information in database
View 2 RepliesI have a datetime column in my table. It has a value like this for example: 4/27/2010 7:34:00 PM. I would like to display the time part of the column in military time. So this datetime column would appear as: 4/27/2010 19:34
Is this possible?