Sunday, September 26, 2004

Client-side ASP scripting with HTML Scripting Pages

Client-side ASP scripting with HTML Scripting Pages
I was wondering how to make HTML pages dynamic, on the line of www.experts-exchange.com and finally decided to do a search on net for the same.

I found this excellent article on www.aspfree.com, which gives a detailed insight. I am now learning this and would post some more urls soon here, after leanring them.

Here is a sample text from the article:
One of the major drawbacks to using embedded web browser controls is that they can only display static content. That is, until now. HTML Scripting Pages, or HSP for short, is the first and only product to actually run ASP pages on the Windows client machine in a plug-in DLL. No longer are webpages doomed to only display static webpages. With HSP, webpages can be seamlessly generated on the fly within either the Internet Explorer webbrowser or embedded IEX webbrowser controls. You can actually run "browser applications" (analogous to a web application) right inside Internet Explorer entirely on the Windows machine with no Internet connection. This ability has tremendous implications for Windows programmers. Suddenly, an entire new programming/display methodology is opened up.

If anyone knows more details, please do let me know.

Thanks
Kiran

Thursday, September 16, 2004

SQL Server Developer Center: Test Run: Automate Testing of Your Stored Procs

SQL Server Developer Center: Test Run: Automate Testing of Your Stored Procs: "
Automate Testing of Your Stored Procs



James McCaffrey


Download the code for this article: TestRun0409.exe (124KB)


Many Windows�-based applications have a SQL Server� back-end component that contains stored procedures. Although techniques to automatically test functions in the front-end code are well known, the techniques to write test automation for stored procedures are not. SQL Server 2005 will provide greatly enhanced integration with the Microsoft� .NET Framework including the ability to write stored procedures in C# and other .NET-targeted languages. This will certainly increase the use of stored procedures and the importance of testing them thoroughly.
In this column I'll walk you through the creation of a simple but representative SQL stored procedure and will then show you how to quickly write powerful test automation that verifies its functionality so that you'll be ready when you start using SQL Server 2005. I will also explain some key principles of writing test automation for SQL stored procedures."

SQL Server Developer Center: Reporting Services: Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services

SQL Server Developer Center: Reporting Services: Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services: "Reporting Services is a server-based reporting platform that is built on the .NET Framework and integrated with SQL Server 2000, so you can integrate rich reporting features into your apps using an extensive Web services-based API. Although the report server uses SQL Server as the repository for reports, any data source with an OLE DB, ODBC, or ADO.NET provider can be used to supply data to the reports, making Reporting Services a great choice for reporting in diverse enterprise environments.
Reporting Services is licensed as part of SQL Server 2000, so if you already have a licensed copy of SQL Server, you can run Reporting Services on the same server for no additional license fee. If you decide to run Reporting Services on a separate machine that is not yet licensed for SQL Server, such as a Web server, you will need to purchase an additional SQL Server license."

SQL Server Developer Center: Using an ADO.NET DataSet as a Reporting Services Data Source

SQL Server Developer Center: Using an ADO.NET DataSet as a Reporting Services Data Source: "Introduction
Reporting Services provides access to SQL Server, Oracle, ODBC, and OLE DB data sources as part of its standard features. For many reporting scenarios, connecting to a database and running a query is all that is needed to get all the information you need to report upon. But what happens if you want to use a DataSet as your data source? For example, maybe you already have a middle tier that processes your data to conform to your business logic and produces a DataSet as a result. Or maybe you don't, but you nonetheless want to manipulate your raw data prior to reporting in ways that are a better fit for a Microsoft Visual Basic or C# implementation than a SQL implementation, and a DataSet would be the logical end result of such processing. Well, fortunately, it is possible to do this. It is even relatively easy, once you work out what parts of the data processing extension interfaces really have to be implemented to wrap up a DataSet in a way that Reporting Services can use. "

MSDN India - Chat Transcript: Exploring XML in SQL Server 2005

MSDN India - Chat Transcript: "SQL Server 2000 XML Features
Host: Srinivas Sampath (MVP) & Vinod Kumar (MSDN India Community Star)"

MSDN India - Chat Transcript: Exploring XML in SQL Server 2005

MSDN India - Chat Transcript: "SQL Server 2000 XML Features
Host: Srinivas Sampath (MVP) & Vinod Kumar (MSDN India Community Star)"

