IIS 7 introduced a new way to secure application pool processes from tampering with other application pools. It does this by using windows Virtual Accounts, something that isn’t used very often and most people aren’t famaliar with. To learn more about it, take a look at http://learn.iis.net/page.aspx/624/application-pool-identities
More importantly, if you want to use Windows Authentication with SQL Server using the ApplicationPoolIdentity, you can’t grant permission using the SQL Server Management Studio UI — you have to do it with SQL statements.
CREATE LOGIN [IIS APPPOOL\YourAppPoolName] FROM WINDOWS WITH DEFAULT_DATABASE=[YourDatabase]
USE [YourDatabase]
CREATE USER [IIS APPPOOL\YourAppPoolName] FOR LOGIN [IIS APPPOOL\YourAppPoolName]
where YourDatabase is the name of your SQL Server database, and YourAppPoolName is the name of the application pool.
General ASP.Net, IIS, SQL Server
Either my Google skills are considerably lacking tonight, or very few people have tried to do what I am.
I have a web form that contains a DataRepeater, each ItemTemplate containing three textboxes (Quantity, Price, Total), and a DropDownList. All these are easily manipulated using the DataRepeater’s Items property, and they’re all easily assigned to after calling DataBind() by making use of the ItemDataBound event.
That’s been working fine for me for quite some time; Now here’s where the problem comes in: I’ve been revamping the user interface for TB to minimize postbacks and unneccesary clutter. In this case, I don’t want any extra empty rows; an empty row will automatically be added as soon as you fill in the last one using JavaScript and Scriptaculous, similar to the behavior present in SQL Server Management Studio or Enterprise Manager for adding rows.
Apparently not many people have tried to do this, or if they have, no one has posted about it anywhere online that I can find.
DataRepeaters, the lightest weight of the data controls available, makes use of the Viewstate to persist information. Usually, not a big deal. If you’re trying to dynamically add rows with Javascript, then it becomes a major problem. Making your field names simply follow the correct naming pattern’s doesn’t work because of the need for the control information to be stored in the Viewstate, and no Javascript code is going to manipulate that.
That’s when you have to scrap the functionality that DataRepeater provides for parsing the data on PostBack and in all actuality, it isn’t bad to do at all, but it seems like a bit of a hack.
General ASP.Net
Something’s been bothering me lately with a web application I’m working on — There’s no way to style select/comboboxes with CSS. This has always been a problem with browsers, I remember back when IE 5.0 was standard and thinking, this will surely be fixed in the next generation or so. Now we’re up to Internet Explorer 8 (in beta form), and this old problem still remains. CSS border styles simply don’t apply to select boxes.
That’s the bad news. The good news? There appears to be a library that tackles this problem. It’s available at http://www.emblematiq.com/projects/niceforms/
As for a little more bad news: It only works on FireFox 2.0/Internet Explorer 7 and above. If you’re on an older browser (say, IE 6), or a mobile device like a Blackberry, then the elements show as if the library wasn’t being used. Definitely worth taking a look at if you’re interested in improving the look and feel of your interface.
General
After much thought, I’ve decided to scrap what was up here prevously, and change xdan.com into an online blog using WordPress; It was too cumbersome to update the site on a normal basis before. Now that it’s using WordPress, I intend on updating the site on a regular basis.
Happy New Year!
General