Arabic module required for Asp.Net Website by aim168
Skills Required Asp . Net 2.0 (C#) SQL Server 2005 Note: Please include your portfolio work which includes mulit-lingual website in your CV... Read More......(read more)...
If you allocate from the Large Object Heap each time an ASPX page is requested, your performance will be dismal
Aside from short-lived LOH allocations, the most common cause of memory related issues in ASP.NET apps is pinning managed memory during long async I/O operations. ASP.NET itself does not do this. Objects larger than 85,000 bytes are allocated in the Large Read More......(read more)...
Selecting an Account for the SQL Server Agent Service
* Built-in account. You can choose from a list of the following built-in Windows service accounts: o Local System account. The name of this account is NT AUTHORITY\System. It is a powerful account Read More......(read more)...
SQL SERVER - Get Date Time in Any Format - UDF - User Defined Functions
One of the reader Nanda of SQLAuthority.com has posted very detailed script of converting any date time in desired format. I suggest every reader of this blog to save this script in your permanent code bookmark and use it when you need it.Refer the function and get familiar yourself with different ......
wum_oneview : DotNetSlackers: ASP.NET News and Articles For Lazy Developers: Verschlagwortet mit: tutorials, How-To.. http://tinyurl.com/6lmkyx
wum_oneview : DotNetSlackers: ASP.NET News and Articles For Lazy Developers: Verschlagwortet mit: tutorials, How-To.. http://tinyurl.com/6lmkyx Read More......(read more)...
ASP.NET MVC Tip #32 – Repopulate Form Fields with ViewData.Eval()
When you need to repopulate the form data in an edit form, displaying both valid and invalid values, use ViewData.Eval() to retrieve the values from both the view data dictionary and the view data Model. You use view data in an ASP.NET MVC application to pass data from a controller action to a view......
Creating a Databound Label Control
ASP.NET includes a number of data source and data Web controls that make it remarkably easy to work with data from a web page. For example, to display
the results of a database query simply add and configure a SqlDataSource control and then bind that to a GridView, ListView,
or some other data......
Guidance on SharePoint
You all might be amazed by the number of emails, messages, and calls I get asking for any of the following: Guidance on SharePoint Requests to add SharePoint Guidance to WCSF Requests to add "Office applications" support to SCSF Well, I can finally help out folks looking for guidance on h......
New SQL Server User Group in Orange County - First Meeting on 8/14/2008
For all my Orange County readers you might be excited to know that you now have another great option for getting your SQL content. Reza Madani is starting a new Orange County SQL Server Users Group and their first meeting is this Thursday, August 14th. Plus, they are bringing in a heav......
SQL Injection Attacks on the Rise
According to security researcher MessageLabs, the number of SQL injection attacks spiked sharply last month, helping account for a near doubling of the number of malicious Web sites it identified and blocked each day....Did you know that DotNetSlackers also publishes .net articles written by top kn......
Visual Studio 2008 Service Pack 1 and .NET Framework 3.5 Service Pack 1 Released!
Finally Visual Studio 2008 Service Pack 1 is out! What does it fix? From Microsoft: Improved WPF designers SQL Server 2008 support ADO.NET Entity Designer Visual Basic and Visual C++ components and tools (including an MFC-based Office 2007 style Ribbon) Visual Studio Team System......
ASP.NET MVC Tip #31 – Passing Data to Master Pages and User Controls
In this tip, I discuss four strategies for passing data to Master Pages and User Controls. I explain how you can pass data by using a code-behind class, by using an action filter, by using method calls, and by using abstract controller base classes. I recommend the final strategy. In this tip, I re......
Introduction to Layout Controls in Silverlight 2
Arranging controls on a user interface in a flexible manner is key to building successful applications. Silverlight 2 provides three main controls that can be used for layout management: · Canvas Control · StackPanel Control · Grid Control In this post I'll provide an introductory look at......
SQL Injection in Classic ASP and Possible Solutions
Nowadays, SQL injection is a big threat for websites. It is a technique by which hackers can execute dangerous SQL commands by taking advantage of un-sanitized input opportunities in web application. While there is a good amount of best practices to prevent SQL injection in ASP.NET, ASP has very l......
SQLAuthority News - Microsoft SQL Server 2008 Books Online - BOL - English
SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. The Help viewer used by Books Online requires the Microsoft .NET Framework version 2.0.Books Online includes the following types of inf......
SQLAuthority News - SQL Server 2008 Pricing and Licensing
SQL Server licensing and pricing are to intervined subjects and very important. I strongly suggest to use properly licensed SQL Server in any production environment. The concept of licensing can be confusing sometime to new administrators. If there is any confusion one should read following documen......
Free controls from DevExpress ?
60 Free controls are available from DevExpress. Some for ASP.NET and some for Windows Forms. Check them out at ...... http://www.devexpress.com/Products/Free/WebRegistration60/ Read More......(read more)...
SQLAuthority News - SQL Server 2008 Downloads Availables
SQL Server Compact 3.5 SP1 for Windows MobileSQL Server Compact 3.5 SP1 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP1 on the Windows mobile devices.SQL Server Compact 3.5 SP1 and Synchronization Services for ADO.NET v1.0 SP1 f......
VS2008 SP1 and NetFX3.5 SP1 Released (Adam Braden)
Today we shipped Service Pack 1 (SP1) for both Visual Studio 2008 and the .Net Framework 3.5. This is the first time weve release both a VS SP and a .NetFramework SP at the same time! Additionally, we released ENU, JPN and 8 additional languages that ship with SQL 2008 at the same time!......
End Parentheses Price Quote Stripper
This was made to change non-decimal prices at the end of a huge SQL Insert... To use to replace in DW (without quotes) use sub expression like: $2,$4)Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categori......
SQL SERVER - 2008 - Download and Install Samples Database AdventureWorks 2005 - Detail Tutorial
Just a day ago I received question from reader who just installed SQL Server 2008. After installation user did not find any samples database along with installation. User want to install samples database which he is very much used to.Sample database are now moved to Microsoft’s opensource site of C......
ASP.Net Tip of the Week Series
Interested in learning tips for web development? The Visual Web Development team has started a “Tips of the Week” blog series where they will share some great ideas at http://blogs.msdn.com/webdevelopertips/default.aspx . We are going to blog about VWD, ASP.NET and IIS in this series. F......
Channel 9 Interview: SQL 2008 & Occasionally Connected Client Support in Visual Studio SP1 (Beth Massi)
I just posted a new Channel 9 interview with Milind Lele, a PM on the VS Pro Tools team. In this interview Milind shows us the improvements made to the tooling in Visual Studio SP1 for occasionally connected clients as well as the new data type support for SQL Server 2008.
Using SQL 2008 built-in ......
SQL SERVER - Fix : Error : 1326 Cannot connect to Database Server Error: 40 - Could not open a connection to SQL Server
If you are receiving following error:TITLE: Connect to Server——————————Cannot connect to Database Server.——————————ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the de......
Hanselminutes Podcast 125 - Accessibility in Web and Rich Applications
My one-hundred-and-twenty-fifth podcast is up . In this episode Scott talks to Saqib Shaikh, a developer for Microsoft Consulting Services in the UK, who is also blind. They chat about accessibility in Windows, on the Web and in the next generation of Web Applications written with AJAX and Silverli......
SQL 2008 Requiring VS 2008 SP1 - KB article explaining the whole thing
Here's a KB article explaining clearly the SQL 2008 won't install unless VS 2008 SP1 situation:
http://support.microsoft.com/kb/956139...Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including ......
SQL SERVER - 2008 - Released To Manufacturing Available
Microsoft has Released To Manufacturing available for SQL Server 2008. Released To Manufacturing (RTM) means that code of SQL Server 2008 has been approved by MS team and it is being send to manufacture. It will be while before it is available on distribute media on store shelves.Currently it is av......
An Arbitrary Cycle Method For ASP.NET MVC
In his Practical Review of ASP.NET MVC , Josh Charles provides a helpful review of ASP.NET MVC from a Rails developer’s perspective. It seemed fair and balanced, and the end result is that there’s room for improvement, which we’re taking to heart. However, that’s not the part that caught my attenti......
ASP.NET MVC Tip #30 – Create Custom Route Constraints
In this tip, I show how you can create custom route constraints that prevent you from accessing a URL unless you are local and authenticated. I show you how you can create a LocalConstraint and an AuthenticatedConstraint. I also demonstrate how you can test your custom constraints. When you create ......
SQL SERVER - EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
One of the JR. Developer asked me a day ago, does SQL Server has similar operation like MINUS clause in Oracle.Absolutely, EXCEPT clause in SQL Server is exactly similar to MINUS operation in Oracle. The EXCEPT query and MINUS query returns all rows in the first query that are not returned in the s......
SQL Server 2008 requires VS 2008 SP1
If your installing SQL Server 2008 on a box that already has Visual Studio 20008 pre SP1, you need to apply VS 2008 SP1 before installing. If not, you'll get this message:
VS 2008 SP1 should be available in a few days.
Thanks to Andrew Brust for pointing this out....Did you know that DotNetS......
SQL Server 2008 RTM Is Here!
That's right! For those of you who have been looking forward to the RTM, the wait is over: SQL Server 2008 has finally been released. It's already available on MSDN. If you haven't played with the new version yet, there are plenty of resources to help you get started. Check out some of these videos......
Displaying a Message in Response to Some Action and Then Hiding It on Subsequent Postbacks
ASP.NET web pages commonly display messages in response to user actions. For instance, a typical CRUD
(Create, Read, Update, Delete) web page might display the message, "Record deleted" immediately after deleting a record and the message "Record updated"
immediately after updating a record. Li......
Hey Ma, I’m On TV!
Recently, Adam Kinney came by my office to interview me for a Channel 9 episode discussing ASP.NET MVC CodePlex Preview 4. I’ve known Adam for a long time, even before he joined Microsoft. I think we met (in person) at Tech-Ed 2003. In any case, we talk a bit about ASP.NET MVC and Preview 4, all th......
Need a simple grid for ASP.NET Ajax?
A client grid control is probably the most requested control for the Ajax Control Toolkit. It will come eventually but if you need a simple grid control right now, DotNetSlackers' Ajax Data Controls do a pretty good job. Their grid supports pagination, sorting, drag and drop of columns, in-place ed......
SQL SERVER - Query to Find Column From All Tables of Database
One question came up just a day ago while I was writing SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN - INTERSECT vs. INNER JOIN.How many tables in database AdventureWorks have column name like ‘EmployeeID’?It was quite an interesting question and I thought if there are scripts wh......
SQL Server 2008 Liberado!!!
El día de hoy fue liberado la versión final (RTM) del tan esperado SQL Server 2008.
La noticia completa la pueden encontrar aquí (en inglés).
Todos los suscriptores de MSDN y TechNet pueden descargarlo inmediatamente.
Estas son las ediciones disponibles de SQL Server 2008 son:
•
S......
100+ PDC Sessions Posted
I just saw that we released another round of PDC sessions... This is the first PDC for years where I have not been personally deeply involved in the planning, so it is fun for me to watch in unfold.. https://sessions.microsoftpdc.com/public/sessions.aspx If you have not already, please regist......
SQL SERVER - 2005 - Get Field Name and Type of Database Table
In today’s article we will see question of one of reader Mohan and answer from expert Imran Mohammed. Imran thank you for answering question of Mohan.Question of Mohan:hi all,how can i get field name and type etc. in MS-SQL server 2005. is there any query available???Answer from Imran Mohammed:@mo......
Want to access SQL Server 2005 from PHP?
You are in luck! Version 1.0 RTM of the SQL Server 2005 Driver for PHP is live! Check out the SQLPHP blog for more details: http://blogs.msdn.com/sqlphp/archive/2008/07/28/microsoft-sql-server-2005-driver-for-php-v1-0-has-released.aspx -Marc Technorati Tags: sql server 2005,php...Did......
ASP.NET MVC Tip #29 – Build a Controller to Debug Your Custom Routes
In this tip, I demonstrate how you can create a special controller that you can use to test your custom routes. I also explain how you can give your routes back their names so you can more effectively unit test your routes. In this tip, I demonstrate how you can create a custom controller that you ......
SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN - INTERSECT vs. INNER JOIN
INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times.When using INTERSECT operator the number and the order of the columns must be......
ASP.NET MVC Application Building #1: Family Video Website – Upload the Videos
In this series of blog entries, I build an entire ASP.NET MVC application from start to finish. I create a Family Video Website that you can use to host home videos and photographs. I have three young children at home, a wife, and a dog. I live in Seattle and my 95 year old grandmother lives in Cal......
SQL SERVER - Effect of Order of Join In Query
Let us try to understand this subject with example.We will use Adventurworks database for this purpose. Table which we will be using are HumanResources.Employee (290 rows), HumanResources.EmployeeDepartmentHistory (296 rows) and HumanResources.Department (16 rows).We will be running following two q......
44 Silverlight Videos
Mike Taulty recently uploaded and amazing collection of Silverlight 2.0 screencasts on how Silverlight works, controls, File IO, networking, UI design, data-binding, interacting with HTML pages, and more. If you want to learn about Silverlight, this set of screencasts should definitely help! ......
ASP.NET MVC Tip #28 – Test If Caching Is Enabled
In this tip, I demonstrate how you can test if the OutputCache attribute is present on a controller action. I also demonstrate how you can test if the OutputCache attribute is set with a particular duration. Caching is the most effective way to improve the performance of an ASP.NET MVC application.......
SQL SERVER - 2008 - Get Current System Date Time
How to get current system date time in SQL Server?First thing which comes to many users is using following script.SELECT GETDATE() AS CurrentDateTimeAbove method is not the only method to retrieve the current system date time for SQL Server. SQL Server 2008 has many different function which provide......
ASP.NET MVC Tip #27 – Create ASP.NET MVC Specific Visual Studio Add-Ins
In this tip, I discuss Eric Hexter’s TDD Class Generator Add-In for Visual Studio. This Add-In enables you to generate a class, an interface, and a test class by entering a single keyboard shortcut. Eric Hexter -- who has done valuable work on the MvcContrib project -- visited Microsoft last ......
Final Two Master Page Tutorials Published
The final two tutorials (#9 and #10) of my Master Pages Tutorial series are now available on www.asp.net. These tutorials explore two advanced master page scenarios:
Specifying the Master Page Programmatically [VB | C#] - in most cases a content page's master page is specified statically throug......
SQL SERVER - 2008 - Find Current System Date Time and Time Offset
If you want to find current datetime in SQL Server I suggest to read the following post :SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}This post is related to new feature available in SQL Server 2008. In SQL Server 2008 there is a function which provi......