MSDN India - Chat Transcript: Exploring XML in SQL Server 2005

MSDN India - Chat Transcript:
An Informative chat on Exploring XML in SQL Server 2005.

Basic Instincts: Thread Synchronization -- MSDN Magazine, September 2004

Basic Instincts: Thread Synchronization -- MSDN Magazine, September 2004: "The Dangers of Concurrency

Some programming problems do not surface until you begin to execute the code associated with a class or object on multiple threads at once. For example, when multiple threads are executing methods concurrently on a single object, it opens up the possibility of one thread seeing data that's been left in an inconsistent or corrupt state by another thread. This is possible because of the way in which threads are scheduled by the underlying operating system.
The way the operating system's thread scheduler preempts one thread and begins to execute another thread is nondeterministic, meaning that a thread may be preempted while in the middle of a set of related update operations. This makes it possible for a second thread to gain control of the processor and to see the first thread's partially completed work."

Web Services Developer Center: Web Services Enhancements (WSE): WS-Security Drilldown in Web Services Enhancements 2.0

Web Services Developer Center: Web Services Enhancements (WSE): WS-Security Drilldown in Web Services Enhancements 2.0: "WS-Security Drilldown in Web Services Enhancements 2.0
Don Smith
Microsoft Corporation
Updated August 2004
Applies to:
SOAP Messaging
Microsoft� .NET Framework
WS-Security Specification
WS-SecurityPolicy Specification
WS-SecureConversation Specification
Web Services Enhancements 2.0 (WSE 2.0) for Microsoft .NET
Download the WSE2SecurityDrilldownSample.exe source code from the Microsoft Download Center.
Summary: How to use Web Services Enhancements 2.0 to implement security, trust, and secure conversations in Web services architecture. Also covers the security-related changes from Web Services Enhancements 1.0. "

ASP.NET Home: ASP.NET: Web Applications: Working with Client-Side Script

ASP.NET Home: ASP.NET: Web Applications: Working with Client-Side Script: "Working with Client-Side Script
Scott Mitchell
4GuysFromRolla.com
August 2004
Summary: While ASP.NET performs most of its processing on the server, some actions are better served by client-side processing. Scott Mitchell shows how your ASP.NET pages and controls can add client-side code. "

SQL Server Developer Center: Securing Your SQL Server 2005 Express Edition Server

SQL Server Developer Center: Securing Your SQL Server 2005 Express Edition Server: "Securing Your SQL Server 2005 Express Edition Server
William Vaughn
Beta V Corporation
Applies to:
Microsoft SQL Server 2005 Express Edition Beta 2
Security

Summary: Get introduced to SQL Server Express, learn how to install and configure it in a secure manner, plus get information on the basics of SQL Server security"

.NET Architecture Center: Overview: Data on the Outside vs. Data on the Inside

.NET Architecture Center: Overview: Data on the Outside vs. Data on the Inside: "Data on the Outside vs. Data on the Inside
An Examination of the Impact of Service Oriented Architectures on Data

By Pat Helland
Microsoft Corporation

Summary: Pat Helland explores Service Oriented Architecture, and the differences between data inside and data outside the service boundary. Additionally, he examines the strengths and weaknesses of objects, SQL, and XML as different representations of data, and compares and contrasts these models. "

The .NET Show: Smart Clients

The .NET Show now has its own Blog. Check it out to learn about upcoming shows, discuss current shows, or just chat with the hosts.
Smart Clients
Posted: September 3, 2004
Show Length: 1 hour, 53 minutes

For many years the primary focus of solution developers has been in deploying Web-based applications. However, there are certain situations when the limitations of a Web-based application can prevent you from really providing your customers with the best possible experience. In those times you really need a 'Smart Client' application. Today's model for building Smart Client applications provides us with both local processing and access capabilities of a traditional application, as well as the ease of deployment and update that is the hallmark of a Web-based application.

Monday, September 06, 2004

Vulnerabilities found in WinZip

