Asp.Net DataGrid from SQL UserControl

About Us

E-commerce

Website Design



Shopping Categories:



We love to hear from our users! Whether you have a technical question or suggestion. We take your questions, suggestions and any issues very seriously, and will try to do our best to assist you.


Helpful Links:




Asp.Net DataGrid from SQL UserControl

Asp.Net DataGrid from SQL UserControl


Asp.Net Custom DataGrid from SQL UserControl
SummarySKUPriceQuantity 

...

01-0005- $5.00




Live test: http://www.eodessa.com/datagridfromsql/

Supports bidirectional data sorting

Calculate summaries and display them within the grid

Abstract data access layer, connect to any available database: SQL Server, Oracle, MySQL, Sybase, Access and more...

Exporting
Export the data to numerous formats such as XML, Excel etc with current UI layout such as visible columns, columns order and etc. 
 
Delete and Edit rows  and add new one

Customizable Page Size and paging.
Miscellaneous Features
DataGrid  is optimized for Microsoft® Visual Studio® .NET
GridLines property.


For more information on the DotNetGrid, feel free to contact us by Email at: .
 
 
Supported IDEs:
 
     Visual Studio .NET 2002 
     Visual Studio .NET 2003
     Visual Studio 2005
     Borland Delphi 8
     Borland Delphi 2005
     Borland Delphi 2006
     Borland C# Builder
 
 
Supported Browsers
 
  Internet Explorer 5.5 +
  Netscape 7 +
  Mozilla
  Mozilla Firefox

<%@ Register TagPrefix="uc1" TagName="datagridfromsql" Src="controls/DataGridfromSQL.ascx" %>

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

<head runat="server">

<title>DataGrid from SQL Demo Page</title>

</head>

<body>

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

<div>

<uc1:datagridfromsql ID="gridTabArea" runat="server" IsEdit="True" IsDelete="True"

IsObjectDelete="False" IsNew="True" PrimaryKey="CountryID" Pagesize="20"

SelectSQL="select CountryID,Name,TwoLetterISOCode,DisplayOrder,LastUpdated from Country"

DeleteSQL="delete from Country where CountryID=" EditPage="Edit.aspx"

Caption="<b>DataGrid from SQL Demo</b><br> "></uc1:datagridfromsql>

</div>

</form>

</body>

</html>

private void DeleteRow(string key)

{

if(!isobjectdelete)

{

Provider provider = null;

try

{

provider = Database.CreateProvider("eOdessa");

provider.ExecuteNonquery(this.deletesql+key);

provider.Dispose();

BindGrid();

}

catch(Root.Data.ProviderException pe)

{

throw new