实现DataGrid拖动和排序
来源:互联网 发布:ssh 命令带端口号 编辑:程序博客网 时间:2024/06/05 16:37
1.html
<HTML>
<HEAD>
<title>MoveDataGrid</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" style="BEHAVIOR: url(movegrid.htc)" runat="server" BackColor="White"
BorderWidth="1px" BorderStyle="None" BorderColor="#CC9966" CellPadding="4" Font-Size="9pt">
<SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
<ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
<FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
<PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
</asp:DataGrid>
</form>
</body>
</HTML>
<HEAD>
<title>MoveDataGrid</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" style="BEHAVIOR: url(movegrid.htc)" runat="server" BackColor="White"
BorderWidth="1px" BorderStyle="None" BorderColor="#CC9966" CellPadding="4" Font-Size="9pt">
<SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
<ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
<FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
<PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
</asp:DataGrid>
</form>
</body>
</HTML>
2.cs
public class MoveDataGrid : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private string constring="";
private int nColumn = 0;
private void Page_Load(object sender, System.EventArgs e)
{
string sql="select * from testgrid";
DataSet ds=GetDataSet(sql);
DataGrid1.Attributes.Add("dragcolor","gray");
DataGrid1.Attributes.Add("slcolor","#ffffcc");
DataGrid1.Attributes.Add("hlcolor","#BEC5DE");
nColumn=ds.Tables[0].Columns.Count;
this.DataGrid1.DataSource=ds;
this.DataGrid1.DataBind();
}
GetDataSet#region GetDataSet
private DataSet GetDataSet(string sql)
{
constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlDataAdapter sda =new SqlDataAdapter(sql,constring);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
Web Form Designer generated code#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
this.DataGrid1.ItemCreated+=new DataGridItemEventHandler(DataGrid1_ItemCreated);
}
/**//// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DataGrid1_ItemCreated(object sender, DataGridItemEventArgs e)
{
if(e.Item.ItemType==ListItemType.Header)
{
for(int i = 0;i<nColumn;i++)
{
e.Item.Cells[i].Attributes.Add("Width","200");
}
}
}
}
3.源代码下载/Files/singlepine/moveandsort.rar {
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private string constring="";
private int nColumn = 0;
private void Page_Load(object sender, System.EventArgs e)
{
string sql="select * from testgrid";
DataSet ds=GetDataSet(sql);
DataGrid1.Attributes.Add("dragcolor","gray");
DataGrid1.Attributes.Add("slcolor","#ffffcc");
DataGrid1.Attributes.Add("hlcolor","#BEC5DE");
nColumn=ds.Tables[0].Columns.Count;
this.DataGrid1.DataSource=ds;
this.DataGrid1.DataBind();
}
GetDataSet#region GetDataSet
private DataSet GetDataSet(string sql)
{
constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlDataAdapter sda =new SqlDataAdapter(sql,constring);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
Web Form Designer generated code#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
this.DataGrid1.ItemCreated+=new DataGridItemEventHandler(DataGrid1_ItemCreated);
}
/**//// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DataGrid1_ItemCreated(object sender, DataGridItemEventArgs e)
{
if(e.Item.ItemType==ListItemType.Header)
{
for(int i = 0;i<nColumn;i++)
{
e.Item.Cells[i].Attributes.Add("Width","200");
}
}
}
}
- 实现DataGrid拖动和排序
- 实现DataGrid拖动和排序
- DataGrid客户端排序和通过鼠标拖动来实现多选
- DataGrid客户端排序和通过鼠标拖动来实现多选
- jquery实现拖动排序
- GridView实现拖动排序
- RecyclerView 实现侧滑删除和拖动排序
- ItemTouchHelper实现RecyclerView拖动排序和滑动删除
- RecyclerView实现拖动排序和滑动删除功能
- wpf ListBox拖动排序实现
- 移动端实现排序拖动
- 用动态属性和DataView实现DataGrid的双向排序
- XP 风格的可拖动列、排序的DataGrid
- DataGrid实现(上下左右移动,添加删除行列,导出,表头拖动)
- DataGrid实现(上下左右移动,添加删除行列,导出,表头拖动)
- DataGrid实现(上下左右移动,添加删除行列,导出,表头拖动)
- datagrid行排序和筛选
- EasyUI Datagrid 分页和排序
- 共享一些JAVA面试题
- 用于DataGrid MoveUp,MoveDown的存储过程
- DataGrid的多种格式化显示方法
- DataGrid实现(上下左右移动,添加删除行列,导出,表头拖动)
- DataGrid显示图片(物理路径式和Stream流式)和添加图片到数据库
- 实现DataGrid拖动和排序
- Java之旅
- 实现如何调整DataGrid列宽
- 常用sql存储过程集锦
- 合并实现DataGrid多表头
- Java模式设计读书笔记 之 抽象工厂模式(上)
- 通用分页控件(DataGrid,DataList,Repeater都可以用它来分页)
- 水情报汛职守机来报提醒程序
- Bin 和 App_Code 文件夹