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