[Solved] How to insert/update/delete programmatically

[Kem Arda]

I need to insert/update/delete records programmatically. Here is my code

ascx:

<%

@ Control Language="C#" Inherits="YourCompany.Modules.Tahakkuk.ViewTahakkuk" AutoEventWireup="true" CodeBehind="ViewTahakkuk.ascx.cs" %>

 

<%

@ Register Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"

 

 

Namespace="System.Web.UI" TagPrefix="asp" %>

 

<%

@ Register Assembly="Telerik.Web.UI, Version=2009.1.527.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4"

 

 

Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

 

 

 

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

 

 

<script type="text/javascript">

 

 

function RowDblClick(sender, eventArgs)

 

{

sender.get_masterTableView().editItem(eventArgs.get_itemIndexHierarchical());

}

 

</script>

 

 

</telerik:RadCodeBlock>

 

 

 

 

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

 

 

<AjaxSettings>

 

 

<telerik:AjaxSetting AjaxControlID="RadGrid1">

 

 

<UpdatedControls>

 

 

<telerik:AjaxUpdatedControl ControlID="RadGrid1" />

 

 

</UpdatedControls>

 

 

</telerik:AjaxSetting>

 

 

 

 

</AjaxSettings>

 

 

</telerik:RadAjaxManager>

 

 

 

 

<

telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticUpdates="true" AllowAutomaticDeletes="true"

 

AllowSorting

="True" AutoGenerateColumns="true" AllowPaging="True" GridLines="None" ShowFooter="True" AllowMultiRowSelection="True"

 

 

PageSize="7" AllowMultiRowEdit="True" AllowAutomaticInserts="True" OnItemDeleted="RadGrid1_ItemDeleted">

 

 

<PagerStyle Mode="NextPrevAndNumeric" />

 

 

<MasterTableView Width="100%" CommandItemDisplay="Top"

 

 

DataKeyNames="HizmetID">

 

 

<CommandItemTemplate>

 

 

<div style="padding: 5px 5px;">

 

Custom command item template

&nbsp;&nbsp;&nbsp;&nbsp;

 

 

<asp:LinkButton ID="btnEditSelected" runat="server" CommandName="EditSelected" Visible='<%# RadGrid1.EditIndexes.Count == 0 %>'>Edit selected</asp:LinkButton>&nbsp;&nbsp;

 

 

<asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" Visible='<%# RadGrid1.EditIndexes.Count > 0 %>'>Update</asp:LinkButton>&nbsp;&nbsp;

 

 

<asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" Visible='<%# RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted %>'>Cancel editing</asp:LinkButton>&nbsp;&nbsp;

 

 

<asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert" Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'>Add new</asp:LinkButton>&nbsp;&nbsp;

 

 

<asp:LinkButton ID="LinkButton3" runat="server" CommandName="PerformInsert" Visible='<%# RadGrid1.MasterTableView.IsItemInserted %>'> Add this Customer</asp:LinkButton>&nbsp;&nbsp;

 

 

<asp:LinkButton ID="LinkButton1" OnClientClick="javascript:return confirm('Delete all selected customers?')"

 

 

runat="server" CommandName="DeleteSelected">Delete selected customers</asp:LinkButton>&nbsp;&nbsp;

 

 

<asp:LinkButton ID="LinkButton4" runat="server" CommandName="RebindGrid">Refresh customer list</asp:LinkButton>

 

 

 

</div>

 

 

</CommandItemTemplate>

 

 

</MasterTableView>

 

 

<ClientSettings>

 

 

<Selecting AllowRowSelect="True" EnableDragToSelectRows="True" />

 

 

</ClientSettings>

 

</

telerik:RadGrid>

 

And all i have in ascx.cs is as follows:

protected void RadGrid1_ItemDeleted(object source, GridDeletedEventArgs e)
        {
            e.ExceptionHandled = true;
        }

 

protected void Page_Load(object sender, System.EventArgs e)

 

{

EntityCollection

<HizmetEntity> hizmet = new EntityCollection<HizmetEntity>();  // Here is how i get an     collection     to     use     as     a source for my RadGrid

 

DBAdapter.FetchEntityCollection(hizmet,

null);

 

 

 

RadGrid1.DataSource = hizmet;

RadGrid1.MasterTableView.DataSource = hizmet;

RadGrid1.DataBind();

}

private

DataAccessAdapter _dbAdapter;

 

 

private DataAccessAdapter DBAdapter

 

{

 

get

 

{

 

if (_dbAdapter == null)

 

{

_dbAdapter =

new DataAccessAdapter();

 

_dbAdapter.ConnectionString =

"";

 

}

 

return _dbAdapter;

 

}

}

What should i do to handle insert/delete/update?  Where and how should i relate RadGrid to my programmatically created DataSource and its insert/update/delete query?

Thanks in advance...

[Tsvetoslav]

Hello Kem Arda,

For insert/update/delete operations you should be using Advanced Databinding as opposed to SimpleDataBinding.

As for implementing programmatically the insert/update/delete operations, you will find helpful the following documentation articles: Insert/Update/Delete at database level; Inserting values in place and with edit forms;

I hope this information helps.

Sincerely yours,
Tsvetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Kem Arda]

Thanks a lot...