ASP.NET

_ASPAle_27-Sep-09 0:10

_ASPAle_

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!

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.

_ASPAle_27-Sep-09 0:17

_ASPAle_

27-Sep-09 0:17

Ok thank you!

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

_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.

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

About ASP.NET application Hosting

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;

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

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.

sashidhar26-Sep-09 23:19

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.

sashidhar26-Sep-09 23:17

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.

sashidhar26-Sep-09 23:20

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.

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

sashidhar27-Sep-09 1:55