Insert and update in Gridview

[Susi]

Hi Friends,

 We are developing a project in N tier architecture. In Presentation Layer I have written for aspx page and how to add/edit in this gridview.

<telerik:RadGrid ID="RadGridview1" runat="server" AllowPaging="false" AutoGenerateColumns="False" PageSize="10" Width="100%" Height="100%"

onpageindexchanged="RadGridview1_PageIndexChanged" >


<MasterTableView ClientDataKeyNames="ID" DataKeyNames="ID" CommandItemDisplay ="Top"  EditMode="EditForms">

 <RowIndicatorColumn Visible="true"></RowIndicatorColumn>

 <EditFormSettings EditFormType="Template">

 <FormTemplate>

 <table width="100%">

<tr>

<td>

<asp:Label ID="lbl_etHeading" runat="server" Text="Add New Component Category" ></asp:Label>

</td>

</tr>


<tr>

<td width="30%">

<asp:Label ID="radlblUserName" runat="server" Text="UserName"></asp:Label>

</td>

<td width="40%">

<telerik:RadTextBox ID="radtxtUserName" runat="server" width="250px"

Text='<%#Bind("UserName")%>' SelectionOnFocus="CaretToEnd" MaxLength="50">

</telerik:RadTextBox>

</td>

<td width="30%">

</td>

</tr>


<tr>

<td width="30%">

<asp:Label ID="radlblFirstName" runat="server" Text="FirstName" Visible="true"></asp:Label>

</td>


<td width="40%">

<telerik:RadTextBox ID="radtxtFirstName" runat="server" width="250px"

Text='<%#Bind("FirstName")%>' SelectionOnFocus="CaretToEnd" MaxLength="100" TextMode="MultiLine">

</telerik:RadTextBox>

</td>

<td width="30%"></td>

</tr>




<tr>

<td>

<asp:Button ID="Insert" runat="server" CommandName="PerformInsert" Text="Insert" />

<asp:Button ID="Update" runat="server" CommandName="Update" Text="Update" />

<asp:Button ID="Cancel" runat="server" CommandName="Cancel" Text="Cancel" />

</td>

</tr>

</table>

</FormTemplate>

</EditFormSettings>




<Columns>

<telerik:GridTemplateColumn HeaderText="#" >

<ItemTemplate>

<asp:Label ID="numberLabel" runat="server" Width="30px"></asp:Label>

</ItemTemplate>

<HeaderStyle Width="30px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="UserName" UniqueName="UserName">

<ItemTemplate>

<asp:LinkButton ID="lnkbtn_Edit" runat="server" CommandName="Edit" Text='<%#Eval("UserName") %>'></asp:LinkButton>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:gridboundcolumn HeaderText="FirstName" DataField="FirstName" UniqueName="FirstName"></telerik:gridboundcolumn>

</Columns>




<CommandItemTemplate>

<asp:LinkButton ID="lnkbtn_AddNew" runat="server" CommandName="InitInsert" Text="Add New Component Category"></asp:LinkButton>

</CommandItemTemplate>



</MasterTableView>

</telerik:RadGrid>

Any idea about in aspx.cs page that means which event or methods, i have to use.

I used RadGridview1_InsertCommand event to add/edit values but i cant pass textbox value to business entity.

 

 

Thanks in Advance..!

[Shinu]

Hello,

Check the following demo.
Grid / Form Template Edit Form

-Shinu.

[Jayesh Goyani]

Hello,

