PHP to ASP.NET Migration Assistant Alpha

Re: how i can convert this link from php to asp.net

er.tushar — Wed, 26 Sep 2007 07:00:47 GMT

Hi,

That can be done easily. Moreover you can use the code on line no 13. But in that case, when u use Delete.aspx, you can access the query parameters like this:
Request.QueryString["ProductID"]
Remember that you will always get string in return. In case you want to use it as integer, you'll have to parse it.

There are many ways of converting this code. I am jotting down the simplest way of doing it, as it is written in PHP (just changing the syntax) (Assuming that you'll be using SQL Server).

On Page_Load function :

StringBuilder content = new StringBuilder();

content.Append("<TABLE BORDER=2> <TR><TD>Full Name<TD>Nick Name<TD>Options</TR>");
SqlConnection con = new SqlConnection("server=localhost;user=tushar;password=pwd;database=asp");
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = " Select * from personnel";
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{

       content.Append("<TR><TD>" + reader["FirstName"].ToString() + reader["LastName"].ToString() );
       ........
       ........

}
content.Append("</table>");
reader.Close();
con.Close();
Response.Write(content.ToString());

I hope this helps.

Regards,

Tushar

Re: how i can convert this link from php to asp.net

Girijesh — Mon, 26 Feb 2007 10:44:01 GMT

nikolaoscy:
1 2 "; 7 echo""; 9 while ($myrow = mysql_fetch_array($result)) 10 { 11 echo "
Full Name Nick Name Options
".$myrow["firstname"]." ".$myrow["nick"]; 12 echo " View "; 13 echo "Delete"; 14 } 15 echo "
"; 16 ?> 17 can i use statement like that on line 13 in order to pass the ID of the record i want to delete to mynext page using asp.net and specificaly C#? thank you Nicholas

Is problem is still unsolved?

Re: how i can convert this link from php to asp.net

nikolaoscy — Mon, 29 Nov 2004 19:24:36 GMT

i done this
<td>Delete</td>

but i get the following error: Compiler Error Message: CS1519: Invalid token '(' in class, struct, or interface member declaration

how i can capture that datareader in my delete page?

how i can convert this link from php to asp.net

nikolaoscy — Mon, 29 Nov 2004 17:41:34 GMT

1 <HTML>
2 <?php
3 $db = mysql_connect("localhost", "root", "");
4 mysql_select_db("learndb",$db);
5 $result = mysql_query("SELECT * FROM personnel",$db);
6 echo "<TABLE BORDER=2>";
7 echo"<TR><TD>Full Name<TD>Nick Name<TD>Options</TR>";
9 while ($myrow = mysql_fetch_array($result))
10 {
11 echo "<TR><TD>".$myrow["firstname"]." ".$myrow["nick"];
12 echo "<TD><a href=\"view.php?id=".$myrow[id]."\">View</a> ";
13 echo "<a href=\"delete.php?id=".$myrow[id]."\">Delete</a>";
14 }
15 echo "</TABLE>";
16 ?>
17 </HTML>

can i use statement like that on line 13 in order to pass the ID of the record i want to delete to mynext page using asp.net and specificaly C#?

thank you
Nicholas

Full Name	Nick Name	Options
".$myrow["firstname"]." ".$myrow["nick"]; 12 echo "	View "; 13 echo "Delete"; 14 } 15 echo "