|
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: Mustafa Basgun
|
Rating:
|
|
Workarounds are generally referred as temporary fixes, but I guess this one is kind of a permanent solution for the 2.0 version of ASP.NET due to the security policy of Microsoft. In the early beta versions of ASP.NET 2.0, SQLDataSource was keeping the latest SelectCommand between the postbacks. But now, it isn't. It is currently reverting to the one that was set when the original data source was created probably during the first Page_Load....
|
|
|
|
Total Hits: 62 | Today: 0
|
Author: Michael Youssef
|
Rating:
|
|
If you read any of my previous ADO.NET articles you will find that I used the SqlDataReader class in many of the examples. Today we will talk more about the SqlDataReader class and use its methods and properties. Some of you may wonder how the SqlDataReader class gets access to the fields using the array-like syntax; we will talk about that as well....
|
|
|
|
Total Hits: 210 | Today: 0
|
Author: Murali Pamidi.
|
Rating:
|
|
Concurrency is one of the key issues that should be addressed in distributed applications. When multiple users attempt to update the same set of data at same time, updates will be made in first come first serve basis without knowing the changes made by the other user. Eg..
1. “User A” reads a data row to Edit.
2. While User A still works on editing the data, User B reads the same data modifies a field and updates.
3. User A finally updates the data without noticing the changes made by U...
|
|
|
|
Total Hits: 5 | Today: 0
|
Author: Chinmay Majmudar
|
Rating:
|
|
This tool seperates all the stored procedures under database schema into individual script files and saves them in the specified physical location.For e.g. Suppose we have 3 procedures (SP1,SP2,SP3) in database and we need to save these procedures in the location 'C:\'. This tool saves these stored procedures into individual .sql file in specified location. (C:\SP1.sql,C:\SP2.sql,C:\SP3.sql)....
|
|
|
|
Total Hits: 84 | Today: 0
|
Author: easerve
|
Rating:
|
|
Deleting records from SQL Server 2000 database using ADO.NET a fairly strait forward process, much like deleting records from SQL Server 2000 Database....
|
|
|
|
Total Hits: 55 | Today: 0
|
Author: Nanaa
|
Rating:
|
|
This topic gives you a new approach on how to organize your data into tables that will help you generate large ‘Crosstab’ Reports using SQL Server 2000/2005. This is a custom solution and does not use and PIVOT/UNPIVOT options which are available in SQL Server 2005....
|
|
|
|
Total Hits: 49 | Today: 0
|
Author: Pradeep Tiwari
|
Rating:
|
|
This article provides some tips when working with Master page or SqlDataSource insert function in VS 2005.
For better understanding please download application files attached with this posting, whose reference is used through this posting.
Today I was doing some practice work with CreateUserControl, and in the customization process I thought to add a UserControl (BillingAddressUserControl.ascx) to collect data for billing address. Very simple one, just 4 values Address, city, stat...
|
|
|
|
Total Hits: 29 | Today: 0
|
Author: Habiburahman Khaled
|
Rating:
|
|
This article will show you how to insert one Parent and Multiple child records into a MySQL Database with transaction at once. It also examines how to use MySQL 5.0, MySQL .Net Connector 5.0.7, and ASP.NET/C# with the 3-Layer application design architecture....
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: pistasio.
|
Rating:
|
|
Recently while working on a order processing system, I needed a quick and dirty method to insert rows of a child table. I thought this would be the ideal time to use .NET 2.0's Gridview and SqlDataSource feature set. While I quickly picked up on the update, delete, and select capabilites, the insert functionality didn't appear to work....
|
|
|
|
Total Hits: 88 | Today: 0
|
Author: Brian Lockwood
|
Rating:
|
|
There is much confusion about how to actually implement connection pooling in VB/VBScript code. In this article I have actually tested various ASP syntax variations and verified the results when using connection pooling.
To preface - here are some highlights and some recent findings:
* Setting connections to "Nothing" in ASP does NOT affect connection pooling - only closing or not closing the connections will affect it if you are using the same connection string. It is recommen...
|
|
|
|
Total Hits: 86 | Today: 1
|
Author: Tony Patton
|
Rating:
|
|
Maintaining data between server calls is a common dilemma in Web development. You may need to maintain information for the application or for particular user sessions. Storing such data is called state management, and ASP.NET provides the means to accomplish the task via various avenues. This includes storing the data in memory, on a state server, or via Microsoft SQL Server. This article focuses on session state management (user session data) using SQL Server....
|
|
|
|
Total Hits: 233 | Today: 0
|
Author: Syed Adnan Ahmed
|
Rating:
|
|
Normally, web developers do not take keen interest to secure the query string and connection string information which usually reside in the registry and the user passwords which reside in the user registration database table. When I was creating a web-based application in ASP.NET, I decided to use these three encryptions to fully secure my application.
.NET provides us the new Cryptography classes to encrypt and decrypt the data whenever used. I would like to discuss these three issues one by...
|
|
|
|
Total Hits: 120 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
Virtually all ASP.NET applications of interest work with database data at some level, and one of the most common databases used in ASP.NET applications is Microsoft's own SQL Server database. With relational databases like SQL, commands are issued through the SQL syntax, which includes SELECT, INSERT, UPDATE, and DELETE statements, among others. One way to issue a command to a database from an ASP.NET application is to craft the SQL query in the application itself. Such queries are often called ...
|
|
|
|
Total Hits: 229 | Today: 0
|
Author: Scott Mitchell
|
Rating:
|
|
There are a plethora of steps one can take to harden their data-drive applications from malicious hackers. The first and most important step is to harden your database software. Do you have the latest service packs installed? If you're using Microsoft SQL Server, have you chosen a sufficiently complex password for the sa account? Is your database configured only to accept Windows authentication? For more information on improving your database's security see 10 Steps to Help Secure SQL Server 200...
|
|
|
|
Total Hits: 20 | Today: 0
|
Author: Robert Hess
|
Rating:
|
|
How can I detect if a user clicks the browser's Stop button while viewing my Web page?Starting with Microsoft® Internet Explorer 5.0, your client-side code can trap the onstop event. This will let you know when the user clicks the Stop button, hits the Escape key, or when the page is being unloaded.
Trapping the onstop event is handy when your page is performing some process that you want to stop when the user clicks the Stop button. Some processes that users might want to stop include...
|
|
|
|
Total Hits: 13 | Today: 0
|
Author: AzamSharp
|
Rating:
|
|
Statistics are always useful to keep track of the application performance. Database statistics are always the main interest of the developer since they need to track that how many times the application has accessed the database. In this article I will show you that how you can use SqlConnection class to retrieve the statistics....
|
|
|
|
Total Hits: 176 | Today: 0
|
Author: Jesudas Chinnathampi (Das)
|
Rating:
|
|
This article is a continuation of my previous article, which talks about Inserting an image to Sql Server. I would recommend to read the above article before continuing this. Compared to inserting an image, retreiving is very simple. The only new thing that we need to write an image is, we need to use the method BinaryWrite of the Response Object. Also we need to set the appropriate content type. In this article, we will discuss about retrieving images from a Sql Server....
|
|
|
|
Total Hits: 52 | Today: 1
|
Author: Andrei Pociu
|
Rating:
|
|
In the first part of the tutorial we dealed with the SQL database. Now we're going to make the ASP .NET web application that will establish a connection to the database we created. We're going to do it the Visual Studio way - as quick as possible with very few effort....
|
|
|
|
Total Hits: 142 | Today: 0
|
Author: Jesudas Chinnathampi (Das)
|
Rating:
|
|
Before reading this article, I assume that the reader has read my two previous articles which talks about Inserting Images to Sql Server in ASP .NET and Retreiving Images from Sql Server in ASP .NET. In this article, we will discuss about populating a datagrid with images. Of course, the images will be coming from the database....
|
|
|
|
Total Hits: 72 | Today: 1
|
Author: Fernando Finelli.
|
Rating:
|
|
his article shows you how to trap the ASP & SQL errors in your site.
First thing to do is to change the Custom Error for The Web Site Properties
[Internal Server Error] - HTTP Error 500 & 500;5001 to this URL - /trap.asp...
|
|
|
|
|
|
