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

[hiweiyi2000]

<%@ 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>

[nga96]

重写算了,呵

[LinYeCunFu]

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

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

[WZCNet]

可算给你重写完了。

<%@ 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>

[WZCNet]

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

[AustinLei]

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();
}
}
}

[cancersyf]

<%@ 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>

[lxcc]

<%@ 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>

[hebookboy]

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

[hiweiyi2000]

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

[webdiyer]

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

[zzuxjwhbdotnet]

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