Hello,
I have a grid in batch edit/cell mode, and everything works.
My problem is that one of the fields is very large - potentially two or three paragraphs of text. I'd like to move this onto it's own row, if possible. I've tried using a radtextbox within a NestedViewTemplate and DetailItemTemplate, and I can get the data to display in both, but I can't figure out how to include it in batch saves. <%#Bind("FieldName")%> doesn't work.
What would be the best way to accomplish this?
Here's a sample of what I have:
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowAutomaticUpdates
=
"true"
AutoGenerateColumns
=
"false"
DataSourceID
=
"DataSource1"
>
<
MasterTableView
CommandItemDisplay
=
"TopAndBottom"
DataKeyNames
=
"ItemNumber"
EditMode
=
"Batch"
AutoGenerateColumns
=
"false"
DataSourceID
=
"DataSource1"
>
<
BatchEditingSettings
EditType
=
"Cell"
HighlightDeletedRows
=
"true"
/>
<
NestedViewTemplate
>
<
telerik:RadTextBox
ID
=
"txtDesc"
runat
=
"server"
Text='<%#Bind("Desc")%>' />
</
NestedViewTemplate
>
<
Columns
>
<
telerik:GridBoundColumn
UniqueName
=
"ItemNumber"
DataField
=
"ItemNumber"
HeaderText
=
"Item Number"
/>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
runat
=
"server"
ID
=
"DataSource1"
ConnectionString
=
"(ConnectionString)"
ConflictDetection
=
"OverwriteChanges"
SelectCommand="SELECT * FROM [Table]"
InsertCommand="INSERT INTO [Table] ([Name], [Desc]) VALUES (@Name, @Desc)"
UpdateCommand="UPDATE [Table] SET [Name]=@Name, [Desc]=@Desc WHERE [ItemNumber]=@ItemNumber">
<
InsertParameters
>
<
asp:Parameter
Name
=
"Name"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Desc"
Type
=
"String"
/>
</
InsertParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"Name"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Desc"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ItemNumber"
Type
=
"Int32"
/>
</
UpdateParameters
>
</
asp:SqlDataSource
>