Database not updating: no errors

[rekhashanmugam]

Hi,

In the below code its not showing any error but its not updating:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
 
public partial class VendorDetails : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        gridViewDataBind();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Redirect("AddDetails.aspx");
    }
    //protected void gvVendor_RowCancellingEdit(object sender, GridViewCancelEditEventArgs e)
    //{
    //    gvVendor.EditIndex = -1;
    //}
    protected void gridViewDataBind()
    {
        string strcon = System.Configuration.ConfigurationManager.ConnectionStrings["VendorNewConnectionString"].ConnectionString;
        SqlConnection Objcon = new SqlConnection(strcon);
        //DataSet Questions = new DataSet();                      
        DataTable dtGrid = new DataTable();
        SqlDataAdapter da;
        Objcon.Open();
        SqlCommand oCmd = new SqlCommand("gridSelect", Objcon);
        oCmd.CommandType = CommandType.StoredProcedure;
        da = new SqlDataAdapter(oCmd);
        da.Fill(dtGrid);
        Objcon.Close();
        gview.DataSource = dtGrid;
        gview.DataBind();
    }
 
 
 
    //protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    //{
 
    //}
 
    //protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    //{
    //    gvVendor.EditIndex = e.NewEditIndex;
    //}
 
    protected void gview_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int rowindex = e.RowIndex;
 
        TextBox TextBox1 = new TextBox();
        TextBox1 = (TextBox)gview.Rows[rowindex].FindControl("txtaddress1");
        string address1 = TextBox1.Text;
 
        TextBox1 = (TextBox)gview.Rows[rowindex].FindControl("txtaddress2");
        string address2 = TextBox1.Text;
 
        TextBox1 = (TextBox)gview.Rows[rowindex].FindControl("txtVendorName");
        string VendorName = TextBox1.Text;
 
        TextBox1 = (TextBox)gview.Rows[rowindex].FindControl("txtAnnualrevenue");
        int Annualrevenue = Convert.ToInt32(TextBox1.Text.ToString());
 
        TextBox1 = (TextBox)gview.Rows[rowindex].FindControl("txtEmailId");
        string EmailId = TextBox1.Text;
 
        TextBox1 = (TextBox)gview.Rows[rowindex].FindControl("txtWebsite");
        string Website = TextBox1.Text;
 
        TextBox1 = (TextBox)gview.Rows[rowindex].FindControl("txtVendorSince");
        DateTime VendorSince = Convert.ToDateTime(TextBox1.Text.ToString());
 
        Label lblVendor = (Label)gview.Rows[rowindex].FindControl("lblVendorId");
        int iVendorID = Convert.ToInt32(lblVendor.Text.ToString());
 
        SqlConnection Objcon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["VendorNewConnectionString"].ConnectionString);
        Objcon.Open();
        SqlCommand oCmd = new SqlCommand("sp_UpdateGrid", Objcon);
 
        oCmd.Parameters.AddWithValue("@VendorName", VendorName);
        oCmd.Parameters.AddWithValue("@Email", EmailId);
        oCmd.Parameters.AddWithValue("@Website", Website);
        oCmd.Parameters.AddWithValue("@Add1", address1);
        oCmd.Parameters.AddWithValue("@Add2", address2);
        oCmd.Parameters.AddWithValue("@VendorSince", VendorSince);
        oCmd.Parameters.AddWithValue("@AnnRev", Annualrevenue);
        oCmd.Parameters.AddWithValue("@VID", iVendorID);
 
        oCmd.CommandType = CommandType.StoredProcedure;
        oCmd.ExecuteNonQuery();
        Response.Write("successfully updated");
        Objcon.Close();
        gridViewDataBind();
        gview.EditIndex = -1;
    }
 
    protected void gview_RowEditing(object sender, GridViewEditEventArgs e)
    {
       gview.EditIndex = e.NewEditIndex;
    }
 
    protected void gview_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gview.EditIndex = -1;
    }
}
 

[Rabbit]

What's not updating?