.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Inserting new row in GridView in ASP.NET 2.0

Posted By: Rahul     Posted Date: November 13, 2009    Points: 2   Category :ASP.Net
 
The GridView was not designed to insert new rows, but there is a way to accomplish this with very little code. This article shows how to do that. The GridView was not designed to insert new rows, but there is a way to accomplish this with very little code.


View Complete Post


More Related Resource Links

inserting from gridview footer

  

I have been following the tutorials from Scott Mitchell on this site.  I am trying to insert a new record from the gridview footer.  I have my BLL set up as a .cs class in the App Code folder.  When I fill in the fields and click add, nothing happens.  The page refreshes and the text boxes empty, but nothing is added to the database.  The edit and delete functions work fine.  Have I put something in the wrong spot?

 

I have the rowcommand and the datasource_inserting on the code page as below.

protected void Oems_RowCommand(object sender, GridViewCommandEventArgs e)
{
    // Insert data if the CommandName == "Insert" 
    // and the validation controls indicate valid data...
    if (e.CommandName == "Insert" && Page.IsValid)
    {
        // TODO: Insert new record...
        OemsDataSource1.Insert();
    }
}


protected void OemsDataSource1_Inserting
(object sender, ObjectDataSourceMethodEventArgs e)
{
    // Programmatically reference Web controls in the inserting interface...
    TextBox txtOem = (TextBox)GridView1.FooterRow.FindControl("txtOem");
    TextBox txtOemStreet = (TextBox)GridView1.FooterRow.FindControl("txtOemStreet");
    TextBox txtOemCity = (TextBox)GridView1.FooterRow.FindControl("txtOemCity");
    DropDownList

Inserting Records Based on Checkbox Selection in a Gridview

  
Using checkboxes, can the row of record(s) be inserted into a database? I am populating a Gridview. Done. A checkbox field has been added, when the user selects one or more rows, a submit button (which is not working) needs to inserting those records into a table. The insert statment will work outside of the page but is not working using the scenario I jut described. Is this task as I have outlined doable? txs Ayomide

Inserting Selected Row onto SQL Server Database from GridView

  




protected void Authorise(object sender, EventArgs e)
        {
            CheckBox chk;

            foreach (GridViewRow rowItem in GridView1.Rows)
            {
               // gets the Debit Reference number for each row checked
                string type = GridView1.DataKeys[rowItem.RowIndex].Values[0].ToString();
				// gets the Debit Error Type Number number for each row checked
                string DDIREF = GridView1.DataKeys[rowItem.RowIndex].Values[1].ToString();
 
                chk = (CheckBox)(rowItem.Cells[0].FindControl("RowChecker"));
   
                // chk.checked will access the checkbox state on button click event
                if (chk.Checked)
                {
                  
					 if (type == "1")
					 {
						// Message_ltr.Text = type + DDIREF;
						 string[] posList;
						 //   string a = "false";
						 DataTable dt = this.ExcelToDatatable_dt;

						 posList = positionList;
						 foreach (DataRow row in dt.Rows)
						 {
								 string error = "No Error Message";
								 fn.InsertNewDDIsTemporary_Proc(
										  row["DDIREF"].ToString()                    //  String DDIREF_P
										, row["Sortcode"].ToString()                  //  String Sortcode_P
										, row["AccountNo"].ToString(

Inserting Selected Row onto SQL Server Database from GridView

  



protected void Authorise(object sender, EventArgs e)
        {
            CheckBox chk;

            foreach (GridViewRow rowItem in GridView1.Rows)
            {
               // gets the Debit Reference number for each row checked
                string type = GridView1.DataKeys[rowItem.RowIndex].Values[0].ToString();
				// gets the Debit Error Type Number number for each row checked
                string DDIREF = GridView1.DataKeys[rowItem.RowIndex].Values[1].ToString();
 
                chk = (CheckBox)(rowItem.Cells[0].FindControl("RowChecker"));
   
                // chk.checked will access the checkbox state on button click event
                if (chk.Checked)
                {
                  
					 if (type == "1")
					 {
						// Message_ltr.Text = type + DDIREF;
						 string[] posList;
						 //   string a = "false";
						 DataTable dt = this.ExcelToDatatable_dt;

						 posList = positionList;
						 foreach (DataRow row in dt.Rows)
						 {
								 string error = "No Error Message";
								 fn.InsertNewDDIsTemporary_Proc(
										  row["DDIREF"].ToString()                    //  String DDIREF_P
										, row["Sortcode"].ToString()                  //  String Sortcode_P
										, row["AccountNo"].ToString()     

Inserting login name using @UserName Values to gridview

  

Dears

Can somebody tell me why if I write the following SQL SELECET  under gridview or details view I  statement get all the data under the login name :

SELECT * FROM CustOrder WHERE (CustomerName = @UserName)

 

 

While if I write the following INSERT statement it save all data but it does not save the login name to database:

 

INSERT INTO CustOrder

                         (ItemName, ItemPrice, Quantity, CustomerName, Status)

VALUES        (@Username,@ItemPrice,@Quantity,@Username, 'New Order')

 

Regards


Inplace Edit in GridView

  
In this article I am presenting a different way to look at EditItemTemplate, using which user navigation for editing is reduced and . it looks very different (see screeen shots) then regular implementation of GridView.

GridView Confirmation Box Using JQuery BlockUI in asp.net

  
JQuery is the most popular JavaScript library. One of the main reasons for its fame is the plugin architecture. Anyone can create a separate library that leverage the JQuery library. In this article we are going to look at the BlockUI library which is used to block the user screen while performing a task.

Textbox Editable GridView in ASP.NET

  
This article describes how I made a fully editable gridview in C# using ASP.NET 2. The idea is that the GridView looks and works like an Excel spreadsheet. You see all the cells in the table, and you can edit any of the cells you like, and they are automatically updated (i.e. saved to the database). This is very often how people expect data tables to work in web pages, and I've often seen people clicking in vain on un-editable gridview cells, somehow expecting to edit them, and not understanding that they need to click an Edit button at the end of the row.

Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

  
In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

AJAX GridView Checkbox Select All in ASP.Net

  
In the previous article GridView Select Multiple Rows you learnt the multiple row selection in GridView control. Here you will get the C# code sample to select all the gridview rows using single checkbox server control. You can highlight the selected rows with different color and Font state Bold. If you want to use the selection values on different ASP.Net

AJAX GridView Paging and Sorting using C# in ASP.Net

  
To enable the GridView Paging and Sorting to update the GridView Data without refreshing the ASP.Net web page AJAX Extension controls are used. UpdatePanel is used to hold the GridView control that triggers the events for the controls placed inside it. By Default UpdatePanel triggers the asynchronous postbacks for its child controls.

GridView Paging Using Ajax in ASP.Net

  
To enable the GridView Paging and Sorting to update the GridView Data without refreshing the ASP.Net web page AJAX Extension controls are used. UpdatePanel is used to hold the GridView control that triggers the events for the controls placed inside it. By Default UpdatePanel triggers the asynchronous postbacks for its child controls.

Displaying Row Details Tooltip on GridView using JQuery

  
Continuing exploring JQuery! I decided to implement a feature to display some kind of details related to a row displayed on GridView. For example when displaying employees details on GridView some information might not fit in the GridView because it will make it huge and wide. These infomration can be diplayed as Tooltip. Or when you want to display a picture and some kind of formated text to be diplayed as tooltip when mouse hover on the image.

jQuery: Highlight Gridview Rows with Checkbox

  
Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

Gridview setup:

Sortable GridView using jQuery's TableSorter

  
This article explains how to use jQuery's plug-in Tablesorter to implement client-side sorting in an ASP.NET GridView. This comes in handy especially when an ObjectDataSource is used with a GridView as GridView does not provide sorting out of the box.

Sorting Gridview using Jquery with ASP.NET

  
I want to show how to sorting a gridview using a Jquery in ASP.NET, it is a flexible client-side table sorting. We have known that Jquery is a new kind of Javascript Library. You can find detail of Jquery in this site http://jquery.com/ there are lot of example with documentation and also allow free download a latest version.

GridView Parent Child View with JQuery Effects

  
I was just checked how to add some more cool effects to the GridView control using JQuery. In this post I will display parent-child data in the GridView control with some help of the wonderful JQuery library.

Let's first populate the GridView control.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend