private void SearchStat(string SearchType)
{
DataSet ds=new DataSet();
string strSQL = "";
SqlConnection sqlConn=new SqlConnection(strConn);
BoundColumn bc = new BoundColumn();
if (SearchType !="Test")
{
if (SearchType == "Chapter")
{
if (Session["ClassID"].ToString()!=""||Session["ClassID"].ToString()!=null)
{
strSQL="select top 10 * from sxzxxjg where kmbh="+Session["ClassID"].ToString()+" order by xxrs desc";
bc = new BoundColumn();
bc.HeaderText = "章的名称";
bc.DataField = "zmc";
this.dgrResult.Columns.Add(bc);
bc = new BoundColumn();
bc.HeaderText = "学习人数";
bc.DataField = "xxrs";
this.dgrResult.Columns.Add(bc);
}
}
else if (SearchType == "Item")
{
if (Session["ClassID"].ToString()!=""||Session["ClassID"].ToString()!=null)
{
strSQL="Select top 10 * From sxxxjg where kmbh="+Session["ClassID"].ToString()+"order by xxrs desc";
bc = new BoundColumn();
bc.HeaderText = "知识点的名称";
bc.DataField = "mc";
this.dgrResult.Columns.Add(bc);
bc = new BoundColumn();
bc.HeaderText = "学习人数";
bc.DataField = "xxrs";
this.dgrResult.Columns.Add(bc);
}
}
else if (SearchType == "Article")
{
strSQL="Select top 10 scmc,cs From jcxgwxqd group by scmc, cs order by cs desc";
bc = new BoundColumn();
bc.HeaderText = "文章名称";
bc.DataField = "scmc";
this.dgrResult.Columns.Add(bc);
bc = new BoundColumn();
bc.HeaderText = "浏览次数";
bc.DataField = "cs";
this.dgrResult.Columns.Add(bc);
}
}
}
}
你可以看一看,不知道对你是否有帮助!-
Dim myTable As DataTable = new DataTable("myTable")
Dim myColumn As DataColumn = New DataColumn
myColumn.DataType = System.Type.GetType("System.Decimal")
myColumn.AllowDBNull = False
myColumn.Caption = "Price"
myColumn.ColumnName = "Price"
myColumn.DefaultValue = 25
myTable.Columns.Add(myColumn)
Dim myRow As DataRow
Dim i As Integer
For i = 0 to 9
myRow = myTable.NewRow()
myRow("Price") = i + 1
myTable.Rows.Add(myRow)
Next i