Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tool to edit text data type in SQL server table
Message
From
17/07/2007 20:22:35
 
 
To
17/07/2007 08:08:00
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
C# 2.0
Database:
MS SQL Server
Miscellaneous
Thread ID:
01240958
Message ID:
01241361
Views:
25
Cetin ,
Thanks for hint.

It turned out that using DataGridView with generators( bindingsource, bindingnavigator and etc... ) which results in VCR toolbar at the top , grid taking the rest of form area is easy and good enough in my case.

Just setting Autosizing and Wrapping allows in-cell editing.
this.monitoring_urlDataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
this.monitoring_urlDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells ;
this.monitoring_urlDataGridView.DefaultCellStyle.WrapMode = DataGridViewTriState.True; 
Surely for very long text ( more than grid height ) it doesn't work , but at least copy/paste back and forth from real text editor does.

Michael

>>I'd like to keep various snippets such as CSS style , javascripts in text field in SQL server.
>>Is there possibility to edit easily data type "text" field using standard tools such as SQL server 2005 Management Studio or Server Explorer in Visual Studio 2005 Professional. I want multiline editing akin to multiline textbox in Windows Form. I understand that something may be written/generated in Windows Forms , but I want this possibility for any table.
>>My pressing "Enter" to create another line for in-place editing just leaves a text cell for the tools mentioned above.
>>
>>I would happy to use a freeware which works against arbitrary table looking like VCR UI or grid where doble-click on selected row brings another popup form with multi-line texbox to edit "text field and etc...
>>
>>TIA
>>Michael
>
>Michael,
>AFAIK you have VFP too, I think it's much easier to create such a tool in VFP:)
>PS: I don't mean it's hard to do in .Net.
>Cetin
Previous
Reply
Map
View

Click here to load this message in the networking platform