DetailsView无法实现编辑操作,但是删除和插入都可以,为什么呀?

兔儿爷 2007-12-14 11:09:05

...全文

130 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

tang_fu 2008-12-01

打赏
举报

是不是你的数据库的编辑权限没有设置好啊、

hulangfy 2008-06-17

打赏
举报

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace WindowsApplication2
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button button1;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;

SqlDataAdapter adapter = new SqlDataAdapter();
private System.Windows.Forms.Button button2;
DataTable dt = new DataTable();

public Form1()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();

InitAdapter();
}

private void InitAdapter()
{
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=sa;database=dbtest");
SqlCommand Selectcmd = conn.CreateCommand();
Selectcmd.CommandText = "select * from account";

//增加查询功能
adapter.SelectCommand = Selectcmd;

//增加插入功能
SqlCommand Insertcmd = conn.CreateCommand();
Insertcmd.CommandText = "insert account values(@name,@pwd)";
Insertcmd.Parameters.Add("@name",SqlDbType.NVarChar,50,"username");
Insertcmd.Parameters.Add("@pwd",SqlDbType.NVarChar,50,"password");

adapter.InsertCommand = Insertcmd;

//增加修改功能
SqlCommand Updatecmd = conn.CreateCommand();
Updatecmd.CommandText = "update account set username=@name,password=@pwd where userid=@id";

SqlParameter para = new SqlParameter();
para.ParameterName = "@name";
para.SqlDbType = SqlDbType.NVarChar;
para.SourceColumn = "username";
para.Size = 50;
para.SourceVersion = DataRowVersion.Current;

SqlParameter para1 = new SqlParameter("@pwd",SqlDbType.NVarChar,50,ParameterDirection.Input,false,(byte)0,(byte)0,"password",DataRowVersion.Current,null);

SqlParameter para2 = new SqlParameter("@id",SqlDbType.Int,4,ParameterDirection.Input,false,(byte)0,(byte)0,"userid",DataRowVersion.Original,null);

Updatecmd.Parameters.Add(para);
Updatecmd.Parameters.Add(para1);
Updatecmd.Parameters.Add(para2);

adapter.UpdateCommand = Updatecmd;

//增加删除功能
SqlCommand Deletecmd = conn.CreateCommand();
Deletecmd.CommandText = "delete account where userid=@id";
SqlParameter para3 = new SqlParameter("@id",SqlDbType.Int,4,ParameterDirection.Input,false,(byte)0,(byte)0,"userid",DataRowVersion.Original,null);
Deletecmd.Parameters.Add(para3);
adapter.DeleteCommand = Deletecmd;

}

/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// dataGrid1
//
this.dataGrid1.DataMember = "";
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(8, 0);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(488, 328);
this.dataGrid1.TabIndex = 0;
//
// button1
//
this.button1.Location = new System.Drawing.Point(512, 40);
this.button1.Name = "button1";
this.button1.TabIndex = 1;
this.button1.Text = "查询";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(512, 96);
this.button2.Name = "button2";
this.button2.TabIndex = 2;
this.button2.Text = "更新";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(592, 374);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.dataGrid1);
this.Name = "Form1";
this.Text = "Form1";
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);

}
#endregion

/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}

private void button1_Click(object sender, System.EventArgs e)
{
dt.Clear();
adapter.Fill(dt);
this.dataGrid1.DataSource = dt;
}

private void button2_Click(object sender, System.EventArgs e)
{
DataTable dt1 = (DataTable)dataGrid1.DataSource;
adapter.Update(dt1);
}

}
}

xiaolei1982 2007-12-16

打赏
举报

你说的不清楚给你个msdn例子，当然是正确的
C#

<%@ Page language="C#" %>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">



  void EmployeesDropDownList_OnSelectedIndexChanged(Object sender, EventArgs e)

  {

    EmployeeDetailsView.DataBind();

  }



  void EmployeeDetailsView_ItemUpdated(Object sender, DetailsViewUpdatedEventArgs e)

  {

    EmployeesDropDownList.DataBind();

    EmployeesDropDownList.SelectedValue = e.Keys["EmployeeID"].ToString();

    EmployeeDetailsView.DataBind();

  }

  

  void EmployeeDetailsView_ItemDeleted(Object sender, DetailsViewDeletedEventArgs e)

  {

    EmployeesDropDownList.DataBind();

  }



  void EmployeeDetailsSqlDataSource_OnInserted(Object sender, SqlDataSourceStatusEventArgs e)

  {

    System.Data.Common.DbCommand command = e.Command;   

    EmployeesDropDownList.DataBind();

    EmployeesDropDownList.SelectedValue = 

      command.Parameters["@EmpID"].Value.ToString();

    EmployeeDetailsView.DataBind();

  }



</script>



<html  >

  <head runat="server">

    <title>Northwind Employees</title>

</head>

