Insert Items to radgrid with external textbox and button click

[ALEX]

Hi ,
 I need to perform radgrid insert operation with external textbox and button.I have one rad grid with data from sql server.I Placed textbox and button completely not related with radgrid.I need to insert values from external textbox to radgrid with external button click.

Can anyone pls help me on this

[Shinu]

Hi,

Please take a look into the following code snippet I tried to insert new item in the RadGrid on an external button click without opening the insert form of RadGrid.

C#:

protected void Button1_Click(object sender, EventArgs e)
{
    string OrderValue = TextBox1.Text;
    SqlConnection.Open();
    string insertQuery = "insert into Orders (OrderID) values ('" + OrderValue + "')"; //query to insert TextBox text in Database
    SqlCommand.CommandText = insertQuery;
    SqlCommand.Connection = SqlConnection;
    SqlCommand.ExecuteNonQuery();
    SqlConnection.Close();
    RadGrid1.Rebind();
}

Thanks,
Shinu.

[ALEX]

I tried this ,only textbox values inserted in sql db ,the values not binded and shown in radgrid.

[Shinu]

Hi Vignesh,

Please make sure that you are Rebinding the RadGrid in the Button Click event and the inserted DataField is  present in the RadGrid. After rebind, the newly inserted data also will be added in the RadGrid from the database. Check the entire code snippet I tried.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1">
    <MasterTableView>
        <Columns>
            <telerik:GridBoundColumn DataField="OrderID" HeaderText="OrderID" SortExpression="OrderID"></telerik:GridBoundColumn>
        </columns>
    <MasterTableView>
</telerik:RadGrid>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="button1_Click" />

C#:

protected void Button1_Click(object sender, EventArgs e)
{
    string OrderValue = TextBox1.Text;
    SqlConnection.Open();
    string insertQuery = "insert into Orders (OrderID) values ('" + OrderValue + "')"; //query to insert TextBox text in Database
    SqlCommand.CommandText = insertQuery;
    SqlCommand.Connection = SqlConnection;
    SqlCommand.ExecuteNonQuery();
    SqlConnection.Close();
    RadGrid1.Rebind();// Rebind the RadGrid
}

Thanks,
Shinu.

[ALEX]

how for update and delete and also radgrid load data in pageload

[Kostadin]

Hello Peter,

You could use the same approach as the one suggested by Shinu, just need to pass a different query string. For example if you would like to delete an item you have to pass the following query string:

string deleteQuery = "DELETE FROM [Products] WHERE [ProductID] = ('" + ProductID+ "')"; //query to item from Database
    SqlCommand.CommandText = deleteQuery ;

Greetings,
Kostadin
the Telerik team