For loop in sql serever

Hi Friend

pelase check the how to loop the and insert data into db using the for loop in sql server (For multiple values )

DECLARE @CNT INT
DECLARE @Q NVARCHAR(1000)

SET @CNT = 110001
WHILE(@CNT <= 113500)
BEGIN
SET @Q = 'insert into plate_numbers values('+ CAST (@CNT AS NVARCHAR) + ')'
-- PRINT @Q
EXEC sp_executesql @Q
SET @CNT = @CNT + 1
END


Regards,
Bhaskar

Some Importent asp.net links

Hi Frineds ,

Below Links are very IMP and good links for asp.net nad C#.Net applciations.

http://www.codeproject.com/KB/WCF/WCFFAQPart3.aspx#Introduction and Goal Interview question in the WCF

http://forums.asp.net/t/1123350.aspx EVAL Function call in Gridview

http://www.aspsnippets.com/Articles/Save-and-Retrieve-Dynamic-TextBox-values-in-GridView-to-SQL-Server-Database.aspx Dynamc textbox insertion

http://jayantnet.wordpress.com/2010/01/23/row-level-javascript-with-gridview-in-asp-net-client-side-calculations-in-gridview/ (Javascript row total)

http://www.dotnetfunda.com/articles/article1182-calculate-running-total-in-a-grid-view-and-display-.aspx?sms_ss=dotnetkicks Count the valuesi ngridview

http://forums.asp.net/p/1235268/2240512.aspx

http://programming.top54u.com/post/ASPNet-20-GridView-Compute-Column-Sum-using-C-sharp.aspx (Compute the grdiview )


http://www.dotnetfunda.com/forums/thread2140-how-to-get-first-column-value-of-each-row-in-gridview.aspx

http://forums.asp.net/t/1538966.aspx footer summary

http://www.eggheadcafe.com/community/aspnet/17/10270672/enable-and-disable-textbox-item-template.aspx disable the textbox any contoles in grid

http://csharpdotnetfreak.blogspot.com/2008/12/hide-gridview-columns-in-normal-mode.html disable the columns in asp.net

http://www.highoncoding.com/Articles/219_GridView_All_Rows_in_Edit_Mode.aspx gridview full edit mode with out clicking the edit button

http://www.functionx.com/aspnet/articles/timesheet.htm IMP and good one for simple time sheet format

http://www.codeproject.com/KB/custom-controls/schedule.aspx (Schedule the event)

http://www.aspdotnetcodes.com/Creating_Class_File_Asp.Net.aspx (Properties of the ASP.NET) GET And SET method values – 10th MARCH
http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx Grid view edit, delete, insert operations.

http://blog.evonet.com.au/post/Creating-a-Stylish-looking-Gridview-with-Filtering.aspx Grdiview Filtering

http://forums.asp.net/p/1107979/1707549.aspx Insert the rows data into sql server DB

http://www.aspdotnetfaq.com/Faq/How-to-insert-row-in-GridView-with-SqlDataSource.aspx row wise update

http://geekswithblogs.net/dotNETvinz/archive/2009/08/02/save-dynamic-textbox-values-from-gridview-to-database.aspx (Dynamic data tables values insertion in asp.net)

http://csharpdotnetfreak.blogspot.com/2009/07/display-total-in-gridview-footer.html columns wise count in asp.net

http://msdn.microsoft.com/en-us/library/ms972948.aspx edit the gridview

http://forums.asp.net/p/1596082/4051697.aspx (Good time sheet example code )

http://www.codeproject.com/KB/aspnet/ExploringSession.aspx (Session concept)




http://www.codeproject.com/KB/aspnet/DataGrid_Template_columns.aspx




http://www.codeproject.com/KB/office/ExportDataSetToExcel.aspx

http://www.codedigest.com/Articles/ASPNET/13_Export_dataset_to_Excel_with_XSLT_in_AspNet_20.aspx (Code download)

http://forums.asp.net/t/1214938.aspx (Convert the data to excel)

http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet_20_%E2%80%93Gridview_to_Excel_DataTable_to_Excel.aspx (sample code for excel)


http://www.codeproject.com/KB/office/ExportDataSetToExcel.aspx (IMP and useful code)

http://technet.microsoft.com/en-us/library/bb124810(EXCHG.65).aspx (Increase the Space)

http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet_20_%E2%80%93Gridview_to_Excel_DataTable_to_Excel.aspx ( New Excel )

http://www.xmlforasp.net/codeSection.aspx?csID=64

http://www.codeproject.com/KB/office/FastExcelExporting.aspx

