/// <summary>
/// DataGrid相邻行有相同内容时对指定列合并/// </summary>/// <param name="spangrid">格式化的DataGrid的ID</param>/// <param name="spancell">要合并的列</param> 
/// <param name="spanby">合并所依据数据的列</param>
public
void
FormatGrid(DataGrid spangrid,
int
spancell,
int
spanby)
{ if(spanby<0 || spanby>spangrid.Items.Count) return; int rowspan = 1; for(int i = 1;i<spangrid.Items.Count;i++)
{ if(spangrid.Items[i].Cells[spanby].Text == spangrid.Items[i-1].Cells[spanby].Text) { rowspan +=1; spangrid.Items[i].Cells[spancell].Visible = false; spangrid.Items[i-rowspan+1].Cells[spancell].RowSpan = rowspan;
} else { string str = spangrid.Items[i].Cells[spanby].Text; string str1 = spangrid.Items[i-1].Cells[spanby].Text; rowspan = 1; } } }
Assembly assmebly
=
Assembly.LoadFile(
@"
C:WindowsApplication2005-09-30.dll
"
);Type t
=
assmebly.GetType(
"
WindowsApplication2005_09_30.Class1
"
);
object
obj
=
Activator.CreateInstance(t,
null
);MethodInfo method
=
t.GetMethod(
"
Test01
"
);
int
i
=
(
int
)method.Invoke(obj,
new
object
[
1
]
{10}
);
namespace
WindowsApplication2005_09_30
{public class Class1{public int Test01(int i){return i*10;}}}
评论
GridView1.Attributes.Add( " BorderColor " , " #0693F5 " );
如果如下设置,结果表格边框的颜色变了.
< asp:GridView ID = " GridView1 " runat = " server " BorderColor = " red " >
</ asp:GridView >
到页面看源代码
< table cellspacing = " 0 " border = " 1 " id = " GridView1 " style = " border-color:Red;border-collapse:collapse; " >
< tr >
其中BorderColor = " red 解释成了style= " border - color:Red
GridView1.Attributes.Add( " BorderColor " , " #0693F5 " );
/// <summary>
/// 合并GridView中某行相同信息的行（单元格）
/// </summary>
/// <param name="GridView1"> GridView对象 </param>
/// <param name="cellNum"> 需要合并的行 </param>
public static void GroupRow(GridView GridView1, int rows)
{
TableCell oldTc = GridView1.Rows[rows].Cells[ 0 ];
for ( int i = 1 ; i < GridView1.Rows[rows].Cells.Count; i ++ )
{
TableCell tc = GridView1.Rows[rows].Cells[i]; // Cells[0]就是你要合并的列
if (oldTc.Text == tc.Text)
{
tc.Visible = false ;
if (oldTc.ColumnSpan == 0 )
{
oldTc.ColumnSpan = 1 ;
}
oldTc.ColumnSpan ++ ;
oldTc.VerticalAlign = VerticalAlign.Middle;
}
else
{
oldTc = tc;
}
}
}
#endregion
#region 合并单元格 合并一行中的几列
/// <summary>
/// 合并单元格 合并一行中的几列
/// </summary>
/// <param name="GridView1"> GridView ID </param>
/// <param name="rows"> 行 </param>
/// <param name="sCol"> 开始列 </param>
/// <param name="eCol"> 结束列 </param>
public static void GroupRow(GridView GridView1, int rows, int sCol, int eCol)
{
TableCell oldTc = GridView1.Rows[rows].Cells[sCol];
for ( int i = 1 ; i < eCol - sCol; i ++ )
{
TableCell tc = GridView1.Rows[rows].Cells[i + sCol]; // Cells[0]就是你要合并的列
tc.Visible = false ;
if (oldTc.ColumnSpan == 0 )
{
oldTc.ColumnSpan = 1 ;
}
oldTc.ColumnSpan ++ ;
oldTc.VerticalAlign = VerticalAlign.Middle;
}
}
#endregion
#region 合并单元格 合并某一列所有行
/// <summary>
/// 合并GridView中某列相同信息的行（单元格）
/// </summary>
/// <param name="GridView1"></param>
/// <param name="cellNum"></param>
public static void GroupCol(GridView GridView1, int cols)
{
if (GridView1.Rows.Count < 1 || cols > GridView1.Rows[ 0 ].Cells.Count - 1 )
{
return ;
}
TableCell oldTc = GridView1.Rows[ 0 ].Cells[cols];
for ( int i = 1 ; i < GridView1.Rows.Count; i ++ )
{
TableCell tc = GridView1.Rows[i].Cells[cols];
if (oldTc.Text == tc.Text)
{
tc.Visible = false ;
if (oldTc.RowSpan == 0 )
{
oldTc.RowSpan = 1 ;
}
oldTc.RowSpan ++ ;
oldTc.VerticalAlign = VerticalAlign.Middle;
}
else
{
oldTc = tc;
}
}
}
#endregion
#region 合并单元格 合并某一列中的某些行
/// <summary>
/// 合并单元格 合并某一列中的某些行
/// </summary>
/// <param name="GridView1"> GridView ID </param>
/// <param name="cellNum"> 列 </param>
/// <param name="sRow"> 开始行 </param>
/// <param name="eRow"> 结束列 </param>
public static void GroupCol(GridView GridView1, int cols, int sRow, int eRow)
{
if (GridView1.Rows.Count < 1 || cols > GridView1.Columns.Count - 1 )
{
return ;
}
TableCell oldTc = GridView1.Rows[sRow].Cells[cols];
for ( int i = 1 ; i < eRow - sRow; i ++ )
{
TableCell tc = GridView1.Rows[sRow + i].Cells[cols];
tc.Visible = false ;
if (oldTc.RowSpan == 0 )
{
oldTc.RowSpan = 1 ;
}
oldTc.RowSpan ++ ;
oldTc.VerticalAlign = VerticalAlign.Middle;
}
}
#endregion