将vb转成c#的代码，100分

2004-11-08 08:19:56 121 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

hiweiyi2000 墨衍会员 · AI 创作全网分发关注 + 加入社区

将VB.NET网站转换成C#的全过程在学习URL重写过程中碰到个是VB写的源码，看起来总是不爽的就GOOLE了下感觉这个文章写的不错原文地址 http://www.cnblogs.com/cngunner/archive/2006/01/16/318309.html前两天看到一个比较不错的网站，可惜是用vb.net写的，俺弄不大明白，于是心血来潮想把它全部转换成C#代码的。花了N长时间，问了几多人，费了不少神，总算是能让网阅读详情

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<Script runat="Server">

Sub Page_Load
Dim conNorthwind As SqlConnection
Dim cmdProducts As SqlCommand
Dim dstProducts As DataSet
Dim strQuery As String

conNorthwind = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;Database=Northwind" )
strQuery = "select ProductName As Text from Products As TreeNode " & _
"Where CategoryID=@categoryID for xml auto, XMLDATA "
cmdProducts = New SqlCommand( strQuery, conNorthwind )
cmdProducts.Parameters.Add( new SqlParameter( "@categoryID", Request.QueryString( "catID" ) ) )
conNorthwind.Open()
dstProducts = New DataSet
dstProducts.ReadXml( cmdProducts.ExecuteXmlReader(), XmlReadMode.Fragment )
dstProducts.DataSetName = "TREENODES"
dstProducts.WriteXml( Response.OutputStream )
conNorthwind.Close()
End Sub

</Script>

...全文

C# VS VB C# C#是微软公司发布的一种面向对象的、运行于.NET Framework之上的高级程序设计语言。 1、C#实现了完全意义上的面向对象？任何事物都必须封装在类中，或者作为类的实例成员－－没有全局常数、全局变量，也没有全局方法。所以C#实现了完全意义上的面向对象。2、C#数据类型：堆和栈的区别：堆：程序运行期间动态分配的内存空间，你可以根据程序的运行情况确定要分配的堆内存阅读详情

hiweiyi2000

.NET社区 62,272 成员 668,968 内容

+ 关注 + 加入社区

切换为时间正序

zzuxjwhbdotnet 2004-11-08

打赏
举报

同意楼上的，先修改web.config文件的配置值。

webdiyer 2004-11-08

打赏
举报

把你的web.config中的customErrors配置节改为：<customErrors mode="Off"/>，然后看看具体出错信息。

hiweiyi2000 2004-11-08

打赏
举报

我不是懒，是自已改的运行不了。
上面的帮改的，也运行不了。
地址：
www.lybh.com/s/TreeViewDataSet.aspx

hebookboy 2004-11-08

打赏
举报

楼主还是应该自己动手来写写这些东西了

lxcc 2004-11-08

打赏
举报

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<Script runat="Server">

private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conNorthwind = new SqlConnection("Server=localhost;UID=sa;PWD=secret;Database=Northwind");
SqlCommand cmdProducts;
DataSet dstProducts = new DataSet();
string strQuery="";

strQuery = "select ProductName As Text from Products As TreeNode " & _
"Where CategoryID=@categoryID for xml auto, XMLDATA ";
cmdProducts = new SqlCommand( strQuery, conNorthwind );
cmdProducts.Parameters.Add( new SqlParameter( "@categoryID", Request.QueryString( "catID" ) ) );
conNorthwind.Open();

dstProducts.ReadXml( cmdProducts.ExecuteXmlReader(), XmlReadMode.Fragment );
dstProducts.DataSetName = "TREENODES";
dstProducts.WriteXml( Response.OutputStream );
conNorthwind.Close();
}

</Script>

cancersyf 2004-11-08

打赏
举报

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<Script runat="Server" language="c#">
void Page_Load()
{
SqlConnection conNorthwind;
SqlCommand cmdProducts;
DataSet dstProducts;
string strQuery;
conNorthwind = new SqlConnection("Server=localhost;UID=sa;PWD=secret;Database=Northwind");
strQuery = "select ProductName As Text from Products As TreeNode " + "Where CategoryID=@categoryID for xml auto, XMLDATA ";
cmdProducts = new SqlCommand(strQuery, conNorthwind);
cmdProducts.Parameters.Add(new SqlParameter("@categoryID", Request.QueryString("catID")));
conNorthwind.Open();
dstProducts = new DataSet();
dstProducts.ReadXml(cmdProducts.ExecuteXmlReader(), XmlReadMode.Fragment);
dstProducts.DataSetName = "TREENODES";
dstProducts.WriteXml(Response.OutputStream);
conNorthwind.Close();
}
</Script>

AustinLei 2004-11-08

打赏
举报

using System;
using System.Data;
using System.Data.SqlClient;

namespace CS
{
/// <summary>
/// Default 的摘要说明。
/// </summary>
public class Default : System.Web.UI.Page
{

private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conNorthwind = new SqlConnection( "Server=localhost;UID=sa;PWD=secret;Database=Northwind" );
String strQuery = "select ProductName As Text from Products As TreeNode Where CategoryID=@categoryID for xml auto, XMLDATA";
SqlCommand cmdProducts = new SqlCommand( strQuery, conNorthwind );
cmdProducts.Parameters.Add( new SqlParameter( "@categoryID", Request.QueryString["catID"]));
conNorthwind.Open();
DataSet dstProducts = new DataSet();
dstProducts.ReadXml( cmdProducts.ExecuteXmlReader(), XmlReadMode.Fragment );
dstProducts.DataSetName = "TREENODES";
dstProducts.WriteXml( Response.OutputStream );
conNorthwind.Close();
}
}
}

WZCNet 2004-11-08

打赏
举报

没别的目的，只想接分，不过楼主确实应该自已动手写一下。

WZCNet 2004-11-08

打赏
举报

可算给你重写完了。

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<Script runat="Server">

void Page_Load()
{
SqlConnection conNorthwind = new SqlConnection("Server=localhost;UID=sa;PWD=secret;Database=Northwind");
SqlCommand cmdProducts;
String strQuery = @"select ProductName As Text from Products As TreeNode " +
"Where CategoryID=@categoryID for xml auto, XMLDATA ";
cmdProducts = new SqlCommand(strQuery, conNorthwind);

cmdProducts.Parameters.Add(new SqlParameter( "@categoryID", Request.QueryString( "catID" )));

conNorthwind.Open();
DataSet dstProducts = new DataSet();

dstProducts.ReadXml( cmdProducts.ExecuteXmlReader(), XmlReadMode.Fragment );
dstProducts.DataSetName = "TREENODES";
dstProducts.WriteXml( Response.OutputStream );
conNorthwind.Close();

}
</Script>

LinYeCunFu 2004-11-08

打赏
举报

楼主是不是应该勤快一点？对着C#的语法一句一句来不就完了么？

大家都知道万事开头难，但你明摆着是不想开这个头呀，所以呢，我会写，我也不会帮你写。

nga96 2004-11-08

打赏
举报

重写算了,呵

将vb转成c#的代码，100分

相关推荐