Asp Dot Net

tags?

Source: http://www.livejournal.com/community/aspdotnet/44745.html

Date: 10/12/05 Keywords: no keywords

I've been trying to get anonymous logon to work with IIS for a while now, and I just can't seem to do it. I'm using IIS6 on Windows Server 2003. If I configure IIS to use the default account of IUSR_SERVY (i.e., IUSR_servername) I get a 401.1 error when I try to access any page. I gave IUSR_SERVY read\execute permissions, and out of desperation, even full control, but I still got a 401.1. I was reading that this problem can be caused when the password IIS has stored doesn't match the actual IUSR_ password, so I tried creating a new account(because nobody seems to know the IUSR password around here), which I called IIS_ANON, and gave it the same permissions as IUSR_SERVY, but that did not work either. The one thing that does seem to work is to set the anonymous user to my account\password, in which case everyting seems to work dandy. That, however, seems like a really bad idea, because I am an administrator(not to mention that I don't like the idea of something without my control running under my name.) So what's the next step in troubleshootin this?

X-posted like mad

Source: http://www.livejournal.com/community/aspdotnet/44452.html

Accessing elements in a Master file.

Date: 10/12/05 Keywords: asp

I've got a master file containing label controls. I want to access these labels within the script files themselves. Can anyone help me with the correct approach? (I'm working with .NET 2.0)

details:

Layout.Master contains: lblHeader1 and lblHeader2 label contols.

Script.aspx uses c# code-behind. I want Script.aspxc to be able to access the labels in Layout.master

Thanks!

UPDATE: I was mispelling my control name. Grrr, here's is an example of how to change the label within the masterfile :

((Label)Master.FindControl("lblHeader1")).Text = "LALA";

Source: http://www.livejournal.com/community/aspdotnet/44184.html

Nulls and SQL

Date: 10/10/05 Keywords: browser, database, sql

Okay this has been bothing me for some time now
whenever i am working with the database (ms-sql 2k)
i keep running into problems with nulls and empty
values, I am passing an empty string into the db
and its fine i pass it through my string cleaner
function and it can't find the value its trying to
enter also with number field unless theres a value
in it the it crashes with the same error my sting
cleanner causes ... what am i doing wrong

