初学者有关问题,求解决,小弟我应该如何把遍历到的值添加到listbox里面成为一行一行的
菜鸟问题,急求解决,我应该怎么把遍历到的值添加到listbox里面成为一行一行的?
public static ArrayList SelectF1008_PARADESCByF1008_PARACODE()
{
try
{
SqlConnection conn = new SqlConnection(DBHelp.conn);
conn.Open();
string sql = "select F1008_PARADESC from TB1008_PARAMETER where F1008_PARACODE='壳架等级'";
SqlCommand comm = new SqlCommand(sql,conn);
SqlDataReader sdr = comm.ExecuteReader();
ArrayList list=new ArrayList();
while(sdr.Read()){
PARAMETER parameter = new PARAMETER();
parameter.F1008_PARADESC = sdr[0].ToString();
string[] strs = parameter.F1008_PARADESC.Split(new char[] { ','});
string s = "";
foreach (var item in strs)
{
s += item.ToString();//
}
list.Add(s);
}
return list;
}
catch (Exception)
{
throw;
}
------解决方案--------------------
public static ArrayList SelectF1008_PARADESCByF1008_PARACODE()
{
try
{
SqlConnection conn = new SqlConnection(DBHelp.conn);
conn.Open();
string sql = "select F1008_PARADESC from TB1008_PARAMETER where F1008_PARACODE='壳架等级'";
SqlCommand comm = new SqlCommand(sql,conn);
SqlDataReader sdr = comm.ExecuteReader();
ArrayList list=new ArrayList();
while(sdr.Read()){
PARAMETER parameter = new PARAMETER();
parameter.F1008_PARADESC = sdr[0].ToString();
string[] strs = parameter.F1008_PARADESC.Split(new char[] { ','});
string s = "";
foreach (var item in strs)
{
s += item.ToString();//
}
list.Add(s);
}
return list;
}
catch (Exception)
{
throw;
}
------解决方案--------------------
foreach (var item in strs)
{
list.Items.Add(item);
}