ASP.NET || Javascript || Dataobject || Code Solutions Free Open Source code for Developersnoreply@blogger.com (Bharat Kumar)Fri, 1 Nov 2024 15:56:43 +0530Blogger http://www.blogger.com91125http://aspsourcecode.blogspot.com/en-usnoAsp Source Code Developed By Bharat KumarASP.NET || Javascript || Dataobject || Code Solutions Free Open Source code for DevelopersASP.NET || Javascript || Dataobject || Code Solutions Free Open Source code for DevelopersBharat Kumarnoreply@blogger.comBharat Kumarhttp://aspsourcecode.blogspot.com/2021/07/automate-git-commands-across-repos.htmlThu, 15 Jul 2021 00:16:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-548964673471648776 Writing Scripts to Apply Commands Across RepositoriesI store all of my local repositories in a particular directory. I wrote these scripts to automate one or more git commands to run on each repository within that directory. It could also be used to do a general clean-up before committing anything to your repository.Here are two ways to do it.Method 1:Use this when you want to store 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2019/11/sonarqube-configuration-for-net-core.htmlWed, 6 Nov 2019 13:43:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4780614643871749022 When multiple developers are working on the same project, it's good to have a code review. SonarQube is a tool through which we can evaluate our code. Here, for demo purposes, we are going to evaluate the web API which is built on .NET Core. Let's see step by step implementation. In order to run SonarQube, we need to install JAVA in our local system.   Refer to the below link to 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2019/11/change-data-capture-in-sql-server.htmlWed, 6 Nov 2019 13:40:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-6599125751155651737 Change Data Capture (CDC) captures the data of insert, update and delete activity. When you insert or delete the data in the table it maintains a record for the same data. When you update the data it maintains records for before updating the data and after updating the data. To understand the change data capture we go through the following process. Process Step 1: Create DB  0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2019/06/8-ways-to-fine-tune-your-sql-queries.htmlFine-tune SQL Queriessql serverMon, 10 Jun 2019 19:46:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4834983240572463928 In organizations that operate without a data warehouse or separate analytical database for reporting, the only source of the latest and up-to-date data may be in the live production database. When querying a production database, optimization is key. An inefficient query may pose a burden on the production database’s resources, and cause slow performance or loss of service for other 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2015/07/google-charts-api-using-database-in.htmlASP.NETchartsgoogle apiTue, 7 Jul 2015 18:56:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-7610318014169045516 Google Charts API Using Database in ASP.Net This article introduces use of the Google Charts API with a database in ASP.NET. Google has a jQuery API for chart and graph visuals. I have explored a little more and used them with a SQL Server database data and simply plunged chart data with jQuery into an aspx page and it works. Step1 : .aspx <%@ Page Language="C#" AutoEventWireup="true"0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2015/06/cascadingdropdown-sample-with-ajax.htmlajax toolkitcascadingdropdownweb serviceThu, 18 Jun 2015 19:41:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4419409779763720349 CascadingDropDown Sample - Ajax Control Toolkit Step 1 : aspx page <table>             <tr>                 <td style="width: 80px">Country:                 </td>                 <td>     &0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2015/05/authentication-aspnetsessionid-session.htmlASP.NETcookiesecuritysessionFri, 8 May 2015 18:24:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-7568578068398703771 Authentication ASP.NET_SessionID (Session) along with AuthToken (GUID) cookie Introduction ASP.NET Session keeps track of the user by creating a cookie called ASP.NET_SessionId in the user browser. This cookie value is checked for every request to ensure that the data being served is specific to that user. In many applications, a Session variable is used to track the logged in user,0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2015/04/preview-uploading-image-file-using.htmlImage uploadjqueryMon, 20 Apr 2015 18:47:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-1324876452859115238 Preview & upload Image file using jquery with generic handler ashx without postback Step 1 : UploadImage.htm <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title>uploading file using jquery with generic handler ashx</title>     <script src="http://code.jquery.com/jquery-1.10.2.js" type="text/javascript0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2014/12/oops-interview-questions.htmlTue, 30 Dec 2014 18:33:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-583639838348926283 1. What is mean by Class? Class is a structure that describes the state (property) and behavior (methods) of the object. It is a template or blueprint to create objects of the class. Class represents the noun and it can be used as type in programming language. E.g Car, Person etc 2. What is mean by Objects? Object is an executable copy of a class. State and behavior of the objects are defined 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2014/09/disable-right-click-in-form-by-java.htmlDisable the Right ClickjavascriptThu, 25 Sep 2014 12:28:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-1061677982104162710 Disable the right click in forms using JavaScript  Script : var message="Function Disabled";  function clickIE() {if (document.all) {(message);return false;}}  function clickNS(e) {if  (document.layers||(document.getElementById&&!document.all)) {  if (e.which==2||e.which==3) {(message);return false;}}}  if (document.layers)  {0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2014/06/run-command.htmldosrun commandswindowsFri, 13 Jun 2014 18:04:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4622837514018950637 Common Tasks with Run Below are a list of commands you can type into the Run dialog: Run Calculatorcalc Run Command Promptcmd Run Firefox (if installed)firefox Run Internet Exploreriexplore Run Microsoft Word (if installed)winword Run Microsoft Excel (if installed)excel Run Microsoft Outlook (if installed)outlook Run Notepadnotepad Run Wordpadwordpad Open Control Panelcontrol panel Open 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2014/05/youtube-or-other-iframe-video-responsive.htmliframeresponsiveWed, 14 May 2014 16:43:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-1947627617521053 How to make a YouTube (or other iframe) video responsive Adding videos to your responsive website can cause many issues with how the site responds to different screen sizes.  iframes are by default a fixed size.  By adding a few lines of CSS to your style sheet and wrapping the iframe embed code in a little bit of HTML you can make your video responsive.   Step 1 : Add this 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2014/03/importing-csv-file-using-bulk-insert.htmlbulk InsertSQLWed, 5 Mar 2014 19:36:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-797573152081933188 public void BulkUpload(DataTable prodSalesData)     {         //DataTable prodSalesData = new DataTable("ProductSalesData");         // Create Column 1: SaleDate         DataColumn dateColumn = new DataColumn();         dateColumn.DataType = Type.GetType("System.DateTime");         0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2014/03/sql-bulk-insert-using-command-builder.htmlWed, 5 Mar 2014 09:45:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4900244039959987270 public void BulkUpload(DataTable odtRatings)     {         DataSet ods = new DataSet();         using (System.Data.SqlClient.SqlConnection objConnection = new System.Data.SqlClient.SqlConnection(SqlHelper.CONN_STRG))         {             //System.Data.SqlClient.SqlDataAdapter objDataAdapter = new0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/04/introduction-basic-concepts-of-oops.htmlIntroduction Basic Concepts of OopsTue, 30 Apr 2013 09:41:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-7032058170955146121 Introduction Basic Concepts of Oops: Encapsulation and inheritance these are the basic concepts of Object Oriented Programming. I wrote it for those who don't have basic concepts of oop, and for those who feels programming a big monster. I tried to make them understand as much easiest. Introduction In this article i would like to describe the people what are the basic concepts of 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/02/play-videos-in-pure-html-page-windows.htmlhtmlplay videosThu, 21 Feb 2013 17:57:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-132618835864189283 Play Videos in Pure HTML Page (Windows Media Player) Page1 :  Videoslist.html <table border="1" cellpadding="10" cellspacing="0" width="90%" align="center" > <tr> <td> <a href="videos.html?vid=videos/1.wmv"><b>Video 1</b></a>  // Local Video Path 4noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/02/different-tab-style-expanding-of.htmldivjavascripttabsWed, 13 Feb 2013 18:15:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-3164274384745033013 Different Tab Style, expanding of arbitrary DIVs on the page enabled <html> <head> <link rel="stylesheet" type="text/css" href="http://www.dynamicdrive.com/dynamicindex17/tabcontent/tabcontent.css" /> <script type="text/javascript" src="http://www.dynamicdrive.com/dynamicindex17/tabcontent/tabcontent.js"> /*********************************************** * Tab 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/02/light-effect-text-using-javascript.htmljavascriptlighteffect textWed, 13 Feb 2013 17:52:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4552998333719338455 Light Effect Text using javascript <script language="JavaScript1.2"> var message="Welcome to Visitor!" var neonbasecolor="green" var neontextcolor="black" var flashspeed=100  //in milliseconds ///No need to edit below this line///// var n=0 if (document.all||document.getElementById){ document.write('<font color="'+neonbasecolor+'">') for (m=0;m<message.length;m++) 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/02/textarea-text-count-on-typing.htmljavascriptonkeyuptextareaWed, 13 Feb 2013 16:12:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4256440464806468217 TextArea Count and Max Length ( Displaying ) on Keyup <html> <head> <script type="text/javascript"> function textCounter(textarea, counterID, maxLen) { cnt = document.getElementById(counterID); if (textarea.value.length > maxLen){ textarea.value = textarea.value.substring(0,maxLen); } cnt.innerHTML = maxLen - textarea.value.length; } </script></head&0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/02/create-dynamic-rows-using-javascript.htmlDynamic TablejavascriptWed, 13 Feb 2013 16:01:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-5866659607743703825 Create Dynamic Rows using javascript <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <link href="/style.css" rel="stylesheet" type="text/css" /> <title>More form fields</title> <script 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/01/export-datatable-to-pdf.htmlExport DataTable to PDFPDFFri, 25 Jan 2013 20:44:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-7979309333652627527 Export DataTable to PDF Step 1 : Import the namespaces using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html; using iTextSharp.text.html.simpleparser; Step 2 : Add the Export Method public void ExportToPdf(DataTable dt) { Document document = new Document(); //string Filename = GetUniqueName(4); PdfWriter writer = 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/01/css-tool-tip.htmlcsstooltipWed, 23 Jan 2013 11:51:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-4494632379709233715 Step 1 : Add Style sheet below the header Tag <style type="text/css"> .tooltip { border-bottom: 1px dotted #000000; color: #000000; outline: none; cursor: help; text-decoration:blink; position: relative; } .tooltip span { margin-left: -999em; position: absolute; } .tooltip:hover span { border-radius: 5px 5px; -moz-border-radius: 5px; 0noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/01/pop-up-div-on-hover.htmlmousehoverpopup formWed, 9 Jan 2013 15:37:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-7832682659896819443 Pop-up div on hover use the below code to popup the text and Develop the Code... <!DOCTYPE html> <html lang="en">   <head>     <meta charset="utf-8" />     <title>jQuery Tutorial - Pop-up div on hover</title>     <style type="text/css">             h1, h3 {       &1noreply@blogger.com (Bharat Kumar)http://aspsourcecode.blogspot.com/2013/01/css-mouseover-for-text.htmlcsscss message boxstylesWed, 9 Jan 2013 14:41:00 +0530tag:blogger.com,1999:blog-3021752241367922231.post-6750415954699890680 CSS mouseover for text on Mouse over text to be displayed by CSS. Mouseover with a text paragraph <span class="dropt" title="Title for the pop-up">Hot Zone Text <span style="width:500px;">Pop-up text</span> </span> CSS code for class dropt: span.dropt {border-bottom: thin dotted; background: #ffeedd;} span.dropt:hover {text-decoration: none; background: #0noreply@blogger.com (Bharat Kumar)