ASP.NET

Re: 403(The website declined to show this webpage) Error - WebConfig Authorization - Need to redirect to login

28-Mar-11 11:54

What settings have you applied to the web.config in your production environment?

I know the language. I've read a book. - _Madmatt

De_Novice28-Mar-11 12:10

De_Novice

28-Mar-11 12:10

Here is a part of the web config file from the production:

<authentication mode="Forms" >
			<forms loginUrl="login.aspx" >          
         </forms>      
		</authentication>	
		
		
          <authorization>
        <allow roles="Admin, Employee"/> 
        <deny users="*"/>
      </authorization>

    </system.web>

   
          <location path="Admin">
      <system.web>
        <authorization>
          <allow roles="Admin"/>
          <deny roles="Employee"/>
          <deny users="*"/>
        </authorization>
      </system.web>
    </location>

Why does it work in development and not when published. I havent changed any settings from development to publish accept the database connection string.

Re: 403(The website declined to show this webpage) Error - WebConfig Authorization - Need to redirect to login

De_Novice28-Mar-11 12:16

De_Novice

28-Mar-11 12:16

ok.. I changed the setting for the admin folder from deny users "*" to deny users"?" and it worked.

<location path="Admin">
     <system.web>
     <authorization>
        <allow roles="Admin"/>
       <deny roles="Employee"/>
       <deny users="?"/>
  </authorization>
  </system.web>

what is the difference between * and ?.

Re: 403(The website declined to show this webpage) Error - WebConfig Authorization - Need to redirect to login

Not Active28-Mar-11 18:05

28-Mar-11 18:05

Reading the documentation helps to answer questions like this. * means all, ? means only authenticated

I know the language. I've read a book. - _Madmatt

Invalid column

Paresh146228-Mar-11 6:03

Paresh1462

28-Mar-11 6:03

i got error : Invalid column name 'A1009'.

chk1 = "select Sno from Student where SID = "+ @smemno.Text.ToString();

SqlCommand ck1 = new SqlCommand(chk1, cn);

v11 = (string)ck1.ExecuteScalar();

what should i do?

Not Active28-Mar-11 6:25

28-Mar-11 6:25

Paresh1462 wrote:
what should i do?

Realize that we are not looking over your shoulder. Give an accurate description of the conditions, your problem, expected outcome and what you have tried.

Without knowing your database structure or what it is populated with how can we tell what column A1009 means?

I know the language. I've read a book. - _Madmatt

GenJerDan28-Mar-11 6:29

GenJerDan

28-Mar-11 6:29

chk1 = "select Sno from Student where SID = '"+ @smemno.Text.ToString()+"'";

will probably fix it, but as Mark said, more details would help tremendously.

There is water at the bottom of the ocean.
My Mu[sic]
My Films
My Windows Programs, etc.

Pete O'Hanlon28-Mar-11 6:41

Pete O'Hanlon

28-Mar-11 6:41

For a start, I would look to change your code to mitigate the chance that you will be left wide open to a Sql Injection attack[^]. Secondly, I would look to Dispose of my SqlCommand object. Wrapping it in a nice using statement will do the trick.

I'm not a stalker, I just know things. Oh by the way, you're out of milk.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

How Gridview Data Export in Excel File in ADO.Net C# on Button Event.

Wendelius28-Mar-11 11:38

Wendelius

28-Mar-11 11:38

As already pointed out, use parameters: SqlParameter[^].

But if you still for some reason want to use literals in SQL statements, add apostrophes when you're adding texts to the statement:

chk1 = "select Sno from Student where SID = '"+ @smemno.Text.ToString() + "'";

The need to optimize rises from a bad design.My articles[^]

Mohit327-Mar-11 20:58

Mohit3

27-Mar-11 20:58

Hi,

Can you please help me how data export in Excel File in Ado.Net using Gridview.

Thanks & Regards
Mohit Sharma

Re: How Gridview Data Export in Excel File in ADO.Net C# on Button Event.

Keith Barrow28-Mar-11 2:38

Keith Barrow

28-Mar-11 2:38

You can't, not on the client. Do you want to export data from the gridview into an Excel Spreadsheet on the server?

Sort of a cross between Lawrence of Arabia and Dilbert.[^]
-Or-
A Dead ringer for Kate Winslett[^]

Re: How Gridview Data Export in Excel File in ADO.Net C# on Button Event.

thatraja28-Mar-11 20:38

thatraja

28-Mar-11 20:38

Here you go

Exporting GridView to Excel[^]

thatraja

My Tip/Tricks
My Dad had a Heart Attack on this day so don't...

[SOLVED] How can i do this?

msqar27-Mar-11 14:14

27-Mar-11 14:14

Heya, i got a new question,

I got my website, where i placed in header the logged in bar, which includes the "Hello, <username>" and bellow PROFILE | LOG OUT.
The thing is, that the LOG OUT in order to work, has to be a

Expert Coming27-Mar-11 19:24

Expert Coming

27-Mar-11 19:24

You can only have 1 form per page. Put everything in the 1 form.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

msqar28-Mar-11 1:14

28-Mar-11 1:14

Yea, but brother told me that, but i got different containers, i.e: like this:

