将vb转成c#的代码,100分
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<Script runat="Server">
Sub Page_Load
Dim conNorthwind As SqlConnection
Dim cmdCategories As SqlCommand
Dim dstCategories As DataSet
Dim strQuery As String
conNorthwind = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;Database=Northwind" )
strQuery = "select CategoryName As Text, 'products.aspx?catid=' + LTRIM( STR( CategoryID ) ) " & _
"As TreeNodeSrc from Categories As TreeNode for xml auto, XMLDATA"
cmdCategories = New SqlCommand( strQuery, conNorthwind )
conNorthwind.Open()
dstCategories = New DataSet
dstCategories.ReadXml( cmdCategories.ExecuteXmlReader(), XmlReadMode.Fragment )
dstCategories.DataSetName = "TREENODES"
dstCategories.WriteXml( Response.OutputStream )
conNorthwind.Close()
End Sub
</Script>