Select, Add, Update, and Delete Data in a ASP.NET GridView Control

Hi Raj..I was looking at this article and I want to know how to show multiple SQL table in gridview using templatefield. I have two tables fed in dropdown list .I want to display the table selected in ddl. I have edit, delete and select button just like this example. Can you please let me know how do i accommodate columns of different SQL tables?

Good Article. Thanks . Das na Das . . .

Me podrias explicar de donde sacas el addnew para ingresar un dato

how to edit update delete data in gridviewis the main part of ado.net. i want to try explain in details easily. http://www.solvingera.com/example/gridview-example-with-insert-update-edit-delete-command.aspx

very good article

Could help try to save a new user I get the message Can not insert the value NULL into 'VendorID' column, table 'prueba.dbo.Vendor' occurs. The column does not allow NULL values. INSERT error. Instruction was completed.

(TextBox)gvusers.FooterRow.FindControl Cannot convert method group 'FindControl' to non-delegate type 'System.Web.UI.WebControls.TextBox'. Did you intend to invoke the method?

this is the error can u rectify

right click on app data folder and click add new item and find .mdf file location and click add.

how attach database in application in aap folder plz help

really good thanks

really good thanks

This is very nice article and useful. Particulary article is very simple and understandable.

raj needed sme help how can we Select, Add, Update, and Delete Data in a ASP.NET GridView in a gridview Control

raj needed sme help how can we Select, Add, Update, and Delete Data in a ASP.NET GridView in a gridview Control

Hi, suggestion for 2 of my questions 1) the grid does not appear if there is no data 2) it would be nice if the new record to enter appears at the top

can u please post the ajax for use of gridview

Hi sir, can you help to provide me a pure c# windows app code about a datagrid view that edit and delete a row to ms sql?? my email i [email protected] Please help me cause i am new to C# and i am still a student........ Thanks in advance

Raj, would also like to use an xml file instead of a sql database but with the same functionality. please help Marai

Hi Raj, I read your article, and would love to have the same code but adding, editing, updating and deleting to an xml file instead of a sql database. Your help will be highly appreciated Regards Sindi

how to control textbox width during editing and updating its increasing ridiculously making mess

When i enter the details and click Add new i get the error as Object reference not set to an instance of an object. Use New keyword to create the object instance When i hard code the values get inserted. Plz help me out? Thanks Diana

it show an error while updating that index out of range. plz help

Dear Rajkumar Can we use your tool in other format, we are intersted to edit entire colums one time ! all the cells with the column should be editable and one button is to save (update) the column. Can you help ?

this aritle is excellent. i learn lot things from this article

Hi Raj, This is very nice article and useful. Particulary article is very simple and understandable. Can u post or send me the simple article about AJAX. To [email protected] Thanks in advance, Sridhar.

good post ! In gridview is there any difference in itemtemplate and bound field?

hi.. this is chandu. i am doing M.C.A . i am doing project on asp.net. i have a problem in accessing the data in grid view control. i am customize the grid view control. my requirement is as follows. Employee number is retrieve from data base and i can provide the salary, da, hra using the text fields of the grid view. when i am pressing the save button the data will be store in data base. please send me the code for it. waiting for your response.

Hi, i have followed ur code. But in a 3Tier scenario I am using a an objectdatasource control along with gridview and a business logic layer. The functionality for Update and delete is perfectly working. But I need to add a new row into the gridview when i click the button and then somehow use the objectdatasource control to perform the insert routine. I am unable to do this.. Can u let me know at ur earliest..?If necessary I will send u the code..

hai i`m new to asp. i run the above code(ie , ur example ) but i didn`t get the result properly in updation and insert. so please solve this

WHY YOU ARE NOT INSERTING VENDORID?? IF I M TAKING IT AS PRIMARY KEY THEN HOW IT COULD BE NULL?

sir,is it possible for u to look at my project if i send it to u?

itz giving error in my project

Respected sir , plese help me i try to update tamplet field in GridViewcontrol in asp.net, i doing same think that above specify u , But my problemis when click on update button that show old value of follwing code , TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl("txtQuantity1"); please help me i very confusing ...i wait u r replay.