I am working on windows mobile and using webservice to store data on server. When I save data from mobile to server Datetime is not stored correctly on server as it should be. Datetime has been changed to Server Datetime which is wrong. I want that it should save that date which i have passed from Windows Mobile.
View 1 RepliesI am confuse in understanding date storing in sql server and retrieving it in C# and converting date formats. guide me on the following basics:
1. In SQL Server datashould be stored as datetime or as string ?
2. To get date in different format (in SQL Server) why we convert it in string, is there no way that date can be obtained as date but in different formats ?
3. For getting date in some particular format is it better to convert date in format from SQL Server or it should be converted in C# ?
4. On C# end what should data type to hold date ?
5. In C# what should data type (string or date) if date is coming from database ?
6. In C# Cant we format date when its data type is date ?
I am using Visual Studio 2008 and SQL Server 2008 and have added a SQL datasource to my form.
When I configure the datasource, I choose my connection string which looks like this in my webconfig:
<connectionStrings>
<add
name="PSFSPRD_ConnectionString"
connectionString="Data
The database I am using has a schema called EQB and as such, my stored procedures are named as EQB.usp_SelectFunds, EQB.usp_SelectAccount, etc.
On the select tab of the Configure Data Source screen, I choose to use a stored procedure. The dropdown shows my stored procedures, however, the schema name does not show up in front of the stored procedures in the drop down. I see only usp_SelectFunds, usp_SelectAccount, etc.
I select one of the stored procedures and when I click TEST, I get the message that the stored procedure is not found. If I instead choose to use a SQL statement instead on the configuration screen and enter EXEC EQB.usp_SelectFunds and click TEST, it works fine.
Why are my stored procedures not showing up correctly in the stored procedure drop down and how can I fix this?
I have a datetime column where I store the amount of time a person workded on a project, so it might be 2011-02-16 05:00:00.000 in the column, this being 5 hours. I need to get a sum of the hours in my sproc I tried
[Code]....
But it tells me I cannot sum on datetime.
is a way of proofing a stored procedure in terms of the datetime localisation. For example, in the C# we may use the web.config or machine.config to set the application's localised date settings:
<pre>globalization uiCulture="en" culture="en-GB"></pre>
This helps when we do a date comparison in a static class of ours to return a certain rating factor. Is there an equivalent way of us checking whether or not the date we pass into the stored procedure is in e.g. UK format and will be compared against our dates in the UK format too? We have 2 datetime columns, DateEffectiveFrom and DateEffectiveTo in our table and we use those dates to compare with the date passed in to return the relevant data.
I'm having a little issue, currently my code, first it saves to DB then send an email in both codes it saves and send the current date and time. I use the following function to get the current date Now() . The problem is when it saves to DB, it saves the current time and date using the timezone of DB server location and the email send the date and time and appear in my wanted timezone (easter time zone). I was wondering if it's possible to make the also save to DB with the correct time zone without using any javascript.
View 2 RepliesHow can i retrieve a document saved in system folder whose path is stored in sql db...
View 3 RepliesI'm suffering a well known problem with globalization, but, I tried to find the answer in the forum and got nothing. My computer has regionalization or globalization from Colombia, as i live there. I made my site and when I published I started to get errors on dates. This errors happen because in Spanish the date format is 'dd/MM/yyyy' being dd:day, MM:month and yyyy:year. In English the date format is 'MM/dd/yyyy'.There is any form or way to correct this in the entire site?? Maybe something in the web.config file?
View 2 RepliesI have a situation where I need to display the time in 24hr clock mode rather than 12hr mode. Is there a way to do this?
I need it to just display the the Hours & Mins e.g. 13:42. AM or PM is optional.
I have an urgent issue with US datetime, in my application I am tring to achieve the following:
1. Enter a datetime in a text box in web form 1
2. Show the date time in the label in the web form 2
3. In web form 2, create a dropdownlist to get a nearest date from database (datatype = DateTime in dd/MM/yyyy) to the date entered from step 1.
In step 1, I am only allowed to enter the date time in US style in text box and I have tried manything like:
- Insert <globalization culture="auto:en-GB" uiCulture="auto:en-GB"/> in web.config
- Set above culture on page webform 1 and 2
I am based in UK, PC reginal and datetime setting are UK dd/MM/yyyy, sql database is in UK.
I am working on application which is deployed in UK environment. But the machine which I am using has US as dateculture.
I always face issues while running application on my machine as some of the functionality which involves date doesnot work and throws exception.
I tried to google on the datetime conversion issue but it did not help.
Can any one please guide me about the changes to be done so that the application works fine in both US and UK environments?
I'm completely ignorant when it comes to SQL Server, so bear with me. I'm following a tutorial on writing a poll [URL] and when I try to save the Stored Procedure I get "Invalid object name 'dbo.NewPoll'". I'm using Visual Studio 2010 and SQL Server 2008 Express. I'm the systems administrator of my production server, infact I have the "box" downstairs. So I can do any changes and all that. familiar with MySQL, maybe I'm not twigging on to something yet.
View 3 RepliesI am developing a web based application for a Motorolla Mc 9090, it is a wireless barcode scanner running windows mobile 5.0.
The idea is to centralize the inventory in one database, by scanning items, serials, bins etc.
I have a set of pages each containg forms, where the user will have to scan an item, and automaticall the scanner has a carriege return (ENTER key) the idea was to have the user simply scan, and the page would automatically click the button posting to server for processing and then the server would reply.
For some reason i cannot get the focus() to work as well as the defaultbutton propperty of the form. There is also 1 more problem, the readOnly textboxes look the same as the non readOnly textboxes, even with the backcolor property changed.(guessing this is just MS)
I am trying to store a SQL Server datetime into MySQL datetime field, but MySQL stores the date value as all zeros. I use this function to trim the fractional part from the SQL Server datetime, but get the same result when trying to store it in MySQL.
[Code]....
I am trying to get data from mysql database and store in sqlserver database. i am getting the following error
The given value of type MySqlDateTime from the data source cannot be converted to type datetime of the specified target column.
I have a MySQL database with a field of type DateTime. When I try to send a date to the DB with the following format:
[Code]....
It does not save the time, only the date and a "00:00:00" at the end. For instance12/1/2011 00:00:00Any idea how I can format save also hours, minutes and seconds? Would it be best to use Timestamps?
I have one pretty stupid problem - datetime issue. I've made one stored procedure for making jobs
[Code]....
[Code]....
i m facing the problem to insert data into database in mobile appliction i have written the code to insert data in c# and its working fine. Executenonquery returns one row but when i select data directly from the database it dont have any data and when i insert data directy into database then data is inserted and show in appliction.
View 4 Replieshow can to get culture info or just culture name from the datetime string e.g i have strings like: "16/02/2008" or "23/02/2008 " can i know the culture name from the above datetime strings?
View 3 RepliesI am having issues debugging locally within Visual Studio 2010 on Server 2008 R2 (x64) for a new ASP.Net MVC application. I am able to debug using the VS Development Server (Cassini) but when I change to use the Local IIS Web Server and Create Virtual Directory, I am unable to debug. I get the standard VS message:
"Unable to start debugging on the web server. The web server is not configured correctly. ..."
Everything looks standard in IIS. The Default Web Site is running under the ASP.NET v4.0 application pool. The virtual directory that Visual Studio created is running under the same app pool. I am running Visual Studio as the Administrator account. It feels like some security setting or something is preventing this to work but I'm at a loss to what it could be.
How show local time in datagridview collumn DateTime from database with universal datetime
View 2 RepliesI am trying to create a stored procedure that filters data from sql server by date but i get this error:
Conversion failed when converting datetime from character string.
my stored procedure is like:
[Code]....
the parameters are passed to the stored procedures as dateTime variables from c# code...
So I'm working with SQL Server 2005 and I'm having trouble saving a stored procedure. (I've only used an Apache server before, and for nothing as complex as the project I'm working on)
Nonetheless, the problem is that I don't know where to actually save the stored procedure I create. In my Object Explorer, I go to the database I want to create it in, expand Programmability, right click on Stored Procedures and choose to create a new one. That's all nice, but when I'm ready to save and test it from my webpage, it asks where to save it. This is probably dumb of me, but I don't know where to. I try to save it on the desktop and click/drag to the Stored Procedures folder in my database, but all that does is open it, not actually store it in the database. Maybe I'm getting the point of stored procedures wrong? Let me know what I should do to save it in the right place so I can access it.
I am trying to start a new mobile web application project but cannot find the mobile page template originally available on VS 2005, nor can I get the mobile web controls to display in the toolbox even though I have then all selected in the tool-> select toolbox items why? and what can I do?
View 1 RepliesI have an assignment to develop a mobile application for My company's customers (around 250000). its could be download from our website or we can also provide to our customers those are visiting our branches, on their demand.Requirments:
View 5 Replies