gridview comme feuille excel

Salut;
J'ai un problème avec  ce code(il permet de travailler avec une gridview comme excel)il modifié pas les données de la base  mais n'affiche aucune faute.

Voici le code si vous pouvez m'aider :

public

partial class Default14 : System.Web.UI. Page

{

bool [] rowChanged;

protected void Page_Load( object sender, EventArgs e)

{

int totalRows = GridView1.Rows.Count;

rowChanged =

new bool [totalRows];

if (Page.IsPostBack)

{

}

}

protected void TextBox_TextChanged( object sender, EventArgs e)

{

TextBox thisTextBox = ( TextBox )sender;

GridViewRow thisGridViewRow = ( GridViewRow )thisTextBox.Parent.Parent;

int row = thisGridViewRow.RowIndex;

rowChanged[row] =

true ;

}

protected void Page_PreRender( object sender, EventArgs e)

{

if (Page.IsPostBack)

{

int totalRows = GridView1.Rows.Count;

for ( int r = 0; r < totalRows; r++)

{

if (rowChanged[r])

{

GridViewRow thisGridViewRow = GridView1.Rows[r];

HiddenField hf1 = ( HiddenField )thisGridViewRow.FindControl( "HiddenField1" );

string pk = hf1.Value;

TextBox tb1 = ( TextBox )thisGridViewRow.FindControl( "TextBox1" );

string cell1 = tb1.Text;

TextBox tb2 = ( TextBox )thisGridViewRow.FindControl( "TextBox2" );

string cell2 = tb2.Text;

TextBox tb3 = ( TextBox )thisGridViewRow.FindControl( "TextBox3" );

string cell3 = tb3.Text;

SqlConnection con = new SqlConnection ( @"Data Source=.\SQLEXPRESS;UID=sa;Password=xxxxx;Initial Catalog=bd1" );

con.Open();

SqlCommand cmd = new SqlCommand ( "update Etudiant set Nom='" + cell1 + "', CIN='" + cell2 + "', CNE='" + cell3 + "' where NUM_INSCRIPTION=" + pk, con);

cmd.ExecuteNonQuery();

con.Close();

}

}

}

}

private void SqlCommand( string p, SqlConnection con)

{

throw new Exception ( "The method or operation is not implemented." );

}

protected void Button1_Click( object sender, EventArgs e)

{

GridView1.DataBind();

}

}

le code aspx

<%

@PageLanguage="C#"AutoEventWireup="false"CodeFile="Default14.aspx.cs"Inherits="Default14" %>

<%

@RegisterAssembly="CustomControls"Namespace="CustomControls.Grid"TagPrefix="cc1" %>

<!

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

<

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

<

headid="Head1"runat="server">

<title>Page sans titre</title>

</

head>

<

body>

<formid="form1"runat="server">

<asp:GridViewID="GridView1"runat="server"AllowPaging="True"AutoGenerateColumns="False"

BackColor

="White"BorderColor="#CCCCCC"BorderStyle="None"BorderWidth="1px"

CellPadding

="3"DataKeyNames="NUM_INSCRIPTION"DataSourceID="SqlDataSource1">

<

FooterStyleBackColor="White"ForeColor="#000066"/>

<

Columns>

<asp:BoundFieldDataField="NUM_INSCRIPTION"HeaderText="NUM_INSCRIPTION"ReadOnly="True"

SortExpression="NUM_INSCRIPTION"/>

<asp:TemplateFieldHeaderText="Nom"SortExpression="Nom">

<ItemTemplate>

<asp:TextBoxID="TextBox4"runat="server"Text='<%# Bind("Nom") %>'>'

OnTextChanged="TextBox_TextChanged" BorderStyle="None">

</asp:TextBox>

<asp:HiddenFieldID="HiddenField1"runat="server"Value='<%# Eval("Nom") %>'/>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateFieldHeaderText="CIN"SortExpression="CIN">

<ItemTemplate>

<asp:TextBoxID="TextBox5"runat="server"Text='<%# Bind("CIN") %>'></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateFieldHeaderText="CNE"SortExpression="CNE">

<ItemTemplate>

<asp:TextBoxID="TextBox6"runat="server"Text='<%# Bind("CNE") %>'></asp:TextBox>

</ItemTemplate>

</asp:TemplateField>

</

Columns>

<

RowStyleForeColor="#000066"/>

<

SelectedRowStyleBackColor="#669999"Font-Bold="True"ForeColor="White"/>

<

PagerStyleBackColor="White"ForeColor="#000066"HorizontalAlign="Left"/>

<

HeaderStyleBackColor="#006699"Font-Bold="True"ForeColor="White"/>

</

asp:GridView>

&nbsp;

<asp:SqlDataSourceid="SqlDataSource1"runat="server"UpdateCommand="UPDATE [Etudiant] SET [Nom] = @Nom, [CIN] = @CIN, [CNE] = @CNE WHERE [NUM_INSCRIPTION] = @NUM_INSCRIPTION"SelectCommand="SELECT [NUM_INSCRIPTION], [Nom], [CIN],[CNE] FROM [Etudiant]"InsertCommand="INSERT INTO [Etudiant] ([NUM_INSCRIPTION], [Nom], [CIN], [CNE]) VALUES (@NUM_INSCRIPTION, @Nom, @CIN, @CNE)"DeleteCommand="DELETE FROM [Etudiant] WHERE [NUM_INSCRIPTION] = @NUM_INSCRIPTION"ConnectionString="<%$ ConnectionStrings:ConnectionString9 %>">

<DeleteParameters>

<asp:ParameterName="NUM_INSCRIPTION"/>

</DeleteParameters>

<UpdateParameters>

<asp:ParameterName="Nom"/>

<asp:ParameterName="CIN"/>

<asp:ParameterName="CNE"/>

<asp:ParameterName="NUM_INSCRIPTION"/>

</UpdateParameters>

<InsertParameters>

<asp:ParameterName="NUM_INSCRIPTION"/>

<asp:ParameterName="Nom"/>

<asp:ParameterName="CIN"/>

<asp:ParameterName="CNE"/>

</InsertParameters>

</asp:SqlDataSource>

<asp:ButtonID="Button1"runat="server"Text="Button"OnClick="Button1_Click"/>

</form>

</

body>

</

html>

Merci infiniment.