or
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { SqlDataAdapter da = new SqlDataAdapter("select c.City, s.State from MST_State as s inner join MST_City as c on c.StateID = s.ID ", con); DataTable mydatatable = new DataTable(); da.Fill(mydatatable); RadGrid1.DataSource = mydatatable.DefaultView; } //protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e) //{ // //} protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e) { //GridEditableItem editedItem = e.Item as GridEditableItem; //UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); GridEditFormInsertItem inserteditem = (GridEditFormInsertItem)e.Item; //Create new row in the DataSource //Insert new values string City = (inserteditem["City"].Controls[0] as TextBox).Text; DropDownList list = (inserteditem.FindControl("State") as DropDownList); string State = list.SelectedValue; con.Open(); string insertquery = String.Format("insert into MST_City values('{0}', '{1}')", City, State); SqlCommand sql = new SqlCommand(); sql.CommandText = insertquery; sql.Connection = con; sql.ExecuteNonQuery(); con.Close(); }
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="MediaList.ascx.cs" Inherits="PledgeWeb.MediaLibrary.Controls.MediaList" %><telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> var mediaList = {}; mediaList.get_AddDocumentModalUrl = function mediaList_getAddDocumentModalUrl() { return '<%= Page.ResolveClientUrl("~/MediaLibrary/Modals/AddDocument.aspx") %>'; } mediaList.get_ViewDocumentModalUrl = function mediaList_getViewDocumentModalUrl(docId) { var url = '<%= Page.ResolveClientUrl("~/MediaLibrary/Modals/ViewDocument.aspx") %>' + '?id=' + docId; return url; } //On insert and update buttons click temporarily disables ajax to perform upload actions //for a more detailed description of why we need this. function conditionalPostback(sender, eventArgs) { var theRegexp = new RegExp("\.UpdateButton$|\.PerformInsertButton$", "ig"); if (eventArgs.get_eventTarget().match(theRegexp)) { var upload = $find(window['UploadId']); //AJAX is disabled only if file is selected for upload (i.e., new documents) if (upload != null && upload.getFileInputs()[0].value != "") { eventArgs.set_enableAjax(false); } } } function validateRadUpload(source, e) { e.IsValid = false; var upload = $find(source.parentNode.getElementsByTagName('div')[0].id); var inputs = upload.getFileInputs(); for (var i = 0; i < inputs.length; i++) { //check for empty string or invalid extension if (inputs[i].value != "" && upload.isExtensionValid(inputs[i].value)) { e.IsValid = true; break; } } } </script></telerik:RadCodeBlock><telerik:RadScriptBlock ID="RadScriptBlock1" runat="server"> <script type="text/javascript"> mediaList.onAddDocumentWindowClosed = function mediaList.onAddDocumentWindowClosed(sender, eventArgs) { var returnValue = eventArgs.get_argument(); if (!Utils.WasRadWindowCancelled(returnValue, true)) { __doPostBack('', ''); } } mediaList.openAddDocumentWindow = function mediaList_openAddDocumentWindow() { Utils.OpenRadWindow ( mediaList.get_AddDocumentModalUrl(), 600, 400, mediaList.onAddDocumentWindowClosed ); } mediaList.openViewWindow = function mediaList_openViewWindow(docId) { Utils.OpenRadWindow ( mediaList.get_ViewDocumentModalUrl(docId), 600, 400 ); } </script></telerik:RadScriptBlock><telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" ClientEvents-OnRequestStart="conditionalPostback"> <asp:Panel ID="pnlMsg" runat="server"> <asp:Label ID="lblMsg" runat="server" Style="color: Red; font-weight: bold;" /> </asp:Panel> <telerik:RadGrid ID="grdMediaLibrary" runat="server" Skin="Default" AutoGenerateColumns="false" Width="100%" AllowPaging="true" PageSize="10" OnItemDataBound="grdMediaLibrary_ItemDataBound" AllowAutomaticInserts="false" AllowAutomaticUpdates="false" OnEditCommand="grdMediaLibrary_Edit" OnUpdateCommand="grdMediaLibrary_Update" OnInsertCommand="grdMediaLibrary_Insert" OnItemCommand="grdMediaLibrary_ItemCommand" OnItemCreated="grdMediaLibrary_ItemCreated" ShowStatusBar="true"> <PagerStyle Mode="NumericPages" AlwaysVisible="false" Position="Bottom" CssClass="Pager" /> <MasterTableView CommandItemDisplay="Top" ClientDataKeyNames="ID" DataKeyNames="ID"> <NoRecordsTemplate> <asp:Label Text="No documents to display" runat="server" /></NoRecordsTemplate> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton"> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn UniqueName="MenuColumn"> <ItemTemplate> <telerik:RadMenu ID="itemMenu" runat="server" CausesValidation="false"> <Items> <telerik:RadMenuItem Value="topMenuItem" ImageUrl="~/Images/collapsed_toggleExpandHover.gif" HoveredImageUrl="~/Images/collapsed_toggleExpandActive.gif" CssClass="SM_imageButton"> <Items> <telerik:RadMenuItem Text="Archive" ImageUrl="~/Images/archive.jpg" /> <telerik:RadMenuItem Text="Recover From Archive" ImageUrl="~/Images/undo.png" /> </Items> </telerik:RadMenuItem> </Items> </telerik:RadMenu> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="ID" Visible="false" ReadOnly="true" UniqueName="DocID" /> <telerik:GridTemplateColumn HeaderText="Document Name" UniqueName="DocName" ReadOnly="false"> <ItemTemplate> <asp:Label ID="lblDocName" runat="server" Text='<%#Eval("Name") %>' /> </ItemTemplate> <EditItemTemplate> <telerik:RadUpload ID="ruDocument" runat="server" MaxFileInputsCount="1" /> <asp:CustomValidator ID="cvDocument" runat="server" ClientValidationFunction="validateRadUpload" ErrorMessage="Please select a file" Display="Dynamic" /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Description" UniqueName="Description"> <ItemTemplate> <asp:Label ID="lblDescription" runat="server" Text='<%# Eval("Description") %>' /> </ItemTemplate> <EditItemTemplate> <telerik:RadTextBox ID="txtDescription" runat="server" Text='<%# Bind("Description") %>' Columns="50" Rows="5" TextMode="MultiLine" /> <des:RequiredTextValidator ID="rtvDescription" runat="server" ControlIDToEvaluate="txtDescription" ErrorMessage="* Required" /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn HeaderText="Date Created" DataField="CreatedDate" ReadOnly="true" DataFormatString="{0:d}" /> <telerik:GridBoundColumn HeaderText="Operator" DataField="CreatedBy" ReadOnly="true" /> <telerik:GridImageColumn ImageUrl="~/Images/Tick.gif" HeaderText="Archived?" UniqueName="ArchivedColumn" /> <telerik:GridTemplateColumn ReadOnly="true" UniqueName="ViewColumn"> <ItemTemplate> <asp:HyperLink ID="hypView" runat="server" Text="View" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <EditFormSettings> <EditColumn ButtonType="PushButton" /> </EditFormSettings> </MasterTableView> </telerik:RadGrid></telerik:RadAjaxPanel><telerik:RadAjaxLoadingPanel ID="loadingPanel" runat="server" Skin="Default" /><telerik:RadAjaxManagerProxy ID="ajaxProxy" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadAjaxPanel1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grdMediaLibrary" LoadingPanelID="loadingPanel" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings></telerik:RadAjaxManagerProxy>FocusedStyle-BackColor not set <telerik:RadNumericTextBox ID="Amount" runat="server" Width="85px" ReadOnly="true"FocusedStyle-BackColor="Lavender" MaxLength="8"></telerik:RadNumericTextBox> <telerik:RadGrid ID="RG1" runat="server" AutoGenerateColumns="False" CellSpacing="0" Width="540px"> <ClientSettings EnablePostBackOnRowClick="true"> <Selecting AllowRowSelect="True" /> <Scrolling AllowScroll="True" UseStaticHeaders="True" /> </ClientSettings> <MasterTableView GridLines="Both" Width="530" DataKeyNames="LCT_Code"><CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings><RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"><HeaderStyle Width="20px"></HeaderStyle></RowIndicatorColumn><ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"><HeaderStyle Width="20px"></HeaderStyle></ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="LCT_Code" FilterControlAltText="Filter column column" HeaderText="Code" UniqueName="LCT_Code"> <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="80px" /> <ItemStyle Font-Bold="True" HorizontalAlign="Center" Width="80px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LCT_Desc" FilterControlAltText="Filter column1 column" HeaderText="Description" UniqueName="LCT_Desc"> <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="200px" /> <ItemStyle Font-Bold="True" HorizontalAlign="Left" Width="200px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LCT_WMLC" FilterControlAltText="Filter column2 column" HeaderText="WMLC" UniqueName="LCT_WMLC"> <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="80px" /> <ItemStyle Font-Bold="True" HorizontalAlign="Left" Width="80px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LCT_WLCM" FilterControlAltText="Filter column3 column" HeaderText="WLCM" UniqueName="LCT_WLCM"> <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Width="150px" /> <ItemStyle Font-Bold="True" HorizontalAlign="Left" Width="150px" /> </telerik:GridBoundColumn> </Columns><EditFormSettings><EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn></EditFormSettings></MasterTableView><FilterMenu EnableImageSprites="False"></FilterMenu><HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> </telerik:RadGrid>I have a grid with only one row currently. As you can see in the attached image the height of the grid is far greater than the one row. How do I get the grid to only take up the needed space yet expand as required for new rows. I have no height field in the definition. Below is the grid definition.
Thanks,