About ASP.NET application Hosting - ASP.NET Discussion Boards

_ASPAle_27-Sep-09 0:10

27-Sep-09 0:10

Oh I understand ... but I can not find examples with sqladapter!

And that means "clueless"? (I can not find a translation in Italian!)

I know that this code is dangerous and attacked via SQL injection. But how can I do? Through stored procedures?

I apologize but I'm a beginner!

Re: Load data into detailsview via C#

Abhijit Jana27-Sep-09 0:15

Abhijit Jana

27-Sep-09 0:15

_ASPAle_ wrote:
I know that this code is dangerous and attacked via SQL injection. But how can I do? Through stored procedures?

Please read this article,
SQL Injection Attacks and Some Tips on How to Prevent Them[^]

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

Re: Load data into detailsview via C#

_ASPAle_27-Sep-09 0:17

_ASPAle_

27-Sep-09 0:17

Ok thank you!

Re: Load data into detailsview via C#

N a v a n e e t h27-Sep-09 0:19

N a v a n e e t h

27-Sep-09 0:19

_ASPAle_ wrote:
I know that this code is dangerous and attacked via SQL injection. But how can I do? Through stored procedures?

The code which I provided takes care SQL injection problems. You do it by writing parameterized queries. The using block in my code ensures resources are properly cleaned up.

_ASPAle_ wrote:
I apologize but I'm a beginner!

A book is best for absolute beginners rather than an Internet forum.

_ASPAle_ wrote:
And that means "clueless"? (I can not find a translation in Italian!)

Dictionary[^]?

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: Load data into detailsview via C#

_ASPAle_27-Sep-09 1:12

_ASPAle_

27-Sep-09 1:12

Will take care ok ... however I have already attended a course of a year to become "web designer", only that the world of Internet is so broad, I starts now to understand how powerful ASP.NET compared to other languages.
Many people underestimate, but wrong, especially those who are in favor of open source like PHP and company! PHP is not very functional for me.

Re: Load data into detailsview via C#

N a v a n e e t h27-Sep-09 1:41

N a v a n e e t h

27-Sep-09 1:41

_ASPAle_ wrote:
I starts now to understand how powerful ASP.NET compared to other languages.

A small correction. ASP.NET is not a language. It is a framework which can be programmed using C# or VB.NET. C# and VB.NET are the languages.

Navaneeth

How to use google | Ask smart questions

Re: Load data into detailsview via C#

khaleel the kiraak27-Sep-09 10:41

khaleel the kiraak

27-Sep-09 10:41

just simply make a dataset and a datatable....

and use sqldataadapter instead of sqlcommand....

and fill the dataset using SqlDataAdapter.fill(Dataset ds, "<tablename>")

then make a datatable

DataTable dt = ds.Tables["<tablename>"];

then ur return statement...

return dt;

About ASP.NET application Hosting

jahirhstu26-Sep-09 23:27

jahirhstu

26-Sep-09 23:27

Dear All,
I am using asp.net 3.5 with Microsoft Reporting Service (RDLC).

My Application works fine in local machine. But when I upload my application in my real application server it shows the following error message
My real application server is a shared asp.net 3.5 hosting provider.
Can anyone advice to resolve it.

Server Error in '/' Application.
Required permissions cannot be acquired.
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 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' 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 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' 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.WebDirectoryBatchCompiler..ctor(VirtualDirectory vdir) +163
System.Web.Compilation.BuildManager.BatchCompileWebDirectoryInternal(VirtualDirectory vdir, Boolean ignoreErrors) +53
System.Web.Compilation.BuildManager.BatchCompileWebDirectory(VirtualDirectory vdir, VirtualPath virtualDir, Boolean ignoreErrors) +175
System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) +83
System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +261
System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +101
System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +126
System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +62
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +33
System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +40
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +160
System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +93
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

I have tried with crystal report too.
It shows the error as follows

