Mega Code Archive

 
Categories / ASP.Net / ADO Database
 

Button Column in a asp

<%@ Page Language=VB Debug=true %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OLEDB" %> <script runat=server> Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)     If Not IsPostBack Then         Dim DBConn as OleDbConnection         Dim DBCommand As OleDbDataAdapter         Dim DSPageData as New DataSet         DBConn = New OleDbConnection( _             "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _             & "DATA SOURCE=" _             & Server.MapPath("EmployeeDatabase.mdb;"))         DBCommand = New OleDbDataAdapter _             ("Select LastName, FirstName, ID From Employee " _             & "Order By LastName, FirstName", DBConn)         DBCommand.Fill(DSPageData, _             "Employee")         dgEmps.DataSource = _             DSPageData.Tables("Employee").DefaultView         dgEmps.DataBind()     End If End Sub Sub Click_Grid(ByVal Sender as Object, ByVal E as DataGridCommandEventArgs)     lblMessage.Text = E.Item.Cells(1).Text End Sub </SCRIPT> <HTML> <HEAD> <TITLE>Using a ButtonColumn Control in a DataGrid Control</TITLE> </HEAD> <Body LEFTMARGIN="40"> <form runat="server"> <BR><BR> <asp:Label      id="lblMessage"      runat="server" /> <BR><BR> <asp:datagrid     id="dgEmps"      runat="server"      autogeneratecolumns="false"     onitemcommand="Click_Grid" >     <columns>         <asp:boundcolumn              HeaderText="Full Name"              DataField="LastName"         />         <asp:boundcolumn              DataField="ID"             Visible=False         />         <asp:buttoncolumn             HeaderText="Other Fields"              ButtonType="PushButton"              Text="Click to Display Other Fields"         />     </columns> </asp:datagrid> </form> </BODY> </HTML>                     EmployeeDatabase.zip( 10 k)