关于dropdownlist的问题 ，在线等，卡这了，请指点下~

[IT_Fish]

Dim ConnStr as String
ConnStr = "Data Source=localhost;Persist Security Info=False;User ID=Gavin;Password='123456';Initial Catalog=VRAS"
Dim Conn as SqlConnection = new SqlConnection(ConnStr)
Dim sql as string
'sql = "SELECT Week FROM ERS"
Dim da as SqlDataAdapter = New SqlDataAdapter("SELECT * FROM week ",Conn)
Dim ds as new DataSet()
da.fill(ds)
If ds.Tables(0).Rows.Count > 0 Then
dropdownlist2.DataSource = ds.Tables(0).DefaultView
dropdownlist2.DataBind()
End If
为什么这段代码我得到在dropdownlist中得到的值是：System.Data.DataRowView
请问哪出问题了？

[Dugu_Niu]

没有指定dropdownlist要显示tables(0)的那个成员吧

[famousun]

dropdownlist2你指定字段了没
dropdownlist2.DataValueField = "字段" ;
.DataTextField="字段"

[IT_Fish]

tables(0)只有一个成员啊，而且work是视图表啊

[IT_Fish]

帮我修改下啊，我只有一个week字段啊

[roapzone]

try::
dropdownlist2.DataSource = ds.Tables(0).DefaultView
.Table.Columns["stringname"];
or
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];

[roapzone]

try:;
dropdownlist2.DataSource = ds.Tables(0).DefaultView
.Table.Columns["week"];
or
dropdownlist2.DataSource = ds.Tables(0).Columns["week"];

[jinbingg]

try::
dropdownlist2.DataSource = ds.Tables(0).DefaultView
.Table.Columns["stringname"];
or
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];

[IT_Fish]

如果是dropdownlist2.DataSource = ds.Tables(0).DefaultView.Table.Columns["stringname"];
出现没有标识符的错误信息。

[IT_Fish]

我的week视图的代码是这样的
SELECT TOP 100 PERCENT Week
FROM dbo.ERS
GROUP BY Week
ORDER BY Week

[roapzone]

这个那??
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];

[roapzone]

or::
dropdownlist2.DataSource = ds.Tables(0).Rows

[roapzone]

我用的::
public ArrayList GetAssinZYRY(string vZYType)
{
SqlConnection sqlcon = new SqlConnection(Configuration.ConnectionString);
SqlCommand sqlcom =new SqlCommand();
sqlcon.Open();
sqlcom.Connection = sqlcon;
sqlcom.CommandType = CommandType.StoredProcedure;
sqlcom.Parameters.Add(new SqlParameter("@ZYType",SqlDbType.Int));
sqlcom.Parameters["@ZYType"].Value = Convert.ToInt16(vZYType);
sqlcom.CommandText ="getAppointZyRY" ;

SqlDataReader my = null;
ArrayList PointRY = new ArrayList();
try
{
my = sqlcom.ExecuteReader();
while(my.Read())
{
PointRY.Add(my.GetSqlValue(0).ToString()+"|"+my.GetSqlValue(1).ToString());
}
}
catch (Exception e)
{
throw(e);
}

finally
{
sqlcon.Close();
my.Close();
my = null;
}

return PointRY;

}

[IT_Fish]

dropdownlist2.DataSource = ds.Tables(0).Rows
没有效果啊，结果和我原来一样
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];
也是没标识符

[roapzone]

da.fill(ds,"tablename")
If ds.Tables("tablename").Rows.Count > 0 Then
dropdownlist2.DataSource = ds.Tables(tablename).DefaultView
dropdownlist2.DataBind()
End If


看看!!

[IT_Fish]

da.fill(ds,"wk")
If ds.Tables("wk").Rows.Count > 0 Then
dropdownlist2.DataSource = ds.Tables("wk").DefaultView
dropdownlist2.DataBind()

得到的结果还是：System.Data.DataRowView
我这方法试过的，这问题真有点莫名其妙，不知道哪出问题了

[gebing0908]

dropdownlist2.DataSource = ds.Tables("wk").DefaultView
dropdownlist2.DataTextField = "week"
dropdownlist2.DataBind()

[IT_Fish]

兄弟，谢谢，谢谢！感激不尽！！！