我的问题的关键是:当listbox控件lblCollegeName中的值被选中时能够取得
ViewState["name"]=dr["Cname"].ToString();
ViewState["OrignPosition"] = dr["paixu"].ToString();这两项的值
这句代码该如何写
ViewState["name"]=dr["Cname"].ToString();
ViewState["OrignPosition"] = dr["paixu"].ToString();这两项的值
这句代码该如何写
解决方案 »
- 求开源商城!来者有分!
- 请高手给些VBScript操作datagrid的源码,谢谢
- 怎么把查询出来的数据显示成复选框的样子?
- dropwodnlist如何跟checkboxlist联动
- 我用C#写了一个自定义登录控件,增加了事件响应机制 但点击登录或重置控件时事件却无响应,到底哪里错了?以下是自定义控件代码
- 如何让datagrid第一列显示1,2,3,4...
- 关于发布页面字体转换的问题!在线等~~!
- 类似于网上的书店主页上...把书的图片从数据库动态的显示在主页面上?助我解决.100分相送
- 关于CKEDITOR和FCKEDITOR的双击图片的问题
- 如何使鼠标点击DataGrid某一行时能高亮显示这一行(就像桌面程序那样的风格)?
- 关于checkbox及文本框的操作问题(急用)
- 我一直想学会的一个简单问题,谢谢!
如果不行的话,你把!去掉试一试
{
if(!Page.IsPostBack)
{
lblCollegeName.AutoPostBack = true;
BindData();
}
}private void BindData()
{
MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("..\\Data\\Cooperation.mdb")+";";
string strSQL = "SELECT * FROM university ORDER BY paixu";
OleDbConnection MyConn =new OleDbConnection(MyConnString);
OleDbCommand MyComm = new OleDbCommand(strSQL,MyConn);
MyConn.Open();
//填充待排序学校名称
dr = MyComm.ExecuteReader();
while(dr.Read())
{
lblCollegeName.Items.Add( new ListItem(dr["Cname"].ToString(),dr["paixu"].ToString()));
}
dr.Close();
//动态生成排序下拉列表
MyComm.CommandText = "SELECT * FROM university ORDER BY paixu";
dr = MyComm.ExecuteReader();
while(dr.Read())
{
ddlReOrder.Items.Add(new ListItem(dr["Cname"].ToString(),dr["paixu"].ToString()));
}
MyConn.Close();
}private void Button1_Click_1(object sender, System.EventArgs e)
{
int OrignPosition = Int32.Parse(ViewState["OrignPosition"].ToString()); //记录原始位置
int InsertPosition = Int32.Parse(ddlReOrder.SelectedItem.Value); //记录插入位置
int RecordCount; //记录记录总数 MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("..\\Data\\Cooperation.mdb")+";";
string strSQL = "SELECT COUNT(*) AS co FROM University";
OleDbConnection MyConn =new OleDbConnection(MyConnString);
OleDbCommand MyComm = new OleDbCommand(strSQL,MyConn);
MyConn.Open();
//计算记录总数
dr = MyComm.ExecuteReader();
if(dr.Read())
{
RecordCount = Int32.Parse(dr["co"].ToString());
}
else
{
RecordCount = 0;
}
dr.Close();
int i;
//给原始位置做上记号
MyComm.CommandText = "UPDATE University SET paixu = 10000 WHERE paixu ="+OrignPosition;
MyComm.ExecuteNonQuery();
if(OrignPosition > InsertPosition)
{
for(i=OrignPosition-1;i>InsertPosition;i--)
{
MyComm.CommandText = "UPDATE University SET paixu ="+(i+1)+" WHERE paixu ="+i;
MyComm.ExecuteNonQuery();
}
//把记录插入到插入点后
MyComm.CommandText = "UPDATE University SET paixu ="+(InsertPosition+1)+" WHERE paixu = 10000";
MyComm.ExecuteNonQuery(); }
else
{
for(i=OrignPosition+1;i<=InsertPosition;i++)
{
MyComm.CommandText = "UPDATE University SET paixu ="+(i-1)+" WHERE paixu ="+i;
MyComm.ExecuteNonQuery();
}
//把记录插入到插入点
MyComm.CommandText = "UPDATE University SET paixu ="+InsertPosition+" WHERE paixu = 10000";
MyComm.ExecuteNonQuery();
}
MyConn.Close();
Response.Redirect( "paixu.aspx" );
}private void lblCollegeName_SelectedIndexChanged(object sender, System.EventArgs e)
{
if(this.lblCollegeName.SelectedItem!=null)
{
ViewState["name"]=this.lblCollegeName.SelectedItem.Text.ToString();
ViewState["OrignPosition"] = this.lblCollegeName.SelectedItem.Value.ToString();
}
}