Friday 24 April 2020

Encode and decode of string JavaScript using c#,vb.net

HttpUtility.JavaScriptStringEncode(redrDetails("Description").ToString())

Important sites on Technology


http://www.bigganprojukti.com
http://projuktiteam.com/old
http://forum.projanmo.com
http://www.introprogramming.info
http://www.pchelplinebd.com
http://www.chobirdokan.com 
http://www.techtunes.com.bd
http://banglabookspdf.blogspot.com
http://tech.priyo.com
http:////www.clickntech.com
https://tutorialzine.com
http://it-bari.com 
http://www.freesms.net
http://tutorialbd.com
http://www.dotnetprogramer.in
http://findnerd.com
http://www.bnebookspdf.blogspot.com
http://tutorial.techaltum.com
http://biggani.org
http://www.dotnetprogramer.in
http://www.sanfoundry.com/csharp-programming-examples
http://www.webcodeexpert.com
http://dotnetguts.blogspot.com
http://www.dotnetissues.com
http://www.tutorialsteacher.com
http://www.code-sample.com
https://codek.tv
http://tutlane.com
http://www.webdevelopmenthelp.net
http://dotnetawesome.blogspot.com
http://www.mdabusufian.blogspot.com
http://www.improgrammer.net
http://www.c-sharpcorner.com
http://www.shafaetsplanet.com
http://nanotouchbd.com
http://www.comjagat.com
http://www.computerjagat.org
http://www.banglafamily.com/index.php?app=core&module=global&section=register&do=05
http://bangla-computertips.blogspot.com
http://bangla-tutorials.blogspot.com/p/computer-tips.html
http://tanbircox.blogspot.com/2012/01/computer-bangla-e-books.html
http://csharp.net-tutorials.com
http://www.functionx.com/
http://www.tutorialspoint.com
http://www.blackwasp.co.uk
http://www.madinaharabic.com
http://www.freesmscraze.com
http://www.math.uiuc.edu
http://www.dotnet-tricks.com
http://www.indiabix.com
http://www.tizag.com
http://www.codinghomework.com
http://www.somewhereinblog.net
http://www.tunerpage.com
http://www.sourcecodeonline.com
http://www.moumachibd.com
http://www.ixl.com/
http://www.afreesms.com/intl/bangladesh
http://freesmsurl.blogspot.com/2011/08/unlimited-free-sms-to-bangladesh.html
http://www.puresoftwarecode.com
http://csharp-video-tutorials.blogspot.com/p/free-c-video-tutorial-for-beginners.html
http://www.youtube.com/user/bdpathshala/videos
http://www.bdpathshala.com
http://www.iconarchive.com
http://blog.subeen.com
http://jompesh.com
http://www.jquery-tutorial.net
http://www.accountingcoach.com/quizzes
https://www.khanacademy.org/computing/computer-science/algorithms/binary-search
http://www.accountantforums.com
http://www.programmr.com
http://www.webcodeexpert.com
http://www.dotnetfox.com
http://www.hub4tech.com
http://rahulrajatsingh.com
http://www.sql-server-helper.com
http://csharpstar.com
http://www.softwareandfinance.com
http://www.worldbestlearningcenter.com
http://practiceexercisescsharp.blogspot.com
http://zetcode.com
http://www.shikkhok.com
http://caviswa.wikifoundry.com
https://dotnetcodr.com
http://www.advancesharp.com
http://tektutorialshub.com
http://www.techtud.com
http://www.dotnetcurry.com
http://www.dotnetheaven.com
http://www.aspneto.com
http://www.jquerybyexample.net
http://www.dotnetawesome.com
http://www.aspsnippets.com
http://www.mathtutor.ac.uk
http://mahedee.net
http://codepedia.info
http://www.itdeveloperzone.com
http://www.aspdotnet-suresh.com
www.dotnetspider.com
www.webcoachbd.com
http://www.programmr.com
http://programmercsharp.blogspot.com/
http://www.blackwasp.co.uk
http://www.onlinebuff.com/
http://www.tracetrick.in/
http://www.pskills.org
http://www.crystalreportsbook.com/Crystal Reports CH 03.htm
http://bangla.salearningschool.com/
http://csharp-video-tutorials.blogspot.com/
http://www.sourcecodester.com
http://www.programmr.com
http://www.codebytopic.com
http://mahedee.net/
http://htmltutor.org/
https://mva.microsoft.com/en-US/training-courses/javascript-for-experienced-developers-14430?l=YVFpNWj4B_9305918554
http://csharp-station.com/
http://tutorial.techaltum.com/
http://www.improgrammer.net/
http://www.javascriptkit.com/
https://designmodo.com
http://www.neerajcodesolutions.com/
http://www.code-sample.com/
http://krasimirtsonev.com/
https://bn.maateen.me
http://www.vetbossel.in
http://www.barelyfitz.com
https://css-tricks.com
https://www.xul.fr
http://www.cybrhome.com/collection/developers
http://www.quackit.com/
http://tutorial.techaltum.com
http://www.w3resource.com
http://www.freewebmentor.com
http://uddoktarkhoje.com
https://www.codeplex.com/
http://www.encodedna.com
http://avtartime.com
http://www.codesolution.org
http://www.studytonight.com
www.geekboots.com
https://sabe.io
http://eloquentjavascript.net
https://www.smashingmagazine.com
https://resource-centre.net
http://web-engineering.info
https://www.tutorialrepublic.com
www.bduddokta.com
https://www.codementor.io
http://codersblock.com
http://www.dotnet4techies.com
http://www.sanwebcorner.com
https://www.latlong.net/convert-address-to-lat-long.html
https://medium.com
https://www.webucator.com
https://webdesignledger.com
http://tutorial.techaltum.com
http://demos.sanwebcorner.com/
www.instantstreetview.com
https://www.coursera.org
https://study.com
https://javascript.info/
https://www.webucator.com/tutorial/advanced-javascript/index.cfm
https://www.guru99.com
https://www.geeksforgeeks.org

