在Gridview中编辑，删除.. [英] Edit , Delete in Gridview..

问题描述

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class Home : System.Web.UI.Page
{
  //  SqlConnection con;
    SqlCommand cmd = new SqlCommand();
    SqlDataAdapter da = new SqlDataAdapter();
    DataSet ds = new DataSet();
    SqlConnection con = new SqlConnection(@"Data Source=....");

    protected void Page_Load(object sender, EventArgs e)
    {
        
    }

    protected void btnSave_Click(object sender, EventArgs e)
    {

        int intCountryID = Convert.ToInt32(ddlCountry.SelectedValue.ToString());
        string strCountry = txtlang.Text.Trim();
        string strDesc = txtDescription.Text.Trim();
        int intUserID = 1;
        DateTime DTDate = DateTime.Now.Date;

        if (txtlang.Text != string.Empty && txtDescription.Text != string.Empty)
        {
            cmd.Connection = con;
            cmd.CommandText = "insert into tbl_language values(" + intCountryID + ",'" + strCountry + "','" + strDesc + "'," + intUserID + ",'" + DTDate + "'," + intUserID + ",'" + DTDate + "',1)";
            cmd.ExecuteNonQuery();
            BindData();
        }
        else
        {
            ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Some fields are missing...')</script>");
        }
    }

    protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindData();


    }
    public void GridView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        BindData();
    }
    protected void GridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        BindData();
    }
    protected void GridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        BindData();
        
        TaskGridView.EditIndex = -1;
        BindData();
    }

    public void BindData()
    {
        con.Open();
        cmd = new SqlCommand("select language_id,language_name,language_desc from tbl_language where ref_country_id = " + Convert.ToInt32(ddlCountry.SelectedValue.ToString()), con);
        da = new SqlDataAdapter(cmd);
        da.Fill(ds);

        GridView1.DataSource = ds;
        GridView1.DataBind();
        GridView1.Visible = true;
        
        con.Close();
    }
}

这是我的代码..

我需要的是有两个表tbl_country，

tbl_language

This is my code ..
What I need is there is two tables tbl_country,
tbl_language

(language_id
ref_country_id
language_name
language_desc
created_by
created_date
updated_by
updated_date
isactive )

..



如果我点击网格中的编辑它应该更新。

如果我点击删除它应该改变它的字段在tbl_language表中是非活动状态。



***我需要的所有编码.cs不在aspx中



请帮帮我..

谢谢提前..











b / b










< br $> b $ b



我仍​​然收到错误..

..

if i click edit in grid it should be updated.
if i click delete it should be change it's field isactive to false state in tbl_language table.

*** All the codings i need in " .cs not in aspx "

Pls help me..
Thanks in advance..














Still i'm getting error..

protected void GridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//BindData();
 
int index = GridView1.EditIndex;
GridViewRow row = GridView1.Rows[index];
TextBox t1 = row.FindControl("TextBox2") as TextBox;
TextBox t2 = row.FindControl("TextBox3") as TextBox;
string t3 = GridView1.DataKeys[e.RowIndex].Value.ToString();
 

string cmdText = "Update tbl_language set language_name= '" + t1.Text + "' , language_desc= '" + t2.Text + "' where language_id='" + t3 + "'";
SqlCommand command = new SqlCommand(cmdText, con);


command.ExecuteNonQuery();
con.Close();
 


GridView1.EditIndex = -1; 
BindData();
}
 

public void BindData()
{
con.Open();
cmd = new SqlCommand("select language_id,language_name,language_desc from tbl_language where ref_country_id = " + Convert.ToInt32(ddlCountry.SelectedValue.ToString()), con);
da = new SqlDataAdapter(cmd);
da.Fill(ds);
 
GridView1.DataSource = ds;
GridView1.DataBind();
GridView1.Visible = true;

con.Close();
}
 

 

 

I'm getting error in rowupdating method...
line : string t3 = GridView1.DataKeys[e.RowIndex].Value.ToString();

推荐答案

这里有一些链接

gridview-edit-delete- and-update-in-Asp-Net [ ^ ]

http://www.mindstick.com/Articles [ ^ ]

如何插入ditupdate-and-delete-data.html [ ^ ]

Here some links for you
gridview-edit-delete-and-update-in-Asp-Net[^]
http://www.mindstick.com/Articles [^]
how-to-inserteditupdate-and-delete-data.html[^]

参考：在ASP.NET Gridview中插入，更新，删除，DataSource作为SQL Server，MS Access（mdb / accdb），XML和Framework为2.0 / 3.0 / 3.5 / 4.0（VS 2005/2008/2010） [ ^ ]

尝试这样一定会帮助你......一切顺利。

http://www.aspdotnet-suresh.com/2011 /02/how-to-inserteditupdate-and-delete-data.html [ ^ ]

try like this it will definitly helps you...all the best.
http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html[^]

这篇关于在Gridview中编辑，删除..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！