Server Error in '/' Application.
Required permissions cannot be acquired.
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 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' 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 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' 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.WebDirectoryBatchCompiler..ctor(VirtualDirectory vdir) +163
System.Web.Compilation.BuildManager.BatchCompileWebDirectoryInternal(VirtualDirectory vdir, Boolean ignoreErrors) +53
System.Web.Compilation.BuildManager.BatchCompileWebDirectory(VirtualDirectory vdir, VirtualPath virtualDir, Boolean ignoreErrors) +175
System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) +83
System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +261
System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +101
System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +126
System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp, Boolean noAssert) +62
System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +33
System.Web.UI.PageHandlerFactory.System.Web.IHttpHandlerFactory2.GetHandler(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath) +40
System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig) +160
System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +93
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

Re: About ASP.NET application Hosting [modified]

Abhishek Sur27-Sep-09 9:56

Abhishek Sur

27-Sep-09 9:56

I think this is the problem with Trust level.
The application requires Full / Medium trust level while you are running it in Low Trust level.

Open your web.config and add

<trust level="Medium" originUrl="" />

to your <system.web> section.

Rose | [Rose]

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

modified on Sunday, September 27, 2009 5:05 PM

about publishing website [modified]

hasani200726-Sep-09 23:08

hasani2007

26-Sep-09 23:08

hello all
I have a question.
My website has fileupload control that everyone can send data as doc,jpg and etc. Now I want to know that when they upload their files, where were these files go? it means that the transferred files go to the internet and I should download them to access them or these files send to my computer directly and I shouldn't connect to internet to see uploaded files.

For example suppose that a person whose name is FIRST upload a word file(doc) for me in my site. now I want to access to it to read it. what should I do?

Should I connect to the server that I buy my host from it and download that file? or that file send to my hard drive directly and it's in my computer.

Does it have any relation to ftp? if it does please explain for me about ftp?

excuse me for low English and long text.

modified on Sunday, September 27, 2009 6:44 AM

Re: about publishing website

Abhijit Jana26-Sep-09 23:14

Abhijit Jana

26-Sep-09 23:14

hasani2007 wrote:
Now I want to know that when they upload their files, where were these files go?

The file will save to your server on the path where you have mentioned in your code. I guess you used some thing like,

FileUpload1.SaveAs(filepath);
Where filepath is server path location. Make sure when you host the site on IIS, you need to give the proper persmission to that folder for giving user to write access permission. It will normally work from VS Studio as VC Intergrated ASP.NET Enginge having full rights to write on Local Disk, but when you will host on IIS you need to setup the permission.

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

Re: about publishing website

sashidhar26-Sep-09 23:19

sashidhar

26-Sep-09 23:19

Hasaini wrote:
I shouldn't connect to internet to see uploaded files.

Did You Get the Question.

Why Do Some People Forget To Mark as Answer .If It Helps.

Re: about publishing website

sashidhar26-Sep-09 23:17

sashidhar

26-Sep-09 23:17

hasani2007 wrote:
Now I want to know that when they upload their files, where were these files go?

It Depends Upon The Code.Where You are go to save files Is it Database or Map Path

Why Do Some People Forget To Mark as Answer .If It Helps.

Re: about publishing website

sashidhar26-Sep-09 23:20

sashidhar

26-Sep-09 23:20

hasani2007 wrote:
download them to access them or these files send to my computer directly and I shouldn't connect to internet to see uploaded files.

Does it have any relation to ftp? if it does please explain for me about ftp?

Can You Explain this part in brief..!

Why Do Some People Forget To Mark as Answer .If It Helps.

Re: about publishing website

hasani200727-Sep-09 0:52

hasani2007

27-Sep-09 0:52

Thanks for your response.
I edit my question by an example.

could you explain for me what is ftp and what does it do?

sincerely

Re: about publishing website

sashidhar27-Sep-09 1:55

sashidhar

27-Sep-09 1:55

Use FileZilla Software Tht U connect to the site and U can See all the file in the folder stucture and You Can Access the files

Why Do Some People Forget To Mark as Answer .If It Helps.

change data value by one when I click on checkbox in gridview

robotz26-Sep-09 22:26

robotz

26-Sep-09 22:26

