Migrate from Other Web Technologies to ASP.NET

HOW TO INSTALL THE MIATRTION TOOL

2010-01-14T02:39:58.457-05:00

when i am installing the Setup.msi, it required to install asp to asp.net migration assistant on your pc.
So i download ASP to ASP.NET Migration Asssitant Training.msi and try to install it, but it said the installer was interrupted before asp to asp.net migration assistant training could be installed, you need to restart the installer to try again. I only click "Close" to exit.
Can you help me how to do?

Convert Windows Application into Web Application with Code

2011-04-10T09:05:16.583-04:00

Dear All,

I have a Windows Application and i got a requirement to convert all forms in Windows application to Web Application including code written in windows application. How can we do this. please do needful...

How to execute multiple parameterized stored procedures within a single transaction using ADODB

2013-04-29T17:26:08.847-04:00

Hi There,

I am trying to port over a classic ASP application to .Net and it has been pretty smooth so far. (I know ideally this should be rewritten in ADO.Net but we do not have the time for that at the moment.)

One method requires a bunch of queries to be executed within a single transaction. The original code as is works just fine but I also need to address a SQL injection issue with it and implement parameterized queries.

Original code: (Works fine)

Sub UpdateSortOrder()

        Dim sqlstr As String, x As Integer

        Dim cn = Server.CreateObject("ADODB.Connection")
        cn.Open(Application("Conn_ConnectionString"))

        Dim rs = Server.CreateObject("ADODB.RecordSet")
        rs.CursorType = 3
        rs.ActiveConnection = cn

        cn.BeginTrans()
        For x = 1 To UBound(Session("DivisionsArray"))
            sqlstr = "EXEC SPName" & _
            "@Param1 = 'value1'," & _
            "@Param2 = " & Value2 & "")

            cn.Execute(sqlstr)
        Next
        cn.CommitTrans()

        cn.Close()
    End Sub

Updated Code: Gives error: COUNT field inccorrect or syntax error. It however seems to me that once cannot pass parameters to Connection object.

Sub UpdateSortOrder()

        Dim sqlstr As String, x As Integer, cn As New ADODB.Connection()

        cn.Open(Application("Conn_ConnectionString"))

        cn.BeginTrans()
        For x = 1 To UBound(Session("DivisionsArray"))
            
            Dim rs As New ADODB.RecordSet(), cmd As New ADODB.Command()
            
            cmd.CommandText = "SPName"
            cmd.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
            cmd.Parameters.Append(cmd.CreateParameter("@Param1", ADODB.DataTypeEnum.adVarChar,            ADODB.ParameterDirectionEnum.adParamInput, 10, value1))
            cmd.Parameters.Append(cmd.CreateParameter("@Param2", ADODB.DataTypeEnum.adUnsignedTinyInt, ADODB.ParameterDirectionEnum.adParamInput, 1, value2))      

            cn.execute(cmd.CommandText, 1, cmd.CommandType)
            
            cmd = Nothing
        Next
        cn.CommitTrans()
        cn.Close()
        
End Sub

If I try this instead, I get the below error:

The connection cannot be used to perform this operation. It is either closed or invalid in this context.

    Sub UpdateSortOrder()

        Dim sqlstr As String, x As Integer, cn As New ADODB.Connection()

        cn.Open(Application("Conn_ConnectionString"))

        cn.BeginTrans()
        For x = 1 To UBound(Session("DivisionsArray"))
            
            Dim rs As New ADODB.RecordSet(), cmd As New ADODB.Command()
            
            rs.CursorType = 3
            rs.ActiveConnection = cn

            cmd.CommandText = "SPName"
            cmd.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
            cmd.Parameters.Append(Param1)
            cmd.Parameters.Append(Param2)      
            
            rs = cmd.Execute()
           
            cmd = Nothing
            rs = Nothing
        Next

        cn.CommitTrans()
        cn.Close()
        
    End Sub

Converting classic ASP to ASP.Net questions

2013-04-29T17:48:36.013-04:00

I have never coded in classic so I hope this is the correct forum. What I need to do is convert to ASP.Net and there are some methods that are depricated or not available and some of those I am trying to get around. What this part of the app is supposed to do is use iTextSharp.dll to create a PDF and display on the bottom of the page. Here is the old code and some conversion (hope I did it correctly if not please correct me :) )