Saturday 28 September 2019

Get all primary key with table name from SQL Server database.

select schema_name(tab.schema_id) as [schema_name],
    tab.[name] as table_name,
    pk.[name] as pk_name,
    substring(column_names, 1, len(column_names)-1) as [columns]
from sys.tables tab
    left outer join sys.indexes pk
        on tab.object_id = pk.object_id
        and pk.is_primary_key = 1
   cross apply (select col.[name] + ', '
                    from sys.index_columns ic
                        inner join sys.columns col
                            on ic.object_id = col.object_id
                            and ic.column_id = col.column_id
                    where ic.object_id = tab.object_id
                        and ic.index_id = pk.index_id
                            order by col.column_id
                            for xml path ('') ) D (column_names)
order by schema_name(tab.schema_id),
    tab.[name]
    

Sunday 3 March 2019

target = '_blank' asp.net button click code behind.

        Context.Response.Write("<script language='javascript'>window.open('LedgerLessPDF.aspx?cid=" & New Encription().DecryptTripleDES(Request.Cookies("CompID").Value, "*n3x@") & "&ACCID=" & ddlBankHead.SelectedValue & "&F=" & txtFromDate.Text & "&T=" & txtTodate.Text & "','_newtab');</script>")

Tuesday 11 December 2018

convert sql datasource to data table and compute on data table.


        Dim dvSql As DataView = DirectCast(SqlDataSourceCustomerInvoice.Select(DataSourceSelectArguments.Empty), DataView)
        Dim dt As New DataTable
        dt = dvSql.ToTable


        Dim amt As Double = dt.Compute("Sum(RentAmt)", "")
        Literal1.Text = "Total Amount: " & amt.ToString()

Wednesday 24 October 2018

select drop down list in asp.net by Text.

ddItems.Items.FindByText("Text").Selected = true;
ddItems.SelectedValue = ddItems.Items.FindByText("Text").Value;

Saturday 20 October 2018

convert sqldatasource to dataview and loop on data.

        Dim paidamount As Double = 0
        Dim saleamount As Double = 0
        Dim DueAmt As Double = 0


        Dim dvSql As DataView = DirectCast(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)
        For Each drvSql As DataRowView In dvSql
            saleamount += CDbl(drvSql("TotalValue"))
            paidamount += CDbl(drvSql("PaidAmount"))

            DueAmt += CDbl(drvSql("Due"))
        Next