I am trying to make update row database using repeater

 I am trying to make update row database using repeater but i Fail on itemcommand  event is not working

 

 

 

My C# Code:- 

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Security;
using System.IO;

public partial class adminpanel_adminpages_update : System.Web.UI.Page
{
//SqlConnection admin_con;
SqlCommand cmd;
string rom_detail_insert_con = ConfigurationManager.ConnectionStrings["rom_con"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack)
{
repeater();
}

}

public void repeater()
{
SqlConnection con = new SqlConnection(rom_detail_insert_con);
SqlCommand cmd = new SqlCommand("select * from rom_details where rom_id=" + Request.QueryString["rom_id"] + "", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet dt = new DataSet();
da.Fill(dt);
Repeater1.DataSource = dt.Tables[0];
Repeater1.DataBind();
}


protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
SqlConnection con = new SqlConnection(rom_detail_insert_con);
if (e.CommandName == "Edit")
{
//string id = ((Label)e.Item.FindControl("Label1")).Text;
string id = Request.QueryString["rom_id"];
DropDownList ddlType = (DropDownList)e.Item.FindControl("category_ddl");

DropDownList brand_ddl = (DropDownList)e.Item.FindControl("brand_ddl");
string title = ((TextBox)e.Item.FindControl("admin_txtbox_title")).Text;
string model_name = ((TextBox)e.Item.FindControl("admin_txtbox_model_name")).Text;
string model_no = ((TextBox)e.Item.FindControl("admin_txtbox_model_no")).Text;
string rom_name = ((TextBox)e.Item.FindControl("admin_txtbox_rom_name")).Text;
string rom_version = ((TextBox)e.Item.FindControl("admin_txtbox_rom_version")).Text;
string credit = ((TextBox)e.Item.FindControl("admin_txtbox_made_by")).Text;
string rom_feature = ((TextBox)e.Item.FindControl("admin_txtbox_rom_feature")).Text;
string rom_install = ((TextBox)e.Item.FindControl("admin_txtbox_rom_installation")).Text;
string dt1 = ((TextBox)e.Item.FindControl("admin_txtbox_download_title1")).Text;
string dl1 = ((TextBox)e.Item.FindControl("admin_txtbox_download_link1")).Text;
string dt2 = ((TextBox)e.Item.FindControl("admin_txtbox_download_title2")).Text;
string dl2 = ((TextBox)e.Item.FindControl("admin_txtbox_download_link2")).Text;
string dt3 = ((TextBox)e.Item.FindControl("admin_txtbox_download_title3")).Text;
string dl3 = ((TextBox)e.Item.FindControl("admin_txtbox_download_link3")).Text;
string dt4 = ((TextBox)e.Item.FindControl("admin_txtbox_download_title4")).Text;
string dl4 = ((TextBox)e.Item.FindControl("admin_txtbox_download_link4")).Text;

string update_query = "update rom_details set "+
"category=@category,"+
"rom_title=@rom_title,"+
"brand_name=@brand_name,"+
"model_name=@model_name,"+
"model_no=@model_no,"+
"rom_name=@rom_name,"+
"rom_version=@rom_version,"+
"rom_made_by=@rom_made_by,"+
"rom_features=@rom_features,"+
"rom_install=@rom_installation,"+
"download_title1=@download_title1,"+
"download_link1=@download_link1,"+
"download_title2=@download_title2,"+
"download_link2=@download_link2,"+
"download_title3=@download_title3,"+
"download_link3=@download_link3,"+
"download_title4=@download_title4,"+
"download_link4=@download_link4 "+
"where rom_id=@Id";
cmd = new SqlCommand(update_query, con);
cmd.Parameters.AddWithValue("@category", ddlType);
cmd.Parameters.AddWithValue("@rom_title", title);
cmd.Parameters.AddWithValue("@brand_name", brand_ddl);
cmd.Parameters.AddWithValue("@model_name", model_name);
cmd.Parameters.AddWithValue("@model_no", model_no);
cmd.Parameters.AddWithValue("@rom_name", rom_name);
cmd.Parameters.AddWithValue("@rom_version", rom_version);
cmd.Parameters.AddWithValue("@rom_made_by", credit);
cmd.Parameters.AddWithValue("@rom_features", rom_feature);
cmd.Parameters.AddWithValue("@rom_installation", rom_install);
cmd.Parameters.AddWithValue("@download_title1", dt1);
cmd.Parameters.AddWithValue("@download_link1", dl1);
cmd.Parameters.AddWithValue("@download_title2", dt2);
cmd.Parameters.AddWithValue("@download_link2", dl2);
cmd.Parameters.AddWithValue("@download_title3", dt3);
cmd.Parameters.AddWithValue("@download_link3", dl3);
cmd.Parameters.AddWithValue("@download_title4", dt4);
cmd.Parameters.AddWithValue("@download_link4", dl4);
cmd.Parameters.AddWithValue("@Id", e.CommandArgument);
//admin_con.Open();
//cmd.ExecuteNonQuery();
//admin_con.Close();


//SqlDataAdapter da = new SqlDataAdapter(adp);
//DataTable dt = new DataTable();
//da.Fill(dt);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
repeater();
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
DropDownList ddlType = (DropDownList)e.Item.FindControl("category_ddl");
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
SqlConnection con = new SqlConnection(rom_detail_insert_con);
SqlCommand cmd = new SqlCommand("select * from rom_details where rom_id=" + Request.QueryString["rom_id"] + "", con);
SqlDataAdapter SqlAd1 = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
SqlAd1.Fill(dt);
ddlType.DataTextField = "category";
ddlType.DataSource = dt;
ddlType.DataBind();

ddlType.SelectedValue = DataBinder.Eval(e.Item.DataItem, "category").ToString();
}
DropDownList brand_ddl = (DropDownList)e.Item.FindControl("brand_ddl");
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
SqlConnection con = new SqlConnection(rom_detail_insert_con);
SqlCommand cmd = new SqlCommand("select * from rom_details where rom_id=" + Request.QueryString["rom_id"] + "", con);
SqlDataAdapter SqlAd1 = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
SqlAd1.Fill(dt);
brand_ddl.DataTextField = "brand_name";
brand_ddl.DataSource = dt;
brand_ddl.DataBind();

brand_ddl.SelectedValue = DataBinder.Eval(e.Item.DataItem, "brand_name").ToString();
}
}
}