' Visual Basic
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
' Executes only the first time the page is processed. After
' that, the list is already in the drop-down list and is
' preserved in view state.
Dim dreader As SqlClient.SqlDataReader
SqlConnection1.Open()
dreader = cmdCategoriesAll.ExecuteReader()
Dim firstrow As Boolean = True
While dreader.Read()
ddlCategoryID.Items.Add(New ListItem(dreader(0).ToString()))
If firstrow Then
txtCategoryName.Text = dreader(1).ToString
txtCategoryDescription.Text = dreader(2).ToString
firstrow = False
End If
End While
dreader.Close()
SqlConnection1.Close()
End If
End Sub// C#
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
// Executes only the first time the page is processed. After
// that, the list is already in the drop-down list and is
// preserved in view state.
System.Data.SqlClient.SqlDataReader dreader;
sqlConnection1.Open();
dreader = cmdCategoriesAll.ExecuteReader();
bool firstrow = true;
while (dreader.Read())
{
ddlCategoryID.Items.Add(new ListItem(dreader[0].ToString()));
if (firstrow)
{
txtCategoryName.Text = dreader[1].ToString();
txtCategoryDescription.Text = dreader[2].ToString();
firstrow = false;
}
}
dreader.Close();
sqlConnection1.Close();
}
}
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
' Executes only the first time the page is processed. After
' that, the list is already in the drop-down list and is
' preserved in view state.
Dim dreader As SqlClient.SqlDataReader
SqlConnection1.Open()
dreader = cmdCategoriesAll.ExecuteReader()
Dim firstrow As Boolean = True
While dreader.Read()
ddlCategoryID.Items.Add(New ListItem(dreader(0).ToString()))
If firstrow Then
txtCategoryName.Text = dreader(1).ToString
txtCategoryDescription.Text = dreader(2).ToString
firstrow = False
End If
End While
dreader.Close()
SqlConnection1.Close()
End If
End Sub// C#
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
// Executes only the first time the page is processed. After
// that, the list is already in the drop-down list and is
// preserved in view state.
System.Data.SqlClient.SqlDataReader dreader;
sqlConnection1.Open();
dreader = cmdCategoriesAll.ExecuteReader();
bool firstrow = true;
while (dreader.Read())
{
ddlCategoryID.Items.Add(new ListItem(dreader[0].ToString()));
if (firstrow)
{
txtCategoryName.Text = dreader[1].ToString();
txtCategoryDescription.Text = dreader[2].ToString();
firstrow = false;
}
}
dreader.Close();
sqlConnection1.Close();
}
}
——直接执行SQL语句就可以了。
如果是建立Access数据库,那可以用DAO或者ADOX。
——参见http://www.csdn.net/expert/topic/394/394959.xml?temp=.166485
如果是其他数据库,那就没试过了:)