i am working in the vb.net and inserting the date into DATETIME field sql db. During duging am checking it shows correct date but when insert into db it show "1/1/1900 00:00:00" . I dont know whats the problem. Code:
Dim ObjDob As DateTime = CDate(Me.ddlDates.SelectedValue & "/" & Me.ddlMonths.SelectedValue & "/" & Me.ddlYears.SelectedValue).ToString("dd/MM/yyyy")
I have a weird thing happening. I have two identical databases installed on one virtual machine but under two different instances of SQLServer. For some reason, periodically when saving from one it will save to the other instead. Using debug, I have verified that the connection string is correct and when the item saves, it still saves to the wrong database.I use session variable, and am of the belief that it might have something to do with it...and t hat when I go from one to the other it is still getting the connection string form the other for some reason.To make sure that it isn't a problem, I make sure that I completely close out one database before opening the other in a new IE window.I assume that when I completely close out an internet explorer window that it abandons all session states. Is that true?
View 7 RepliesI am getting error while inserting date in sql database :
My SQL Table Structure isÂ
Column Name | DB TYPEID ---- INT -----Autogenerated -- PKey
Proj_StartDate ---- Date
In Application i have created a class for holding variable properties then linking this class to another class where my insert method is residing :
public class ProjectMaker {Â
public string Proj_StartDate { get; set; }
}
Now the Class in which i am linking above Class Property is :
 public class ProjectMaker_DB { public static void InsertRecord(ProjectMaker model) {
var cmd = new SqlCommand {
CommandType = CommandType.StoredProcedure,
CommandText = "[dbo].[sproc_INSERT_d_project_p]"
[Code] ....
That was my Class library project , Now here's my Coding for button click event in startup project :Â
protected void SubmitProject_OnServerClick(object sender, EventArgs e) {
if (SubmitProject.InnerHtml.Contains("Submit")) {
#region Submit Section
try {
var rec = new ABC_Library.ProjectMaker()
[Code] ....
I am getting start date from Ajax calendar extender toolkit's Selected Date .
After clicking Submit Button it gives me error : "Input string was not in a correct format" ...
In 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 very weird thing happening. I have two databases that have exactly the same tables but different database names on the same virtual machine, but in different instances of SQL Server. For some reason, when using one of them, it will save to the other. In debug, looking at my connection string..I have verified that it is correct, yet when I allow the save, I look in the table and it isn't there, it is in the other database that is in a table with a completely different name and in a different instance of SQL Server.
View 1 RepliesI have 3 dropdownlist with day,month(e.g Jan, Feb...) and year value. However I am getting an error from my code when trying to insert the concantenated values into a date field in sql server 2008.
My code:
[Code]....
I've got a web app that uses a MS SQL Server 2008 database. Recently I made two copies of the database, one for ongoing development, the other for users to begin testing and evaluting the application.
I've got two seperate web applications now. I've changed the web.config of the 'test' version to point to the test DB, but it still seems to be using the previous version.
Is this cached somewhere? I've run IISRESET on the box, but the the 'test' version of my web app still seems to point to the wrong DB.
I'm stumped. I have a client site on a virtual private server - Windows Web Server 2008 SP2, IIS7, SQL Server 2008 Express.I'm trying to setup a second web application, to allow him to review updates prior to their going live. I've created the web application in IIS7, and I have added a second database to SQL Server. The second db is essentially a copy of the production db, with 'DEV' prefixed to the database name and a few new fields in a few tables.My production site works fine. However, the test site comes back with an SqlException: "Invalid column name 'version'." This is one of the new fields - which leads me to believe that my dev site is referring to the production database, and not the dev database. Connection strings, however, do point to different databases (although the login is the same for both):
[code]...
i want to search a text in the database even if user writes wrong spelling.
I am using LIKE operator. But I am not getting exact result.
For example: I want to search 'Norrebro' if user types 'Norebro' (wrong spelling)
LIKE operator does not work in this case. So how can I get the exact result??
for ex. my amount is $ 1,234,343.00
and i want to insert the numbers ONLY in my database (1234343) how to that in c# .net???
I am wanting to insert a record into a table in SQL then retrieve its key at the same time, the key is a int that is automatically generated, I read something about the '@@Identity' function, is this what I need? How could I then bind this to a label in the ASP.net page?
View 12 RepliesI would like to know how to format a string date so it can be inserted in a DataTime field in MS SQL 2005 using ASP.NET 3.5 with C#.
I have a form with 3 Dropdownlists; 1 for selecting days(1 to 31), 1 for month (1 to 12) and 1 for years (say 1980 to 2010).
When the form is submitted, I want to join the selected values from the dropdownlist as a string ( say dd/mm/yyyy) and insert that into a datetime field in a database table.
I am using the following code, but I get the error message "String was not recognized as a valid DateTime." when i submit my form.
[Code]....
I'm having some trouble using EWS with tasks and reminders, specifically, the due date.
When I run my code, shown below, the task is added to my exchange account and I can see it fine in outlook. All the data in it looks fine too. However, if I specify to have a reminder for the task, the due date it shows is very wrong.
It's usually 17 hours in the future, but the screenshot I've provided shows it being 19 hours in the future. I'm finding it very strange that if I open the task, the due date looks fine, but the reminder is saying it is due well into the future.
Screenshot: http://s970.photobucket.com/albums/ae187/paulehn/?action=view¤t=ewstask.jpg
ExchangeVersion exchVersion = new ExchangeVersion();
exchVersion = ExchangeVersion.Exchange2007_SP1;
ExchangeService service = new ExchangeService(exchVersion);
service.UseDefaultCredentials = true;
service.Url = new Uri("https://mail.domain.com.au/ews/exchange.asmx");
Task task = new Task(service);
task.Subject = "Subject";
task.Body = new MessageBody(BodyType.HTML, "Body");
task.StartDate = DateTime.Today;
task.DueDate = DateTime.Now.AddHours(2);
task.ReminderDueBy = DateTime.Now;
task.ReminderMinutesBeforeStart = 15;
task.IsReminderSet = true;
task.Save();
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 have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 RepliesAfter deploying our web application, one of the user was not able to login to the application. After checking, we could realize that his system date was worng, It was a greater than current date. If the system data was less than the current date we can still login. We are using asp.net membership
View 2 RepliesI have a problem using the calendar control on asp.net. Whenever I pick a date from the calendar to input it on my table which is from sql server 2005, I the wrong time. For example the time today is 6pm, 12 AM will be shown on my table. What do you think is the problem?
Do you think I have a problem with my timezone on mysql server 2005 or with my asp.net application. I'm doing a web-based program.
et me know which control is used to insert date of birth in to sql server database and it saved in which format(as date or datetime).If it is datetime then how to convert as date.
View 8 RepliesI have got the following exception when try to select data from SQL Server or inserting data in in with a C# windows application. I am passing the date in where clause of select query in single quotes like this '16/03/2011' The exception message is shown below:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Is there any perfect solution for inserting and selecting date from sqlserver database irrelevant to the operating system. i.e. that works on both Italian and English OS.
I'm currently developing a software application for my client. Part of the project is to keep track of his stock's shipping status. The client must insert the stock's pick-up date, expected time of departure (ETD) and expected time of arrival (ETA). The stocks will be called out using Grid View and the status, being one of the keys of the database, will be shown. Before the current date reaches pick-up date, the status must show "in warehouse", and after the current date reaches pick-up date and is before ETD, status must show that its "on the way to the port", and after ETD and before ETA, "in freight", and finally after ETA, "arrived". What datatype should I use for the database and where should I program it so that it changes automatically accordingly ?
View 5 RepliesI am having a masked textbox for inserting date.But if i am inserting any invalid date (i.e 40/34/5000) it is accepting but it is give out of range error at runtime.I want to avoid this problem during inserting time to display any error message to user as'Invalid Date' using any ASP.Net controls.Pls suggest me which control I can use to have this type of validation and pls send me the code as well.Pls respond me ASAP.
View 5 RepliesMy Table in the Database is not inserting the data from a form. Here is the code for the Table,
CREATE TABLE [dbo].[aspnet_UserGen] (
[UserGenId] UNIQUEIDENTIFIER NOT NULL,
[FamilyName] CHAR (100) NOT NULL,
[FirstName] CHAR (100) NULL,
[Code].....
I have a simple web form that takes data inputted by a user online but I can't get the date field formatted so it can allow UK short date format to be entered. I need to allow dates to be entered like this: dd/mm/yyyy but currently if I enter the UK format date 25/02/2011 I get an error, as the field is in US format (mm/dd/yyyy).
It's a SQL database created from within MS Visual Web Developer 2010, and I'm a SQL newbie.
How do I change the date format to UK so UK format dates can be accepted?
I have date in sql server 2008 database table.and now I want to compare current date with database table date.So how can i compare these two dates?
View 1 RepliesI am saving users information in Sql Server 2005 Database. The problems are:1. If a user selects 1/Jan/1990 then in the Age column of the database automatically 23 should be saved i.e users age, how do I calculate the age and use it in the query? 2. The format of DateofBirth column is incorrect it should be 1/Jan/1990 inspite of2013-01-01 00:00:00.000. The data type is Datetime
------------------Design is--------------
<form id="form1" runat="server">Â Â Â <div>Â Â Â Â Â Â Â
FirstName <asp:TextBox ID="TxtFirstName" runat="server"></asp:TextBox>Â Â Â Â Â Â Â
<br />    <br /> LastName    <asp:TextBox ID="TxtLastName" runat="server"></asp:TextBox>      Â
<br />  <br />       Gender   <asp:DropDownList ID="DdlGender" runat="server" Style="top: 105px; left: 80px;  Â
[Code] ....