Solved

comprehensive gridview example

Posted on 2009-04-04
1
212 Views
Last Modified: 2012-05-06
Do you know of an example of the Gridview so I can,
Add/Remove fields or
Edit them
Add record
Delete record
Format the fields

I have done most of it in my example, however, I do not know the best way to format or insert record
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EditExample_formview.aspx.cs" Inherits="EditExample" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<script runat="server">
 
    protected void Page_Load(object sender, EventArgs e)
    {
            AccessDataSource1.DataFile = "~/App_Data/AccountInfo.mdb";
            AccessDataSource1.SelectCommand="SELECT Scenario.* from Scenario";
            AccessDataSource1.UpdateCommand = "UPDATE Scenario SET BusinessStartYear = ?, ReportingStart = ?, ReportingEnd = ?, FilterString = ? WHERE ScenarioID = ?";
            AccessDataSource1.DeleteCommand="DELETE FROM Scenario WHERE ScenarioID = ?";
            AccessDataSource1.InsertCommand="INSERT xxx  = ?";
            AccessDataSource1.UpdateParameters.Add("BusinessStartYear", "DateTime");
            AccessDataSource1.UpdateParameters.Add("ReportingStart", "DateTime");
            AccessDataSource1.UpdateParameters.Add("ReportingEnd", "DateTime");
            AccessDataSource1.UpdateParameters.Add("FilterString", "String");
            AccessDataSource1.DeleteParameters.Add("ScenarioID", "Int32");
    }
</script>
1
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" DataKeyNames="ScenarioID" DataSourceID="AccessDataSource1" PageSize="16" AllowSorting="True" AutoGenerateColumns="true" >
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
            </Columns>
        </asp:GridView>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server">
        </asp:AccessDataSource>
 
 
 
 
        <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" 
            DataSourceID="AccessDataSource1" Height="50px" Width="125px">
            <Fields>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
            </Fields>
        </asp:DetailsView>
 
 
 
 
    </form>
</body>
</html>

Open in new window

0
Comment
Question by:goodk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
Kamaraj Subramanian earned 500 total points
ID: 24071322
get the sample code here

http://www.codeproject.com/KB/webforms/Editable_GridView.aspx

http://www.codeproject.com/KB/webforms/EditGridviewCells.aspx

just register yourself in the website and download the source code.

0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Use System DSN 6 91
cron.exe SCOM alert 3 54
SCCM 2012 - Backup and Recovery Best Practice 2 117
Access 2016 - Use a Button to Select a specific Record on a form 12 82
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question