public DataView listbinding(int xuserid)
{
string strComm="listtype";
SqlConnection conn=new SqlConnection(connString);
SqlCommand comm=new SqlCommand(strComm,conn);
comm.CommandType=CommandType.StoredProcedure;
SqlParameter userid=new SqlParameter("@uid",SqlDbType.Int);
userid.Value=xuserid;
comm.Parameters.Add(userid);
try
{
conn.Open();
SqlDataAdapter adp=new SqlDataAdapter(comm);
//SqlDataReader dr=comm.ExecuteReader();
DataSet ds=new DataSet();
adp.Fill(ds,"listTable");
comm.Parameters.Clear();
//dr.Close();
conn.Close();
return ds.Tables["listTable"].DefaultView;
}
finally
{
if(conn.State==ConnectionState.Open)
{
conn.Close();
}
}
}
上面是数据操作
下面是绑定到dropdownlist DataView dv=listbinding(userID);
listType.DataSource=dv;
listType.DataTextField="albumtitle";
listType.DataValueField="systype";
listType.DataBind();