I got a datagrid that supposed to edit the datagrid once the user clicks on edit button next to each record. I want this page recives the record number as passed value but i do not know how to do it .(datagridupdate?record=4)
Is there a way to pass record value to this part of code which is resposible for finding the record that we want to update ? I be happy to get some help here. thanks
Code:Sub DBEditDataGrid_Edit(Sender As Object, E As DataGridCommandEventArgs) DBEditDataGrid.EditItemIndex = E.Item.ItemIndex DataBindGrid End Sub
Code:<%@ Page Language="VB" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <script language="VB" runat="server"> Dim objConnection As SqlConnection Dim myDataReader As SqlDataReader Sub Page_Load(Sender As Object, E As EventArgs) ' Set up our connection. objConnection = New SqlConnection("Data Source=(local);" _ & "Initial Catalog=teniss2;User Id=web;Password=web;" _ & "Connect Timeout=15;Network Library=dbmssocn;") LoadDataFromDB If Not IsPostBack Then DataBindGrid End If End Sub Sub LoadDataFromDB() Dim objCommand As SqlCommand ' Create new command object passing it our SQL query ' and telling it which connection to use. objCommand = New SqlCommand("SELECT * FROM Players;", objConnection) ' Open the connection, execute the command, and close the connection. objConnection.Open() myDataReader = objCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection) End Sub Sub DataBindGrid() DBEditDataGrid.DataSource = myDataReader DBEditDataGrid.DataBind End Sub Sub DBEditDataGrid_Edit(Sender As Object, E As DataGridCommandEventArgs) DBEditDataGrid.EditItemIndex = E.Item.ItemIndex DataBindGrid End Sub ....... .......




Reply With Quote