<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select pu_state , pu_city ,pu_county from YourTable", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "abc") MyDataGrid.DataSource=ds.Tables("abc").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="宋体">DataGrid 控件的简单选择</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
>
<Columns> <asp:BoundColumn
HeaderText="列1"
DataField="pu_state">
</asp:BoundColumn> <asp:BoundColumn
HeaderText="列2"
DataField="pu_city">
</asp:BoundColumn> <asp:BoundColumn
HeaderText="列3"
DataField="pu_county" </asp:BoundColumn></asp:DataGrid></body>
</html>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select pu_state , pu_city ,pu_county from YourTable", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "abc") MyDataGrid.DataSource=ds.Tables("abc").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="宋体">DataGrid 控件的简单选择</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
>
<Columns> <asp:BoundColumn
HeaderText="列1"
DataField="pu_state">
</asp:BoundColumn> <asp:BoundColumn
HeaderText="列2"
DataField="pu_city">
</asp:BoundColumn> <asp:BoundColumn
HeaderText="列3"
DataField="pu_county" </asp:BoundColumn></asp:DataGrid></body>
</html>
解决方案 »
- 复选框记住密码
- 只有在配置文件或 Page 指令中将 enableSessionState 设置为 true 时,才能使用
- 求教:关于.net项目网银多次支付的逻辑
- 文件名格式
- asp.net连接access的问题
- membership有多少人在用?membership有多灵活?
- dataList模版问题?高人进
- DataList统计分析问题,在模板列中加上一个文本框,怎么通过单击某个按钮,统计出所有文本框中的值。
- .net连接人人网。。总是提示sig无效。。求解。
- 生成数据集/架构失败,对存储过程未提供参数?
- (在线等待)请教一下如何在.net中对控件付背景颜色
- 出错:ORA-00904: invalid column name,哪位大虾指点下,先谢了
select all=str1+str2+str3,....
from TableName
/// 自定义DataGrid项模板
/// </summary>
public class DataGridColumnItemTemplate : ITemplate
{
private string DataField; //数据子段
private string DataFormat; //格式化输出
private event CreateItemCellEventHandle CreateItemCell; //创建自定义单元格事件 //构造函数
public DataGridColumnItemTemplate(string DataField,string DataFormat,CreateItemCellEventHandle CreateItemCell)
{
this.DataField=DataField;
this.DataFormat=DataFormat;
this.CreateItemCell=CreateItemCell;
} //内联模板中添加子控件,container-->TableCell
public void InstantiateIn(Control container)
{
//绑定数据源时触发事件
container.DataBinding+=new EventHandler(Cell_DataBinding);
} //自定义绑定处理函数
protected void Cell_DataBinding(object sender,EventArgs e)
{
TableCell cell=(TableCell)sender; //单元格
DataGridItem item=(DataGridItem)cell.Parent; //项
if(item==null) return; //制定了创建单元格的事件则触发自定义创建单元格的事件来创建单元格
//否则按照默认的方式创建单元格,类似于创建绑定列
if(CreateItemCell!=null) //创建自定义列
{
CreateItemCell(this,new CreateItemCellEventArgs(item,cell,this.DataField,this.DataFormat));
}
else //类似于创建绑定列
{
cell.Text=DataBinder.Eval(item.DataItem,this.DataField,this.DataFormat);
}
}
} /// <summary>
/// 创建单元格事件参数
/// </summary>
public class CreateItemCellEventArgs : EventArgs
{
public DataGridItem Item=null; //列表项(行)
public TableCell Cell=null; //创建的单元格
public string DataField=""; //数据子段名
public string DataFormat=""; //数据输出格式 //构造函数
public CreateItemCellEventArgs(DataGridItem item,TableCell cell,string dataField,string dataFormat)
{
this.Item=item;
this.Cell=cell;
this.DataField=dataField;
this.DataFormat=dataFormat;
}
} /// <summary>
/// 委托创建自定义单元格
/// </summary>
public delegate void CreateItemCellEventHandle(object sender,CreateItemCellEventArgs e); /*
eg.
TemplateColumn column=new TemplateColumn();
column.HeaderText="HeaderText";
DataGridColumnItemTemplate itemTemplate=new DataGridColumnItemTemplate("DataField","DataFormat",new CreateItemCellEventHandle(CreateItemCell));
column.ItemTemplate=itemTemplate;
private void CreateItemCell(object sender,CreateItemCellEventArgs e)
{
e.Cell.Text=(e.Item.ItemIndex+1).ToString();
}
*/