http://www.eggheadcafe.com/community/aspnet/2/10071419/application-memory-size-and-out-of-memory-exception.aspx (out of memory excetion)



http://aspalliance.com/979_Working_with_Web_Services_Using_ASPNET.all (WebServices)

http://www.c-sharpcorner.com/Blogs/BlogDetail.aspx?BlogId=770 (Unable to open the file in .Net 2005.)

http://support.microsoft.com/default.aspx?scid=kb;en-us;196505&Product=ie600 (IIS Problem for download the Excel from Internet)

http://forums.asp.net/t/956392.aspx (Internet Explorer can not download the file from server)

http://wiki.asp.net/page.aspx/387/connecting-to-sap-data-from-aspnet/ (SAP Connecter for .NET)

http://www.codeproject.com/KB/dotnet/SAP_NET_Connector.aspx (SAP Connection)

http://www.thespot4sap.com/articles/SAP_Netweaver_Creating_Web_Apps.asp (SAP Connector)

http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/210/exporting-a-datagrid-to-excel-the-easy-way.aspx (export to excel)

http://www.codeproject.com/KB/dotnet/SAP_NET_Connector.aspx?display=PrintAll (SAP.net Connector and Code. How to connect the SAP)

http://www.1keydata.com/sql/sqlouterjoin.html oracle group By

http://www.webreference.com/programming/javascript/ajax_forms/ AJAX Based Form Submission


Sql Injection concept – Attacks the website.
http://stackoverflow.com/questions/3775964/xss-attack-on-the-asp-net-website
http://en.wikipedia.org/wiki/Cross-site_scripting
http://www.testingsecurity.com/how-to-test/injection-vulnerabilities/XSS-Injection

Thank you ,
Bhaskar

Create an ASP.NET Dynamic Data Website Using ADO.NET Entity Framework

Create an ASP.NET Dynamic Data Website Using ADO.NET Entity Framework.

Plese Check the below links for Dynamic Data website.

http://www.dotnetcurry.com/ShowArticle.aspx?ID=232

For Video Tutorial

http://www.asp.net/aspnet-in-net-35-sp1/videos/getting-started-with-dynamic-data

Please also refer these keywords in google "Routing","Dynamic Data"

Happy Coding
Uday

Export data from dataset to excel with more than 65000 records with multiple excel sheets in asp.net

Hi ,

Please check below links for exporting data from dataset to excel with multiple excel sheets in asp.net .

http://www.codeproject.com/KB/office/OutputDatasetToExcel.aspx (This link is working fine but it is accept only 65000 records but excel 2007 it is open the 10 lac records per sheet)


another one if you fine tune that code then we achive the multiple sheets in excel with number of rows.

http://www.codeproject.com/KB/office/ExportDataSetToExcel.aspx

Regards,
Uday

A Step-by-Step Approach to Creating a Web Service Task Using SQL Server Integration Services

Hello DotNetgems/SSIS Guys,

Web Services and SOA are assuming greater importance in the IT strategy of businesses. This tutorial describes a step-by-step method to create a SSIS package containing a web service task. The web service used in the tutorial will be discussed first. This will be followed by describing how the package is configured using the Visual Studio 2005 IDE.

Click Here for more info

Regards,
Uday

WPF Examples for .Net 4.0

WPF Examples for .Net 4.0

please check here for WPF and some more .Net 4.0 concepts.

http://windowsclient.net/wpf/


http://msdn.microsoft.com/en-us/library/aa970268.aspx


Happy Coding

what is Strong reference and Weak reference?

Just to refresh our minds about strong references before starting to talk about weak references.A reference pointing to an object created by the new operator is called a Strong Reference and as long as this reference is still pointing to that object it will reside in memory. However, if a weak reference points to an object it gets collected by the garbage collector as soon as more memory is in need.

When to use Weak references?

For example, if you have data (not critical for your application) to be retrieved from an xml file, text file, or even a data source then you could use a weak reference. Even if it get collected by the garbage collector you can still re-process the data.

Below is a sample code to get a weak reference out of a strong one.

// Create new strong reference to an object
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
// Load the xml into that object
doc.Load(Server.MapPath("~/test.xml"));
// Create weak reference out of doc object
WeakReference docWeakRef = new WeakReference(doc);
// Set the doc object to null;
doc = null;

Now you can still get the strong reference to that object before using

docWeakRef.Target // which returns a strong reference to the weak object


Just remember before using the object always check the Target property if it is null then the object has been collected by the garbage collector and of course removed from the memory.

Regards,
Udayabhaskar