i can not edit update delete in gridview in asp.net
data is not update and delete for my table so please help me
cs page
using System;
using System.Collections;
using System.Configuration;
using System.Data;
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.Data.SqlClient;
public partial class thakyou : System.Web.UI.Page
{
string connString = ConfigurationManager.ConnectionStrings["SairajDBConString"].ToString().Trim();
public object UserName { get; set; }
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
}
protected void Button3_Click(object sender, EventArgs e)
{
string connString = ConfigurationManager.ConnectionStrings["SairajDBConString"].ToString().Trim();
SqlConnection con = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("Select [UserName],[Emailid],[Password],[Birthday],[MobileNo],[Location]from [sairaj];", con);
try
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataTable sairaj = new DataTable();
sda.Fill(sairaj);
gridview1.DataSource = sairaj;
gridview1.DataBind();
}
catch (Exception)
{
}
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("Registrationpage.aspx");
}
protected void btndel_Click1(object sender, EventArgs e)
{
string connString = ConfigurationManager.ConnectionStrings["SairajDBConString"].ToString().Trim();
SqlConnection con = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("delete sairaj where UserName=@username,Emailid=@emailid,Password=@password,Birthday=@birthday,Location=@location", con);
try
{
con.Open();
cmd.Parameters.AddWithValue("@username", UserName);
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
}
}
protected void gridview1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gridview1.EditIndex = -1;
gridview1.DataSource = sairaj;
gridview1.DataBind();
}
protected void gridview1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = (GridViewRow)gridview1.Rows[e.RowIndex];
Label lbldeleteID = (Label)row.FindControl("lblid");
}
protected void gridview1_RowEditing(object sender, GridViewEditEventArgs e)
{
gridview1.EditIndex = e.NewEditIndex;
DataBind();
}
protected void gridview1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
DataTable dt = (DataTable)Session["sairaj"];
GridViewRow row = gridview1.Rows[e.RowIndex];
string Username = (gridview1.Rows[e.RowIndex].Cells[2]).Text;
string Emailid = (gridview1.Rows[e.RowIndex].Cells[3]).Text;
string Password = (gridview1.Rows[e.RowIndex].Cells[4]).Text;
string Birthday = (gridview1.Rows[e.RowIndex].Cells[5]).Text;
string Mobileno = (gridview1.Rows[e.RowIndex].Cells[6]).Text;
string Location = (gridview1.Rows[e.RowIndex].Cells[7]).Text;
gridview1.EditIndex = -1;
DataBind();
}
private void Deletesairaj(int sairaj)
{
string connString = ConfigurationManager.ConnectionStrings["SairajDBConString"].ToString().Trim();
SqlConnection con = new SqlConnection(connString);
{
string query = "DELETE FROM sairaj WHERE sairaj=" + sairaj + "";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.Parameters.AddWithValue("@username", UserName);
cmd.ExecuteNonQuery();
con.Close();
}
}
private void Updatesairaj(int sairaj, string Username, string Emailid, string Password, string Birthday, string MobileNo, string Location)
{
string connString = ConfigurationManager.ConnectionStrings["SairajDBConString"].ToString().Trim();
SqlConnection con = new SqlConnection(connString);
{
string query = "UPDATE sairaj SET UserName='" + Username + "', Emailid='" + Emailid + "', Passwprd='" + Password + "', Birthday='" + Birthday + "', MobileNo='" + MobileNo + "', Location='" + Location + " WHERE sairaj=" + sairaj + "";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.Parameters.AddWithValue("@username", UserName);
cmd.ExecuteNonQuery();
con.Close();
}
}
public object sairaj { get; set; }
}
aspx page
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="thankyou.aspx.cs" Inherits="thakyou" %>
ImageUrl="~/thankyou-for-registration-confirmation-temp-eng.png" Width="759px" /> | |
Text="Display all Detalis" Width="119px" style="text-align: center" /> | Text="Registration page" style="margin-left: 0px" /> |
DataKeyNames="sairaj" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3"> ShowEditButton="True" ShowHeader="True" /> |
SELECT TOP 1000 [UserName]
,[Emailid]
,[Password]
,[Birthday]
,[MobileNo]
,[Location]
FROM [sairaj].[dbo].[sairaj]
7 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SAIRAJ MOREPosted Oct 11, 2016, 11:40 PM
Guest UserPosted Oct 11, 2016, 1:14 AM
Atul PatilPosted Oct 10, 2016, 2:38 AM
SAIRAJ MOREPosted Oct 10, 2016, 12:23 AM
Incorrect syntax near '='.
Munesh SharmaPosted Oct 8, 2016, 2:39 AM
Lokesh KumarPosted Oct 7, 2016, 9:49 AM
Midhun TpPosted Oct 7, 2016, 6:58 AM