C# convert sql blob type to plain string

Blob stands for binary large object

 

 byte[] bytesArr= (byte[])rows[i]["congest"]; 
 bk.Congest = Encoding.UTF8.GetString(bytesArr)
复制代码
public static DataSet GetSQLDataset(string selectSQL)
{
    DataSet ds = new DataSet();
    using (MySqlDataAdapter da = new MySqlDataAdapter(selectSQL, conn))
    {
        da.Fill(ds);
    }
    return ds;
}



 private void LoadCmdExecuted(object obj)
 {
     string selectSQL = "select * from  mt;";
     DataSet ds=DBHelper.GetSQLDataset(selectSQL);
     if(ds!=null && ds.Tables!=null && ds.Tables.Count>0)
     {
         var rows=ds.Tables[0].Rows;
         int rowsCount = rows.Count;
         MessageBox.Show($"Get {rowsCount}");
         List<Book> booksList = new List<Book>();
         var colsCnt=ds.Tables[0].Columns.Count;
         int id = 0;
        
         for(int i=0;i<rowsCount;i++)
         {
             Book bk = new Book();
             if (Int32.TryParse(rows[i]["id"]?.ToString(), out id))
             {
                 bk.Id = id;
                 bk.Name = rows[i]["name"]?.ToString();
                 bk.Author = rows[i]["author"]?.ToString();
                 //bk.Congest = rows[i]["congest"]?.ToString();
                 byte[] bytesArr = (byte[])rows[i]["congest"];
                 if(bytesArr!=null && bytesArr.Any())
                 {
                     bk.Congest = Encoding.UTF8.GetString(bytesArr);
                 }                        
                 bk.Comment= rows[i]["comment"]?.ToString(); 
                 bk.Content = rows[i]["content"]?.ToString();
                 bk.Summary = rows[i]["summary"]?.ToString();
                 bk.ImgUrl = rows[i]["imgurl"]?.ToString();
                 bk.Title = rows[i]["title"]?.ToString();
                 bk.Topic = rows[i]["topic"]?.ToString();
             }
             booksList.Add(bk);
         }
         BooksCollection = new ObservableCollection<Book>(booksList);
     }
 }
复制代码

 

posted @   FredGrit  阅读(9)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
历史上的今天:
2019-09-01 Redis
点击右上角即可分享
微信分享提示