Solved

comprehensive gridview example

Posted on 2009-04-04
1
206 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
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now