or
Hi telerik team
i'm trying to select date from jquery calendar. i can select calendar on first time after that
i have action to postback page and i go to select calendar again it's not work.
how can i do ? help me pls
This Code Under RadAjaxLoadingPanel ,RadAjaxManager ,RadScriptManager
<
asp:Content
ID
=
"HeaderContent"
runat
=
"server"
ContentPlaceHolderID
=
"HeadContent"
>
<
link
type
=
"text/css"
href
=
"../Styles/ui-lightness/jquery-ui-1.8.10.custom.css"
rel
=
"stylesheet"
/>
<
style
type
=
"text/css"
>
.demoHeaders { margin-top: 2em; }
#dialog_link {padding: .4em 1em .4em 20px;text-decoration: none;position: relative;}
#dialog_link span.ui-icon {margin: 0 5px 0 0;position: absolute;left: .2em;top: 50%;margin-top: -8px;}
ul#icons {margin: 0; padding: 0;}
ul#icons li {margin: 2px; position: relative; padding: 4px 0; cursor: pointer; float: left; list-style: none;}
ul#icons span.ui-icon {float: left; margin: 0 4px;}
ul.test {list-style:none; line-height:30px;}
</
style
>
</
asp:Content
>
<
asp:Content
ID
=
"BodyContent"
runat
=
"server"
ContentPlaceHolderID
=
"MainContent"
>
<
telerik:RadCodeBlock
id
=
"RadCodeBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function openPopup(typeofv) {
//alert(obj.name);
var pageURL = "ItemMaster_Search.aspx?typeofv=" + typeofv;
var w = 750;
var h = 600;
var left = (screen.width / 2) - (w / 2);
var top = (screen.height / 2) - (h / 2);
window.open(pageURL, '', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width=' + w + ', height=' + h + ', top=' + top + ', left=' + left);
//var value = obj.value;
//window.open('ItemMaster_Search.aspx?txtName=' + value, null, 'height=600,width=750,status=yes,toolbar=no,menubar=no,location=no');
return false;
}
</
script
>
<
script
type
=
"text/javascript"
src
=
"../js/jquery-1.4.4.min.js"
></
script
>
<
script
type
=
"text/javascript"
src
=
"../js/jquery-ui-1.8.10.offset.datepicker.min.js"
></
script
>
<
script
type
=
"text/javascript"
>
$(function () {
var d = new Date();
var toDay = d.getDate() + '/' + (d.getMonth() + 1) + '/' + (d.getFullYear() + 543);
// กรณีต้องการใส่ปฏิทินลงไปมากกว่า 1 อันต่อหน้า ก็ให้มาเพิ่ม Code ที่บรรทัดด้านล่างด้วยครับ (1 ชุด = 1 ปฏิทิน)
$("#MainContent_from_DT").datepicker({ changeMonth: true, changeYear: true, dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay, dayNames: ['อาทิตย์', 'จันทร์', 'อังคาร', 'พุธ', 'พฤหัสบดี', 'ศุกร์', 'เสาร์'],
dayNamesMin: ['อา.', 'จ.', 'อ.', 'พ.', 'พฤ.', 'ศ.', 'ส.'],
monthNames: ['มกราคม', 'กุมภาพันธ์', 'มีนาคม', 'เมษายน', 'พฤษภาคม', 'มิถุนายน', 'กรกฎาคม', 'สิงหาคม', 'กันยายน', 'ตุลาคม', 'พฤศจิกายน', 'ธันวาคม'],
monthNamesShort: ['ม.ค.', 'ก.พ.', 'มี.ค.', 'เม.ย.', 'พ.ค.', 'มิ.ย.', 'ก.ค.', 'ส.ค.', 'ก.ย.', 'ต.ค.', 'พ.ย.', 'ธ.ค.']
});
$("#MainContent_To_DT").datepicker({ changeMonth: true, changeYear: true, dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay, dayNames: ['อาทิตย์', 'จันทร์', 'อังคาร', 'พุธ', 'พฤหัสบดี', 'ศุกร์', 'เสาร์'],
dayNamesMin: ['อา.', 'จ.', 'อ.', 'พ.', 'พฤ.', 'ศ.', 'ส.'],
monthNames: ['มกราคม', 'กุมภาพันธ์', 'มีนาคม', 'เมษายน', 'พฤษภาคม', 'มิถุนายน', 'กรกฎาคม', 'สิงหาคม', 'กันยายน', 'ตุลาคม', 'พฤศจิกายน', 'ธันวาคม'],
monthNamesShort: ['ม.ค.', 'ก.พ.', 'มี.ค.', 'เม.ย.', 'พ.ค.', 'มิ.ย.', 'ก.ค.', 'ส.ค.', 'ก.ย.', 'ต.ค.', 'พ.ย.', 'ธ.ค.']
});
});
</
script
>
</
telerik:RadCodeBlock
>
<
div
>
<
table
cellpadding
=
"0"
cellspacing
=
"0"
class
=
"tablemain"
border
=
"0"
>
<
tr
>
<
td
class
=
"td4Colhead"
>
เริ่มวันที่ <
span
class
=
"spanvalidate"
>*</
span
> </
td
>
<
td
class
=
"td4Colinput"
>
<
asp:TextBox
ID
=
"from_DT"
runat
=
"server"
CssClass
=
"textboxclass50"
MaxLength
=
"10"
ReadOnly
=
"true"
></
asp:TextBox
>
<
asp:RequiredFieldValidator
ID
=
"RequiredFieldValidator1"
runat
=
"server"
ControlToValidate
=
"from_DT"
CssClass
=
"validater"
ErrorMessage
=
"เริ่มวันที่"
>*</
asp:RequiredFieldValidator
>
</
td
>
<
td
class
=
"td4Colhead"
>
ถึงวันที่ </
td
>
<
td
class
=
"td4Colinput"
>
<
asp:TextBox
ID
=
"To_DT"
runat
=
"server"
CssClass
=
"textboxclass50"
MaxLength
=
"10"
ReadOnly
=
"true"
></
asp:TextBox
>
</
td
>
</
tr
>
</
table
>
</
div
>
<
br
/>
</
asp:Content
>
<
telerik:RadCodeBlock
ID
=
"rcb1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
// ***** Begin Paste from Excel scripts.
var lastFocused;
function pasteFromExcel() {
if (!lastFocused) return;
var clipData = window.clipboardData.getData('Text');
var crlf = String.fromCharCode(13) + String.fromCharCode(10);
var table = clipData.split(crlf);
for (var tRow = 0; tRow <
table.length
- 1; tRow++)
table[tRow] = table[tRow].split(String.fromCharCode(9));
Array.remove(table, table[table.length - 1]);
fillTable(table);
}
function fillTable(table) {
var
pCell
=
lastFocused
.parentNode;
var
pRow
=
pCell
.parentNode;
var
pBody
=
pRow
.parentNode;
var
maxRows
=
pBody
.rows.length;
var
maxCols
=
pRow
.cells.length;
hasChanges
=
true
;
for (var
row
=
0
; row < table.length; row++) {
for (var
col
=
0
; col < table[row].length; col++) {
var
cCellIndex
=
pCell
.cellIndex + col;
var
cRowIndex
=
pRow
.sectionRowIndex + row;
if (cRowIndex < maxRows && cCellIndex < maxCols) {
var
cCell
=
pBody
.rows[cRowIndex].cells[cCellIndex];
var
pInput
=
cCell
.getElementsByTagName("input")[0];
pInput.style.backgroundColor
=
"#F7FAFF"
;
pInput.value
=
table
[row][col];
}
}
}
}
function gridFocus(e) {
e
= e || window.event;
var
target
= e.target || e.srcElement;
if (target.tagName.toLowerCase() == "input" && target.type.toLowerCase() == "text")
lastFocused
=
target
;
}
function clearCells(sender) {
var radGrid = $get('<%= RadGrid1.ClientID %>');
var inputs = radGrid.getElementsByTagName("input");
for (var el = 0; el <
inputs.length
; el++) {
if (inputs[el].type == "text") {
inputs[el]
.value
=
""
;
inputs[el]
.style.backgroundColor
=
""
;
}
}
}
// ***** End Paste from Excel scripts.
</script>
</
telerik:RadCodeBlock
>
<
div
>
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowMultiRowEdit
=
"true"
DataSourceID
=
"SqlDataSource1"
onclick
=
"gridFocus(event)"
Width
=
"830px"
ShowHeader
=
"true"
Skin
=
"Office2007"
OnColumnCreated
=
"RadGrid1_ColumnCreated"
AllowAutomaticUpdates
=
"true"
OnItemUpdated
=
"RadGrid1_ItemUpdated"
AutoGenerateColumns
=
"False"
>
<
MasterTableView
EditMode
=
"InPlace"
CommandItemDisplay
=
"Top"
TableLayout
=
"Fixed"
>
<
CommandItemTemplate
>
<
div
style
=
"float: left"
>
<
input
type
=
"button"
value
=
"Paste from Excel"
onclick
=
"pasteFromExcel()"
/>
<
input
type
=
"button"
value
=
"Clear cells"
onclick
=
"clearCells()"
/>
</
div
>
<
div
style
=
"float: right"
>
<
asp:Button
ID
=
"UpdateEditedButton"
CommandName
=
"UpdateEdited"
Text
=
"Update edited items"
runat
=
"server"
/>
</
div
>
</
CommandItemTemplate
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"ID"
DataType
=
"System.Int32"
HeaderText
=
"ID"
UniqueName
=
"ID"
Visible
=
"true"
ReadOnly
=
"True"
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/>
<
ItemStyle
HorizontalAlign
=
"Left"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column1"
HeaderText
=
"Column1"
UniqueName
=
"Column1"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column2"
HeaderText
=
"Column2"
UniqueName
=
"Column2"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column3"
HeaderText
=
"Column3"
UniqueName
=
"Column3"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column4"
HeaderText
=
"Column4"
UniqueName
=
"Column4"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column5"
HeaderText
=
"Column5"
UniqueName
=
"Column5"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column6"
HeaderText
=
"Column6"
UniqueName
=
"Column6"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column7"
HeaderText
=
"Column7"
UniqueName
=
"Column7"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column8"
HeaderText
=
"Column8"
UniqueName
=
"Column8"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column9"
HeaderText
=
"Column9"
UniqueName
=
"Column9"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Column10"
HeaderText
=
"Column10"
UniqueName
=
"Column10"
Visible
=
"true"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"
DeleteCommand="DELETE FROM [EmptyTable] WHERE [ID] = @ID" InsertCommand="INSERT INTO [EmptyTable] ([ID], [Column1], [Column2], [Column3], [Column4], [Column5], [Column6], [Column7], [Column8], [Column9], [Column10]) VALUES (@ID, @Column1, @Column2, @Column3, @Column4, @Column5, @Column6, @Column7, @Column8, @Column9, @Column10)"
SelectCommand="SELECT * FROM [EmptyTable]" UpdateCommand="UPDATE [EmptyTable] SET [Column1] = @Column1, [Column2] = @Column2, [Column3] = @Column3, [Column4] = @Column4, [Column5] = @Column5, [Column6] = @Column6, [Column7] = @Column7, [Column8] = @Column8, [Column9] = @Column9, [Column10] = @Column10 WHERE [ID] = @ID">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
/>
</
DeleteParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"Column1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column7"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column8"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column9"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column10"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
/>
</
UpdateParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"Column1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column7"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column8"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column9"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column10"
Type
=
"String"
/>
</
InsertParameters
>
</
asp:SqlDataSource
>
</
div
>
protected
void
Page_Load(
object
sender, EventArgs e)
{
for
(
int
i = 0; i < RadGrid1.PageSize; i++)
RadGrid1.EditIndexes.Add(i);
}
protected
void
RadGrid1_ColumnCreated(
object
sender, GridColumnCreatedEventArgs e)
{
if
(e.Column
is
GridBoundColumn)
e.Column.Visible = (e.Column
as
GridBoundColumn).DataField !=
"ID"
;
}
protected
void
RadGrid1_ItemUpdated(
object
source, GridUpdatedEventArgs e)
{
e.KeepInEditMode =
true
;
}
<
telerik:RadCodeBlock
ID
=
"rcb1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
// ***** Begin Paste from Excel scripts.
var lastFocused;
function pasteFromExcel() {
if (!lastFocused) return;
var clipData = window.clipboardData.getData('Text');
var crlf = String.fromCharCode(13) + String.fromCharCode(10);
var table = clipData.split(crlf);
for (var tRow = 0; tRow <
table.length
- 1; tRow++)
table[tRow] = table[tRow].split(String.fromCharCode(9));
Array.remove(table, table[table.length - 1]);
fillTable(table);
}
function fillTable(table) {
//Changed this line to the 2 lines below.
// var
pCell
=
lastFocused
.parentNode;
var
pSpan
=
lastFocused
.parentNode;
var
pCell
=
pSpan
.parentNode;
var
pRow
=
pCell
.parentNode;
var
pBody
=
pRow
.parentNode;
var
maxRows
=
pBody
.rows.length;
var
maxCols
=
pRow
.cells.length;
hasChanges
=
true
;
for (var
row
=
0
; row < table.length; row++) {
for (var
col
=
0
; col < table[row].length; col++) {
var
cCellIndex
=
pCell
.cellIndex + col;
var
cRowIndex
=
pRow
.sectionRowIndex + row;
if (cRowIndex < maxRows && cCellIndex < maxCols) {
var
cCell
=
pBody
.rows[cRowIndex].cells[cCellIndex];
var
pInput
=
cCell
.getElementsByTagName("input")[0];
pInput.style.backgroundColor
=
"#F7FAFF"
;
pInput.value
=
table
[row][col];
}
}
}
}
function gridFocus(e) {
e
= e || window.event;
var
target
= e.target || e.srcElement;
if (target.tagName.toLowerCase() == "input" && target.type.toLowerCase() == "text")
lastFocused
=
target
;
}
function clearCells(sender) {
var radGrid = $get('<%= RadGrid1.ClientID %>');
var inputs = radGrid.getElementsByTagName("input");
for (var el = 0; el <
inputs.length
; el++) {
if (inputs[el].type == "text") {
inputs[el]
.value
=
""
;
inputs[el]
.style.backgroundColor
=
""
;
}
}
}
// ***** End Paste from Excel scripts.
</script>
</
telerik:RadCodeBlock
>
<
div
>
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowMultiRowEdit
=
"true"
DataSourceID
=
"SqlDataSource1"
onclick
=
"gridFocus(event)"
Width
=
"830px"
ShowHeader
=
"true"
Skin
=
"Office2007"
OnColumnCreated
=
"RadGrid1_ColumnCreated"
AllowAutomaticUpdates
=
"true"
OnItemUpdated
=
"RadGrid1_ItemUpdated"
AutoGenerateColumns
=
"False"
>
<
MasterTableView
EditMode
=
"InPlace"
CommandItemDisplay
=
"Top"
TableLayout
=
"Fixed"
>
<
editformsettings
>
<
editcolumn
filtercontrolalttext
=
"Filter EditCommandColumn column"
>
</
editcolumn
>
</
editformsettings
>
<
CommandItemTemplate
>
<
div
style
=
"float: left"
>
<
input
type
=
"button"
value
=
"Paste from Excel"
onclick
=
"pasteFromExcel()"
/>
<
input
type
=
"button"
value
=
"Clear cells"
onclick
=
"clearCells()"
/>
</
div
>
<
div
style
=
"float: right"
>
<
asp:Button
ID
=
"UpdateEditedButton"
CommandName
=
"UpdateEdited"
Text
=
"Update edited items"
runat
=
"server"
/>
</
div
>
</
CommandItemTemplate
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
/>
<
rowindicatorcolumn
filtercontrolalttext
=
"Filter RowIndicator column"
visible
=
"True"
>
</
rowindicatorcolumn
>
<
expandcollapsecolumn
filtercontrolalttext
=
"Filter ExpandColumn column"
visible
=
"True"
>
</
expandcollapsecolumn
>
<
Columns
>
<
telerik:GridNumericColumn
DataField
=
"ID"
DataType
=
"System.Int32"
HeaderText
=
"ID"
UniqueName
=
"ID"
Visible
=
"true"
ReadOnly
=
"True"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column1"
HeaderText
=
"Column1"
UniqueName
=
"Column1"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column2"
HeaderText
=
"Column2"
UniqueName
=
"Column2"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column3"
HeaderText
=
"Column3"
UniqueName
=
"Column3"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column4"
HeaderText
=
"Column4"
UniqueName
=
"Column4"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column5"
HeaderText
=
"Column5"
UniqueName
=
"Column5"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column6"
HeaderText
=
"Column6"
UniqueName
=
"Column6"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column7"
HeaderText
=
"Column7"
UniqueName
=
"Column7"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column8"
HeaderText
=
"Column8"
UniqueName
=
"Column8"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column9"
HeaderText
=
"Column9"
UniqueName
=
"Column9"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"Column10"
HeaderText
=
"Column10"
UniqueName
=
"Column10"
Visible
=
"true"
>
</
telerik:GridNumericColumn
>
</
Columns
>
</
MasterTableView
>
<
filtermenu
enableimagesprites
=
"False"
>
</
filtermenu
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"
DeleteCommand="DELETE FROM [EmptyTable] WHERE [ID] = @ID" InsertCommand="INSERT INTO [EmptyTable] ([ID], [Column1], [Column2], [Column3], [Column4], [Column5], [Column6], [Column7], [Column8], [Column9], [Column10]) VALUES (@ID, @Column1, @Column2, @Column3, @Column4, @Column5, @Column6, @Column7, @Column8, @Column9, @Column10)"
SelectCommand="SELECT * FROM [EmptyTable]" UpdateCommand="UPDATE [EmptyTable] SET [Column1] = @Column1, [Column2] = @Column2, [Column3] = @Column3, [Column4] = @Column4, [Column5] = @Column5, [Column6] = @Column6, [Column7] = @Column7, [Column8] = @Column8, [Column9] = @Column9, [Column10] = @Column10 WHERE [ID] = @ID">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
/>
</
DeleteParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"Column1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column7"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column8"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column9"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column10"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
/>
</
UpdateParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"ID"
Type
=
"Int32"
/>
<
asp:Parameter
Name
=
"Column1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column2"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column3"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column4"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column5"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column6"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column7"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column8"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column9"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"Column10"
Type
=
"String"
/>
</
InsertParameters
>
</
asp:SqlDataSource
>
</
div
>
<%@ Page Language=
"VB"
AutoEventWireup=
"false"
CodeFile=
"TestBed2.aspx.vb"
Inherits
=
"TestBed2"
%>
<!DOCTYPE html>
<html xmlns=
"http://www.w3.org/1999/xhtml"
>
<head runat=
"server"
>
<title></title>
<style type=
"text/css"
>
.classDiv
{
float: left;
width: 150px;
}
.clear
{
width: 100%;
clear: both;
height: 110px;
}
</style>
</head>
<body>
<form id=
"form1"
runat=
"server"
>
<telerik:RadStyleSheetManager ID=
"RadStyleSheetManager1"
runat=
"server"
>
</telerik:RadStyleSheetManager>
<telerik:RadScriptManager ID=
"RadScriptManager1"
runat=
"server"
>
<Scripts>
<asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name=
"Telerik.Web.UI.Common.Core.js"
>
</asp:ScriptReference>
<asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name=
"Telerik.Web.UI.Common.jQuery.js"
>
</asp:ScriptReference>
<asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name=
"Telerik.Web.UI.Common.jQueryInclude.js"
>
</asp:ScriptReference>
</Scripts>
</telerik:RadScriptManager>
<telerik:RadAjaxManager ID=
"RadAjaxManager1"
runat=
"server"
>
</telerik:RadAjaxManager>
<div class=
"classDiv"
>
<telerik:RadButton ID=
"RadButton16"
runat=
"server"
ToggleType=
"Radio"
ButtonType=
"StandardButton"
GroupName=
"StandardButton"
AutoPostBack=
"false"
>
<ToggleStates>
<telerik:RadButtonToggleState Text=
"Checked"
PrimaryIconCssClass=
"rbToggleRadioChecked"
/>
<telerik:RadButtonToggleState Text=
"UnChecked"
PrimaryIconCssClass=
"rbToggleRadio"
/>
</ToggleStates>
</telerik:RadButton>
</div>
</form>
</body>
</html>
protected
void
RadGrid1_NeedDataSource(
object
sender, GridNeedDataSourceEventArgs e)
{
dtValues =
new
DataTable();
dtValues.Columns.Add(
"Items"
);
dtValues.Columns.Add(
"Rate"
);
dtValues.Columns.Add(
"Quantity"
);
dtValues.Columns.Add(
"Amount"
);
RadGrid1.DataSource = dtValues;
}
protected
void
btnAdd_Click(
object
sender, EventArgs e)
{
RadGrid1.MasterTableView.IsItemInserted =
true
;
RadGrid1.MasterTableView.Rebind();
}
protected
void
RadGrid1_ItemCreated(
object
sender, GridItemEventArgs e)
{
if
(e.Item
is
GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted)
{
GridEditFormInsertItem insertItem = (GridEditFormInsertItem)e.Item;
RadComboBox combo = insertItem.FindControl(
"RadComboBox1"
)
as
RadComboBox;
combo.AutoPostBack =
true
;
combo.SelectedIndexChanged +=
new
RadComboBoxSelectedIndexChangedEventHandler(combo_SelectedIndexChanged);
Button Save = insertItem.FindControl(
"btnSave"
)
as
Button;
Save.Click +=
new
EventHandler(Save_Click);
Button cancel = insertItem.FindControl(
"btnCancel"
)
as
Button;
cancel.Click +=
new
EventHandler(Cancel_Click);
}
}
protected
void
Cancel_Click(
object
sender, EventArgs e)
{
Button Cancel = (Button)sender;
GridEditFormInsertItem insertItem = (GridEditFormInsertItem)Cancel.NamingContainer;
RadComboBox combo = insertItem.FindControl(
"RadComboBox1"
)
as
RadComboBox;
Label lblRate = (Label)insertItem.FindControl(
"lblRate"
);
RadNumericTextBox txtQauntityE = (RadNumericTextBox)insertItem.FindControl(
"txtQuantityE"
);
Label lblAmount = (Label)insertItem.FindControl(
"lblAmount"
);
combo.SelectedIndex = -1;
lblRate.Text =
""
;
txtQauntityE.Text =
""
;
lblAmount.Text =
""
;
RadGrid1.MasterTableView.IsItemInserted =
false
;
RadGrid1.MasterTableView.Rebind();
}
protected
void
Save_Click(
object
sender, EventArgs e)
{
Button Save = (Button)sender;
GridEditFormInsertItem insertItem = (GridEditFormInsertItem)Save.NamingContainer;
RadComboBox combo = insertItem.FindControl(
"RadComboBox1"
)
as
RadComboBox;
Label lblRate = (Label)insertItem.FindControl(
"lblRate"
);
RadNumericTextBox txtQauntityE = (RadNumericTextBox)insertItem.FindControl(
"txtQuantityE"
);
Label lblAmount = (Label)insertItem.FindControl(
"lblAmount"
);
if
(combo.SelectedIndex > 0 && txtQauntityE.Text !=
null
)
{
DataRow drValues = dtValues.NewRow();
drValues[
"Items"
] = combo.SelectedItem.Text;
drValues[
"Rate"
] = lblRate.Text;
drValues[
"Quantity"
] = txtQauntityE.Text;
drValues[
"Amount"
] = lblAmount.Text;
dtValues.Rows.Add(drValues);
dtValues.AcceptChanges();
RadGrid1.DataSource = dtValues;
RadGrid1.Rebind();
RadGrid1.MasterTableView.IsItemInserted =
false
;
RadGrid1.MasterTableView.Rebind();
}
else
{
}
}
protected
void
combo_SelectedIndexChanged(
object
o, RadComboBoxSelectedIndexChangedEventArgs e)
{
RadComboBox combo = (RadComboBox)o;
GridEditFormInsertItem insertItem = (GridEditFormInsertItem)combo.NamingContainer;
Label lblRate = (Label)insertItem.FindControl(
"lblRate"
);
SqlConnection conn =
new
SqlConnection(ConfigurationSettings.AppSettings[
"conn"
].ToString());
SqlCommand cmd =
new
SqlCommand(
"select [Rate] FROM [tblProducts] where ProductName=@ProductName"
, conn);
cmd.Parameters.Add(
new
SqlParameter(
"@ProductName"
, combo.SelectedValue));
SqlDataAdapter da =
new
SqlDataAdapter(cmd);
DataSet ds =
new
DataSet();
da.Fill(ds);
if
(ds.Tables[0].Rows.Count > 0)
{
lblRate.Text = ds.Tables[0].Rows[0].ItemArray.GetValue(0).ToString();
}
RadNumericTextBox Quantity = (RadNumericTextBox)insertItem.FindControl(
"txtQuantityE"
);
Quantity.Focus();
}
protected
void
RadGrid1_ItemDataBound(
object
sender, GridItemEventArgs e)
{
if
(e.Item
is
GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted)
{
GridEditFormInsertItem insertItem = (GridEditFormInsertItem)e.Item;
}
}