get-dataview-control.ascx

Professional ASP.NET source code

<%@Control Language="C#"%>

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

<script language="C#" runat="server">

	public DataView GetDataView(string strConnect, string strSQL)
	{
		// creates a DataView object based on a single table holding data specified
		// in the connection string and SQL statement provided as parameters

		try
		{
			// create a new Connection object using the connection string
			OleDbConnection objConnect = new OleDbConnection(strConnect);

			// create a new DataAdapter using the connection object and select statement
			OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(strSQL, objConnect);

			// create a new DataSet object to fill with data
			DataSet objDataSet = new DataSet();

			// fill the dataset with data from the DataAdapter object
			objDataAdapter.Fill(objDataSet, "Books");

			return objDataSet.Tables[0].DefaultView;
		}
		catch (Exception objError)
		{
			return null;
		}
	}
	
</script>