如何在gridview中使用deletecommand进行更新 [英] how to use deletecommand in gridview for updation

问题描述

我有3个网页。管理员，学生和老师。我在每个页面都使用了网格视图。我的表有一个列为'status'。它的默认值为0.我想在gridview中点击删除时将此值更新为1。我写了以下代码。但它不起作用。请帮助。



这是.aspx文件代码 -

   SelectCommand = SELECT * FROM [login] WHERE（[username] = @username）  
 DeleteCommand = UPDATE [login] SET [status] =  1  WHERE [id] = @ id   
 InsertCommand = INSERT INTO [登录]（[姓名]，[中名]，[姓]，[用户名]，[密码]，[联系方式]，[dob]，[电子邮件]，[地址]，[职业]，[ltype]）VALUES（ @ name，@ midname，@ hotame，@ username，@ password，@ contact，@ dob，@ email，@ address，@ occupation，@ ltype）
   UpdateCommand = UPDATE [login] SET [name] = @ name，[midname] = @midname，[surname] = @surname，[username] = @用户名，[密码] = @password，[联系方式] = @contact，[dob] = @ dob，[ema il] = @email，[地址] = @地址，[占用] = @occupation，[ltype] = @ltype WHERE [Id] = @Id  >  

这是我背后的代码 -

  protected   void  GridView1_RowDeleting（ object  sender ，GridViewDeleteEventArgs e）
 {
 SqlConnection con =  new  SqlConnection（  Data Source = SNEHAL-PC\SNEHAL1; Initial Catalog = TEMPRUJU; Integrated Security = True）; 
 SqlCommand cmd; SqlDataReader博士; 
 con.Open（）; 
 GridViewRow row = GridView1.Rows [e.RowIndex]; 
 cmd =  new  SqlCommand（ 更新登录set status = 1其中id =' + GridView1.DataKeys [e.RowIndex] .Value.ToString（）+  '，CON）; 
 dr = cmd.ExecuteReader（）; 
} 

解决方案

问题在于：dr = cmd.ExecuteReader（）;

使用这个int result = cmd.ExecuteNonQuery（）;



尝试这个...





LINK1

i have 3 web pages. admin,student and teacher. i have used grid view on each of this page.my table is having a column as 'status'.which is having default value 0. I want to update this value to 1 when i click on delete in gridview. I have written following code. But it is not working.pls help.

this is .aspx file code-

" SelectCommand="SELECT * FROM [login] WHERE ([username] = @username)"
 DeleteCommand="UPDATE [login] SET [status]= 1 WHERE [id]=@id" 
InsertCommand="INSERT INTO [login] ([name], [midname], [surname], [username], [password], [contact], [dob], [email], [address], [occupation], [ltype]) VALUES (@name, @midname, @surname, @username, @password, @contact, @dob, @email, @address, @occupation, @ltype)
" UpdateCommand="UPDATE [login] SET [name] = @name, [midname] = @midname, [surname] = @surname, [username] = @username, [password] = @password, [contact] = @contact, [dob] = @dob, [email] = @email, [address] = @address, [occupation] = @occupation, [ltype] = @ltype WHERE [Id] = @Id">

and this is my code behind-

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) 
{ 
SqlConnection con = new SqlConnection("Data Source=SNEHAL-PC\SNEHAL1;Initial Catalog=TEMPRUJU;Integrated Security=True");
 SqlCommand cmd; SqlDataReader dr;
 con.Open();
 GridViewRow row = GridView1.Rows[e.RowIndex];
 cmd=new SqlCommand("Update login set status=1 where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'",con); 
dr = cmd.ExecuteReader(); 
}

解决方案

problem is here : dr = cmd.ExecuteReader();
use this int result = cmd.ExecuteNonQuery();

try this...


link1

这篇关于如何在gridview中使用deletecommand进行更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！