Feeds:
Posts
Comments

Archive for the ‘SQL’ Category

Part four of this series changes the lesson plan again! This lesson introduces you to Microsoft SQL Server 2008 and SQL Management Studio. Youíll learn how to create a database, add tables to it, and populate it with data. You’ll then use that data and bind it to a template control.

(more…)

Read Full Post »

Cheat Sheets are so useful for web-developers to remember various things. It’s always complicated to memorize syntax for web developers and designers since they are always evolving and rising. Here, Cheat Sheet is always come in handy. These cheat sheets are designed to be printer friendly.
In this article we are going to present some most useful cheat sheets, especially for front end web developer. It would helpful for HTML, CSS, JavaScript and SEO purposes.

Are you looking to contribute to our design community?

Suggest a link

to a relevant article, or submit your own! You will help push the design community to much higher levels.

(more…)

Read Full Post »

How to use Oracle (and other non Microsoft) SP in SqlDataSource Select command

Introduction

Using Oracle Stored Procedures in SqlDataSource Select command is not straightforward. When you return recordset from Oracle SP, you have to declare out parameter of sys_refcursor type, which is not possible without handling Selecting event on the data source.

Background

To do that, I’ll demonstrate two ways, one with simple code behind handler of the Selecting event, and the other with developing custom Parameter control, and sub classing SqlDataSource control. The latter is more complicated, but it gives you the ability to use stored procedures not only from Oracle, but from all databases which return cursors from their stored procedures.

(more…)

Read Full Post »

Introduction

All of the tutorials we’ve examined so far have used a tiered architecture consisting of presentation, Business Logic, and Data Access layers. The Data Access Layer (DAL) was crafted in the first tutorial (Creating a Data Access Layer) and the Business Logic Layer in the second (Creating a Business Logic Layer). Starting with the Displaying Data With the ObjectDataSource tutorial, we saw how to use ASP.NET 2.0’s new ObjectDataSource control to declaratively interface with the architecture from the presentation layer.

While all of the tutorials so far have used the architecture to work with data, it is also possible to access, insert, update, and delete database data directly from an ASP.NET page, bypassing the architecture. Doing so places the specific database queries and business logic directly in the web page. For sufficiently large or complex applications, designing, implementing, and using a tiered architecture is vitally important for the success, updatability, and maintainability of the application. Developing a robust architecture, however, may be unnecessary when creating exceedingly simple, one-off applications.

(more…)

Read Full Post »

 SQL Injection attacks are really nasty security vulnerabilities, and something all web developers (regardless of platform, technology or data layer) need to make sure they understand and protect themselves against.  Unfortunately developers too often neglect putting focused time on this – and leave their applications (and worse their customers) extremely vulnerable. (more…)

Read Full Post »

 bookcover[1] There has been a lot of excitement in the community about the new ASP.NET MVC framework that is about to ship (literally any day now – announcement coming soon).  As with anything new, people are also asking for more tutorials/samples/documentation that cover how to get started and build applications with it. (more…)

Read Full Post »

Hi guys…I’ve been gone nearly a month now. I’ve finished the last of my classes of my last year of my BSc degree (final exams are in January) and we were having all sorts of grad parties. Add to that finishing off a freelance project and my new role as one of the moderators of http://forums.asp.net, blogging had to take a back seat. Anyway, I’m back 🙂

(more…)

Read Full Post »

Older Posts »