定义一个类，返回一串数组

.cs文件下调用

        string[] companyInfo = nCard.GetCompanyInfo(lu.leaver.COMPANYCODE);
       companyAddressLb.Text = companyInfo[1].ToString();

类文件下调用：

    public string[] GetCompanyInfo(string companycode)
    {

        
    //   string [] strs ={};//这样会出现：索引超出了数组界限的错误
        string strlist = @"select * from Eflow_CompanyInfo where COMPANYCODE='" + companycode + "'";
        SqlDataAdapter da = new SqlDataAdapter(strlist,SqlHelper.connStr);
        DataSet ds = new DataSet();
        da.Fill(ds);
        int count = ds.Tables[0].Columns.Count;

          string[] strs = new string[count];

        if(count>0)
        {
            for (int i = 0; i < count; i++)
            {
                strs[i] = ds.Tables[0].Rows[0][i].ToString();
            }
        }
        return strs;
    }

其中string[count]中定义数组的长度，要动态分配。

 

改进的一种方法，实现可以动态控制获取表中的哪一列

 

        string[] companyInfo = nCard.GetCompanyInfo(lu.leaver.COMPANYCODE);
       companyAddressLb.Text = companyInfo[1].ToString();
       companyPhoneLb.Text = companyInfo[2].ToString();
       zipLb.Text = companyInfo[3].ToString();
       faxLb.Text = companyInfo[4].ToString();
       companycodeLb.Text = companyInfo[5].ToString();

在类的文件夹下

    public string[] GetCompanyInfo(string companycode)
    {

      
     
        string strlist = @"select * from Eflow_CompanyInfo where COMPANYCODE='" + companycode + "'";
        SqlDataAdapter da = new SqlDataAdapter(strlist,SqlHelper.connStr);
        DataSet ds = new DataSet();
        da.Fill(ds);
        int count = ds.Tables[0].Columns.Count;
        string[] strs = new string[count];
        if(count>0)
        {
        
             strs[1] = ds.Tables[0].Rows[0]["ADDRESS"].ToString();
             strs[2]=ds.Tables[0].Rows[0]["SWITCHBOARD"].ToString();
            strs[3]=ds.Tables[0].Rows[0]["ZIP"].ToString();
            strs[4]=ds.Tables[0].Rows[0]["FAX"].ToString();
            strs[5] = ds.Tables[0].Rows[0]["COMPANYALIAS"].ToString();
          
        }
        return strs;
    }