Asp net gridview onupdating
Asp net gridview onupdating
Needless to say, a large amount of time goes into rather mundane data-related tasks such as: Oftentimes this data access code is very similar, leading to writing mundane and oft-repeated code.
You can either select a table or view from the drop-down, picking the fields you want returned, or you can provide your own SQL statement or stored procedure name to call.
NET 2.0, has a Data Source ID property, which you can set to the ID of the data source control whose data you want to display.
By setting the Grid View's Data Source ID, the Grid View will, by default, show all the fields of all the records returned by the data source control.
Visual Basic Public Class Product #Region "Private Member Variables" Private _product ID As Integer Private _product Name As String Private _quantity Per Unit As String 'Consider making _unit Price & _unit In Stock nullable fields, 'since they are NULL in the Northwind database.
Private _unit Price As Decimal Private _units In Stock As Integer #End Region #Region "Constructors" Public Sub New() End Sub Public Sub New(By Val product ID As Integer, _ By Val product Name As String, By Val quantity Per Unit As String, _ By Val unit Price As Decimal, By Val units In Stock As Integer) Me._product ID = product ID Me._product Name = product Name Me._quantity Per Unit = quantity Per Unit Me._unit Price = unit Price Me._units In Stock = units In Stock End Sub #End Region #Region "Public Properties" Public Property Product ID() As Integer Get Return _product ID End Get Set(By Val value As Integer) If value As you can see in the source code, the Get Products() method retrieves the pertinent fields from the Northwind database's Products table in a Sql Data Reader and then loops through the retrieved results, creating a Product instance of each one and adding that instance to a List of Products.
(We'll examine creating INSERT, UPDATE, and DELETE statements later on in this article.) Figure 2 The last step of the wizard allows you to run the SELECT statement specified against the data store to see what data, exactly, is returned.
That's all there is to configuring a Sql Data Source.But before we do, realize that when displaying data on a Web page, accessing the data is only one part of the puzzle. Next, you'll need to specify what data the Grid View should display.The other piece is displaying the data, and that's where the Grid View control comes in. The Grid View control, like all data Web controls in ASP.Notice that we did not need to write a single line of server-side code in order to display data from a database. NET page contains the specific details pertinent to data access.That is, buried in the Sql Data Source's declarative syntax you'll find a reference to a connection string, SQL statements for (potentially) SELECTs, INSERTs, UPDATEs, and DELETEs, and a list of parameters for each type of SQL statement.Start by dragging and dropping a Grid View control from the Toolbox onto the ASP. The Smart Tag will prompt you to select the Grid View's Data Source. Figure 3 (Click on the graphic for a larger image) Figure 4 The data source controls, like any other ASP.