<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://forums.asp.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Search results matching tags 'Oracle' and 'datagrid'</title><link>http://forums.asp.net/search/SearchResults.aspx?q=&amp;tag=Oracle%2cdatagrid&amp;orTags=0&amp;o=DateDescending</link><description>Search results matching tags 'Oracle' and 'datagrid'</description><dc:language>en-US</dc:language><generator>CommunityServer 2007 SP1 (Build: 20510.895)</generator><item><title>Database Lookups for ASP.NET and AJAX 3.5</title><link>http://forums.asp.net/thread/2529246.aspx</link><pubDate>Thu, 31 Jul 2008 04:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:2529246</guid><dc:creator>CodeOnTime</dc:creator><description>&lt;p&gt;&lt;strong&gt;&lt;font size="4"&gt;&lt;img title="Database Lookups for ASP.NET and AJAX 3.5" style="WIDTH:300px;HEIGHT:263px;" height="263" alt="Database Lookups for ASP.NET and AJAX 3.5" src="http://codeontime.com/images/DatabaseLookups.png" width="300" align="right" /&gt;Database Lookups&lt;/font&gt; &lt;/strong&gt;is a free code generator project that allows to replace standard &lt;em&gt;ASP.NET&lt;/em&gt; controls &lt;em&gt;DropDownList&lt;/em&gt; and &lt;em&gt;ListBox&lt;/em&gt;&amp;nbsp; used by database web application developers to display and select lookup values.&lt;/p&gt;
&lt;p&gt;The replacement &lt;em&gt;DataViewLookup&lt;/em&gt; is implemented as &lt;em&gt;AJAX ASP.NET 3.5&lt;/em&gt; control with dynamic user interface based on&amp;nbsp;abbreviated version of the&amp;nbsp;&lt;a href="http://codeontime.com/ProductsDAF.aspx"&gt;Data Aquarium Framework&lt;/a&gt;.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Popup lookup windows with infinite scalability allow to sort data, apply adaptive filters, and page through thousands of records without effort. You can provide multiple views of the same data to make record selection even more efficient&lt;/p&gt;
&lt;p&gt;No programming is required. The configuration is done via &lt;a href="http://blog.codeontime.com/2008/05/data-aquarium-framework.html" target="_blank"&gt;data controllers&lt;/a&gt; that are included in the source code of your application. There are no external dependencies in the code.&lt;/p&gt;
&lt;p&gt;Review a&amp;nbsp;&lt;a href="http://codeontime.com/ProductsDL.aspx"&gt;complete feature list&lt;/a&gt; of this code generator project.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://store.codeontime.com/install/setup.exe"&gt;Download&lt;/a&gt; the &lt;strong&gt;Database Lookups for ASP.NET and AJAX 3.5&lt;/strong&gt; code generator project and improve usability of the user interface in your database web applications.&lt;/p&gt;
&lt;p&gt;Try the &lt;a href="http://dev.codeontime.com/demo/nwl/" target="_blank"&gt;demo&lt;/a&gt; of database lookups now.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;Code OnTime LLC&lt;/p&gt;</description></item><item><title>Re: Connection with oracle9i</title><link>http://forums.asp.net/thread/1642778.aspx</link><pubDate>Thu, 29 Mar 2007 04:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:1642778</guid><dc:creator>veeaar</dc:creator><description>&lt;p&gt;Hey buddy!&lt;/p&gt;&lt;p&gt;The above link given by praveen is indeed very informative. As an addon to the explanation you can find a crisp example here:-&lt;/p&gt;&lt;pre class="coloredcode"&gt;&lt;b id="1"&gt;1    &lt;/b&gt;&lt;span class="kwd"&gt;string&lt;/span&gt; ConnString = &lt;span class="st"&gt;"data source=dsn1;user id=user1;password=pwd1;"&lt;/span&gt;;
&lt;b id="2"&gt;2    &lt;/b&gt;OracleConnection NewConn = &lt;span class="kwd"&gt;new&lt;/span&gt; OracleConnection(ConnString);
&lt;b id="3"&gt;3    &lt;/b&gt;&lt;span class="kwd"&gt;string&lt;/span&gt; sql=&lt;span class="st"&gt;"SELECT * FROM Table1"&lt;/span&gt;;
&lt;b id="4"&gt;4    &lt;/b&gt;OracleCommand NewComm = &lt;span class="kwd"&gt;new&lt;/span&gt; OracleCommand(sql);
&lt;b id="5"&gt;5    &lt;/b&gt;NewComm.Connection = NewConn;
&lt;b id="6"&gt;6    &lt;/b&gt;&lt;span class="kwd"&gt;try&lt;/span&gt;
&lt;b id="7"&gt;7    &lt;/b&gt;{
&lt;b id="8"&gt;8    &lt;/b&gt;	NewConn.Open();
&lt;b id="9"&gt;9    &lt;/b&gt;	OracleDataReader NewReader = NewComm.ExecuteReader();
&lt;b id="10"&gt;10   &lt;/b&gt;	DataGrid1.DataSource = NewReader;
&lt;b id="11"&gt;11   &lt;/b&gt;	DataGrid1.DataBind();
&lt;b id="12"&gt;12   &lt;/b&gt;}
&lt;b id="13"&gt;13   &lt;/b&gt;&lt;span class="kwd"&gt;catch&lt;/span&gt;(Exception ex)
&lt;b id="14"&gt;14   &lt;/b&gt;{
&lt;b id="15"&gt;15   &lt;/b&gt;        Label1.Text = ex.Message;
&lt;b id="16"&gt;16   &lt;/b&gt;}
&lt;b id="17"&gt;17   &lt;/b&gt;
&lt;b id="18"&gt;18   &lt;/b&gt;NewComm.Connection.close();
&lt;b id="19"&gt;19   &lt;/b&gt;NewComm.Connection.Dispose();
&lt;/pre&gt;&amp;nbsp;&lt;br /&gt;</description></item></channel></rss>