private void WriteDocumentWithStreaming(ref SqlConnection conn, int ConfID)
        {
            SqlParameter param = null;
            SqlCommand cmd = new SqlCommand(SQLData.spGetPDF, conn);
            cmd.CommandType = CommandType.StoredProcedure;
            param = new SqlParameter("@ConfID", SqlDbType.NVarChar, 100);
            param.Direction = ParameterDirection.Input;
            param.Value = ConfID;
            cmd.Parameters.Add(param);
            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            if (reader.HasRows)
            {
                reader.Read();
                TextWriter tw;
                
                HttpResponse Response = new HttpResponse(tw);
                                
                Response.Buffer = false;
                Response.ClearHeaders();
                Response.ContentType = "Application/pdf";
               
                const int ChunkSize = 1024;
                byte[] buffer = new byte[ChunkSize];
                byte[] binary = (reader["PDFContent"]) as byte[];
                MemoryStream ms = new MemoryStream(binary);
                int SizeToWrite = ChunkSize;
                for (int i = 0; i < binary.GetUpperBound(0) - 1; i = i + ChunkSize)
                {
                    if (!Response.IsClientConnected)
                    {
                        return;
                    }
                    if (i + ChunkSize >= binary.Length)
                    {
                        SizeToWrite = binary.Length - i;
                    }
                    byte[] chunk = new byte[SizeToWrite];
                    ms.Read(chunk, 0, SizeToWrite);
                    Response.BinaryWrite(chunk);
                    Response.Flush();
                }
                Response.Close();
            }
            reader.Close();
        }

 don't see where this is actually writing somewhere.

Also, what control do I use to display?

It was originally this way:

sLink = "./PDFConfirmations/default.aspx?cid=" & requestLong("confirmation_id") 
response.write "<iframe src=""" & sLink & """ width=""100%"" height=""50%"" ></iframe>"

how to convert pdf to jpg in asp.net..

2012-05-02T06:17:45.917-04:00

i want to convert pdf page convert in to jpg..

32 bit DLL on 64 bit Windows 8

2013-04-17T16:34:46.353-04:00

IIS 8
asp.net framework 4.0
Windows Server 2012

I have a legacy dll I need to execute, here is the C# I am trying to use

[DllImport(@"codegen.dll")]
    public static extern string CreateCode2(
     int level,
     string name,
     string encrypt_template,
     Int64 hardwareID,
     int otherinfo1,
     int otherinfo2,
     int otherinfo3,
     int otherinfo4,
     int otherinfo5
     );

I have placed the 32 bit DLL in the /bin folder, the website root, AND c:\windows\system32.

I have enabled 32 bit apps as mentioned here http://stackoverflow.com/questions/13828135/register-com-dll-on-windows-server-2008-64-bit

Yet - over and over, I get this when trying to invoke my page.

Server Error in '/' Application.
Unable to load DLL 'codegen.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.DllNotFoundException: Unable to load DLL 'codegen.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Source Error:


Line 135:        if (long.TryParse(sfp, out lfp))
Line 136:        {
Line 137:            unlockingcode = CreateCode2((int)1, regname, encrypt_template, lfp, 0, 0, 0, 0, 0);
Line 138:        }
Line 139:


Source File: xxxx    Line: 137

Stack Trace:


[DllNotFoundException: Unable to load DLL 'codegen.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)]
   classicReceipt.CreateCode2(Int32 level, String name, String encrypt_template, Int64 hardwareID, Int32 otherinfo1, Int32 otherinfo2, Int32 otherinfo3, Int32 otherinfo4, Int32 otherinfo5) +0

The DLL is in 3 places, including the search path, there is just NO WAY that it "could not be found". My mind is going to "permissions", but how do I debug that?

update:

I went into "Handler Mappings" and added a handler for:

*.DLL
CodeGen.DLL
read/write/script/execute

No change.

oh and before anyone suggests it, this DLL does not need to be registered.

Populate Excel Sheet with ASP.NET (C#)

2012-09-05T14:00:51.143-04:00

Hello,

I can populate the page, but I cannot save an excel file so that I can use that excel file to open up for the user. I can save a PDF file, but not an excel file. I am using Microsoft.Office.Interop.Excel to generate an excel page.

Please help. I cannot save that file or have it popup so that the user can save the file.

Thank you so much,

Cristina

P.S. CODE is BELOW........................................................................

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Collections;
using System.Data;
using System.Runtime.CompilerServices;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
using System.Windows.Forms;
using System.Collections;

    /// <summary>
    /// public static void makeWorkbook(ArrayList aktRecords, Hashtable recCount, int numWorkbooks)
    ///
    /// make the workbook from the array that was generated.
    /// </summary>
    /// <param name="aktRecords"></param>
    /// <param name="recCount"></param>
    /// <param name="numWorkbooks"></param>
    public static void makeWorkbook(ArrayList aktRecords, Hashtable recCount)
    {
        //Declare these two variables globally so you can access them from both
        //Button1 and Button2.
        Excel.Application objApp;
        Excel._Workbook objBook;

        Excel.Workbooks objBooks;
        Excel.Sheets objSheets;
        Excel._Worksheet objSheet;

        Excel.Range range;

        try
        {
            // Instantiate Excel and start a new workbook.
            objApp = new Excel.Application();
            if (objApp == null)
            {
                return;
            }
            // Uncomment the line below if you want to see what's happening in Excel
            objApp.Visible = true;

            objBooks = objApp.Workbooks;
            objBook = objBooks.Add(Missing.Value);
            objSheets = objBook.Worksheets;

            int i = 0; // each site array.
            String siteCode;

            foreach (String[,] ary in aktRecords.ToArray())
            {

                siteCode = ary[1, 12];

                int count = (int)recCount[siteCode];

                objSheet = (Excel.Worksheet)objSheets.Add(Missing.Value);
                objSheet = (Excel._Worksheet)objSheets.get_Item(1);

                range = objSheet.get_Range("A1", Missing.Value);

                range = range.get_Resize(count + 1, 12);

                //Set the range value to the array.
                range.set_Value(Missing.Value, ary);
                objSheet.get_Range("A1", "K1").Font.Bold = true;
                objSheet.get_Range("A1", "K1").HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
                objSheet.get_Range("G1", "K1").ColumnWidth = 25;
                objSheet.get_Range("B1", "F1").ColumnWidth = 10;
                objSheet.get_Range("A1").ColumnWidth = 12;
                objSheet.get_Range("I1").ColumnWidth = 10;
                objSheet.Name = siteCode;
            }

            //Return control of Excel to the user.
            objApp.Visible = true;
            objApp.UserControl = true;

        }
        catch (Exception theException)
        {
            String errorMessage;
            errorMessage = "Error: ";
            errorMessage = String.Concat(errorMessage, theException.Message);
            errorMessage = String.Concat(errorMessage, " Line: ");
            errorMessage = String.Concat(errorMessage, theException.Source);

            //MessageBox.Show(errorMessage, "Error");
        }

    }

exe pain

2013-04-15T00:45:02.52-04:00

Through a series of unfortunate events, I now have to write a .exe program to call from a classic ASP site.

my IIS 8 server REFUSES to execute it no matter what settings and permissions I grant.

I am trying to execute this exe in an iframe with a call that looks like this (based on my old Delphi CGI App.

http://mysite.com/cgi-bin/program.exe/getcode.html?ORDERID=1647

I PROMISE you that the exe is there in the right folder, yet I get

HTTP Error 404.0 - Not Found
The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

I have tried this in and out of the IFRAME and get the same result.

the EXE I have written is not complicated, and should return SOMETHING, even if it gets an error internally. I just think Windows is refusing to execute it.

I am TOTALLY NEW to IIS8 so feel free to help me out with the details of what I need to do.

php to as.net converter

2013-04-04T06:16:15.63-04:00

I have a very big php website which I want to convert it into asp.net or asp.net MVC. Can anybody suggest if there is any free tool which can automate this job.

Regards,

Krishna.

Any regrets about leaving the LAMP stack?

2012-01-21T03:02:39.307-05:00

I've worked with .NET a pretty good amount now. I've put a lot of hours into learning about the platform. It's shocking to say, but thousands of hours. This has included tutorials, books, classses, countless hours debugging...etc. I feel like I've come a really long way. I also now that I have a lot further to go to be an "Enterprise" level guy. I wonder if i really want to be an "Enterprise" level guy.

I'm starting to wonder if the LAMP stack would be better suited for me. My impression is that the php based stuff may be simpler. It's also that WordPress may be pretty easy to deliver stuff more quickly. These impressions may be completely inaccurate. The open source aspect is also very cool.

The .NET Framework and all of the other technologies used with it, SQL Server, ASP.net...etc, are incredible. The breadth and capabilities of them are phenominal. But the complexity seems like it can get tremendous.

Does anyone have any regrets about moving from the LAMP stack or any other thoughts on this? Is the PHP world a simpler world?

From Java to C# Calling a web API

2013-01-30T16:32:42.163-05:00

Hi,

This piece of code I have written to make a request doesn't work. I have an example on Java but there are pieces of the code that I can't translate. Here is the sample code:

URL url = new URL (“http://www.costco.com”);
String encodingStyleURI = Constants.NS_URI_SOAP_ENC;
// Build the call.
Call call = new Call ();
call.setTargetObjectURI ("/ urn/ services");
call.setMethodName ("POST");
call.setEncodingStyleURI(encodingStyleURI);
// Make the call
Response resp = call.invoke (/* router URL */ url, /* actionURI */ "" );
// Check the response.
Parameter result = resp.getReturnValue();
System.out.println (result.getValue ()); }

How can I translate "String encodingStyleURI = Constants.NS_URI_SOAP_ENC;" and "call.setEncodingStyleURI(encodingStyleURI);" from java to C#??

I'm calling an Apache server with soap services I guess.

Any help please! Thank you

PHP curl_Init to asp.net 4.0

2013-03-17T09:41:21.007-04:00

I need help to translate PHP to asp.net 4.0. I would appreciate some code or examples that can help me to work it out.

/Connection Resource
  //http://docs.oneall.com/api/resources/connections/read-connection-details/
  $resource_uri = 'https://'.$site_domain.'/connections/'.$token .'.json';
 
  //Setup connection
  $curl = curl_init();
  curl_setopt($curl, CURLOPT_URL, $resource_uri);
  curl_setopt($curl, CURLOPT_HEADER, 0);
  curl_setopt($curl, CURLOPT_USERPWD, $site_public_key . ":" . $site_private_key);
  curl_setopt($curl, CURLOPT_TIMEOUT, 15);
  curl_setopt($curl, CURLOPT_VERBOSE, 0);
  curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
  curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 1);
  curl_setopt($curl, CURLOPT_FAILONERROR, 0);
 
  //Send request
  $result_json = curl_exec($curl);
 
  //Error
  if ($result_json === false)
  {
    //You may want to implement your custom error handling here
    echo 'Curl error: ' . curl_error($curl). '<br />';
    echo 'Curl info: ' . curl_getinfo($curl). '<br />';
    curl_close($curl);
  }
  //Success
  else
  {
    //Close connection
    curl_close($curl);
 
    //Decode
    $json = json_decode ($result_json);
 
    //Extract data
    $data = $json->response->result->data;
 
    //Check for plugin
    if ($data->plugin->key == 'social_login')
    {
      //Operation successfull
      if ($data->plugin->data->status == 'success')
      {
        //The token of the user that signed in/up using his social network account
        $user_token = $data->user->user_token;
 
        // 1] Check if you have a userID for this token in your database
        $user_id = GetUserIdForUserToken($user_token);
 
        // 2.1] If the userID is empty then this is the first time that this user signs in
        if ($user_id === null)

Many thanks in advance

Emil

php to asp solution!!!

2013-02-07T15:23:17.237-05:00

Good morning to all of the knowledge I request all of you, is that I need to convert an application that I have in php to asp.net and the only way I've seen that has worked for many people is with PHP to ASP.NET 1.x Migration Assistant but when trying to install will not let me. I thank all of you if I cooperate or tell me a way to convert php code to visual.net.

Using IKVM libraries

2013-03-15T09:35:19.85-04:00

Apparently, some of the lib work fine, and when i run in eclipse it works fine.

but when i add the lib in asp.net and use the functions

which opens a jdbc connection it does not work

had added

the ikvm core /jdbc to the reference

Convert VBScript Code into Asp.Net C#

2013-03-06T05:19:14.203-05:00

Sub GetPhotos(category)
		Dim template, xsl
		
		Set xsl = Server.CreateObject("Msxml2.FreeThreadedDOMDocument")
        xsl.async = false
        xsl.load Server.MapPath("photogallery/photos.xslt")
        
        Set template = Server.CreateObject("MSXML2.XSLTemplate")
        template.stylesheet = xsl	        
		
		Dim doc 
		Set doc = Server.CreateObject("Msxml2.FreeThreadedDOMDocument")
	    doc.async = False
	    doc.load( Server.MapPath("photogallery/photos.xml") )
	    
	    Dim proc 
	    Set proc = template.createProcessor()
	    proc.input = doc
	    proc.output = Response
 
		proc.addParameter "category", category		
	    proc.transform
    End Sub

how to Conver the Code from PHP to C#.NET

2013-02-17T11:29:51.95-05:00

Convert this Code into Asp.Net C#.........

2013-03-05T10:52:36.247-05:00

Sub GetPhotos(category)
		Dim template, xsl
		
		Set xsl = Server.CreateObject("Msxml2.FreeThreadedDOMDocument")
        xsl.async = false
        xsl.load Server.MapPath("photogallery/photos.xslt")
        
        Set template = Server.CreateObject("MSXML2.XSLTemplate")
        template.stylesheet = xsl	        
		
		Dim doc 
		Set doc = Server.CreateObject("Msxml2.FreeThreadedDOMDocument")
	    doc.async = False
	    doc.load( Server.MapPath("photogallery/photos.xml") )
	    
	    Dim proc 
	    Set proc = template.createProcessor()
	    proc.input = doc
	    proc.output = Response
 
		proc.addParameter "category", category		
	    proc.transform
    End Sub

Migration of 1.1 to 4.0 Framework

2013-03-04T20:16:41.553-05:00

Hi,

When migrating 1.1 to 4.0 Framework from visual studio,all obsolete methods calls are shown in warnings. Does Microsoft provides support for the obsolete methods in case of any issues or should those warning needs to changed as per the recommendation.

A quick response is highly appreciated.

Delay migration by using C# .NET code in Classic ASP pages (COM Interop)

2013-03-12T15:36:28.103-04:00

We have a large amount of ASP pages and instead of taking a lot of time and effort of converting them all to ASP.NET, we would like to quickly be able to utilize some functionality from .NET Framework 4.0.

I didn't think this would be that difficult, but I'm unable to call my test DLL (that is written in C# under 4.0 framework) in my Classic ASP page. I've come across several articles outlining various steps. Here's what I've done so far:

1) Adjusted the Assembly.cs to have ComVisible(true)
2) Compiled the DLL
3) regasm Tester.dll /tlb: Tester.tlb
4) gacutil /i Tester.dll
5) added code to classic ASP page:

dim foo
set foo = Server.CreateObject("Tester.Numbers")

Below is the original page where I got the code for my test DLL:

http://www.codeproject.com/Articles/3511/Exposing-NET-Components-to-COM

Can anyone see anything I'm missing? Thanks.

Help a classic ASP person understand QueryString Parameters in ASP.net

2013-03-12T13:19:12.037-04:00

Hello, I am only familiar with classic ASP and am trying to learn how to upgrade my site. We will eventually be upgrading to SQL server, but for now, we are connecting to an access database.

My question is how to create dynamic SQL statements based on QueryString variables. In the past with classic ASP I would do something like the following. It would allow me to build a search page where the user could select any one of many different search combinations. All the values would pass through the querystring and then based on what the user selected, I could create the proper SQL statement.

If Request.QueryString("pony") <> "" Then
mySQL = "SELECT * FROM myTable INNER JOIN myPony on myTable.petID = myPony.petID WHERE pony LIKE '" & Request.QueryString("pony") & "'"
Else
mySQL = "SELECT * FROM myTable INNER JOIN myHorse on myTable.petID = myHorse.petID WHERE horse LIKE '" & Request.QueryString("horse") & "'"
End if

I'm not sure how do do the equivalent in ASP.net. I've got a SqlDataSource and can add a QueryStringParameter like the following, however, I'm not sure how to make it "dynamic" to accommodate any number of different search parameters entered by the user.

<asp:SqlDataSource ID="results" runat="server" 
        ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:MyConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT * FROM myTable WHERE myTable.Name=@MyName"> 
        <selectparameters>
              <asp:QueryStringParameter QueryStringField="MyName" Name="MyName" />
          </selectparameters>

Thanks in advance for any help or suggestions you can provide