Search results for query: *

I have an asp button on a page that is disabled by default. I want to create a function that OnKeyPress event of a text box the button will get enabled. I've tried a few different options but nothing works. document.getElementById('Button1').disabled = ''...

question.... is con.close() enough to close the connection ? or should I also add con.dispose() ? I have been getting a message stating "Timeout expired. the timeout period elapsed prior to a connection from the pool. This may have occurred because all pooled connections were in use and...

I have a simple innerjoin as shown below SELECT MyTable1.Field1 MyTable2.Field1 FROM MyTable1 INNER JOIN MyTable2 ON MyTable1.ID = MyTable2.ID What I'm trying to do check a third table to see if a record was created that relates to any of the innerjoin records. The results...

I'm trying to create a simple layout to be used on an asp.net master page. I would like the header and menu to stay in position while the content scrolls up or down. Also the footer to stay at the bottom of the page at all times Example of what I'm looking to do...

I'm getting a value from a label on a webform and passing it to another form using the code below. var value = '<%= l10.Text %>'; the problem is when there is an apostrophe within the text. since i never will know what text the label will have, how can I ignore the apostrophe within the...

I have the below query with an inner join that works like I want. But, I now need to join a third table and get a count of a specific field. SELECT TABLE1.FIELD1 ,TABLE2.FIELD1 ,TABLE2.FIELD2 ,TABLE1.FIELD2 ,COUNT(TABLE1.FIELD3) AS QTY FROM TABLE2 INNER JOIN TABLE1 ON...

I have a field called DUE_DATE I'm trying to show records that have a DUE_DATE of today and anything 10 days out in between. The below shows 10 days out but does not show today's records. DUE_DATE BETWEEN GETDATE() AND GETDATE() + 10 any help would be appreciated thanks

I have a query that has an inner join. everything works fine except I'm trying to subtract two fields to get a remaining balance. both fields are int. SUM(MY_TABLE.TRANSFERED) AS TRANSFERED ,SUM(MY_TABLE.RECEIVED - MY_TABLE.TRANSFERED) AS REMAINING what is happening is the value will not...

I need some info on how to handle session time outs on web forms. So, I have the following code on each one of my pages form load event; If Not IsPostBack Then If Session("User") IsNot Nothing AndAlso Session("Group") IsNot Nothing Then ' let them access the page...

I'm trying to get the table structure including the field descriptions. There are several examples of how to do this but how do I get the field description included in the information schema ? SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MyTable' ORDER BY ORDINAL_POSITION Any...

I have a field called STATUS. I'm trying to run a procedure that will update the field STATUS if the below code results are > 8 days SELECT DATEDIFF(DAY, DATE_FIELD, GETDATE()) AS DAYS_IN_QUE FROM TABLE any help would be appreciated thanks

I would like to set my web application into full screen mode (F11). I'm looking at what might be the best way to handle this or if this is even possible or recommended. Would like some feedback or ideas if possible. Thanks in advance.

is it possible on a windows 10 tablet to make the tablet keyboard default to the numeric keypad? If so, how ? I've been searching and can't find anything on this. we have an app that users will mostly type numeric values and changing back and forth from text to numeric gets old real fast...

I'm trying to count records that are past due. table has 5 dates and a field called type e.g. date_1, date_2, date_3, date_4, date_5, type I'm trying to count the above dates based on <getdate() and group them by type. so the results would show something like this type date_1 date_2...

I need to display a message if a textbox is not empty but a combox box is. all examples I have found check if a single textbox is empty. so if txt1 has txt but cbo1 does not, I would like a message displayed. I'm trying to do this using java script because my room on my asp.net form is...

I'm using the below code to send out an html email using sql server 2012. I'm trying to include the @count inside the html message but can't get it to work. I've tried (' + @count +') as well. Declare @count int = 0 DECLARE @Body NVARCHAR(2000) SELECT @count = COUNT(1) FROM MY_TABLE WHERE...

I'm trying to use two different css styles in my master page. both files are exactly the same except one expands the form wider. In my master page I have the following; <head runat="server"> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title></title>...

I'm trying to set a div to to 100% hieght and to the center of the content placeholder in my asp.net masterpage. I can't seem to get it to work. my css is below any help woudl be appreciated .maindiv { position:fixed center !important; display:inline-block; background-color...

I'm trying to setup a custom error section in my web.config file. I've been researching how to do this and have tried several examples but can't seem to make this work. I'm trying to get rid of the yellow application error screens that could show. This is my latest web.config entry...

I have two tables Table 1 and Table 2 Now, in Table 1 the data could look like this all on 1 row Number Result 1 Result 2 Result 3 100 7.1 7.8 6.4 Table 2 has multiple rows Number Test Percent 100 abc 1.3 100 cde 12.9 100...