<script type="text/javascript">
function OnOpen1()
{
<%= RadDatePicker1.ClientID %>.ShowPopup();
var datePicker = $find("<%= RadDatePicker1.ClientID %>");
datePicker.get_selectedDate(); */
}
<CSP:CSPGrid ID="ClientiGrid" runat="server" AutoGenerateColumns="False" AutoGenerateHierarchy="True"
GridLines="None" Skin="Web20" AllowAutomaticUpdates="True">
<ClientSettings ColumnsReorderMethod="Swap">
<DataBinding FilterParameterType="List" ResponseType="Json">
<DataService DataServiceType="AdoNet" />
</DataBinding>
</ClientSettings>
<MasterTableView AllowAutomaticUpdates="True" DataKeyNames="ClienteStudioId"
TableLayout="Fixed">
<columns>
<CSP:CSPGridBoundColumn DataField="ClienteStudioId"
HeaderText="ClienteStudioId" Resizable="false" UniqueName="ClienteStudioId"
Visible="false">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="RagioneSociale" HeaderText="RagioneSociale"
Resizable="false" UniqueName="RagioneSociale" Visible="true">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="CodFiscale" HeaderText="CodFiscale"
Resizable="false" UniqueName="CodFiscale" Visible="true">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="PIva" HeaderText="PIva" Resizable="false"
UniqueName="PIva" Visible="true">
</CSP:CSPGridBoundColumn>
<CSP:CSPGridBoundColumn DataField="Fax" HeaderText="Fax" Resizable="false"
UniqueName="Fax" Visible="true">
</CSP:CSPGridBoundColumn>
</columns>
<CommandItemSettings ExportToPdfText="Export to Pdf" />
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column">
</EditColumn>
</EditFormSettings>
<ExpandCollapseColumn AndCurrentFilterFunction="NoFilter"
CurrentFilterFunction="NoFilter" DataSecurity="Read" FilterDelay=""
FilterListOptions="VaryByDataType">
</ExpandCollapseColumn>
<RowIndicatorColumn AndCurrentFilterFunction="NoFilter"
CurrentFilterFunction="NoFilter" DataSecurity="Read" FilterDelay=""
FilterListOptions="VaryByDataType">
</RowIndicatorColumn>
</MasterTableView>
<PagerStyle CssClass="rgPager" Mode="NextPrevAndNumeric" Wrap="True" />
</CSP:CSPGrid>
But in RadGrid the above code are not adding.So Please help me in this regards.
Thanks & Regards,
Anita Sahu
<
telerik:RadAjaxLoadingPanel
ID
=
"itemsLoadingPanel"
runat
=
"server"
Skin
=
"Vista"
Transparency
=
"30"
></
telerik:RadAjaxLoadingPanel
>
<
telerik:RadAjaxPanel
ID
=
"itemsPanel"
runat
=
"server"
LoadingPanelID
=
"itemsLoadingPanel"
>
<
div
>
<
telerik:RadTextBox
ID
=
"itemSearchPSTxt"
runat
=
"server"
EmptyMessage
=
"PS #"
/>
<
telerik:RadTextBox
ID
=
"itemSearchDescriptionTxt"
runat
=
"server"
EmptyMessage
=
"Description"
/>
<
telerik:RadTextBox
ID
=
"itemSearchPartNumTxt"
runat
=
"server"
EmptyMessage
=
"Part #"
/>
<
telerik:RadButton
ID
=
"itemSearchBtn"
runat
=
"server"
Text
=
"Search"
OnClick
=
"itemSearchBtn_Click"
/>
<
asp:Label
ID
=
"itemSearchErrorlbl"
runat
=
"server"
Text
=
"*You must input a search value"
CssClass
=
"error"
Visible
=
"false"
/>
</
div
>
<
telerik:RadGrid
ID
=
"itemsRadGrid"
runat
=
"server"
AutoGenerateColumns
=
"true"
AutoGenerateEditColumn
=
"true"
AllowPaging
=
"true"
OnItemCommand
=
"itemsRadGrid_ItemCommand"
>
<
MasterTableView
CommandItemDisplay
=
"Top"
NoMasterRecordsText
=
"No Records"
EditMode
=
"PopUp"
>
<
CommandItemSettings
ShowAddNewRecordButton
=
"false"
ShowRefreshButton
=
"false"
/>
<
EditFormSettings
EditFormType
=
"Template"
PopUpSettings-Modal
=
"true"
PopUpSettings-Width
=
"720px"
CaptionFormatString
=
"Edit Item"
>
<
FormTemplate
>
<
table
>
<
tr
>
<
td
>Description:</
td
>
<
td
>Part Number:</
td
>
<
td
>Category:</
td
>
</
tr
>
<
tr
>
<
td
><
telerik:RadTextBox
ID
=
"editItemDescription"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemPartNum"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemCategory"
runat
=
"server"
/></
td
>
</
tr
>
<
tr
>
<
td
>Internal Account Number:</
td
>
<
td
>Status:</
td
>
<
td
></
td
>
</
tr
>
<
tr
>
<
td
><
telerik:RadTextBox
ID
=
"editItemAcctNum"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemStatus"
runat
=
"server"
Text /></
td
>
<
td
></
td
>
</
tr
>
<
tr
>
<
td
>Expires: <
asp:DropDownList
ID
=
"editItemExpires"
runat
=
"server"
><
asp:ListItem
Text
=
"Yes"
Value
=
"1"
/><
asp:ListItem
Text
=
"No"
Value
=
"0"
/></
asp:DropDownList
></
td
>
<
td
>Serial Numbered: <
asp:DropDownList
ID
=
"editItemSerialNum"
runat
=
"server"
><
asp:ListItem
Text
=
"Yes"
Value
=
"1"
/><
asp:ListItem
Text
=
"No"
Value
=
"0"
/></
asp:DropDownList
></
td
>
<
td
>Lot Numbered: <
asp:DropDownList
ID
=
"editItemLotNum"
runat
=
"server"
><
asp:ListItem
Text
=
"Yes"
Value
=
"1"
/><
asp:ListItem
Text
=
"No"
Value
=
"0"
/></
asp:DropDownList
></
td
>
<
td
>Consigned: <
asp:DropDownList
ID
=
"editItemConsigned"
runat
=
"server"
><
asp:ListItem
Text
=
"Yes"
Value
=
"1"
/><
asp:ListItem
Text
=
"No"
Value
=
"0"
/></
asp:DropDownList
></
td
>
</
tr
>
<
tr
>
<
td
>OEM:</
td
>
<
td
>OEM ID:</
td
>
<
td
>OEM Item ID:</
td
>
</
tr
>
<
tr
>
<
td
><
telerik:RadTextBox
ID
=
"editItemOEM"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemOEMID"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemOEMItemID"
runat
=
"server"
/></
td
>
</
tr
>
<
tr
>
<
td
>Vendor:</
td
>
<
td
>Vendor ID:</
td
>
<
td
>Vendor Item ID:</
td
>
</
tr
>
<
tr
>
<
td
><
telerik:RadTextBox
ID
=
"editItemVendor"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemVendorID"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemVendorItemID"
runat
=
"server"
/></
td
>
</
tr
>
<
tr
>
<
td
>Vendor Price:</
td
>
<
td
>Price Each:</
td
>
<
td
>Cost Code:</
td
>
<
td
>Conversion Rate:</
td
>
<
td
>Unit of Measure:</
td
>
</
tr
>
<
tr
>
<
td
><
telerik:RadTextBox
ID
=
"editItemVendorPrice"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemPriceEach"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemCostCode"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemCoversionRate"
runat
=
"server"
/></
td
>
<
td
><
telerik:RadTextBox
ID
=
"editItemUnitMeasure"
runat
=
"server"
/></
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"4"
><
telerik:RadButton
ID
=
"editItemUpdateBtn"
runat
=
"server"
Text
=
"Update"
/></
td
>
</
tr
>
</
table
>
</
FormTemplate
>
</
EditFormSettings
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
protected
void
itemSearchBtn_Click (
object
sender, EventArgs e)
{
itemSearchErrorlbl.Visible =
false
;
string
PartNum = itemSearchPartNumTxt.Text;
string
Description = itemSearchDescriptionTxt.Text;
string
PSNum = itemSearchPSTxt.Text;
string
whereStatement =
""
;
if
(PartNum !=
""
|| Description !=
""
|| PSNum !=
""
)
{
if
(PartNum !=
""
)
{
whereStatement =
"items.PartNumber = "
+
"'"
+ PartNum +
"'"
;
}
if
(Description !=
""
)
{
// See if there is already a statement to see if we need to add AND
if
(whereStatement ==
""
)
{
whereStatement =
"items.Description like "
+
"'%"
+ Description +
"%'"
;
}
else
{
whereStatement = whereStatement +
" AND items.Description like "
+
"'%"
+ Description +
"%'"
;
}
}
if
(PSNum !=
""
)
{
if
(whereStatement ==
""
)
{
whereStatement =
"items.CrossRefID = "
+
"'"
+ PSNum +
"'"
;
}
else
{
whereStatement = whereStatement +
" AND items.CrossRefID = "
+
"'"
+ PSNum +
"'"
;
}
}
itemsRadGrid.DataSource = GetDataTable(
"SELECT ItemParValues.ID, Min, Max, Locations.Name, ItemID FROM ItemParValues INNER JOIN items on ItemParValues.ItemID = items.ID INNER JOIN Locations on Locations.ID = ItemParValues.LocationID WHERE "
+ whereStatement);
itemsRadGrid.DataBind();
}
else
// Display error
itemSearchErrorlbl.Visible =
true
;
}
protected
void
itemsRadGrid_ItemCommand(
object
sender, GridCommandEventArgs e)
{
if
(e.CommandName == RadGrid.EditCommandName)
{
}
}
public
DataTable GetDataTable(
string
queryString)
{
using
(SqlCommand cmd =
new
SqlCommand(queryString, connection))
{
SqlDataAdapter da =
new
SqlDataAdapter(cmd);
DataTable dt =
new
DataTable();
da.Fill(dt);
return
dt;
}
}
<telerik:RadGrid ID="RadGrid1" runat="server"
AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True"
DataSourceID="GetProvider" GridLines="None" Skin="Windows7" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True">
<MasterTableView AutoGenerateColumns="False" DataSourceID="GetProvider" CommandItemDisplay="Top" DataKeyNames="SuspendedProviderId" >
<Columns>
<telerik:GridBoundColumn DataField="SocialSecurityAct" HeaderText="SocialSecurityAct"
SortExpression="SocialSecurityAct" UniqueName="SocialSecurityAct">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="42CFR" HeaderText="42CFR" SortExpression="42CFR"
UniqueName="42CFR">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="42USC" HeaderText="42USC" SortExpression="42USC"
UniqueName="42USC">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Description" HeaderText="Description" SortExpression="Description"
UniqueName="Description">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SuspendedProviderId" DataType="System.Int32" Visible="false"
HeaderText="SuspendedProviderId" ReadOnly="True" SortExpression="SuspendedProviderId"
UniqueName="SuspendedProviderId">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Id" DataType="System.Int32" HeaderText="Id" Visible="false"
SortExpression="Id" UniqueName="Id">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="SuspendedProviderId" DataType="System.Int32" Visible="false"
HeaderText="SuspendedProviderId" SortExpression="SuspendedProviderId" UniqueName="SuspendedProviderId">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings EditFormType="Template">
<FormTemplate>
<table id="Table2" cellspacing="2" cellpadding="1" width="100%" border="0" rules="none"
style="border-collapse: collapse; background: white;">
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>SocialSecurityAct</b>
</td>
</tr>
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>42 CFR</b>
</td>
<td>
<asp:TextBox runat="server" ID="txt42CFR" Text='<%# Bind("42CFR") %>' Enabled="false"/>
</td>
</tr>
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>42 USC</b>
</td>
<td>
<asp:TextBox runat="server" ID="txt42USC" Text='<%# Bind("42USC") %>' Enabled="false" />
</td>
</tr>
<tr class="EditFormHeader">
<td colspan="2" style="font-size: small">
<b>Description</b>
</td>
<td>
<asp:TextBox runat="server" ID="txtDescription" Text='<%# Bind("Description") %>' Enabled="false"/>
</td>
</tr>
<tr>
<td align="right" colspan="2">
<asp:ImageButton ID="btnUpdate" ImageUrl="~/Img/Update.gif" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>
</asp:ImageButton>
<asp:ImageButton ID="btnCancel" runat="server" ImageUrl="~/Img/Cancel.gif" CausesValidation="False"
CommandName="Cancel"></asp:ImageButton>
</td>
</tr>
</table>
</FormTemplate>
</EditFormSettings>
<CommandItemSettings AddNewRecordText="Add " />
</MasterTableView>
</telerik:RadGrid>
</fieldset>
<asp:SqlDataSource ID="GetProvider" runat="server"
InsertCommand="spInsert" UpdateCommand="spUpdate"
DeleteCommand="spDelete" DeleteCommandType="StoredProcedure"
InsertCommandType="StoredProcedure" UpdateCommandType="StoredProcedure"
onupdating="GetProvider_Updating"
oninserting="GetProvider_Inserting">
<SelectParameters>
<asp:QueryStringParameter Name="SuspendedProviderId" QueryStringField="SuspendedProviderId"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:QueryStringParameter Name="SuspendedProviderId" QueryStringField="SuspendedProviderId" Type="Int32" />
<asp:Parameter Name="Id" Type="Int32" DefaultValue="1" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Id" Type="Int32" DefaultValue="1" />
<asp:Parameter Name="SuspendedProviderId" Type="Int32" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="SuspendedProviderId" />
</DeleteParameters>
</asp:SqlDataSource>
During the insert it passes all the column value , but i just want to pass the insert paramenter value. That means
Just pass these values.
<InsertParameters>
<asp:QueryStringParameter Name="SuspendedProviderId" QueryStringField="SuspendedProviderId" Type="Int32" />
<asp:Parameter Name="Id" Type="Int32" DefaultValue="1" />
</InsertParameters>
Help needed ASAP
Thanks
Eva