Vulnerabilities found in WinZip: "An attacker could potentially exploit unspecified buffer overflow vulnerabilities in WinZip to execute arbitrary code or gain access to systems, SecurityTracker said in an advisory.
The Silver Spring, Md.-based vulnerability watchdog said the flaws affect 9.0 and prior versions of WinZip, a file-compressing utility for Windows. The advisory said they could be exploited to execute arbitrary code and gain user access via a local system or network.
'When you're able to execute arbitrary code, you can do anything,' said Michael Haisley, a handler for the Bethesda, Md.-based Internet Storm Center, a service of the SANS Institute. 'In the past, zip files were considered safe. That has proven not to be the case.' "

Friday, September 03, 2004

2 Gmail Invitations available...

Hi guys,

Some days back, I was asking for Gmail Invitation and one generous person gave it to me. Now that I have some with me, I thought of passing them on to those who wanna use them.

Please let me know if there is anyone who wants a Gmail Account, so that I can send them an invitation. Please mail me at kmayee@gmail.com to get the same.

I am not going to ask you anything in return as a facour, its just passing on the help that I received.

Kiran

DBAzine - An Irregular Sorting Requirement by Craig Mullins

DBAzine - An Irregular Sorting Requirement by Craig Mullins:
"An Irregular Sorting Requirement
by Craig S. Mullins

Sometimes the requirements of a particular application dictate that data needs to be sorted using some irregular collating sequence. These odd needs sometimes cause developers to sit and scratch their heads for hours, searching for ways to make DB2 do something that seems “unnatural.” But often you can create an answer just by understanding the problem and applying some creative SQL.

At this point, some of you might be asking “What the heck is he talking about?” Fair enough. Let’s look at an example to clarify the issue.

Assume that you have a table containing transactions, or some other type of interesting facts. The table has a CHAR(3) column containing the name of the day on which the transaction happened; let’s call this column DAY_NAME.

Now, let’s further assume that we want to write queries against this table that orders the results by DAY_NAME. We’d want Sunday first, followed by Monday, Tuesday, Wednesday, and so on. How can this be done?

"

Accessing Secured Web Services from Windows SharePoint Services Applications

In a service-oriented environment, managing the security credentials for an application that is accessing a Web service is a critical issue. This article describes how you can use the Kerberos version 5 authentication protocol and impersonation to secure a Web service accessed by a SharePoint application to ensure that only properly authenticated and authorized users have access to the Web service in Windows Server 2003 and Windows Server 2000 environments

A Developer's Introduction to Web Parts

Learn what Web Parts are and how to create them. Developers can build Web Parts as ASP.NET custom controls. Administrators can install Web Parts on any site based on Windows SharePoint Services. Users can add Web Parts to pages by dragging and dropping in a browser, and they can personalize them by setting properties. Web Parts can connect to other Web Parts using standard interfaces. (43 printed pages)

A sample Visual Studio .NET solution that contains two custom Web Parts written in C# accompanies this article. With the first Web Part, users can select a customer and view configurable information about the customer. With the second Web Part, users can view the orders for a single customer. A user can add these Web Parts to a Web Part Page and connect them to each other, so that the second Web Part displays orders for the customer selected in the first Web Part.

Adding a Custom View Style to Microsoft Windows SharePoint Services

Enhance the experience of users in Windows SharePoint Services by creating and deploying a custom view style for lists or document libraries. You can create a view style that goes beyond the default styles to provide users a specific kind of interaction with lists and libraries. A view style can be deployed so that it becomes available for use in all lists and libraries or only in ones you specify

Best Practices for Developing Web Parts for SharePoint Products and Technologies

Using the programming model behind Windows SharePoint Services, you can create your own Web Parts that provide new functionality to enhance your Web Part Pages. Learn best practices to improve performance and usability of Web Parts, and ways to create Web Parts that integrate well with other components of a Web Part Page.

Wednesday, September 01, 2004

ASP.NET.4GuysFromRolla.com: Highlighting Search Keywords in a DataGrid Web Control

ASP.NET.4GuysFromRolla.com: Highlighting Search Keywords in a DataGrid Web Control: "This article will examine how to provide such functionality in ASP.NET when using a DataGrid Web control. A DataGrid is an excellent Web control to list search results. Essentially you provide a TextBox Web control into which a user can enter a search query. When the user submits the form, it's posted back and the database is queried for matching records. These returned results can then be databound to the DataGrid, which will show one result per HTML table row. For more information on the DataGrid Web control be sure to read Scott Mitchell's A Thorough Examination of the DataGrid Web Control article series"