Store Opening And Closing Time Of Restaurants In Database?
Aug 30, 2010
i need to store opening and closing time of Restaurants in database as well as compare them with current time to see whether it is closed or open when user is viewing it... How to do??
i am not able think how to desing UI through which resturant owner can save opening n closing time for their resturant ? like what control.
I'm trying to complete a regular expression that will pull out matches based on their opening and closing characters, the closest I've gotten is
^([[)[a-zA-Z.-_]+(]])
Which will match a string such as "[[word1]]" and bring me back all the matches if there is more than one, The problem is I want it to pick up matchs where there may be a space in so for example "[[word1 word2]]", now this will work if I add a space into my pattern above however this pops up a problem that it will only get one match for my entire string so for example if I have a string
"Hi [[Title]] [[Name]] [[surname]], How are you"
then the match will be "[[Title]] [[Name]] [[surname]]" rather than 3 matches "[[Title]]", "[[Name]]", "[[surname]]". I'm sure I'm just a char or two away in the Regex but I'm stuck, How can I make it return the 3 matches.
I'm trying to run the templated user control example provided by MSDN. Code is as follows:
So according to MSDN this should implement as follows:
[code]...
Designer complains that content is not allowed between the opening and closing tags of TemplatedFirstControl and that FirstTemplate is not supported. So what's missing? I duplicated MSDN's code verbatim
The problem is accordion's showed on the page, but doesn't works. I try use code of all examples, but the problem is the same for all of them. I don't understand what to do, because the code is the same as in the tutorials. When I click on the pane it doesn't changing/closing/opening. What can it be?
I just upgraded from VWD 200t to VWD 2010. I'm now seeing an error message that I never saw before. Error is: 'Text is not allowed between the opening and closing tags for element SqlDataSource'
Here is my HTML:
[Code]....
There is a green squiggly line under SqlDataSource, here:
asp:SqlDataSource ID="SqlDataSource2"
I have a similar problem here:
[Code]....
Like above, there is a green squiggly line under SqlDataSource, here:
I know I've seen this in one of the video tutorials but I have no idea which one and I have reinstalled VS since then. I think it was Chris Pels that showed how to set up VS so that you had IntelliSense for XML files. The reason I ask is because I'm going through the Security tutorials series and working on the web.config file and the editor doesn't highlight the closing or opening tag when you click on one or the other like it does for HTML or C#.
Not sure if I'm explaining this clearly or not. When working with HTML or C# I can click on the opening tag for an element, say a div tag and VS will bold the type of the closing div tag. This makes it easy to be sure that I'm not messing up my tags. Well this doesn't happen with an XML document. I saw in one of the videos where the author configured the settings in VS so that IntelliSense would work in an XML document. I just don't remember the path to those settings or what changes were made.
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 need to store time in database and then show in using gridview.I wonder how to store and show data so that user will see correct datetime depanding on his timezone?
I am trying to make a routine system(school, college) where i will use three text field as input1> Class start time(input: 8:00 AM) // when school/college will start.2> Class ending time(input: 1:00 PM) // when all of my class will finish3> Duration of class(input: 1.5(hour))// class hourdesired output: A class routine where time(hour) will be shown in row and Day(e.g, sunday,monday) will be shown in column.questions: 1> how i'll take the input as time:hour from text field?2> how i can save the calculated time in database for use in other page?
So far I use [URL] to get the longitude and lattitude of some address.
function load() { if (GBrowserIsCompatible()) { map = new GMap2(document.getElementById('"mapHolderID'); map.addControl(new GSmallMapControl()); map.addControl(new GMapTypeControl()); map.setCenter(new GLatLng(lattitude,longitude), 15); var point=new GLatLng(lattitudelongitude); map.addOverlay(new GMarker(point); } }
So if user enters Downtown it would take the user to downtown. Now what I want is that if user searches for downtown resturants search result should point to downtown as well as list all the resturants in downtown.
I have a page that opens up displaying information based on a querystring. What I would like to do when this page opens is open another page. After x seconds, I want to close the original page.So, what I have done is the following
1) used Page_load page event to display the info based on a query string (no issues)
The problem I have is that when the original window closes, it calls the function (point 2)) to open the secondary window again. I was just wondering how I can stop this from happening (basically the second page is opened twice).
I have a weird problem. I have a window, on a button click I open a modal popup (using ModelPopupExtender), that let's you select a few criteria and then click a submit button. On click of submit button, I open a new window (using window.open()) that shows the status of what happened to your submitted request. However, every time this status window is opened, it goes to the login page. I am thinking the modal popup can't pass the authentication cookie to the newly opened window, but I'm not sure.
I'm having some problems with connections to an SQL database not closing after being opened, which is maxxing out the pool and causing the site not to load any of the dynamic content (until eventually unused idle connections get close, as the problem seems to go away after a while).
I've been through my code several times and can't figure out where things are not being closed properly.
Is there a surefire way to make sure these connections are properly closed? Or to pinpoint where the problem lies?
Most places in the site I am using ObjectDataSource. You don't need to close a connection when using that, do you?
Where ObjectDataSource isn't used, a developer wrote this method and put it in a class file called "common.cs":
[Code]....
I searched the entire solution for every instance of "common.openDatabase()", and where it occurs I make sure there is a "cmd.Connection.Close();" that follows.
Am I missing something or doing it wrong?
Here's an example of where a db connection gets opened and then (purportedly) closed:
I am using a adapted version ofhttp://www.mikesdotnetting.com/Article/45/Programmatically-accessing-data-from-DataSource-controlsDon't we need something like a closing-routine / close connection command after getting data from the database?If yes: What is the correct closing command?
Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
Web service error response (code/message etc) would you store it in a database? or would you keep the error response in a method.By the time I'm done with this, there will be hundreds of error response, maybe in the future, thousands? (I dont know yet, depends how large this web service grows).EDIT: error response is the response returned back to the application via the web service, (not to be confused with error logging).
I have a web app that is trying to open a SQL Server Database and it's not working. The error that I am receiving is below:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections."
What needs to be done regarding the highlighted line in the error message?
