I have a radgrid in batchedit. The Update and Select works fine but Insert didn't.
I use a defaultValue for a Select and Insert in code behind. For a select this works fine but when i try to insert the field of Database have null v
<
telerik:RadGrid
ID
=
"RGV"
runat
=
"server"
Width
=
"500px"
RenderMode
=
"Lightweight"
GridLines
=
"None"
AllowAutomaticDeletes
=
"True"
AllowAutomaticInserts
=
"True"
PageSize
=
"10"
AllowAutomaticUpdates
=
"True"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
DataSourceID
=
"SDS"
Skin
=
"WebBlue"
>
<
MasterTableView
CommandItemDisplay
=
"TopAndBottom"
DataKeyNames
=
"id"
DataSourceID
=
"SDS"
HorizontalAlign
=
"NotSet"
EditMode
=
"Batch"
AutoGenerateColumns
=
"False"
CommandItemSettings-AddNewRecordText
=
"Insertar centro"
CommandItemSettings-SaveChangesText
=
"Guardar"
CommandItemSettings-CancelChangesText
=
"Cancelar"
CommandItemSettings-RefreshText
=
"Refrescar"
NoMasterRecordsText
=
"No data"
NoDetailRecordsText
=
"No data"
>
<
BatchEditingSettings
EditType
=
"Cell"
/>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Empresa"
HeaderText
=
"Empresa"
SortExpression
=
"Empresa"
UniqueName
=
"Empresa"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Numero"
HeaderText
=
"Numero"
SortExpression
=
"Numero"
UniqueName
=
"Numero"
>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"Desde"
HeaderText
=
"Desde"
SortExpression
=
"Desde"
UniqueName
=
"Desde"
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"HastaEl"
HeaderText
=
"Hasta el"
SortExpression
=
"HastaEl"
UniqueName
=
"HastaEl"
>
</
telerik:GridDateTimeColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
AllowKeyboardNavigation
=
"true"
></
ClientSettings
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
ID
=
"SDS"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:PCMConnectionString %>"
SelectCommand="SELECT * From Table1 Where idRevisionCentros=@idRevisionCentros"
InsertCommand="INSERT INTO Table1 (idRevisionCentros,Empresa,Numero,Desde,HastaEl) VALUES (@idRevisionCentros,@Empresa,@Numero,@Desde,@HastaEl)"
UpdateCommand="UPDATE Table1 SET Empresa=@Empresa, Numero=@Numero,Desde=@Desde,HastaEl=@HastaEl WHERE id = @id">
<
SelectParameters
>
<
asp:parameter
Name
=
"idRevisionCentros"
type
=
"Int32"
/>
</
SelectParameters
>
<
InsertParameters
>
<
asp:parameter
Name
=
"idRevisionCentros"
type
=
"Int32"
/>
<
asp:Parameter
Name
=
"Empresa"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"Numero"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"Desde"
Type
=
"DateTime"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"HastaEl"
Type
=
"DateTime"
></
asp:Parameter
>
</
InsertParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"id"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"Empresa"
Type
=
"String"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"Numero"
Type
=
"Int32"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"Desde"
Type
=
"DateTime"
></
asp:Parameter
>
<
asp:Parameter
Name
=
"HastaEl"
Type
=
"DateTime"
></
asp:Parameter
>
</
UpdateParameters
>
</
asp:SqlDataSource
>
</
fieldset
>
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
int
idRevisionCentros = getIdRevisionCentros();
//return any number, for exemple 1;
SDS.SelectParameters[0].DefaultValue = idRevisionCentros.ToString();
//<-- Works fine
SDS.InsertParameters[0].DefaultValue = idRevisionCentros.ToString();
//<-- Insert null in DB for this field.....
}
}
Hi,
we are having a requirement to use the editor webpart to access the externally hosted html file and modify the changes and preview the design in the webpart. With the help of RADEditor webpart, i can able to write the html and see the preview but dont have an option to access the external HTML (similar to content editor webpart path properties). Is there way to do this?
Regards
Kathir
<
Scrolling
AllowScroll
=
"true"
UseStaticHeaders
=
"true"
ScrollHeight
=
"500px"
/>
Now, when scrolling is enabled, RadGrid doesn't fit its height to the content, it contains. The height will me much larger than the content itself. As a workaroung, I implemented a client side function Telerik provided on a demo page. The code is
function GridCreated(sender, args) {
var scrollArea = sender.GridDataDiv;
var dataHeight = sender.get_masterTableView().get_element().clientHeight;
if (dataHeight < 500) {
scrollArea.style.height = dataHeight + 17 + "px";
}
}
Sim Id | Sim Number | Phone Number | Network |
612 | 33333 | 7845698584 | Orange |
613 | 5555555555 | 7865984558 | O2 |
614 | 77777777777 | 7845898568 | T-Mobile |
616 | 6.05643E+19 | 7886400749 | Orange |
617 | 4.84783E+19 | 8189428786 | Orange |
618 | 7.86511E+19 | 5873120201 | Orange |
619 | 2.18533E+19 | 9137077548 | Orange |
620 | 4.63874E+19 | 8268437527 | Orange |
621 | 5.72428E+19 | 3478728312 | Orange |
622 | 4.31133E+19 | 8275787977 | Orange |
623 | 2.38482E+18 | 5451253979 | Orange |
624 | 6.94754E+19 | 1153142640 | Orange |
625 | 4.73383E+19 | 3272183543 | Orange |
626 | 9.50517E+19 | 1133185943 | Orange |
627 | 4.45572E+19 | 4538341455 | Orange |
628 | 3.11145E+19 | 2844557113 | Orange |
629 | 3.03666E+19 | 9437130953 | Orange |
630 | 9.91132E+19 | 245415386 | Orange |
631 | 2.32191E+19 | 5993223235 | Orange |
632 | 7.02665E+19 | 5953534740 | Orange |
In an web form 2010 application that I am currently working with, the radeditor is being used. Right now I have one letter being generated at a time. However I want to place 2 to 3 letters within the same varchar(max) column within a sql server database. I would like each letter to print on separate pages.
I have tried html like the following:
<html><body><p>test1</p><p style="page-break-after:always;"></p><p>test2</p><p style="page-break-after:always;"></p><p>test3</p><p style="page-break-after:always;"></p></body></html>
and found everything still prints on the same page.
Thus is there anything within the radeditor that will make the page breaks actually work?
Hi,
I am trying to add a button (pref imagebutton) to each one of the group headers (the row that has the expand/colapse functionality).
The intent is to give such button the ability to remove all the records of that group.
For example:
> Group 1
Row 1
Row 2
Row 3
> Group 2
Row 1
Row 2
I want the button on the "Group" rows, ideally to the right.
I have been researching but only found solutions to add it to each row and to the raid header, but not on the ExpandCollapse row.
Any ideas?