datagrid help

**EyeTalion** · Aug 9th, 2002, 09:49 AM

What I need to do is just display some read only data from a database and/or another form. Does anyone have some sample code that will get me started?

thanks,
eye

**Cander** · Aug 9th, 2002, 10:13 AM

this is for the asp .net datagrid, but the main code is exactly the ame, just remove the html and asp stuff, and remove the .DataBind method

Code:

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb"%> 

<html>
	<script language="VB" runat="server">
		' ---------------------------------
		' Code by Chris Andersen
		' This example shows how to show data from an access database in the DataGrid control
		' and how to write a new record to the database.
		' ---------------------------------
		
		' Recordset no longer exists for ADO .NET. Create DataSets and populate it from the data you get from
		' a DataAdapter or other source. In this case we are getting ADO DataSet using the System.Data.OleDb.OleDbDataAdapter Class
		Dim myDS As New DataSet
		Dim myConn As OleDbConnection
		Dim myCommand As OleDbDataAdapter
		Dim strConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.Mappath("/candersen/db/test.mdb")
		Dim strSQL As String
		
		Sub Page_Load(Sender As Object, E As EventArgs)
			' This sub is called everytime the Page Loads
		End Sub
		
		Sub Go_Click(Sender As Object, E As EventArgs)
			Dim strName As String = Name.Text
			Dim strAge As String = Age.Text
			
			' Write posted data to the lables
			lblName.Text = strName
			lblAge.Text = strAge

			' Insert Posted Data to database
			strSQL = "Insert Into Test(Name,Age) VALUES('" & strName & "','" & strAge & "')" 
			
			' Populate DataSet
			FillDataSet()
			
			' Update DataGrid
			UpdateGrid()
		End Sub
		
		Sub UpdateGrid()
			' Updates the DataGrid
			strSQL = "Select * FROM Test"
			
			'Populate DataSet
			FillDataSet()
			
			' Now set the DataGrid's source to the Dataset and bind it
			MyDataGrid.DataSource = myDS.Tables("Test").DefaultView
			MyDataGrid.DataBind()
			
		End Sub
		
		Sub FillDataSet()
			' Reusable code to populate the Dataset from the SQL statement
			'Start Connection to ADO source
			myConn = New OleDbConnection (strConnString)
		
			' Run the Sql statement and get the Data into the DataAdapter
			myCommand = New OleDbDataAdapter(strSQL, myConn)

			' Fill the DataSet and name the table
			myCommand.Fill(myDS, "Test")
			         
			myConn.Close()
		End Sub
		
	</script>
	<body>
		<form action="aspnet1.aspx" method="post" runat="server">
			<!-- ASP .NET server control textbox  -->
			<table>
				<tr>
					<td>Name</td>
					<td><asp:textbox BackColor="#ccccff" id="Name" 
						BorderColor="black"
						runat="server"/></td>
				</tr>
				<tr>
					<td>Age</td>
					<td><asp:textbox BackColor="#ccccff" id="Age"
						BorderColor="black"
						runat="server"/></td>
				</tr>
			</table>
					
			<!-- ASP .NET sever control button -->
			<asp:button id="btnGo" text="Go" OnClick="Go_Click" runat="server"/><br/>
			
			<!-- ASP .NET server control Label-->
			Your name is <asp:label id="lblName" runat="server"/><br/>
			Your age is <asp:label id="lblAge" runat="server"/><br/>
			
			<!-- ASP .NET server control DataGrid -->
			<asp:DataGrid id="MyDataGrid" runat="server"
			    Width="700"
			    BackColor="#ccccff" 
			    BorderColor="black"
			    ShowFooter="false" 
			    CellPadding=3 
			    CellSpacing="0"
			    Font-Name="Verdana"
			    Font-Size="8pt"
			    HeaderStyle-BackColor="#aaaadd"
			    EnableViewState="false">
			  
			  	<Columns>
				<asp:HyperLinkColumn
				            DataNavigateUrlField="Name"
				            DataNavigateUrlFormatString="test_details.aspx?id={0}"
				            Text="View"
				          />
				</Columns>
			  </asp:DataGrid>
		</form>
	</body>
</html>

Thread: datagrid help

Thread Tools

Display

datagrid help

Posting Permissions