SQL Server :: Formatting Int To Be Shown As Hh:mm:ss?
Oct 28, 2010
I have a column, which is an int, that has seconds stored in it, basically it is how long a user stayed on a form. My end users would like to see the display of how long a user stayed on the form in format of hh:mm:ss.
i have a store procedure that load data in a table of SQL SERVER 2008 from an excel file.the issue is, that the excel file have a column of DATE type, and i want that the system interprets the format in it, no matter what comes in it.dd/MM/yyyy mm/dd/yyyyi have an argue about this with my parnerts, cause i think is imposible, if you don't have a format before the process runs.
I am using this code to fill my datalist: Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim myConnection As SqlConnection Dim myCommand As SqlDataAdapter myConnection = New SqlConnection("mydb") myCommand = New SqlDataAdapter("SELECT * FROM Posts", myConnection) Dim ds As DataSet = New DataSet() myCommand.Fill(ds) DataList1.DataSource = ds DataList1.DataBind() End Sub
It works and fills the datalist with the whole table. When this page opens the address bar is like [URL].Ii would like the datalist to show all contents in the table with this specific thread ID.
I have a panel extended by the ModalPopupExtender that is sometimes shown using the .Show() method in my code-behind. I have a javascript function that resizes the popup and am able to get it to run when I use the client-side show function but how do I run the same javascript function when using the server-side Show() function?
we save the images in database and read the file to show on web front. The problem is some of the images fails to be shown on the page. but if we right click and choose show image, it is shown again. is it because of database timeout ?
I recently came across the AsyncFileUpload control in the latest (3.0.40412) release of the ASP.Net Ajax Control Toolkit. There appears to be an issue when using it in a hidden control that is later revealed, such as a tag with
[Code]....
Server-side Code - [Code]....
I have a breakpoint on the UploadedComplete event but it never fires. However, if you take the AsyncFileUpload control out of the , making it visible at initial page render, the control works as expected.
I recently came across the AsyncFileUpload control in the latest (3.0.40412) release of the ASP.Net Ajax Control Toolkit. There appears to be an issue when using it in a hidden control that is later revealed, such as a <div> tag with visible=false.
I have a series of textboxes on a FormView. There is a textbox for entering a percent for a deposit amount and next to that a corresponding textbox for entering a dollar value for a deposit amount. There are 3 sets of these.
If a user changes a percent textbox, I update the dollar value textbox based on the percent times the project's total cost. If a user changes the dollar value textbox, the percent textbox gets updated as a percent of that dollar amount divided by the project's total cost.
I have the percent textboxes formatted as "{0:0%}" and the dollar value textboxes as "{0:C}".
When a user types into the textbox, the formatting goes away and we get raw numbers but I don't want those raw numbers to remain as such after they tab or click out of the field. I added a TextChanged event to reset the formatting. This works fine on reformatting the percent textbox but the currency one remains as just a raw numeric value.
Here is the markup (ignore the lack of validation for numeric input only...it will be added):
I am using MessageBox to display a message in my asp.net application. For this I have included the namespace using System.Windows.Forms; Now When I click the submit button the messagebox is displayed as minimized. I want the messagebox on screen istead of getting minimized.
in my application, images are not shown in IE,where as it works f9 in Mozila, it sucks me,Plz help me to solve out the problemcheck it out the websitewww.clcparivar.inimages visible in Mozila bt nt shown in IE [URL]
I am generating simple reports. I am using reportviewer to view the report,dataset file(name.xsd) to retrieve and store the data, and report file(name.rdlc) to design my report. I am getting the data from remote database. when i run my application,it is generating the report and everything is correct, but when i run my aplpication from IIS, the report viewer is not showing any data in the report. unable to figure out the problem.
I've added a .ascx control in a Master Page in the site's root. It is perfectly shown when the page is in the same master page path (in the root in this case), but when the page is contained in a subfolder, the component isn't displayed.
Basically, if you go to Start and click Computer and then click on the Network link on the left hand side, you'll notice on the right hand side several categories, one of which is titled "Network Infrustructure", in that category, my router is listed, and in my case, it is "LINKSYS WAG160N Wireless-N ADSL2+ Gateway" and when you right-click and select properties, it lists basic info such as internal/gateway IP address, on mine it is "192.168.1.1"
I would like to know how to retreive this information in code, preferably a Windows API so that i can call it using a legacy VB6 app. Also, even if you just know a .NET version or a Delphi version, However, the answer i'm ultimately seeking is a method to access this via VB6 so that would probably be a WinAPI call (will upvote & select this as answer), however, other methods are also welcome incase i can't find a legacy method (i will upvote these).
In my web application i need to show a page in the frame by using some options.
Successfully i have done it. But from the sub form which shown in the frame, from it on a button click I need to disable or enable the gridview in the main page. How can I do it?
I just want to find whether the ModalpopupExtender is shown or hidden in Javascript
like,
if($find('ctl00_contentArea_MpInfoError').Show()) // Above line is wrong here i need correct code to find out. { //do something } else { //do something }
My website [URL]The actual path for es.argyletv.com is argyletv.com/es/. You can access the same files for that website by typing in essentially 2 different addresses, which is bad for search engine optimization. For instance, es.argyletv.com/entry.aspx yields the same result as es.argyletv.com/es/entry.aspx.
I am trying to determine when the subdomain directory is included in the url, so that I can remove it and redirect the user to the url without the directory via a 301 redirect. The problem that I have is that:Request.Url.ToString();[URL]I've also tried to use Request.RawUrl.ToString(); and pretty much every type of output in the request class to no avail. What I need, is to be able to determine what is being shown in the address bar, so that I can direct the user to the correct URL if need be.
I installed markit slide show module for dotnetnuke but the images are not shown after I upload them .when I right-click on the image and choose properties the sourse of image is like this :http://www.behtinweb.com/DesktopModules/Markit.SlideShow/ImageHandler.ashx?mg=/Portals/0/SlideShow_Photos/388/web_design6.jpg&w=550&h=190&Q=0and when I copy the link in the address bar of my browser I have the "Page cannot be found error" .
I have created login page in which if user credential are incorrect it will show the message through jquery notification bar.But, what is happening when page is being postback it will show complete blank page after that it will load the controls of that page and then the error message will be shown if it is there. So, its taking quite a long time .So, how can we access or load the page in faster way?? or should i make any changes while postback?
we're facing a weird and seemingly randomly appearing problem where the browser renders the complete, raw HTTP response (to a GET request) including all headers and the compressed content as text instead of just using the contents and rendering it. This happens for whole page loads as well as postbacks as well as page loads inside an iframe; for sure in Firefox 3.6.*, not sure about IE right now.
Our service is an ASP.NET 2.0 web app running on IIS 7.5, on our test machines we regularly have Fiddler running in the background (wondering if this might be part of the problem).
This behaviour occurs very rarely but we have started seeing this problem lately during our tests.
Has anybody encountered this problem before and knows what causes it and maybe even knows what to do about it?
I have a web site. if I have a syntax error (i.e. intx i = 1;) on a .cs file in the app code folder, I can see the compilation errror with a line number on the IE browser as usual. But if I have that syntax error on a aspx.cs file, I only see a blank screen.
Note: for other reasons, I could not use Visual Studio to do compliation.
I have an web application with a masterpage, a modalPopupExtender to insert new records, and and updatePanel with a gridview inside, which I have modified the edit and delete buttons into a templateField to allow the use of a confirmButtonExtender.The problem is that I cannot edit (you click on the edit button, you modify the record, but I cannot confirm the edit).But, if I show the modalPopup (it doesn't matter if I insert a new record or not), the, the edit works, anyone knows what could be?