Question

因此,这是我关于在C#使用(联线集合)的尝试的样本代码。现在,我认为这给我留下了一个错误,因为这不是一种方法。然而,是否有办法解决这一问题?

<% @Page Language="C#" %>
<% @Import Namespace="System.Data.Odbc" %>
<% @Import Namespace="System.Web.Configuration" %>

<script language="C#" runat="server">
string conString = WebConfigurationManager.ConnectionStrings["cheese"].ConnectionString;
using (OdbcConnection con = new OdbcConnection(conString)) {
    con.Open();
    using (OdbcCommand com = new OdbcCommand("SELECT pies FROM ducks WHERE isapie = nope", con)) {
        com.Parameters.AddWithValue("@var", paramWord);
        using (OdbcDataReader reader = com.ExecuteReader()) {
            while (reader.Read()) {
                Response.Write(reader.GetString(0));
            }
        }
    }
    con.Close();
}
</script>

现在,错误的行文是:

Line 8:     using (OdbcConnection con = new OdbcConnection(conString)) {

上述错误是:

Compiler Error Message: CS1519: Invalid token  using  in class, struct, or interface member declaration

I am trying to keep my code minimalistic, easy to edit, etc. and so I d like to avoid having unnecessary classes, methods, etc. simply for the sake of having them.

Answer 1

你有几个问题;第一个问题是,你没有以某种方法界定你的法典。为此,您必须将其放在第_页内。例如:

<script language="C#" runat="server">

void Page_Load(object sender,EventArgs e)
{
    string conString = WebConfigurationManager.ConnectionStrings["cheese"].ConnectionString;
    using (OdbcConnection con = new OdbcConnection(conString)) {
    con.Open();

    using (OdbcCommand com = new OdbcCommand("SELECT pies FROM ducks WHERE isapie = nope", con)) {
         com.Parameters.AddWithValue("@var", paramWord);
         using (OdbcDataReader reader = com.ExecuteReader()) {
          while (reader.Read()) 
             Response.Write(reader.GetString(0));
         }//end using reader
     }//end using ODBCCommand
  }//end using ODBCConnection
}//page_load
</script>

The second problem is that you use using to open the connection and you attempt to use the connection object below the closing }. By the the time you reach the second using where you instantiate your OdbcCommand the connection is already disposed. you need to do something like this instead:

void Page_Load(object sender,EventArgs e)
{
string conString = WebConfigurationManager.ConnectionStrings["cheese"].ConnectionString;
using (OdbcConnection con = new OdbcConnection(conString)) {
    con.Open();

using (OdbcCommand com = new OdbcCommand("SELECT pies FROM ducks WHERE isapie = nope", con)) {
    com.Parameters.AddWithValue("@var", paramWord);
    using (OdbcDataReader reader = com.ExecuteReader()) {
        while (reader.Read()) {
            Response.Write(reader.GetString(0));
        }
    }
 }
 con.Close();
 }
}

最后,你应使用电网或某种电网,来约束这一数据,而不是对<代码>的书写。答复精准/代码。假设你在你的网页上有“观点”,你可以完全做到:

gridView.DataSource=com.ExecuteReader();
gridView.DataBind();

友情链接