We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Add new row in grid with SQLDatasource

Thread ID:





127389 Nov 11,2016 03:11 PM UTC Nov 15,2016 05:33 AM UTC ASP.NET Web Forms 3
Tags: Grid
Asked On November 11, 2016 03:11 PM UTC


how can i add a new row directly from my grid :

Here is my code (very simple)

<ej:Grid ID="Grid1" runat="server" CssClass="" DataSourceCachingMode="None" DataSourceID="SqlDataSource1" EnableLoadOnDemand="False" MinWidth="0">
            <ej:Column DataType="number" Field="id" IsPrimaryKey="True">
            <ej:Column DataType="string" Field="Client">
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>" DeleteCommand="DELETE FROM [TaClients] WHERE [id] = @original_id AND [Client] = @original_Client" InsertCommand="INSERT INTO [TaClients] ([id], [Client]) VALUES (@id, @Client)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [TaClients]" UpdateCommand="UPDATE [TaClients] SET [Client] = @Client WHERE [id] = @original_id AND [Client] = @original_Client">
            <asp:Parameter Name="original_id" Type="Int32" />
            <asp:Parameter Name="original_Client" Type="String" />
            <asp:Parameter Name="id" Type="Int32" />
            <asp:Parameter Name="Client" Type="String" />
            <asp:Parameter Name="Client" Type="String" />
            <asp:Parameter Name="original_id" Type="Int32" />
            <asp:Parameter Name="original_Client" Type="String" />

Thank you

Ragavee U S [Syncfusion]
Replied On November 14, 2016 12:15 PM UTC

Hi Guyot, 

We have created a sample to insert a record to database from grid using the SqlDataSource InsertCommand property, which can be downloaded from the below location. 

In the above sample, since the IsIdentity property for the primaryKey column is set, it is not necessary to define the column within the InsertCommand property as the column value will be automatically generated and thus will conflict with the value we pass. 

So please ensure in your sample project also, if the IsIdentity property is set for the column in the database table and accordingly pass the values in the InsertCommand property. 

Ragavee U S. 

Replied On November 14, 2016 03:16 PM UTC

Thank you :)

Ragavee U S [Syncfusion]
Replied On November 15, 2016 05:33 AM UTC

Hi Guyot, 
Thanks for your update. 
Please let us know if you need any further assistance on this. 
Ragavee U S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon