如何在Datagridview上显示LONG数据类型? [英] How to show LONG datatype on Datagridview?

问题描述

大家好，
我在Oracle 10g数据库上有一张表，该表的队列类型之一是LONG数据类型.尽管我可以轻松地将该字段绑定到Richtextbox并进行更新，但是我无法在datagridview上显示此字段.怎么做呢?我在VS和PL/SQL过程上尝试过一些方法，但没有设法做到.
BR

Hi all,
I have a table on my Oracle 10g database and one of the coulumn type of the table is LONG datatype. Although I can easily bind this field to Richtextbox and update it, I could not show this field on datagridview. How can be done this? I tried something on VS and PL/SQL procedures, but I have not managed to do.
BR

推荐答案

将长数据绑定到网格之前，请将长数据转换为字符串.
当您在项目模板中绑定特定的列值时，可以使用内联方法来完成此操作.或也可以在设计器页面中进行转换.

Before you bind your long data to the grid , convert the long to string.
This can be done using inline methods when you are binding that particular column value in item template. or Convertion can be done in designer page as well.

你好约翰逊，
您可以使用此PL/SQL函数将LONG字段转换为VARCHAR2.


创建或替换函数LONG_TO_CHAR(in_table_name varchar，
in_column varchar2，in_id varchar)

将varchar2返回为
my_text varchar2(32767);
my_sql varchar2(2000);

开始

sql_cur:=''从
中选择``|| in_column ||''
" ||| in_table_name ||"，其中id =

''|| chr(39)|| in_id || chr(39);

dbms_output.put_line(my_sql);
立即执行my_sql到my_text;
my_text:= substr(my_text，1，4000);
返回MY_TEXT;

结束LONG_TO_CHAR;


您可以像这样简单地调用此函数；

根据结果​​从MY_TABLE中选择long_to_char(``MY_TABLE''，``LONG_TYPE_COLUMN''，ID)

亲切的问候...

Hello Johnson,
you can use this PL/SQL function to convert LONG field to VARCHAR2.


create or replace function LONG_TO_CHAR(in_table_name varchar,
in_column varchar2, in_id varchar)

return varchar2 as
my_text varchar2(32767);
my_sql varchar2(2000);

begin

sql_cur := ''select ''||in_column||'' from

''||in_table_name||'' where id =

''||chr(39)||in_id||chr(39);

dbms_output.put_line (my_sql);
execute immediate my_sql into my_text;
my_text := substr(my_text, 1, 4000);
return MY_TEXT;

end LONG_TO_CHAR;


And you can simply call this function like that;

Select long_to_char (''MY_TABLE'' ,''LONG_TYPE_COLUMN'' ,ID) AS RESULT From MY_TABLE

Kindest regards...

这篇关于如何在Datagridview上显示LONG数据类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！