数据绑定问题。用一个list选择名称后，得出此名称的两个参数。请帮分析代码
<% @ Page Language="C#" Debug="true" %>
<% @ import namespace="System.Data"%>
<% @ import namespace="System.Data.OleDb"%>
<script Language="c#" runat="server">
OleDbDataReader dr;
private void Page_Load(object sender,EventArgs e)
{
if(!IsPostBack){string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\jizhan.mdb;";
String strSel = "Select jizhan from zhanzhi";
OleDbConnection MyConn = new OleDbConnection(MyConnString);
OleDbCommand MyComm = new OleDbCommand(strSel,MyConn);
MyConn.Open();
dr = MyComm.ExecuteReader();
list1.Items.Clear();
while(dr.Read())
list1.Items.Add(dr["jizhan"].ToString());
dr.Close();
MyConn.Close();
}
}
void GetAuthor(object sender,EventArgs e)
{
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\DataBase\\jizhan.mdb;";
OleDbConnection MyConn = new OleDbConnection(MyConnString);
String mySelectCmd="Select jizhan from zhanzhi";
OleDbCommand MyCommand = new OleDbCommand(mySelectCmd,MyConn);
MyCommand.CommandType=CommandType.StoredProcedure;
MyCommand.Parameters.Add("RETURN_VALUE",OleDbType.Integer);
MyCommand.Parameters["Return_Value"].Direction=ParameterDirection.ReturnValue;
MyCommand.Parameters.Add("@jizhan",OleDbType.VarChar,11);
MyCommand.Parameters["@jizhan"].Direction=ParameterDirection.Input;
MyCommand.Parameters["@jizhan"].Value=list1.SelectedItem.Text;
MyCommand.Parameters.Add("@zuobiaox",OleDbType.VarChar,20);
MyCommand.Parameters["@zuobiaox"].Direction=ParameterDirection.Output;
MyCommand.Parameters.Add("@zuobiaoy",OleDbType.VarChar,40);
MyCommand.Parameters["@zuobiaoy"].Direction=ParameterDirection.Output;
MyConn.Open();
MyCommand.ExecuteNonQuery();
zuobiaox.Text=MyCommand.Parameters["@zuobiaox"].Value.ToString();
zuobiaoy.Text=MyCommand.Parameters["@zuobiaoy"].Value.ToString();
MyConn.Close();
}
</script>
<form runat="server" id="form1" >
<asp:Panel id="panel1" runat="server">
<asp:DropDownList id="list1" runat="Server" />
<asp:Button id="button3" Text="显示距离" runat="Server" Onclick="GetAuthor" />
<asp:TextBox id="zuobiaox" runat="Server"/>
<asp:TextBox id="zuobiaoy" runat="Server"/>
</asp:Panel>
</form>
问题点数：0、回复次数：0Top
