|
I could be wrong, but rather than use the suggestions above, I think it is quicker / more efficient (for large databases anyway) to use something like
select count(ID) from [tableName]
Assuming your table has an ID field.... (otherwise, I dare say any fieldname would do, but again, an Int type probably would be most efficient.)
Someone may correct me....
Fred
|
|
|
|
|
How to print the results of the "SELECT COUNT(*) from Table name".
chandu
|
|
|
|
|
Same way you print anything... you have to read the result into a variable and print it.
You can use the ExecuteScalar command on a Command object to read the number directly into a variable - eg, in VB, SQLServer:
Dim objCmd As SqlCommand
Dim n As Integer, s As String
...
objCmd.CommandText = "SELECT COUNT(ID) FROM TableName"
n = objCmd.ExecuteScalar
...
s = "There are " & n.ToString & " records in the database."
|
|
|
|
|
Thanks A loooooooot.......... I am a fresher in to asp.net. thanks for helping.[ ]
chandu
|
|
|
|
|
How am i import news reader xml file to HTML tab ?
I got that news.xml file from BBC
Regards
Kusal
|
|
|
|
|
How to access data from iframe which some textbox controls and dropdowns
sasim
|
|
|
|
|
iframes are nested frames which may refer to another source ( .html page) .
Here is an example which displays the user name when clicking on the button
1. detailform.html
Enter your name : <input type="textbox" name="txtUserName" id="txtUserName"/>
2. iframesample.html - constructs iframe referring detailform.html
function callclick()
{
var frameDocument = document.getElementById("testforiframe").Document;
alert("This is your name : " + frameDocument.getElementById("txtUserName").value);
}
Hope this is what you wanted . revert if you have any clarifications .
Thanks
Priya
Priya Rohan
|
|
|
|
|
Hi All
I am developing a search Engine in which i result will diplay at the left rame of the page and if i click the link(from result) that should be open in right frame. So What should i use so that left frame will not have to post back each time.
Which one will be better Iframe or Frameset ? i don't know anything about them right now
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
here[^]
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi Sandeep,
go with IFrame.
Regards,
Satips. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi All,
In my application(site)i've menubar but when i click or chose on that menu page will be over-write and new page is displayed but menu is disappear.
how to make my menu bar static for all page in my application.
Regards
SMK
|
|
|
|
|
You need to add it to every page.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Nothing much .. Just make it a user control and just add this user control to every page
|
|
|
|
|
Hey it is very simple, just make the menu control in the user control, and add that user control to all the pages where ever you need that menu control.
Regards,
Satips.
|
|
|
|
|
Hi all!
Please help me in my problem.
I'm developing a 'plugin' to the web-site. I can't change any files in root web-site 
My aspx files are placed in ~/plugins/task/ folder.
I create web.config in this folder with appSettings and user section. In code-behind file i tried to read application settings written in web.config, but i can't see them  . My user section is also unavailable.
Is there a way to accomplish my task or I should use resource files for my settings? 
|
|
|
|
|
As far as I know, the web.config needs to be referenced in the root web.config in order to get loaded properly.
|
|
|
|
|
I can't find any related information! My be you can give me some references or link where i can read about this?
|
|
|
|
|
For a web application this is not the case.
Check the following link for detailed article on web.config.
http://www.sitepoint.com/article/web-config-file-demystified
The section relevant to this check "A Few Other Issues"
" * A Web application can contain more than one Web.config file. The settings in a file apply to the directory in which it's located, and all child directories. Web.config files in child directories take precedence over the settings that are specified in parent directories.
* Web.config files are protected by IIS, so clients cannot get to them. If you try to retrieve an existing http://mydomain.com/Web.config file, you'll be presented with an "Access denied" error message.
* IIS monitors the Web.config files for changes and caches the contents for performance reasons. There's no need to restart the Web server after you modify a Web.config file.
"
Coming to the original issue, can you post your web.config file.
i Think, i Wait, i Fast
rAm
|
|
|
|
|
here is my local web.config located in subfolder:
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<configSections>
<section name="taskTestConfig" type="TaskTest.CompilersConfigurationHandler"/>
<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, 
 System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, 
 PublicKeyToken=31bf3856ad364e35">
<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, 
 System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, 
 PublicKeyToken=31bf3856ad364e35">
<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, 
 System.Web.Extensions, Version=1.0.61025.0, 
 Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, 
 System.Web.Extensions, Version=1.0.61025.0, 
 Culture=neutral, PublicKeyToken=31bf3856ad364e35">
<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, 
 System.Web.Extensions, Version=1.0.61025.0, 
 Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere"/>
<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, 
 System.Web.Extensions, Version=1.0.61025.0, 
 Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, 
 System.Web.Extensions, Version=1.0.61025.0, 
 Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/>
</sectionGroup>
</sectionGroup>
</sectionGroup>
</configSections>
<!-- MY LOCAL SETTINGS-->
<appSettings>
<add key="user_process_timeout" value="15000"/>
<add key="show_trace" value="true"/>
</appSettings>
<!-- END -->
<!-- USER SECTION-->
<taskTestConfig>
<compilers>
<add name="C#" compilerExecCmd="C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" compilerExecArgs="/out:"%output%" /target:exe /warn /nologo "%input%"" inputFileExtention="cs" outputFileExtention="exe" validatorExecCmd="%output%" validatorExecArgs=""/>
</compilers>
</taskTestConfig>
<!-- END -->
<system.web>
<pages>
<controls>
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</controls>
</pages>
<httpHandlers>
<remove verb="*" path="*.asmx"/>
<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/>
</httpHandlers>
<httpModules>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</httpModules>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
</system.web>
<system.webServer>
<validation validateIntegratedModeConfiguration="false"/>
<modules>
<add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</modules>
<handlers>
<remove name="WebServiceHandlerFactory-Integrated"/>
<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</handlers>
</system.webServer>
</configuration>
|
|
|
|
|
Hi Diablo,
I assume you have not renamed the file web.config to something else. In case you have renamed it, make it as web.config.
If it is alright, I don't see any issue with the .config file. Might have to dig a bit little deep to find a fix.
rAm
i Think, i Wait, i Fast -- Siddartha
|
|
|
|
|
Thanks! Now I managed to solve my problem
|
|
|
|
|
How did u solve?What was the cause?
rAm
i Think, i Wait, i Fast -- Siddartha
|
|
|
|
|
hai every one
how to schedule timer in asp.net
plz give one sample code
thanks
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
A timer occurs on the client, and so it's done using javascript, not whatever language you're using on the server. Google for javascript timer and you'll get tons of hits.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i want this for master-detail data
i want to use data grid to store data
but i don't want to bind database.
when i select save button i want to save it in database
vijaya
vijaya
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
