|
Hi,
I want to improve the following query's performance executing on sqlce.
select *
from TABLE_A
where field_a in (select field_a
from TABLE_B
where field_b = '0000162080'
and field_c = '2'
and field_d = '011')
order by field_e
Table_A has index for field_a and Table_B has index for field_b and field_c. How can I rewrite the query to execute faster?
thanks,
- ferudun
|
|
|
|
|
I have a custom section defined in the app.config of my application and I want to read the parameters and store the values in a custom class, but I find that the code for ConfigurationManager.GetSection()
returns a null value, and I can't find the reason.
the full code is the following:
<br />
public class WSProvidersFactory : IConfigurationSectionHandler <br />
{<br />
<br />
public object Create(object parent, <br />
object configContext, System.Xml.XmlNode section)<br />
{<br />
WSProvider objProvider = new WSProvider();<br />
objProvider.Name = section.SelectSingleNode("Name").InnerText;<br />
objProvider.Type = section.SelectSingleNode("Type").InnerText;<br />
objProvider.Url = section.SelectSingleNode("Url").InnerText;<br />
return objProvider;<br />
}<br />
public static string GetProviderUrl(ServiceType _typeService)<br />
{<br />
WSProvider _provider = null;<br />
<br />
switch (_typeService)<br />
{<br />
case ServiceType .Local:<br />
throw new Exception("Not Implemented."); <br />
case ServiceType.MainWS:<br />
_provider = (WSProvider)System.Configuration.ConfigurationManager.GetSection<br />
("WebServiceClientProviders/WsNetTiersProviderPrincipal");<br />
break;<br />
case ServiceType.AltWS:<br />
_provider = (WSProvider)System.Configuration.ConfigurationManager.GetSection<br />
("WebServiceClientProviders/WsNetTiersProviderSecundario");<br />
break;<br />
}<br />
return _provider.Url;<br />
}<br />
<br />
[Serializable]<br />
private class WSProvider <br />
{<br />
private string _name;<br />
<br />
public string Name<br />
{<br />
get { return _name; }<br />
set { _name = value; }<br />
}<br />
private string _type;<br />
<br />
public string Type<br />
{<br />
get { return _type; }<br />
set { _type = value; }<br />
}<br />
private string _url;<br />
<br />
public string Url<br />
{<br />
get { return _url; }<br />
set { _url = value; }<br />
}<br />
}<br />
}<br />
AND the code in the app.config file is this:
<<configuration><br />
<<configSections><br />
<<section name="WebServiceClientProviders"<br />
type="ConfigSections.MyConfigHandler,ConfigSections"/><br />
<</configSections><br />
<connectionStrings><br />
<add name="netTiersConnectionString" connectionString="Server=(local);Database=Application_Prueba;Trusted_Connection=True;" /> <br />
</connectionStrings><br />
<br />
</Application.Pruebas.Data><br />
<WebServiceClientProviders><br />
<!-- <br />
*** WebserviceClient Provider ***<br />
The url parameter indicates the webservices url (ex: http:
--><br />
<WsNetTiersProviderPrincipal><br />
<name>WsNetTiersProviderPrincipal"</name><br />
<type>Application.Pruebas.Data.WebServiceClient.WsNetTiersProvider, Application.Pruebas.Data.WebServiceClient"</type><br />
<url>http:
</WsNetTiersProviderPrincipal><br />
<br />
<WsNetTiersProviderSecundario><br />
<name>WsNetTiersProviderSecundario"</name><br />
<type>Application.Pruebas.Data.WebServiceClient.WsNetTiersProvider, Application.Pruebas.Data.WebServiceClient"</type><br />
<url>http:
</WsNetTiersProviderSecundario><br />
<br />
</WebServiceClientProviders><br />
<br />
</configuration><br />
What am I doing wrong?
|
|
|
|
|
<a href="http://www.codeproject.com/useritems/Send_SMS.asp?df=100&forumid=379162&select=2097796&msg=2097796">http://www.codeproject.com/useritems/Send_SMS.asp?df=100&forumid=379162&select=2097796&msg=2097796</a>.
I referred this link to send sms.It works fine but the messages are not going toa mobile from my application.can any one help me?.
Hi,Im Razana
|
|
|
|
|
The article forum itself complains of even build errors and the article is under-voted. Also to secure the systems from being succumbing to spam, most of the Indian providers have stopped supporting email to sms gateways.
You can try using one of the SMS service providers I have reviewed from here:
http://lavanyadeepak.blogspot.com/2007/03/sms-enabling-applications.html[^]
|
|
|
|
|
I am developing a project which has a web project as a part of it. Now to use it, i need to first install IIS. Is there any way, that my setup project will also install IIS if it does not already exist.
Also, can i create virtual directory in IIS from C# code ?
thanks
Chayan
|
|
|
|
|
IIS is part of Windows media. So I would suggest instead of bundling those files, you can just detect and prompt for IIS to the user.
You can, however, create virtual directories from C# Code (using System.DirectoryServices)
|
|
|
|
|
Thanks a lot for your great help. I found the way to create virtual directory using C#. And this is quite cool. Thank you very much.
So you are suggesting not to bundle those IIS files in installer. Rather, give user a prompt to install IIS. Can you please tell me why ?
I just need to know, does it have any bad consequences ? Is there any chance of License Related Legal issues or copy right infringement ? Also, is there any other system related problems ? or any other ?
It will be a great help if you can please send some details.
Thanks
Chayan
|
|
|
|
|
Iftekhar Naim wrote: So you are suggesting not to bundle those IIS files in installer. Rather, give user a prompt to install IIS. Can you please tell me why ?
Because different versions off IIS require different versions of Windows. On top of that, you'll probably also have to install service packs and hot fixes, which you would also have to bundle with your installer.
Basically, you're taking on the responsibility of screwing up someones server when they install your app. Don't.
You simply have to tell the end users that IIS is a requirement to install and run your application. Let the user decide how best to handle the installation of IIS and any fixes, so it doesn't screw up the rest of their server.
|
|
|
|
|
Hi,
I have created an object for a class i have written.
How to delete this object? I dont want to wait for the garbage collector to run its algorithm neither call the GC explicitly.
Gautham
|
|
|
|
|
Why do you want the object deleted?
If you are using some unmanaged resources that you need to release, implement the IDisposable interface.
---
single minded; short sighted; long gone;
|
|
|
|
|
search google for destructor
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
But the destructor (or Finalizer as it is also called) won't run until the garbage collector does. And then when a destructor is in place it slows garbage collection down because it has additional code to run.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
thank you for the explanation 
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Are you just copying what ever looks the more convincing answer so far?
NOTE: This was originally a reply to satips. That post has now been deleted.
-- modified at 6:11 Monday 25th June, 2007
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
To re-emphasise what Guffa said. If you have unmanaged resources, or otherwise use objects that also implement IDisposable then you should implement IDisposable to free up or dispose of those resources. If those conditions are not met then let the garbage collector do its job - it is better at it than anyone else.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
The reason for this explicit object release is in our application in we are creating n number of objects for a specific operation after that operation is finished we no longer require thise objects
We thought that the performance would be better if we explicitly release objects than waiting for the GC to do at later stages!
So the answer is ti implement IDisposable! thank you!
Gautham
|
|
|
|
|
gauthee wrote: So the answer is ti implement IDisposable!
Depends. Do you have objects that already implement IDisposable to dispose of in the object, or do you manage any unmanaged resources in the object? If the answer is no to either then IDisposable won't do anything for you.
Remember, the Garbage Collector knows more about the system state and when it would be an opportune moment to garbage collect things than you do because it can constantly fine tune itself.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
|
This is almost always a bad idea as it ultimately ends up slowing down your application.
-----------------------------
In just two days, tomorrow will be yesterday.
|
|
|
|
|
Scott Dorman wrote: This is almost always a bad idea as it ultimately ends up slowing down your application.
I Totaly agree with you there, but since he needs (for some reason) to force the GarbageCollector to collect, this is the way.;)
GanDad
|
|
|
|
|
how can I get into outlook by a click event?,help me
Hi,Im Razana
|
|
|
|
|
razanabanu wrote: how can I get into outlook by a click event?,help me
What you want to do is unclear. Can you be more specific?
So you want to create an Outlook Add-in or want to open an Outlook window from your application?
---
![Beer | [beer]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/beer.gif) Hakuna-Matata
It means no worries for the rest of your days...
It's our problem free, Philosophy
![Jig | [Dance]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/jig.gif)
"I think my response was 'What idiot dreamed this up?'" -- Mary Ann Davidson, Oracle's chief security officer, in typical blunt manner, remembering her reaction to the company's scheme to brand its databases as "unbreakable."
|
|
|
|
|
yes,I want to open an Outlook window from my application...
Hi,Im Razana
|
|
|
|
|
|
hi guys,
I want to open the outlook and add a RSS feed into it... Basically i have the URL of the rss and now just want to add it in Outlook... How can i achieve that??
can anyone help me out..please
thanks,
huzefa
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
