myConn.ConnectionString=strConn;
string strSQL="select classname,classid from xclass";
SqlDataAdapter myCMD=new SqlDataAdapter(strSQL,myConn);
DataSet ds=new DataSet();
myCMD.Fill(ds,"classname1");
parentname.DataSource=ds.Tables["classname1"].DefaultView;
parentname.DataValueField=ds.Tables["classname1"].Columns[1].ColumnName;
parentname.DataTextField=ds.Tables["classname1"].Columns[0].ColumnName;
parentname.DataBind();放在Page_Load里,运行时显示为空的啊
string strSQL="select classname,classid from xclass";
SqlDataAdapter myCMD=new SqlDataAdapter(strSQL,myConn);
DataSet ds=new DataSet();
myCMD.Fill(ds,"classname1");
parentname.DataSource=ds.Tables["classname1"].DefaultView;
parentname.DataValueField=ds.Tables["classname1"].Columns[1].ColumnName;
parentname.DataTextField=ds.Tables["classname1"].Columns[0].ColumnName;
parentname.DataBind();放在Page_Load里,运行时显示为空的啊
parentname.TableMappings.Add("Table","classname1");
Dim myCommand As SqlCommand
Dim strsql As String
Dim myDataReader As SqlDataReader strsql = "select dmbh,dmmc from dmxx"
myCommand = New SqlCommand(strsql, objConnection)
ddl.Items.Clear()
ddl.Items.Add(New ListItem("--选项--", "-1"))
Try
objConnection.Open()
myDataReader = myCommand.ExecuteReader()
If myDataReader.Read() Then
ddl.Items.Add(New ListItem(RTrim(myDataReader.Item(1)), RTrim(myDataReader.Item(0))))
While myDataReader.Read()
ddl.Items.Add(New ListItem(RTrim(myDataReader.Item(1)), RTrim(myDataReader.Item(0))))
End While
Else End If
myDataReader.Close() Catch er As SqlException Finally
If objConnection.State = ConnectionState.Open Then
objConnection.Close()
End If
End Try
可以参考一下
还有
parentname.DataSource=ds.Tables[0].;
parentname.DataValueField="字段名";
parentname.DataTextField="字段名";