@ Register assembly="Devart.Data.Oracle.Web, Version=5.35.54.0, Culture=neutral, PublicKeyToken=09af7300eec23701" namespace="Devart.Data.Oracle.Web" tagprefix="cc1" %>

<!

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<

html xmlns="http://www.w3.org/1999/xhtml">

<

head runat="server">

<title></title>

<telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />

</

head>

<

body>

<form id="form1" runat="server">

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

<Scripts>

<%

--Needed for JavaScript IntelliSense in VS2010--%>

<%

--For VS2008 replace RadScriptManager with ScriptManager--%>

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />

</Scripts>

</telerik:RadScriptManager>

<script type="text/javascript">

//Put your JavaScript code here.

</script>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

</telerik:RadAjaxManager>

<div>

</div>

<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None"

onneeddatasource="RadGrid1_NeedDataSource" >

<

HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

<

MasterTableView AllowAutomaticUpdates="True" AutoGenerateColumns="False">

<

CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<

RowIndicatorColumn>

<

HeaderStyle Width="20px"></HeaderStyle>

</

RowIndicatorColumn>

<

ExpandCollapseColumn>

<

HeaderStyle Width="20px"></HeaderStyle>

</

ExpandCollapseColumn>

</

MasterTableView>

</telerik:RadGrid>

<cc1:OracleDataSource ID="OracleDataSource1" runat="server"

ConnectionString="User Id=user_name;Password=password;Server=PROD;Persist Security Info=True;"

OldValuesParameterFormatString="Original_{0}"

SelectCommand="select * from data_prequal.data_reporting">

</cc1:OracleDataSource>

</form>

</

body>

</

html>

using

System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Devart.Data.Oracle;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Telerik.Web.UI;

partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{if (Page.IsPostBack) return;
}

private DataTable GetOrdersDetails()
{
string ConnString = "User Id=user_name;Password=password;Server=PROD;Persist Security Info=True;";
string query = "SELECT * FROM data_reporting";
DataTable myDataTable = new DataTable();

using (OracleConnection conn = new OracleConnection(ConnString))
{
using (OracleDataAdapter adapter = new OracleDataAdapter())
{
adapter.SelectCommand = new OracleCommand(query, conn);
conn.Open();

try
{
adapter.Fill(myDataTable);
}

finally
{
conn.Close();
}

}

}

return myDataTable;

}

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
RadGrid1.DataSource = GetOrdersDetails();
}

}

Protected Sub AsyncUpload1_FileUploaded(ByVal sender As Object, ByVal e As Telerik.Web.UI.FileUploadedEventArgs) Handles AsyncUpload1.FileUploaded

Thumbnail.Width =

Unit.Pixel(200)

Thumbnail.Height =

Unit.Pixel(150)

Dim imageData As Byte() = New Byte(e.File.InputStream.Length) {}

e.File.InputStream.Read(imageData, 0, e.File.InputStream.Length)

Thumbnail.DataValue = imageData

End Sub

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click

    For Each f As Telerik.Web.UI.UploadedFile In AsyncUpload1.UploadedFiles

    f.SaveAs(

"c:\a.jpg", True)

    Next

End Sub