header container
form
LOGGED IN BAR
/form
/header container

body container
CONTACT FORM
/body container

can i do something like this ?

header container
form
LOGGED IN BAR

/header container

body container
CONTACT FORM
/form
/body container

Thanks for replying btw!.

Not Active28-Mar-11 1:22

28-Mar-11 1:22

There is no reason to have two separate forms on your page. Use one form and handle the proper events. Such as, handle the login/logout button click event and the submit button click event. What problem are you trying to solve with two forms?

I know the language. I've read a book. - _Madmatt

msqar28-Mar-11 1:28

28-Mar-11 1:28

Hello again, Mark Smile | :)

My doubt is about the asp:container's i got on each aspx.
as i mentioned in the previous reply, i got a header container and a body container.

My questions is: Am I able to open a form in the header container and close it in the body container, and afterwards, manage all the events with onclick property -as you said-?

Because i got the log out bar in the header, and contact us form in the body. Need a solution in order to place all the events in one single form Big Grin | :-D

Thanks again!!!

Marian.

Not Active28-Mar-11 2:19

28-Mar-11 2:19

One form and many ContentPlaceHolders is how the default masterpage is constructed when starting an ASP.NET web application project within Visual Studio. Do you understand the concept of masterpages and contentplaceholders?

I know the language. I've read a book. - _Madmatt

msqar28-Mar-11 2:37

[SOLVED] navigation takes too long

28-Mar-11 2:37

yea, correct me if i'm wrong, the masterpage is the "DEFAULT" page and then i create other pages that "inherits" (i know is not inheritance, but just an example in order to explain what i know) from the masterpage. For example if i have a masterpage with header and footer as master.master with a contentplaceholder in the body. Then i create a login.aspx with master.master as the masterpage and include my independent code inside of the container of login.aspx. When i run the webpage, the masterpage creates the proper HTML.
I realised about the forms, when you create a new .aspx file, with the default code. It shows something like this:

// Here I should add all the ContentPlaceHolder's right?

And manage all the events from each page without needing a lot of forms.

Thanks again Big Grin | :-D

Marian.

msqar27-Mar-11 10:22

27-Mar-11 10:22

Hi community Big Grin | :-D

thanks for helping me so far, i'm really glad that i found this site.
Here's the doubt i got since i started with ASP:

1) I'm not using IIS yet, im using the localhost provided by ASP.NET to test and debug my website before i upload it to the host.
Anyway, when i change from aspx to aspx it takes like if i would be really connecting to the internet and its loading all the things, its not like when you are making the website with flat HTML, PHP, javascript, etc using XAMPP. Actually my website its not fully loaded with images and things that might get you lag.

After thinking why this is happening, i was really upset, so i tried to create my very same website (without asp components, masterpage and stuff ofc) and the same js files, image files, css files, all was alike, and it worked awesome, very fast... so i said, there's two things here... is it the ASP.NET inner localhost or ASP.NET itself.

For instance, i got some pictures with onmouseover event and change to another img, and on mouseout it returns to the "off" state.
And the very first time i mouseover the image, it takes about 3 seconds to load the mouseover image, after the first one, everything looks normal. But why it has to load the image if i'm locally requesting it?

2) Remembered that i have another thing to clear up. I'm trying to reset the fields of my asp inputs and selects components, is there anyway to do it as the HTML does with the

<input type="reset">

? is there a similar property for ASP? I did it now by code behind with the onclick event, that restarts all the fields to "" or SelectedIndex = 0, works good, but it makes a postback because its server side, i would like to do it, without the postback. Any possibility???

Thanks! Hope i'm not bothering you with my noob questions.

Marian Big Grin | :-D

Expert Coming27-Mar-11 19:28

Expert Coming

27-Mar-11 19:28

Javascript is how you do it on the client side. A quick google search will teach you how to reset fields on page load, be careful though, you dont want the script running on postbacks.

The slow loading ASP.NET stuff can happen for lots of reason, a slow machine trying to run the site while using Visual Studio, having debuggers attached... ect...

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

msqar28-Mar-11 8:55

28-Mar-11 8:55

Yea, it might be, tomorrow i will test my project on a better computer and not my netbook, anyway my netbook is pretty powerful (dual atom 1.8ghz, 4gb ram, and a 512mb video card (ION2 Platform)) dunno, it runns everything really fast.
But im still thinking about the Localhost. When its loading it says at the bottom of the browser in the status bar:

"Waiting for localhost..."

And remains like 2 or 3 seconds per page.... and it loads as i said, as if it would be running in the internet.

Thanks again!

Marian.

msqar28-Mar-11 9:27

28-Mar-11 9:27

Yea! you were right! Tried my website in a C2D 2GB RAM and it worked PERFECT, took not even 1 sec to load a page. Everything runnning so smoothly (locally ofc).
Thank you very much!

Marian.

gavindon28-Mar-11 10:00

gavindon

28-Mar-11 10:00

you have to remember when running on //localhost that you are essentially running a server for a minute in the background. The first time you run the application from within VS the server has to start up etc etc.. I run an asus laptop with i7 processor, 8 gigs ram and so on. even mine can be few seconds slow on the first run.

Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.

msqar28-Mar-11 10:06