list泛型有关问题二维数组

list泛型问题二维数组
oracle数据库里有两行两列数据
IP地址  时间
a            10
b            25

我想把它们读出来放到list<string> <string> 可能这样写不对
就是存到list  list是个二维数组 [a,10]   [b,25]一组我该怎么写
------解决思路----------------------

引用:

Quote: 引用:

Quote: 引用:

IP如果唯一，可以用Dictionary来存储

string s = "select * from PINGWEBSITE where IFWORK='Y'";
                List<string[]> li = new List<string[]>();
                OracleDataReader dr = DbHelperOra.ExecuteReader(s);
                while (dr.Read())
                {
                    string[] temp = new string[2];
                    temp[0] = (string)dr["IPADDRESS"];
                    temp[1] = (string)dr["OVERTIME"];
                    li.Add(temp);
                }
                foreach (string[] str in li)
                {
                    string IPStr = str[0];
                    string TimeStr = str[1];
                    Console.WriteLine("IP:"+IPStr+"Time:"+TimeStr);
                }

代码

写成这样的试试



string s = "select * from PINGWEBSITE where IFWORK='Y'";

                List<string[]> li = new List<string[]>();

                OracleDataReader dr = DbHelperOra.ExecuteReader(s);

                while (dr.Read())

                {

                    string[] temp = new string[2];

                    temp[0] =Convert.ToString(dr["IPADDRESS"]);

                    temp[1] = Convert.ToString(dr["OVERTIME"]);

                    li.Add(temp);

                }

                foreach (string[] str in li)

                {

                    string IPStr = str[0];

                    string TimeStr = str[1];

                    Console.WriteLine("IP:"+IPStr+"Time:"+TimeStr);

                }

引用:

Quote: 引用:

Quote: 引用:

IP如果唯一，可以用Dictionary来存储

string s = "select * from PINGWEBSITE where IFWORK='Y'";
                List<string[]> li = new List<string[]>();
                OracleDataReader dr = DbHelperOra.ExecuteReader(s);
                while (dr.Read())
                {
                    string[] temp = new string[2];
                    temp[0] = (string)dr["IPADDRESS"];
                    temp[1] = (string)dr["OVERTIME"];
                    li.Add(temp);
                }
                foreach (string[] str in li)
                {
                    string IPStr = str[0];
                    string TimeStr = str[1];
                    Console.WriteLine("IP:"+IPStr+"Time:"+TimeStr);
                }

代码

写成这样的试试



string s = "select * from PINGWEBSITE where IFWORK='Y'";

                List<string[]> li = new List<string[]>();

                OracleDataReader dr = DbHelperOra.ExecuteReader(s);

                while (dr.Read())

                {

                    string[] temp = new string[2];

                    temp[0] =Convert.ToString(dr["IPADDRESS"]);

                    temp[1] = Convert.ToString(dr["OVERTIME"]);

                    li.Add(temp);

                }

                foreach (string[] str in li)

                {

                    string IPStr = str[0];

                    string TimeStr = str[1];

                    Console.WriteLine("IP:"+IPStr+"Time:"+TimeStr);

                }

谢谢大神已经可以了

问最后一个问题其他类需要调用str[0] str[1] 可以直接用么

public List<string[]> li = new List<string[]>(); 定义成外部可访问的就行, 放到方法外面去,每次添加数据先清理当前的List数组,
li.Clear();

list泛型有关问题 二维数组

相关推荐

list泛型有关问题二维数组