<telerik:RadGrid ID="RadGridview1" runat="server" AllowPaging="false" AutoGenerateColumns="False"
          PageSize="10" Width="100%" Height="100%"
          oninsertcommand="RadGridview1_InsertCommand"
          onneeddatasource="RadGridview1_NeedDataSource"
          onupdatecommand="RadGridview1_UpdateCommand" >
          <MasterTableView ClientDataKeyNames="ID" DataKeyNames="ID" CommandItemDisplay="Top"
              EditMode="EditForms">
              <RowIndicatorColumn Visible="true">
              </RowIndicatorColumn>
              <EditFormSettings EditFormType="Template">
                  <FormTemplate>
                      <table width="100%">
                          <tr>
                              <td>
                                  <asp:Label ID="lbl_etHeading" runat="server" Text="Add New Component Category"></asp:Label>
                              </td>
                          </tr>
                          <tr>
                              <td width="30%">
                                  <asp:Label ID="radlblUserName" runat="server" Text="UserName"></asp:Label>
                              </td>
                              <td width="40%">
                                  <telerik:RadTextBox ID="radtxtUserName" runat="server" Width="250px" Text='<%#Bind("UserName")%>'
                                      SelectionOnFocus="CaretToEnd" MaxLength="50">
                                  </telerik:RadTextBox>
                              </td>
                              <td width="30%">
                              </td>
                          </tr>
                          <tr>
                              <td width="30%">
                                  <asp:Label ID="radlblFirstName" runat="server" Text="FirstName" Visible="true"></asp:Label>
                              </td>
                              <td width="40%">
                                  <telerik:RadTextBox ID="radtxtFirstName" runat="server" Width="250px" Text='<%#Bind("FirstName")%>'
                                      SelectionOnFocus="CaretToEnd" MaxLength="100" TextMode="MultiLine">
                                  </telerik:RadTextBox>
                              </td>
                              <td width="30%">
                              </td>
                          </tr>
                          <tr>
                              <td>
                                  <asp:Button ID="Insert" runat="server" CommandName="PerformInsert" Text="Insert" />
                                  <asp:Button ID="Update" runat="server" CommandName="Update" Text="Update" />
                                  <asp:Button ID="Cancel" runat="server" CommandName="Cancel" Text="Cancel" />
                              </td>
                          </tr>
                      </table>
                  </FormTemplate>
              </EditFormSettings>
              <Columns>
                  <telerik:GridTemplateColumn HeaderText="#">
                      <ItemTemplate>
                          <asp:Label ID="numberLabel" runat="server" Width="30px"></asp:Label>
                      </ItemTemplate>
                      <HeaderStyle Width="30px" />
                  </telerik:GridTemplateColumn>
                  <telerik:GridTemplateColumn HeaderText="UserName" UniqueName="UserName">
                      <ItemTemplate>
                          <asp:LinkButton ID="lnkbtn_Edit" runat="server" CommandName="Edit" Text='<%#Eval("UserName") %>'></asp:LinkButton>
                      </ItemTemplate>
                  </telerik:GridTemplateColumn>
                  <telerik:GridBoundColumn HeaderText="FirstName" DataField="FirstName" UniqueName="FirstName">
                  </telerik:GridBoundColumn>
              </Columns>
              <CommandItemTemplate>
                  <asp:LinkButton ID="lnkbtn_AddNew" runat="server" CommandName="InitInsert" Text="Add New Component Category"></asp:LinkButton>
              </CommandItemTemplate>
          </MasterTableView>
      </telerik:RadGrid>

protected void RadGridview1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
   {
       DataTable dt = new DataTable();
       dt.Columns.Add("UserName", typeof(string));
       dt.Columns.Add("FirstName", typeof(string));
       dt.Columns.Add("ID", typeof(string));
       dt.Rows.Add("Shipper1", "Shipper11","1");
       RadGridview1.DataSource = dt;

   }
   protected void RadGridview1_InsertCommand(object sender, GridCommandEventArgs e)
   {
       GridEditableItem item = e.Item as GridEditableItem;
       RadTextBox radtxtFirstName = item.FindControl("radtxtFirstName") as RadTextBox;
       string str1 = radtxtFirstName.Text;
   }
   protected void RadGridview1_UpdateCommand(object sender, GridCommandEventArgs e)
   {
       GridEditableItem item = e.Item as GridEditableItem;
       RadTextBox radtxtFirstName = item.FindControl("radtxtFirstName") as RadTextBox;
       string str1 = radtxtFirstName.Text;
   }

Thanks,
Jayesh Goyani

[Susi]

Dear Jayesh Goyani,

yes perfect, I didn't think that way..

Thank you very much...!