检查此C#代码以创建字符串 [英] Check this c# code to create a string

问题描述

请参见代码:

Please see the code:

public static string str1;
   public static string str2;
   public static string str3;
   public static string gets3pending()
   {
       string id = "";
       string Path = "";
       SqlConnection con = Database.GetConnection();
       SqlCommand com = new SqlCommand("Select id,Path from tblShareFile where status=0", con);
       DataSet ds = new DataSet();
       DataTable dt = new DataTable();

       SqlDataAdapter da = new SqlDataAdapter(com);
       //DataSet ds = new DataSet();
       da.Fill(ds, "tblShareFile");
       da.Fill(dt);
       SqlDataReader dr = com.ExecuteReader();

       while (dr.Read())
       {
           if (dt.Rows.Count > 0)
           {
               //for (int i = 0; i < dt.Rows.Count; i++)
               {
                   str1 += dr["id"].ToString() + "''";
                   str2 += dr["Path"].ToString() + "''";

               }
           }
       }

           dr.Close();

           string str3 = str1.ToString() + str2.ToString();

           return str3;

我想创建这样的字符串:1，path1 2，path2 3，path3等.
只是显示id和路径名，但是不起作用.

拜托，有人可以帮我吗?

预先感谢.

I want to create string like this: 1,path1 2,path2 3,path3 etc.
It''s just to show id and path name, but it''s not working.

Please, can any one help me?

Thanks in advance.

推荐答案

尝试

f (dt.Rows.Count > 0)
{
//for (int i = 0; i < dt.Rows.Count; i++)
  {
     str3 + = dr["id"].ToString() + "," + dr["Path"].ToString() + " ";
  }
}

最好使用This

It is good to use This

StringBuilder str = new StringBuilder();
            while (dr.Read())
      {
          if (dt.Rows.Count > 0)
          {

          str.Append(dr["id"].ToString());
          str.Append(" ,");
          str.Append(dr["Path"].ToString());
          }
      }

您也可以使用以下数据集进行操作

you can also do it with dataset like below

for(int i=0 ;i<ds.Tables[0].Rows.Count;i++)
             {
                 str1 += ds.Tables[0].Rows[i]["id"].ToString() + "," + ds.Tables[0].Rows[i]["Name"].ToString();
             }

这篇关于检查此C#代码以创建字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！