<%@ 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;Integrated Security=SSPI")
MyCommand = New SqlDataAdapter("select * form 表 where id= 5", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "Authors") MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></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;Integrated Security=SSPI")
MyCommand = New SqlDataAdapter("select * form 表 where id= 5", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "Authors") MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></body>
</html>
textbox.text=ds.table["authors"].row[那一行][那一列];
那一行 可以使用 0 1 3 ....
那一列 也是 0 1 2 3 ... 或者 直接就是列名 列名要 ""啊
{
string strClientCode;
string strSQL; strClientCode = lstClientcode.SelectedItem.Value;
strSQL = "select client_code,client_name,location,agency_comission_pct,ac_payment_term,";
strSQL += "case when active_ind ='Y' then 'Yes' when active_ind = 'N' then 'No' end as active_ind from client"; if (strClientCode != "All Client")
strSQL += " where client_code='" + strClientCode + "'";
DataTable DT = global.getSelect(strSQL); DataView dv = new DataView();
dv = DT.DefaultView; string SortExpression = dgdClient.Attributes["SortExpression"]; string SortDirection = dgdClient.Attributes["SortDirection"]; dv.Sort = SortExpression + " " + SortDirection; dgdClient.DataSource = dv;
dgdClient.DataBind();
setPageButton();//设置分页按钮的Enable }显示在文本框中:
txtID.text = DT.Rows[0]["id"].ToString();
txtName.text = DT.Rows[0]["名字"].ToString();
txtSex.text = DT.Rows[0]["性别"].ToString();
ObjOraAdaT_Record.Fill(DsT_Record,"T_Record");this.TextBox1.Text = DsT_Record.Table["T_Record"].Rows[0]["名字"].ToString();
if(dr.Read())
{
Textid.Text=dr["id"].ToString();
TextName.Text=dr["name"].ToString();
TextSex.Text=dr["sex"].ToString();
}