<body>

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

        

      <h3>Northwind Employees</h3>



        <table cellspacing="10">

            

          <tr>

            <td valign="top">

              <asp:DropDownList ID="EmployeesDropDownList" 

                DataSourceID="EmployeesSqlDataSource" 

                DataValueField="EmployeeID" 

                DataTextField="FullName"

                AutoPostBack="True"

                OnSelectedIndexChanged="EmployeesDropDownList_OnSelectedIndexChanged"

                RunAt="Server" />            

            </td>

                

            <td valign="top">                

              <asp:DetailsView ID="EmployeeDetailsView"

                DataSourceID="EmployeeDetailsSqlDataSource"

                AutoGenerateRows="false"

                AutoGenerateInsertbutton="true"

                AutoGenerateEditbutton="true"

                AutoGenerateDeletebutton="true"

                DataKeyNames="EmployeeID"     

                Gridlines="Both"

                OnItemUpdated="EmployeeDetailsView_ItemUpdated"

                OnItemDeleted="EmployeeDetailsView_ItemDeleted"      

                RunAt="server">

                

                <HeaderStyle backcolor="Navy"

                  forecolor="White"/>

                  

                <RowStyle backcolor="White"/>

                

                <AlternatingRowStyle backcolor="LightGray"/>

                

                <EditRowStyle backcolor="LightCyan"/>

                                    

                <Fields>                  

                  <asp:BoundField DataField="EmployeeID" HeaderText="Employee ID" InsertVisible="False" ReadOnly="true"/>                    

                  <asp:BoundField DataField="FirstName"  HeaderText="First Name"/>

                  <asp:BoundField DataField="LastName"   HeaderText="Last Name"/>                    

                  <asp:BoundField DataField="Address"    HeaderText="Address"/>                    

                  <asp:BoundField DataField="City"       HeaderText="City"/>                        

                  <asp:BoundField DataField="Region"     HeaderText="Region"/>

                  <asp:BoundField DataField="PostalCode" HeaderText="Postal Code"/>                    

                </Fields>                    

              </asp:DetailsView>

            </td>                

          </tr>            

        </table>

            

        <asp:SqlDataSource ID="EmployeesSqlDataSource"  

          SelectCommand="SELECT EmployeeID, LastName + ', ' + FirstName AS FullName FROM Employees" 

          Connectionstring="<%$ ConnectionStrings:NorthwindConnection %>" 

          RunAt="server">

        </asp:SqlDataSource>



 

        <asp:SqlDataSource ID="EmployeeDetailsSqlDataSource" 

          SelectCommand="SELECT EmployeeID, LastName, FirstName, Address, City, Region, PostalCode

                         FROM Employees WHERE EmployeeID = @EmpID"



          InsertCommand="INSERT INTO Employees(LastName, FirstName, Address, City, Region, PostalCode)

                         VALUES (@LastName, @FirstName, @Address, @City, @Region, @PostalCode); 

                         SELECT @EmpID = SCOPE_IDENTITY()"



          UpdateCommand="UPDATE Employees SET LastName=@LastName, FirstName=@FirstName, Address=@Address,

                           City=@City, Region=@Region, PostalCode=@PostalCode

                         WHERE EmployeeID=@EmployeeID"



          DeleteCommand="DELETE Employees WHERE EmployeeID=@EmployeeID"



          ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>"

          OnInserted="EmployeeDetailsSqlDataSource_OnInserted"

          RunAt="server">

          

          <SelectParameters>

            <asp:ControlParameter ControlID="EmployeesDropDownList" PropertyName="SelectedValue"

                                  Name="EmpID" Type="Int32" DefaultValue="0" />

          </SelectParameters>

          

          <InsertParameters>

            <asp:Parameter Name="LastName"   Type="String" />

            <asp:Parameter Name="FirstName"  Type="String" />

            <asp:Parameter Name="Address"    Type="String" />

            <asp:Parameter Name="City"       Type="String" />

            <asp:Parameter Name="Region"     Type="String" />

            <asp:Parameter Name="PostalCode" Type="String" />

            <asp:Parameter Name="EmpID" Direction="Output" Type="Int32" DefaultValue="0" />

          </InsertParameters>



          <UpdateParameters>

            <asp:Parameter Name="LastName"   Type="String" />

            <asp:Parameter Name="FirstName"  Type="String" />

            <asp:Parameter Name="Address"    Type="String" />

            <asp:Parameter Name="City"       Type="String" />

            <asp:Parameter Name="Region"     Type="String" />

            <asp:Parameter Name="PostalCode" Type="String" />

            <asp:Parameter Name="EmployeeID" Type="Int32" DefaultValue="0" />

          </UpdateParameters>



          <DeleteParameters>

            <asp:Parameter Name="EmployeeID" Type="Int32" DefaultValue="0" />

          </DeleteParameters>



        </asp:SqlDataSource>

      </form>

  </body>

</html>