Hi!

I have database of movies and if there is available movies, someone (member) can borow it. I need to keep track of how many more movies is available so when someone returns a movie I increase the number of available movies by one. I have a gridview of borowed movies and I can click on checkbox if some movie is returned. My question is how do I update database to increase number of available movies (for example Matrix) by one when I check "movie returned" checkbox in gridview? Is there some easy way? I also need to search through a movie database and display names and how many movies is available for each movie (I need to display it in gridview). I know how to search for a movie but don't know sql command that will display field of movie availability.

Re: change data value by one when I click on checkbox in gridview

Christian Graus26-Sep-09 22:30

Christian Graus

26-Sep-09 22:30

robotz wrote:
Is there some easy way?

Yes, it's called SQL. This is a very simple SQL statement.

robotz wrote:
I also need to search through a movie database and display names and how many movies is available for each movie (I need to display it in gridview)

OK, so once you do the search, you need to do a join to whatever table tells you how many movies you have on hand, that's basically it. The specifics depend on the layout of the DB, but it's all still SQL 101.

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.

Re: change data value by one when I click on checkbox in gridview

robotz26-Sep-09 22:39

robotz

26-Sep-09 22:39

Christian Graus wrote:
Yes, it's called SQL. This is a very simple SQL statement.

Can you tell me this statement?
if checkbox is checked (movie returned) then number of available movies is increased by one
else number of available movies is decreased by one

How to wrote that in sql? Do I need to combine UPDATE and SELECT somehow?

Re: change data value by one when I click on checkbox in gridview

Christian Graus26-Sep-09 22:50

Christian Graus

26-Sep-09 22:50

I can't tell you the statement without seeing the db. But yes, you'd do a select to get the old value, add one and update the column to contain that value.

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.

Visual Studio .NET Debugger Does Not Stop on Breakpoints When I Debug ASP.NET Pages in VS1.1

K.Safvi26-Sep-09 20:20

K.Safvi

26-Sep-09 20:20

Hi all,
I have a problem. The debugger in VS1.1 is not hitting the breakpoint. I have correct configuration settings (set to Debug) under the Project Properties and also debug attribute is set to true in config file. When the application is built and the output is rendered in the browser the application gets detached and enven can be rebuilt and run again. Can any one guide me whats the issue?
Thanks in advance.
Safvi

Re: Visual Studio .NET Debugger Does Not Stop on Breakpoints When I Debug ASP.NET Pages in VS1.1

Parwej Ahamad26-Sep-09 20:59

Parwej Ahamad

26-Sep-09 20:59

Are you using Windows Vista ?

Parwej Ahamad
ahamad.parwej@gmail.com

Re: Visual Studio .NET Debugger Does Not Stop on Breakpoints When I Debug ASP.NET Pages in VS1.1

K.Safvi26-Sep-09 21:26

K.Safvi

26-Sep-09 21:26

no i am using XP service pack 2. Thnaks for the reply.
Safvi

Re: Visual Studio .NET Debugger Does Not Stop on Breakpoints When I Debug ASP.NET Pages in VS1.1

Parwej Ahamad26-Sep-09 21:28

Parwej Ahamad

26-Sep-09 21:28

Do you have multiple framework version on your machine?

Follow the below instruction-

If Anonymous is on, then the app is running under the ASPNET account (or
possibly Network Service). These accounts (and add IUSR_ while you're
there) should also be in the Debuggers group.
Or
simply turn off Anonymous. If your web server is not your desktop, then try
turning on Basic. Then the application will be running under your user
context.

Parwej Ahamad
ahamad.parwej@gmail.com

Re: Visual Studio .NET Debugger Does Not Stop on Breakpoints When I Debug ASP.NET Pages in VS1.1

K.Safvi26-Sep-09 21:51

K.Safvi

26-Sep-09 21:51

yes i do have multiple dot net frameworks on my mechine.

i turned off Anonymous but it did not work. How to put a certain account under Debuggers group. i m using a Windows XP and the application is running on locahost.

Thanks,
Safvi

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.