All: 

I am trying to update a certain row on my Gridview.  I see that there is an AutogenerateUpdate in the properties but when i do this it is asking for an update command that is not provided.  I went into my SQLDataSource and tried to configure the update command but was unclear on how to do this.  This is what I want it to do... 

To start off i have one main table and inside the table lets say I have 3 fast food services.  The services consist of McDonalds, Burger King, and Wendy's.   The user has a drop down menu and in the collection of the DDL is the fast food services.  When the user selects, lets say McDonalds, it shows all the food items offered and their prices.  With inflation and gas prices sky rocketing, lets say McDonald's changes their price of the Big Mac to $6.  The user would then go into the update information page of the wepsite and select McDonald's in the DDL and then click the edit button on the GridView.  Once they click that they are allowed to edit any information in that specific row of the GridView. This is were my problem occurs.  It is asking for an update command. 

 I would like to try and go through just the selected row and update the single column that way but I think this might be better. 

My question is this,  How do I allow the user to Update a specific row in the GridView?

any Suggestions?

- NUStudent -
 

If u have 3 field inthe database and suppose u want to update a particular field u can use the below coding

com=new sqlcommand("select name=@name where id=@id",con);

com.parameters.add("@name",sqldbtype.varchar).values=((textbox)gridview1.Rows[e.RowIndex].cells[0].Controls[0].text;

com.parameters.add("@id",sqldbtype.int).values=((textbox)gridview1.Rows[e.RowIndex].cells[1].Controls[0].text;

con.Open();

com.ExecuteNonQuery();

con.Close();