ASP.NET

Re: how to check database is available before open the connection?

27-Jul-09 0:20

How do you mean by

Piyush Vardhan Singh wrote:
how to check database is available

Do you mean checking if exists database before open it? If yes then try this query

select * <br />
From sysdatabases<br />
where [name]='yourdbname'

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Abhijit Jana27-Jul-09 0:21

Abhijit Jana

27-Jul-09 0:21

Piyush Vardhan Singh wrote:
how to check database is available before open the connection object?

So you want to make sure database exist or not with out connecting the database? D'Oh! | :doh:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: how to check database is available before open the connection?

Piyush Vardhan Singh27-Jul-09 0:26

Piyush Vardhan Singh

27-Jul-09 0:26

thanks for reply

i want to avoid network failures error.when network is not available. so i want check database is available before open the connection object

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
Eventure Technology
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Re: how to check database is available before open the connection?

Abhijit Jana27-Jul-09 1:05

Abhijit Jana

27-Jul-09 1:05

Piyush Vardhan Singh wrote:
want to avoid network failures error.when network is not available.

You have to taking care of Connection Time out For this . If the connection is not available you will get an Timeout Excepation Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: how to check database is available before open the connection?

Piyush Vardhan Singh28-Jul-09 0:04

Piyush Vardhan Singh

28-Jul-09 0:04

YES but i want to handle this without error?

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
Eventure Technology
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

open new window

ptvce26-Jul-09 23:51

ptvce

26-Jul-09 23:51

i want my form open the new window and send querystring :
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "openWindow", "window.location.href='"http://sadafit-9d6e926:8084/pages/ShowImg.aspx[^]"?queryString=" + strSelect+"';", true);

i wrote this code but the window dont open in new window, what should i do

Abhishek Sur26-Jul-09 23:53

Abhishek Sur

26-Jul-09 23:53

use window.open

rather than window.location.href.

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

Christian Graus26-Jul-09 23:54

26-Jul-09 23:54

I don't think your quotes line up. Does it open the page you expect it to, at all ?

According to google[^], you're also doing it wrong. Which makes sense, if you read your code, what about the command you've provided, makes you think it's going to open a new window ? window.open appears to be what you need. And a good book on javascript or at least a lesson in how to use google.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Blue_Boy27-Jul-09 0:16

27-Jul-09 0:16

Set target to blank.
i.e target="_blank">

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: open new window [modified]

ptvce27-Jul-09 0:33

ptvce

27-Jul-09 0:33

plz coorect my code i dont know where should i put targer

Blue_Boy27-Jul-09 0:43

27-Jul-09 0:43

Instead using window.location.href use window.open

Here it is:

Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "openWindow", "window.open('http://sadafit-9d6e926:8084/pages/ShowImg.aspx[^]?queryString=" + strSelect+"');", true);

But next time use google and work by yourself because getting ready-answer from others will not make you excellent developer.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

modified on Monday, July 27, 2009 6:59 AM

ptvce27-Jul-09 1:00

ptvce

27-Jul-09 1:00

thanks its right, it work now Rose | [Rose]

Blue_Boy27-Jul-09 1:02

required field validator issue

27-Jul-09 1:02

You are welcome,but trying to face problems by yourself will increase level of your exprience and professionalize.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

ademsandeepreddy26-Jul-09 23:42

ademsandeepreddy

26-Jul-09 23:42

Hi,

when i am using update panel the required field validator failed for dropdownlist,

when i deleted update panel it(required field validator) works fine.how to rectify this problem

can any one help me regarding this issue.

Thanks&Regards

Sandeep

Re: required field validator issue

Christian Graus26-Jul-09 23:44

Re: required field validator issue

26-Jul-09 23:44

You're using a bunch of different controls to avoid having to learn how to write your own code. You need to look at the javascript for both controls, and try to work out why one stops the other from working. I suspect the answer is that the validator stops postbacks, and the update panel does not post back, by definition.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Abhishek Sur26-Jul-09 23:51

Abhishek Sur

26-Jul-09 23:51

Actually Updatepanel is required to validate in server. If you dont want to post the page to the server and get the validation done in the server,
put some javascript in.

You can call the javascript function on client side events.

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: required field validator issue

Abhijit Jana26-Jul-09 23:54

Abhijit Jana

26-Jul-09 23:54

Please read the article from MSDN
Walkthrough: Using Validation Controls Inside an UpdatePanel Control

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Server Error in '/' Application: Required permissions cannot be acquired

Chesnokov Yuriy26-Jul-09 23:13

Chesnokov Yuriy

26-Jul-09 23:13

I've got web project that includes native win32 DLL resided in bin folder and unsafe web page that accesses functions from that DLL. In web.config /unsafe compilation is also enabled. On my PC it runs normally but when I put it to http on 3rd party web hosting it returns that error:

What is the reason and solution?

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Security.Policy.PolicyException: Required permissions cannot be acquired.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[PolicyException: Required permissions cannot be acquired.]
   System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission) +7604211
   System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission) +57

[FileLoadException: Could not load file or assembly 'Sample, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
   System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +43
   System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +127
   System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +142
   System.Reflection.Assembly.Load(String assemblyString) +28
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +46

[ConfigurationErrorsException: Could not load file or assembly 'Sample, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +613
   System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +203
   System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +105
   System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +178
   System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +54
   System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +227
   System.Web.Compilation.BuildManager.CompileGlobalAsax() +52
   System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +337

[HttpException (0x80004005): Could not load file or assembly 'Sample, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +58
   System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +512
   System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +729

[HttpException (0x80004005): Could not load file or assembly 'Sample, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8890735
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +85
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +259

Чесноков

Re: Server Error in '/' Application: Required permissions cannot be acquired

Christian Graus26-Jul-09 23:24

Re: Server Error in '/' Application: Required permissions cannot be acquired

26-Jul-09 23:24

If it's not a deployment issue, then it's an issue with permissions on your web host. Talk to them.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Chesnokov Yuriy27-Jul-09 1:02

Chesnokov Yuriy

27-Jul-09 1:02

It is certainly not.
ASP.NET dll has a native dll in its <Module> section. I presume that is the reason server fails to load it.

Do you know any web hosters who allows native dll support by default?

Чесноков

How to Retrieve TCP/UDP Statistics using System.Net.NetworkInformation

that_dude_tj26-Jul-09 23:07

that_dude_tj

26-Jul-09 23:07

I went to the msdn website:http://msdn.microsoft.com/en-us/library/system.net.networkinformation.aspx
looking for help writing the code in VB.

Mathematical

geeeeeeeetha26-Jul-09 22:59

geeeeeeeetha

26-Jul-09 22:59

i'm retriving this value from database
12+(IIf( 0>0, 0, 0))+34

How to eval this value

Re: Mathematical

Christian Graus26-Jul-09 23:02