### String cleaner function ###
Function Strip_SQL(ByVal strValue as String)
Dim ModStrValue As String
' the values replacing the char values are actually ascii and are rended by the browser here
Dim ModStrValue1 As String = replace(strValue,vbCrLf,"[br/]")
Dim ModStrValue2 As String = replace(ModStrValue1, chr(34),""")
Dim ModStrValue3 As String = replace(ModStrValue2, chr(9)," ")
Dim ModStrValue4 As String = replace(ModStrValue3, chr(13),"[BR/]")
Dim ModStrValue5 As String = replace(ModStrValue4, chr(39),"'")
Dim ModStrValue6 As String = replace(ModStrValue5, chr(40),"(")
Dim ModStrValue7 As String = replace(ModStrValue6, chr(41),")")
Dim ModStrValue8 As String = replace(ModStrValue7, chr(61),"=")
Dim ModStrValue9 As String = replace(ModStrValue8, chr(64),"@")

Return ModStrValue9

End Function

### how the function is places on the request ###
Dim editorial As String = Strip_SQL(Request.Form("editorial"))

### passing the variable to codebehind ###
Dim EditAdminResort As New Devotion2Motion.AdminComp()
EditAdminResort.EditResort(editorial )

### The function that passes the variable to the query ###
Public Function EditResort(ByVal editorial As String)
' Create Instance of Connection and Command Object
Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("strConn"))
Dim myCommand As New SqlDataAdapter("sp_call_Resort_Update", myConnection)
' Mark the Command as a SPROC
myCommand.SelectCommand.CommandType = CommandType.StoredProcedure

' Add Parameters to SPROC
Dim parametereditorial As New SqlParameter("@editorial ", SqlDbType.nVarChar, 4000)
parametereditorial .Value = editorial
myCommand.SelectCommand.Parameters.Add(parametereditorial )

' Create and Fill the DataSet
Dim myDataSet As New DataSet()
myCommand.Fill(myDataSet)

' Return the DataSet
Return myDataSet

End Function

### the error ###
System.Data.SqlClient.SqlException: Procedure 'sp_call_Resort_Update' expects parameter '@editorial ', which was not supplied.

Source: http://www.livejournal.com/community/aspdotnet/44011.html

[Geek] reading excel into a web form

Date: 10/10/05 Keywords: database, sql, web

I have been told we need to make a feature that will
allow the user to upload an excel spreadsheet (this
will always be formatted in the same was) to the server
then on postback link to the spreadsheet and read the
information from specific cells out into a web form
which can be checked before submission by web form
to the sql server database.

I've never done this before i am fairly sure that i
can connected to a excel spreadsheet as a datasource
*hopes with fingers crossed* but can i specify individual
cells to write from? how difficult is to specify which
worksheet your wanting information from etc

I am going to look into it on the web later but if anyone
has any ideas or has done something similar i'd very
much appreciate any help with this, I did in the past
have to attempt connecting to a excel sheet which
didn't go well.

Source: http://www.livejournal.com/community/aspdotnet/43534.html

more confused

Date: 09/19/05 Keywords: asp, web

Based on my last post this is where i have goten and its still not working
and is returning a error message as follows, i am useing .net vb what am
i doing wrong?

Compiler Error Message: BC30456: 'FindByValue' is not a member of 'System.Web.UI.WebControls.ListItem'.
Source Error:
Line 19: End Get
Line 20: Set
Line 21: dsCountryDD.SelectedItem.FindByValue(Value) = true
Line 22: End Set
Line 23: End Property
Source File: c:\inetpub\wwwroot\devotion2motion.com\UserControls\CountryDD.ascx Line: 21

countryDD.ascx page

[%@ Inherits="Devotion2Motion.DropDownsComp" Src="../CodeBehind/DropDowns.vb" ClassName="CountryDD"%]
[script language="vb" runat="server"]

Sub Page_Load()
If IsPostback = True Then

End If

Dim CountryDD As New Devotion2Motion.DropDownsComp()
' Select the country dropdown list
dsCountryDD.DataSource = CountryDD.GetCountryDD()
dsCountryDD.DataBind()

End Sub

Public Property Value As Integer
Get
Return dsCountryDD.SelectedItem.Value
End Get
Set
dsCountryDD.SelectedItem.FindByValue(Value) = true
End Set
End Property

[/script]
[asp:DropDownList DataTextField="country" DataValueField="countryID" ID="dsCountryDD" runat="server"/]

control in the aspx page
[UserContol:CountryDD Value='[%# DataBinder.Eval(Container.DataItem,"countryID") %]' runat="server"/]

Source: http://www.livejournal.com/community/aspdotnet/43315.html

passing info into a ascx file

Date: 09/15/05 Keywords: database, asp

I have a set of dropdownlists that are used contantly so
i put them in ascx files. Now i need to set the SelectItem
in the dropdownlist in the ascx file based on the database
values pulled out in the aspx file EditResort.aspx for
editing the resort information. How do i set SelectItem
in the usercontrol from the aspx file or pass the value
into the ascx file from EditResort.aspx (i've been told
that you cannot pass values into a ascx file).

very confused
Fuzzygoth

Source: http://www.livejournal.com/community/aspdotnet/43072.html

Loooong variable strings

Date: 09/08/05 Keywords: no keywords

How can i concatonate all the values for this function while they
are on separate lines?

' I want each value on a new line is there a way do do this and still make te function
' ReplaceAccomIntValues() run? I am sure it can i just don't know what the proccess is
' Called or remember how to do it

<%# ReplaceAccomIntValues(DataBinder.Eval(Container.DataItem, "Garage"),
DataBinder.Eval(Container.DataItem, "Phone"),
DataBinder.Eval(Container.DataItem, "CarPark"),
DataBinder.Eval(Container.DataItem, "Tv"),
DataBinder.Eval(Container.DataItem, "TownCentre"),
DataBinder.Eval(Container.DataItem, "SwimPool"),
DataBinder.Eval(Container.DataItem, "Radio"),
DataBinder.Eval(Container.DataItem, "NearSlopes"),
DataBinder.Eval(Container.DataItem, "DgsAdmit"),
DataBinder.Eval(Container.DataItem, "Safe"),
DataBinder.Eval(Container.DataItem, "CrossCtry"),
DataBinder.Eval(Container.DataItem, "SuitDisable"),
DataBinder.Eval(Container.DataItem, "Balcony"),
DataBinder.Eval(Container.DataItem, "OnTLake"),
DataBinder.Eval(Container.DataItem, "Solarium"),
DataBinder.Eval(Container.DataItem, "Suite"),
DataBinder.Eval(Container.DataItem, "QutZone"),
DataBinder.Eval(Container.DataItem, "BeautyCb"),
DataBinder.Eval(Container.DataItem, "Minibar"),
DataBinder.Eval(Container.DataItem, "Tennis"),
DataBinder.Eval(Container.DataItem, "WhirlPl"),
DataBinder.Eval(Container.DataItem, "Elevator"),
DataBinder.Eval(Container.DataItem, "Sauna")) %>

Source: http://www.livejournal.com/community/aspdotnet/42800.html

Web Forms not submitting on server

Date: 08/31/05 Keywords: html, asp, web

I have a web form i have build to submit to another page
and it keeps trying to submit to the inital form page even
though the action is set to pagetwo.aspx.

I made a simple test form from the book and that doesn't
submit either, here follows the code but it appears to just
ignore the action command in the form and submit PageOne.aspx
to PageOne.aspx? any thoughts?

PageOne.aspx

[%@ Page Language="vb" Debug="true" %]
[script language="vb" runat="server"]

[/script]
[form action="test2.aspx" method="get" enctype="multipart/form-data" id="form1" runat="server"]

[asp:TextBox ID="TG1" runat="server"/]

[asp:DropDownList ID="TG2" runat="server"]
[asp:ListItem Value="1" Text="Yes"/]
[asp:ListItem Value="2" Text="No"/]
[asp:ListItem Value="3" Text="Maybe"/]
[/asp:DropDownList]

[input type="submit" id="submit"]

[/form]

PageTwo.aspx
[%@ Page Language="vb" Debug="true" %]
[script language="vb" runat="server"]

Dim TG1a As String
Dim TG2a As String

TG1a = Request.Form(TG1)
TG2a = Request.Form(TG2)

message.text = TG1a
message2.text = TG2a

[/script]
[html]
[head]
[meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"]
[title]Untitled Document[/title]
[/head]
[body]

[asp:Label ID="TG1a" runat="server"/]
[asp:Label ID="TG2a" runat="server"/]

[/body]
[/html]

Source: http://www.livejournal.com/community/aspdotnet/42631.html

No records

Date: 08/30/05 Keywords: asp

I'm messing around with ASP.NET 2.0 after a few years of ASP. How detect 0 rows returned and display "No Records Found" if there's 0 records returned for a Gridview or FormView?

Source: http://www.livejournal.com/community/aspdotnet/42429.html

Changes from VWD & Whidbey Beta 2 to RTM

Date: 08/30/05 Keywords: asp, microsoft

http://msdn.microsoft.com/asp.net/beta2/beta2rtmchanges/default.aspx

Source: http://www.livejournal.com/community/aspdotnet/42205.html

Visual Studio.Net 2003 Query

Date: 08/26/05 Keywords: no keywords

How do you allow shared development of a Visual Studio.Net 2003 project, such that
everyone in a team can see a project and make modifications to it?

Source: http://www.livejournal.com/community/aspdotnet/41671.html