Monday, December 31, 2012
Tuesday, December 25, 2012
Return SQL Query Result as XML in SQL Server- AUTO Mode
In previous post Return SQL Query Result as XML in SQL Server , I explained For XML clause for getting the query result as XML. I also explained RAW mode of this clause. Today I will explain AUTO mode in FOR XML clause.
Monday, December 24, 2012
Return SQL Query Result as XML in SQL Server
SQL Server gives you option to retrieve data as XML by supporting For XML clause, which you can use as a part of your query. For XML clause supports different options that let you define the format of XML data.
For XML clause supports four modes- RAW, AUTO, EXPLICIT, PATH. When you include the FOR XML clause in your query, you must specify one of these four modes.
For XML clause supports four modes- RAW, AUTO, EXPLICIT, PATH. When you include the FOR XML clause in your query, you must specify one of these four modes.
Thursday, December 13, 2012
Validate ListBox and DropDown List using Required Field Validator
In Asp.Net, sometimes we need to validate List Box and Drop Down List using Required Field validator. Here I am sharing the code for validating List Box and Drop Down List, it is tricky and avoids to use java script function for validation.
Monday, December 10, 2012
How to delete row in data table?
In ASP.Net, we use the data tables very frequently in our application. Sometimes
we need to delete the row from the data table using some filter condition.
Today I will show you a simple example to delete the row from your data table
based on your condition.
We
have a data table structure as showing below in the image:
Subscribe to:
Posts (Atom)