<asp:Datagrid id=  "Datagrid1"  AutoGenerateColumns= false style= "Z-INDEX: 101 ; LEFT: 
6px; POSITION: absolute; TOP: 14px" runat= "server" >
<Columns>
<asp:BoundColumn DataField= "Productid"  HeaderText= "ProductiD" >
</asp:BoundColumn>
<asp:BoundColumn DataField= "ProductName"  HeaderText= "ProductName" >
</asp:BoundColumn>
<asp:BoundColumn DataField= "Total"  HeaderText= "Total"  DataFormatString= "{0 :c}">
</asp:BoundColumn>
</Columns>
</asp:DataGrid> 

Dim myconnection As SqlConnection 
Dim  myda As SqlDataAdapter 
Dim ds As DataSet Private Sub Page_Load(ByVal sender As System.Object, ByVal e 
	As System.EventArgs) Handles MyBase.Load 'Put user code  to 
	initializethepageheremyconnection=NewSqlConnection( "Server=localhost;uid=sa;password=;
                         database=northwind;" )
	myda = New SqlDataAdapter( "Select * from Products" , myconnection)
	ds = New DataSet()
	myda.Fill(ds,  "AllTables" )
	Dim dc As DataColumn
	dc = New DataColumn( "Total" , Type.GetType( "System.Double" ))
	dc.Expression =  "UnitPrice * UnitsInStock" 
	ds.Tables( 0 ).Columns.Add(dc)
	DataGrid1.DataSource = ds
	DataGrid1.DataBind()
End Sub