public void BindGrid(string execsql)
{
string mysql=execsql;
da=new SqlDataAdapter(mysql,myConnection);
DataSet ds=new DataSet();
da.Fill(ds);
this.MyList.DataSource=ds;
this.MyList.DataBind();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
this.MyList.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.MyList_PageIndexChanged); }
#endregion protected void btnSearch_Click(object sender, System.EventArgs e)
{
try
{
mysql = "select * from Orders,users where Orders.UserID=users.UserID and OrderID =" + this.txtBookName.Text.Trim();
this.BindGrid(mysql);
}
catch
{
Response.Write("<script language=javascript>alert('查找失败,请回到首页才能进行高级查询')</script>");
}
}
//选择所有
protected void SelectAll(object sender, EventArgs e)
{
CheckBox check = (CheckBox)sender;
if (check.Text == "全选")
{
int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{
CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
cb.Checked = check.Checked;
}
}
} protected void MyList_SelectedIndexChanged(object sender, System.EventArgs e)
{
} //删除订单
protected void btnDelete(object sender, EventArgs e)
{
int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{
CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
if (cb.Checked)
{
string deletestr="delete from Orders where OrderID="+Convert.ToInt32(this.MyList.Items[i].Cells[0].Text);
SqlCommand myCommand=new SqlCommand(deletestr,myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
this.BindGrid(mysql);
} //分页
private void MyList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
this.MyList.CurrentPageIndex=e.NewPageIndex;
this.BindGrid(mysql);
} protected void Exit_Click(object sender, System.EventArgs e)
{
Session.Abandon();
Response.Redirect("Default.aspx");
} private void Button1_Click(object sender, System.EventArgs e)
{
} protected void btnAddBook_Click(object sender, System.EventArgs e)
{
Response.Redirect("AddBook.aspx");
}
{
string mysql=execsql;
da=new SqlDataAdapter(mysql,myConnection);
DataSet ds=new DataSet();
da.Fill(ds);
this.MyList.DataSource=ds;
this.MyList.DataBind();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
this.MyList.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.MyList_PageIndexChanged); }
#endregion protected void btnSearch_Click(object sender, System.EventArgs e)
{
try
{
mysql = "select * from Orders,users where Orders.UserID=users.UserID and OrderID =" + this.txtBookName.Text.Trim();
this.BindGrid(mysql);
}
catch
{
Response.Write("<script language=javascript>alert('查找失败,请回到首页才能进行高级查询')</script>");
}
}
//选择所有
protected void SelectAll(object sender, EventArgs e)
{
CheckBox check = (CheckBox)sender;
if (check.Text == "全选")
{
int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{
CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
cb.Checked = check.Checked;
}
}
} protected void MyList_SelectedIndexChanged(object sender, System.EventArgs e)
{
} //删除订单
protected void btnDelete(object sender, EventArgs e)
{
int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{
CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
if (cb.Checked)
{
string deletestr="delete from Orders where OrderID="+Convert.ToInt32(this.MyList.Items[i].Cells[0].Text);
SqlCommand myCommand=new SqlCommand(deletestr,myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
this.BindGrid(mysql);
} //分页
private void MyList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
this.MyList.CurrentPageIndex=e.NewPageIndex;
this.BindGrid(mysql);
} protected void Exit_Click(object sender, System.EventArgs e)
{
Session.Abandon();
Response.Redirect("Default.aspx");
} private void Button1_Click(object sender, System.EventArgs e)
{
} protected void btnAddBook_Click(object sender, System.EventArgs e)
{
Response.Redirect("AddBook.aspx");
}
解决方案 »
- C# HTTP请求 读写流问题, 读取丢失问题,请问什么原因?
- 关于DataAdapter填充非框架数据集DataSet
- 求:如何得到TREEVIEW当前选中节点的最后一项
- 如何实现对 System.Windows.Forms.DataGridView的增加、修改、上除操作
- c#可以做出来地图吗?
- 大家帮帮忙,想个解决方法。
- 请助,我的winform 程序在读配置文件字段时报了以下的错.
- 如何改变c#语言编辑窗口中字体的大小,。net的字太小了
- 又有麻烦了,怎么在客户端下载服务端中存储在数据库表中的文件。
- 小白求助,正在VSC#编程电脑死机,再打开就有个项目打不开了
- 求助关于C#操作TXT文件的问题
- 该字符串未被识别为有效的 DateTime
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;public partial class _Default : System.Web.UI.Page
{
/// <summary>
/// 执行数据绑定,将查询sql语句execsql的查询结果显示在MyList中
/// </summary>
/// <param name="execsql"></param>
public void BindGrid(string execsql)
{
//定义Sql语句变量
string mysql = execsql;
//定义数据适配器,用来读取数据
da = new SqlDataAdapter(mysql, myConnection);
DataSet ds = new DataSet();
//将从数据库中读取的数据存储在DataSet中
da.Fill(ds);
//将DataSet绑定给MyList,以便在MyList显示查询出的数据
this.MyList.DataSource = ds;
this.MyList.DataBind();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
//MyList的页码索引改变时的事件委托
this.MyList.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.MyList_PageIndexChanged);
}
#endregion /// <summary>
/// 数据查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSearch_Click(object sender, System.EventArgs e)
{
try
{
mysql = "select * from Orders,users where Orders.UserID=users.UserID and OrderID =" + this.txtBookName.Text.Trim();
this.BindGrid(mysql);
}
catch
{
//通过javascript弹出提示信息
Response.Write("<script language=javascript>alert('查找失败,请回到首页才能进行高级查询')</script>");
}
}
/// <summary>
/// 选择所有
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SelectAll(object sender, EventArgs e)
{ CheckBox check = (CheckBox)sender;
if (check.Text == "全选")
{
int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{
//从MyList控件中查找所有的chk_delete复选框,并勾选
CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
cb.Checked = check.Checked; }
}
} protected void MyList_SelectedIndexChanged(object sender, System.EventArgs e)
{ } /// <summary>
/// 执行删除操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete(object sender, EventArgs e)
{ int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{
CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
if (cb.Checked)
{
//循环将勾选则记录执行删除操作
//定义删除Sql语句
string deletestr = "delete from Orders where OrderID=" + Convert.ToInt32(this.MyList.Items[i].Cells[0].Text);
//执行Sql语句的命令对象
SqlCommand myCommand = new SqlCommand(deletestr, myConnection);
//打开数据库连接
myConnection.Open();
//执行Sql语句
myCommand.ExecuteNonQuery();
//关闭数据库连接
myConnection.Close(); }
}
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
//在删除完成后重新绑定数据
this.BindGrid(mysql); } //分页
private void MyList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
//在点击分页按钮后,设置当前页的数据
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
this.MyList.CurrentPageIndex = e.NewPageIndex;
this.BindGrid(mysql);
} /// <summary>
/// 退出系统
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Exit_Click(object sender, System.EventArgs e)
{
//销毁Session
Session.Abandon();
//重新定向到默认页Default.aspx
Response.Redirect("Default.aspx");
} private void Button1_Click(object sender, System.EventArgs e)
{ } protected void btnAddBook_Click(object sender, System.EventArgs e)
{
//定向至AddBook页
Response.Redirect("AddBook.aspx");
}}
{
string mysql=execsql;//根据传过来的SQL语句创建桥接器,用于连接DATASET
da=new SqlDataAdapter(mysql,myConnection);//创建一个 DATASET (数据集)
DataSet ds=new DataSet();//通过适配器对象的Fill方法将数据填充到数据集中
da.Fill(ds);将数据集绑定到DATALIST控件上
this.MyList.DataSource=ds;
this.MyList.DataBind();
}//这是程序自动生成的
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
this.MyList.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.MyList_PageIndexChanged);}
#endregion
//应该是查询按钮的点击事件
protected void btnSearch_Click(object sender, System.EventArgs e)
{
try
{
//SQL语句, "Trim()是去掉txtBookName.Text控件文字的两端空格的"
mysql = "select * from Orders,users where Orders.UserID=users.UserID and OrderID =" + this.txtBookName.Text.Trim();//调用上面那个方法,把SQL的字符串传过去。
this.BindGrid(mysql);
}
catch
{
Response.Write("<script language=javascript>alert('查找失败,请回到首页才能进行高级查询')</script>");
}
}
//选择所有
protected void SelectAll(object sender, EventArgs e)
{//当你更改复选框checkBox对象的选择后,触发CheckedChanged事件,如果是”全选“,把datalist列表中的删除控件设置成全选。
CheckBox check = (CheckBox)sender;
if (check.Text == "全选")
{
int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{
CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
cb.Checked = check.Checked;}
}
}protected void MyList_SelectedIndexChanged(object sender, System.EventArgs e)
{} //删除订单
//找到选中的删除按钮。根据所选择的删除按钮删除数据
protected void btnDelete(object sender, EventArgs e)
{int i, j = this.MyList.Items.Count;
for (i = 0; i < j; i++)
{CheckBox cb = (CheckBox)this.MyList.Items[i].Cells[6].FindControl("chk_delete");
if (cb.Checked)
{
string deletestr="delete from Orders where OrderID="+Convert.ToInt32(this.MyList.Items[i].Cells[0].Text);
SqlCommand myCommand=new SqlCommand(deletestr,myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();}
}
//重新绑定
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
this.BindGrid(mysql);} //分页
private void MyList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
mysql = "select * from Orders,users where Orders.UserID=users.UserID order by OrderID desc";
this.MyList.CurrentPageIndex=e.NewPageIndex;
this.BindGrid(mysql);
}
protected void Exit_Click(object sender, System.EventArgs e)
{
//删除Session对象
Session.Abandon();
//跳转到首页
Response.Redirect("Default.aspx");
}private void Button1_Click(object sender, System.EventArgs e)
{}protected void btnAddBook_Click(object sender, System.EventArgs e)
{
//跳转页面
Response.Redirect("AddBook.aspx");
}