Monday, March 12, 2012

Using Multiple Programming Languages in ASP.NET Website

Using Multiple Programming Languages in ASP.NET Website

ASP.NET websites do not allow you to use multiple programming languages such as C# and Visual Basic in the App_Code folder of the website project. If you are creating a C# web site and you have copied a Visual Basic source file in App_Code folder, you won’t be able to compile your ASP.NET website. Off course, if it is a small source file, then you can convert it into C# source code either yourself or by using any code converter but it is time wasting practice if you have a large file or you want to use multiple source files. In this tutorial, I will show you how you can use multiple programming languages source files in a single website project by just doing some simple modifications in the configuration settings of the website.

Please check Below Link for more details :


CLICK HERE









Happy Programming.....
DotNet Gems

Sunday, March 4, 2012

Micosoft Certification Exams Codes

Certification
• Exam 70-511: TS: Windows Applications Development with Microsoft .NET Framework 4
• 70-515: MCTS prerequisite: TS: Web Applications Development with Microsoft .NET Framework 4
• 70-513: TS: Windows Communication Foundation Development with Microsoft .NET Framework 4
• 70-516:Accessing Data with Microsoft .NET Framework 4
• 70-518: PRO: Designing and Developing Windows Applications Using Microsoft .NET Framework 4
• 70-519: PRO: Designing and Developing Web Applications Using Microsoft .NET Framework 4
• 70-521: Upgrade: Transition Your MCPD Enterprise Application Developer Skills to MCPD Enterprise Application Developer 4.0
• 70-523: Upgrade: Transition Your MCPD Enterprise Application Developer Skills to MCPD Enterprise Application Developer 4.0

Monday, July 4, 2011

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

Sunday, May 22, 2011

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

Tuesday, March 29, 2011

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

Sunday, October 10, 2010

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

Monday, July 5, 2010

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