ASP.NET - Urgent

Hi frndz

iam doing project in asp.net 2.0,c#. In my project i have to add,update delete the products in admin page. when i add the product it works gud. but when i update  the products and give submit the product names didnt get update . plz help very urgent.

My fields in database are:

1.id
2.reference
3.manufacturer
4.model
5.year
6.colors
7.format
8.description
9.photo
10.photo1

Below is my code:

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

public partial class Admin_edit_stock : System.Web.UI.Page, System.Web.UI.ICallbackEventHandler
{
    int pID;
    connection con = new connection();
    protected void Page_Load(object sender, EventArgs e)
    {
      if (Session["admin"] == null)
      {
        Response.Redirect("default.aspx");
      }
      String cbReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "ReceiveServerData", "context");
      String callbackScript;
      callbackScript = "function CallServer(arg, context)" + "{ " + cbReference + ";}";
      Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "CallServer", callbackScript, true);
      GridView1load();

    }
    public String GetCallbackResult()
    {
      return "";
    }
    public void RaiseCallbackEvent(String eventArgument)
    {

      string ID = eventArgument.ToString();
      pID = Convert.ToInt32(ID);
      delete();
    }
    protected void gridviewchanged(object sender, GridViewPageEventArgs e)
    {
      GridView1.PageIndex = e.NewPageIndex;
      GridView1.DataBind();
    }
    public void GridView1load()
    {
      SqlDataAdapter da = new SqlDataAdapter("select id,reference,manufacturer,model,year,colors,format,description,photo,photo1 from tbl_saffire", con.sqlconnection());
      DataSet ds = new DataSet();
      da.Fill(ds, "tbl_saffire");
      GridView1.DataSource = ds;
      GridView1.DataBind();
    }
    protected void delete()
    {
      SqlCommand cmd = new SqlCommand("delete from tbl_saffire where id='" + pID + "'", con.sqlconnection());
      cmd.ExecuteReader();
      GridView1load();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      SqlCommand cmd2 = new SqlCommand("select max(id) id from tbl_saffire", con.sqlconnection());
      SqlDataReader dr = cmd2.ExecuteReader();
      if (dr.Read())
      {
        lbl_id.Text = dr.GetValue(0).ToString();
      }
      if (FileUpload2.FileName == "")
      {
        lbl_path.Text = "unknown.jpg";
      }
      else
      {
        lbl_path.Text = lbl_maxid.Text + FileUpload2.FileName;
        FileUpload2.PostedFile.SaveAs(Server.MapPath("~/Admin/upload/") + lbl_path.Text);
      }
      if (FileUpload1.FileName == "")
      {
        lbl_path1.Text = "unknown.jpg";
      }
      else
      {
        lbl_path1.Text = lbl_maxid.Text + FileUpload1.FileName;
        FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Admin/upload/") + lbl_path1.Text);
      }
      SqlCommand cmd = new SqlCommand("update tbl_saffire set reference='"
       + Txt_mnfrs.Text + "',manufacturer='"
        + Txt_model.Text + "',model='"
        + Txt_year.Text + "',year='"
        + Txt_color.Text + "',colors='"
        + Txt_size.Text + "',format='"
        + txt_desc.Text + "',description='"
        + lbl_path.Text + "',photo='"
      + lbl_path1.Text + "'where id='" + lbl_id.Text + "'", con.sqlconnection());
      cmd.ExecuteNonQuery();
      Response.Redirect("edit_stock.aspx");
      lbl_msg.Text = "Record Updated Sucessfully!";
      txt_ref.Text = "";
      Txt_mnfrs.Text = "";
      Txt_model.Text = "";
      Txt_year.Text = "";
      Txt_color.Text = "";
      Txt_size.Text = "";
      txt_desc.Text = "";      
      lbl_path.Text = "";
      lbl_path1.Text = "";
    }
    protected void update(object sender, EventArgs e)
    {
      LinkButton lik = (LinkButton)sender;
      GridViewRow di = (GridViewRow)lik.Parent.Parent;
      HiddenField hidden = (HiddenField)di.FindControl("hidden");
      lbl_id.Text = hidden.Value;      
      SqlCommand cmd1 = new SqlCommand("select id,reference,manufacturer,model,year,colors,format,description,photo,photo1 from tbl_saffire where id='" + lbl_id.Text + "'", con.sqlconnection());
      SqlDataReader dr = cmd1.ExecuteReader();
      if (dr.Read())
      {

        lbl_id.Text = dr.GetValue(0).ToString();
        txt_ref.Text = dr.GetValue(1).ToString();
        Txt_mnfrs.Text = dr.GetValue(2).ToString();
        Txt_model.Text = dr.GetValue(3).ToString();
        Txt_year.Text = dr.GetValue(4).ToString();
        Txt_color.Text = dr.GetValue(5).ToString();
        Txt_size.Text = dr.GetValue(6).ToString();
        txt_desc.Text = dr.GetValue(7).ToString();
        lbl_path.Text = dr.GetValue(8).ToString();
        lbl_path1.Text = dr.GetValue(9).ToString();
    
        
        

      }
    

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

    }
}


Help me frndz its very urgent!

Hello Friend.

I can not see anything wrong in your code, here you can put the breakpoint on update command and check if you are getting any exception, and most important execute your block of code in try catch block.

Second run your query in SSMS/SQLWB and check what is the result it produce.

Let me know in case of any error or exception

Regards
D

Where do you call the below method.

protected void update(object sender, EventArgs e)

I am not seeing it anywhere ?



And also in the same method I can see that you are only fetching the record and not updating anything ?

SqlCommand cmd1 = new SqlCommand("select id,reference,manufacturer,model,year,colors,format,description,photo,photo1 from tbl_saffire where id='" + lbl_id.Text + "'", con.sqlconnection());
    SqlDataReader dr = cmd1.ExecuteReader();
    if (dr.Read())
    {

      lbl_id.Text = dr.GetValue(0).ToString();
      txt_ref.Text = dr.GetValue(1).ToString();
      Txt_mnfrs.Text = dr.GetValue(2).ToString();

HI frnd

Now it is k but , wherever i update the products it updating in a last row only. it cannot upload in a correct row. can u help me

You can mention an unique id in your where condition to update a particular row.

Regards
D