Wednesday, June 6, 2012

How to get ASP.NET Gridview selected row value

Gridview binding is one of the important to get selected row value from a Grid view. consider the following ASP.NET form i want to insert data that will save in SQL database and the Gridview will be load. Now i want when i will click on Select in Gridview button , selected row value will be load on Text field for update.

  Class File:

 public class Wing  
     public int WingId { get; set; }  
     public string WingName { get; set; }  
     public string WingCode { get; set; }  

Datagrid binding in aspx

 <asp:GridView ID="wingsGridView" runat="server" Width="500px" AutoGenerateColumns="False"  
             <asp:BoundField DataField="WingId" HeaderText="Id" />  
             <asp:BoundField DataField="WingCode" HeaderText="Code" />  
             <asp:BoundField DataField="WingName" HeaderText="Name" />  
             <asp:CommandField ShowSelectButton="True" />  

code behind code :

 protected void Page_Load(object sender, EventArgs e)  
       if (!IsPostBack)  
         wingIdLabel.Visible = false;  
     private void LoadWingDataGrid()  
       wings = new List<Wing>();  
       wings = wingManagerObj.GetAllWingsName();  
       if (wings.Count > 0)  
         wingsGridView.DataSource = wings;  
         wingsGridView.Visible = true;  
  protected void wingsGridView_SelectedIndexChanged(object sender, EventArgs e)  
        Wing  _wingObj = new Wing();  
         _wingObj.WingId = Convert.ToInt32(wingsGridView.SelectedRow.Cells[0].Text);  
         _wingObj.WingCode = wingsGridView.SelectedRow.Cells[1].Text;  
         _wingObj.WingName = wingsGridView.SelectedRow.Cells[2].Text;  
         wingCodeTextBox.Text = _wingObj.WingCode;  
         wingNameTextBox.Text = _wingObj.WingName;  
         wingIdLabel.Text = _wingObj.WingId.ToString();  
         wingInSaveButton.Text = "Update";  
       catch (Exception exception)  
         messageLabel.Text = exception.Message;  

If you have any query please replay.

vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link.