Edit, Delete, Update and Insert operations in a DataGrid: Part II

Sign in to leave a comment.

• VR

  vasantha r16y agoPosted Jun 2, 2010, 5:43 AM

  i want new row using gridview only..not in textbox
• AR

  ashvin ravi16y agoPosted May 13, 2010, 2:21 AM

  suppose i will update the fields based on the datatype nvarchar. how wil i modify the below code int U_ID = (int)gridedit.DataKeys[(int)e.Item.ItemIndex];
• S

  ss16y agoPosted Mar 14, 2010, 3:31 AM

  hi how in insert you get id is it auto increment? you dont get it this code have error
• RM

  raj mohan17y agoPosted Jun 25, 2009, 7:17 AM

  Good explanation .Thank you www.rajmohan.co.nr
• VK

  vinay kumar18y agoPosted Mar 14, 2008, 6:48 AM

  hello sir, I vinaykumar visited ur site it is just fantastic i jst got lots of information i am very thankful to you . please can u help me. I need a run time project should be used ASp.net ,ado.net and some understandable c# because i am new to c#. onemore time thank u very much Thankyou with regards vinay email:[email protected]
  • 

    Rahul Kumar Saxena18y agoPosted Mar 19, 2008, 8:26 AM

    Hi Vinay Thanx Dear, Well u told me thta u r new to.NET n u need small Project so Enjoy this small Project http://www.dotnetheaven.com/UploadFile/rahul4_saxena/OnLineAddressBook05212007064752AM/OnLineAddressBook.aspx
  • 

    Rahul Kumar Saxena18y agoPosted Mar 19, 2008, 8:29 AM

    Enjoy One more small Project http://www.dotnetheaven.com/UploadFile/rahul4_saxena/friendnetworksite05312007042414AM/friendnetworksite.aspx
  • 

    Rahul Kumar Saxena17y agoPosted Feb 23, 2009, 6:12 AM

    Hi VINAY One more small project for u http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/MyCollegeMyFriend12222008111537AM/MyCollegeMyFriend.aspx?ArticleID=dc412f94-5a58-4b25-8473-0238562ea290
• LR

  laxman reddy19y agoPosted Sep 28, 2007, 10:48 PM

  hai raahul nice rticle i have the like requirement here i am explainging i have to show an update button in each row of the datagrid and when ever use click the update button user can able to update the row here i know how to add update button in the data grid but idont know how to write code to function the update button please help me it is little bit urgent and i am a new comer thank u in advance
• CG

  Chris Gann19y agoPosted Sep 2, 2007, 1:50 PM

  I get these errors when trying to edit or delete: Edit (after clicking 'Update') "Failed to convert parameter value from a Guid to a Int32. " Del (after clicking) "Specified cast is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. " Exception Details: System.InvalidCastException: Specified cast is not valid. Source Error: Line 88: { Line 89: con = new SqlConnection(ConfigurationSettings.AppSettings["connect"]); Line 90: int U_ID = (int)gridedit.DataKeys[(int)e.Item.ItemIndex]; Line 91: cmd.CommandText = " Delete from record where id=" + U_ID; Line 92: cmd.Connection = con;
  • CG

    Chris Gann19y agoPosted Sep 3, 2007, 12:56 PM

    I found the answer, In the updategrid_UpdateCommand class, the id SqlDbType in my DB is a UniqueIdentifier and yours is an Integer. I just changed the type and it worked great! cmd.Parameters.Add("@id", SqlDbType.Int).Value = gridedit.DataKeys[e.Item.ItemIndex]; cmd.Parameters.Add("@id", SqlDbType.UniqueIdentifier).Value = gridedit.DataKeys[e.Item.ItemIndex]; Thanks again for a very helpful article. CG
• SG

  sonia gupta19y agoPosted May 10, 2007, 1:18 AM

  Hi , I m working on PDA aplication ,this is very new to me ,so if anyone knows about "How to add button and textbox in datagrid coloumn in .net compact framework" plz maiolas soon as possible
• SG

  sonia gupta19y agoPosted May 10, 2007, 1:17 AM

  pls u hv a solution then sen dme soon
  • 

    Rahul Kumar Saxena19y agoPosted May 14, 2007, 2:52 AM

    Hi sonia, Thanx to visit my article. I will send u ur solution as soon ass possible. ok
• NG

  NagarjunaReddy Gandra19y agoPosted Apr 27, 2007, 7:04 AM

  How to put dropdown list in data grid control in design mode
  • 

    Rahul Kumar Saxena19y agoPosted May 14, 2007, 2:04 AM

    To Put DropDown List in DataGrid You have to use <asp:template column> Inside this you will find <Item template>. Inside this you will find <asp: DropDown List> . Ok dear by doing this you can use DropDpwn list.
  • 

    Rahul Kumar Saxena19y agoPosted Apr 27, 2007, 7:43 AM

    Hi nagarjuna, Thanx to visit my article , I will post an article with your need soon.
  • SB

    satish babu19y agoPosted Jul 4, 2007, 5:50 AM

    <asp:DataGrid id=DataGrid1 style="Z-INDEX: 103; LEFT: 344px; POSITION: absolute; TOP: 88px" Width="384px" runat="server"> <COLUMNS> <asp:TemplateColumn> <ITEMTEMPLATE> <asp:DropDownList id=drp Runat="server"></asp:DropDownList> </ITEMTEMPLATE> </asp:TemplateColumn> </COLUMNS> </asp:DataGrid>