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
请问哪出问题了?
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
请问哪出问题了?
解决方案 »
- XML属性修改如何处理换行
- asp.net怎么实现不规则的新闻标题绑定???(急需解决!高手进) 在线等啊
- visual studio2005和sqlserver2005连接
- 请教:用C#.net做的网站,访问数据库的问题
- 使用URL传值遇到的问题
- .net 调试asp程序 ,有什么办法?? ***************
- 高手进来谈一下XmlDataDocument类和DataSet类的区别看看
- ASP.NET 如何访问LDAP
- windows窗体怎么才能没有滚动条?
- 如何在Asp.net中把数据存入到Word或Excel中
- 如何替换datalist中绑定的值?
- javascript格式转化问题
dropdownlist2.DataValueField = "字段" ;
.DataTextField="字段"
dropdownlist2.DataSource = ds.Tables(0).DefaultView
.Table.Columns["stringname"];
or
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];
dropdownlist2.DataSource = ds.Tables(0).DefaultView
.Table.Columns["week"];
or
dropdownlist2.DataSource = ds.Tables(0).Columns["week"];
dropdownlist2.DataSource = ds.Tables(0).DefaultView
.Table.Columns["stringname"];
or
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];
出现没有标识符的错误信息。
SELECT TOP 100 PERCENT Week
FROM dbo.ERS
GROUP BY Week
ORDER BY Week
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];
dropdownlist2.DataSource = ds.Tables(0).Rows
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; }
没有效果啊,结果和我原来一样
dropdownlist2.DataSource = ds.Tables(0).Columns["stringname"];
也是没标识符
If ds.Tables("tablename").Rows.Count > 0 Then
dropdownlist2.DataSource = ds.Tables(tablename).DefaultView
dropdownlist2.DataBind()
End If
看看!!
If ds.Tables("wk").Rows.Count > 0 Then
dropdownlist2.DataSource = ds.Tables("wk").DefaultView
dropdownlist2.DataBind() 得到的结果还是:System.Data.DataRowView
我这方法试过的,这问题真有点莫名其妙,不知道哪出问题了
dropdownlist2.DataTextField = "week"
dropdownlist2.DataBind()