On UI Ajax calendar control is used to allow the user Expiry Date as shown below. As this is one of the controls in search, when the Search button is pressed using SQL statement (copied below) data is retrieved from ExpiryDate column of the table. The table creator declared the column type as string and the dates are saved as single digits(Example: 2/2/10 sometimes and sometime as double digits (Example: 02/02/10) I like to know the best practice in retrieving both type of strings from database table. Calendar control
[Code]....
SQL(part of stored proc)
[Code]....
with in button click event stored procedure is called to return search results.
HDSK_AUTO HDSK_ID HDSK_CASEDESC 1 TC1 pc spoil 2 TC2 problem Action table: ACT_AUTO ACT_HDSK_ID ACT_DATE ACT_TIMEIN ACT_TIMEOUT ACT_ACTIONS ACT_STATUS [code]...
How do I go about doing this in SQL? I need to return 3 columns: ID, the stuff combined into a single field, and the latest status of each ID. (by latest I mean the most recent entered record's ACT_STATUS. this could be based on the ACT_AUTO I think, which is the auto-increment number)
i have 2 databases in my project with many tables of information. my need is to pull certain pieces of data from different tables and put them into one table called "results" at a certain time called "endDate" in the database. what is the best way to do this automatically?
I am trying to retrieve a Guid from the database but my application just isnt having it. I have a field in the database called "LoginUserId" and it is of type "uniqueidentifier".In my User Model I have:
[Code]....
I keep getting the error: Specified cast is not valid.
I have a picture that i would like to upload to a database. I am really new to this so i am not sure what to do. I have been using the following code below to upload and retrieve the picture, looks like its uploading ok, but i cant retrieve it. The code i am using comes from this site,
I am beginner to sql database and asp.net.I want to fetch datetime from sql database and display it in textbox.I have wrote one stored procedure.The Procedure is
declare @o_Output varchar(30) SET @o_Output = getdate() select @o_Output
Using the above procedure i'm getting current date and time.but my problem is i am hitting ql database while page loading itself. if i am hitting db on 12.40pm means, the textbox showing always the sametime only. I am trying to insert or update some data's into db that time only, i am hitting the db.The textbox datetime(12.50pm) has been changed that time alone. i want to update datetime to textbox at every minutes or seconds.
working with sql server 2005/ visual studio 2005 asp.net c# i just wanted to know ... to insert a date to the database in a field that gets "dateTime" i need to insert the origin syntax. what is the right syntax for the datetime in the database? and to invent for users to insert a wrong sytax ... wich validations i need to put on the field? same question on the type "image" in database it gets like a jpg file? how do i insert an image to the database? If i have a textbox that contain a number ... and i want to ask somthing about the number. how do i do it ? .... like i now that i need to convert it to int i tried this way but it didnt work:
I have a record created date stored as" 2010-05-16 15:44:18.700" in sql server database. When I read this date it gets converted to "5/16/2010 3:44:18 PM" . How should I read it so that I don't loose the ending '700' value so that it gets written exactly to another database.Code for reading the record:
String myConn = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString(); SqlConnection con = new SqlConnection(myConn); SqlCommand cmd = new SqlCommand();[code].....
I am selecting time from dropdownlist. and want to convert it in datetime and store it in database. When I am converting it to Datetime using following statement.
I am currently writing a small templating system in ASP.NET to allow users to add content. For example, the user can enter the string (variable type is string).
topHeader[x] = "They think it's all over. It is now!";
However, one change that's needed is the ability to add some basic HTML tags within this content, so the following can be done
topHeader[x] = "They think it's all over. <strong>It is now!</strong>" or
topHeader[x] = "They think it's all over. <a title="Football News" href="URL">It is now!</a>";
If you add such things into strings now they are not formatted as HTML, but I want to somehow escape them so that they can be. Naturally I've looked on the Internet for the answer, but as Razor is fairly new there's not much out there to help me out.
in 1st List Box i am populating Items List and on selection of any Items The 2nd ListBox populated with Distinct Dates of Sales of the Particular Items. (Here is face a problem as i am unable to display only Date in 2nd List Box as it is also dislayig the Time as the Databasse Field is Datetime) and now i want to pass the Date from 2nd Listbox to 3rd List Box to Populate all the records of this date into 3rd LsitBox.
I need to format this date time into the format Day/Month/Year on the same template field.
I am avoiding doing this under SQL server because that will mean changing my data type in my dataset to string instead of data time which i do not want.
I have a table in my aspnet database. I added a bottom row "Not Selected", if the user doesn't select from a databound drop down list. This row is at the bottom, because I just added it to the table data. Is there any way to move this one row to the top of the table manually? There is not "cut" and "paste" when I select the whole row.
I nearly completed my project and was about to put it out to be run. My boss was going to make a minor change to the connection string and then put it out there. In short, my application was running off a dummy database, while the real database was out there. I have the connection string comiple and built through out my project in the aspx pages and the cs pages.
However, my boss wants to be able to change a single connection string in a single place, essentially in the web.config file. I'm fine with that, but I don't know how to access the connection strings stored in the web.config files. How do you do that? So far, I've only created a new connectionstring in my code on each page. I've told him you could do a "find and replace" on all the files but he doesn't want to do that. In short, he wants to change the connection string the same way he does all the other projects he works with, php, vb and etc.
how do you access the connection strings stored in the web.config file programmatically?
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
I have a table in my SQL DB that is a DateTime table, what I want to do is take the numeric datetime it stores and convert it to a long date (i.e. 12/12/2012 conversts to December 12, 2012). Seaching the forums it looks like the string.format is the way to go and searching for info on that I found [URL] which lists all the different formats but they do not list a formating string to convert to the format I want to use. Does anyone know what format string I would use to convert a numeric date to a long date like I want? And can you show it in a code example because I am not 100% sure I understand the code examples shown on that site.
I am having trouble formatting the date on a textbox I get the error above if I don't enter the date in MM/DD/YY format in the textbox. I am also using this in a FormView so I can't format it or don't know how to in the code behind so if there is a way to format it in design view that would be preferable. Does anyone have any ideas on how I would do any of this.
how do I get the Row count from a table CustomerDatabaseTables in the Database.What I want to do is if the Row Count is greater than 5 then I want to disable a buttonCREATE NEW USER. But I am not able to figure out a way for doing it.Can anyone post the code for the same in VB.
I need to somehow test if a table exists in a database. If it does not then I need to create the table. How can I test for existence of a table using SQL? It seems like some type of SQL logic is needed?