Problem with inserting data in GRIDVIEW

Hoang Nguyen

13y2.5k.NET

I created a Gridview. I could insert, delete, update data in Gridview

Load gridview..delete and update are OK

but when I inserted data ..load gridview...no change facing

I opened SQL SERVER then I saw data that I inserted before ....after that I clicked refresh but still unchange.......:( data loop in table in database

tell me..what's this problem?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vimlesh Mishra13y ago

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

<title>GRIDINSERTUPDATEDELETEtitle>

<style type="text/css">

.Gridview

{

font-family:Verdana;

font-size:10pt;

font-weight:normal;

color:black;

}

style>

head>

<body>

<form id="form1" runat="server">

<div>

<asp:GridView ID="gvDetails" DataKeyNames="UserId,UserName" runat="server"

AutoGenerateColumns="false" CssClass="Gridview" HeaderStyle-BackColor="#61A6F8"

ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White"

onrowcancelingedit="gvDetails_RowCancelingEdit"

onrowdeleting="gvDetails_RowDeleting" onrowediting="gvDetails_RowEditing"

onrowupdating="gvDetails_RowUpdating"

onrowcommand="gvDetails_RowCommand">

<Columns>

<asp:TemplateField>

<EditItemTemplate>

<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server" ImageUrl="~/Images/update.jpg" ToolTip="Update" Height="20px" Width="20px" />

<asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/Images/Cancel.jpg" ToolTip="Cancel" Height="20px" Width="20px" />

EditItemTemplate>

<ItemTemplate>

<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Edit.jpg" ToolTip="Edit" Height="20px" Width="20px" />

<asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server" ImageUrl="~/Images/delete.jpg" ToolTip="Delete" Height="20px" Width="20px" />

ItemTemplate>

<FooterTemplate>

<asp:ImageButton ID="imgbtnAdd" runat="server" ImageUrl="~/Images/AddNewitem.jpg" CommandName="AddNew" Width="30px" Height="30px" ToolTip="Add new User" ValidationGroup="validaiton" />

FooterTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="UserName">

<EditItemTemplate>

<asp:Label ID="lbleditusr" runat="server" Text='<%#Eval("Username") %>'/>

EditItemTemplate>

<ItemTemplate>

<asp:Label ID="lblitemUsr" runat="server" Text='<%#Eval("UserName") %>'/>

ItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtftrusrname" runat="server"/>

<asp:RequiredFieldValidator ID="rfvusername" runat="server" ControlToValidate="txtftrusrname" Text="*" ValidationGroup="validaiton"/>

FooterTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="City">

<EditItemTemplate>

<asp:TextBox ID="txtcity" runat="server" Text='<%#Eval("City") %>'/>

EditItemTemplate>

<ItemTemplate>

<asp:Label ID="lblcity" runat="server" Text='<%#Eval("City") %>'/>

ItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtftrcity" runat="server"/>

<asp:RequiredFieldValidator ID="rfvcity" runat="server" ControlToValidate="txtftrcity" Text="*" ValidationGroup="validaiton"/>

FooterTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Designation">

<EditItemTemplate>

<asp:TextBox ID="txtDesg" runat="server" Text='<%#Eval("Designation") %>'/>

EditItemTemplate>

<ItemTemplate>

<asp:Label ID="lblDesg" runat="server" Text='<%#Eval("Designation") %>'/>

ItemTemplate>

<FooterTemplate>

<asp:TextBox ID="txtftrDesignation" runat="server"/>

<asp:RequiredFieldValidator ID="rfvdesignation" runat="server" ControlToValidate="txtftrDesignation" Text="*" ValidationGroup="validaiton"/>

FooterTemplate>

asp:TemplateField>

Columns>

asp:GridView>

div>

<div>

<asp:Label ID="lblresult" runat="server">asp:Label>

div>

form>

body>

html>

use this coder.......

using System;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

SqlConnection con = new SqlConnection("Data Source=SystemXXX;Integrated Security=true;Initial Catalog=XXXX");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindEmployeeDetails();

}

}

protected void BindEmployeeDetails()

{

con.Open();

SqlCommand cmd = new SqlCommand("Select * from Employee_Details", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

con.Close();

if (ds.Tables[0].Rows.Count > 0)

{

gvDetails.DataSource = ds;

gvDetails.DataBind();

}

else

{

ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());

gvDetails.DataSource = ds;

gvDetails.DataBind();

int columncount = gvDetails.Rows[0].Cells.Count;

gvDetails.Rows[0].Cells.Clear();

gvDetails.Rows[0].Cells.Add(new TableCell());

gvDetails.Rows[0].Cells[0].ColumnSpan = columncount;

gvDetails.Rows[0].Cells[0].Text = "No Records Found";

}

}

protected void gvDetails_RowEditing(object sender, GridViewEditEventArgs e)

{

gvDetails.EditIndex = e.NewEditIndex;

BindEmployeeDetails();

}

protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());

string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();

TextBox txtcity = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtcity");

TextBox txtDesignation = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtDesg");

con.Open();

SqlCommand cmd = new SqlCommand("update Employee_Details set City='" + txtcity.Text + "',Designation='" + txtDesignation.Text + "' where UserId=" + userid, con);

cmd.ExecuteNonQuery();

con.Close();

lblresult.ForeColor = Color.Green;

lblresult.Text = username + " Details Updated successfully";

gvDetails.EditIndex = -1;

BindEmployeeDetails();

}

protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gvDetails.EditIndex = -1;

BindEmployeeDetails();

}

protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Values["UserId"].ToString());

string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();

con.Open();

SqlCommand cmd = new SqlCommand("delete from Employee_Details where UserId=" + userid, con);

int result = cmd.ExecuteNonQuery();

con.Close();

if (result == 1)

{

BindEmployeeDetails();

lblresult.ForeColor = Color.Red;

lblresult.Text = username + " details deleted successfully";

}

}

protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)

{

if(e.CommandName.Equals("AddNew"))

{

TextBox txtUsrname = (TextBox)gvDetails.FooterRow.FindControl("txtftrusrname");

TextBox txtCity = (TextBox)gvDetails.FooterRow.FindControl("txtftrcity");

TextBox txtDesgnation = (TextBox) gvDetails.FooterRow.FindControl("txtftrDesignation");

con.Open();

SqlCommand cmd =

new SqlCommand(

"insert into Employee_Details(UserName,City,Designation) values('" + txtUsrname.Text + "','" +

txtCity.Text + "','" + txtDesgnation.Text + "')", con);

int result= cmd.ExecuteNonQuery();

con.Close();

if(result==1)

{

BindEmployeeDetails();

lblresult.ForeColor = Color.Green;

lblresult.Text = txtUsrname.Text + " Details inserted successfully";

}

else

{

lblresult.ForeColor = Color.Red;

lblresult.Text = txtUsrname.Text + " Details not inserted";

}

}

}
Hoang Nguyen13y ago
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadData();
}
}

as

protected void Page_Load(object sender, EventArgs e)
{

LoadData();

}

I tried ...at this time, data can't be inserted into database.......
Vithal Wadje13y ago
try by replacing your code

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadData();
}
}

as

protected void Page_Load(object sender, EventArgs e)
{

LoadData();

}
Satyapriya Nayak13y ago
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

    Untitled Page





            DataKeyNames="VendorId"
        AllowPaging="True"
        CellPadding="3"
        OnPageIndexChanging="ResultGridView_PageIndexChanging"
        OnRowDeleting="ResultGridView_RowDeleting"
        OnRowEditing="ResultGridView_RowEditing"
            OnRowUpdating="ResultGridView_RowUpdating"
            OnRowCancelingEdit="ResultGridView_RowCancelingEdit" PageSize="5"
            BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
            CellSpacing="2" OnRowCommand="ResultGridView_RowCommand" AllowSorting="true"
            onsorting="ResultGridView_Sorting">

                                    ReadOnly="True" SortExpression="VendorId" />

































































































            onclick="btn_search_Click" />







using System;
using System.Configuration;
using System.Data;
using System.Linq;
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.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    //SqlConnection conn = new SqlConnection(connStr);
    SqlDataAdapter ad = new SqlDataAdapter();
    SqlCommand cmd = new SqlCommand();
    DataTable dataTable;
    SqlDataAdapter sqlda;
    DataSet ds;
    string str;
    protected void Page_Load(object sender, EventArgs e)
    {
        Session["sortBy"] = null;
        if (!IsPostBack)
        {
            FillVendorGrid();
        }
    }
    private void FillVendorGrid()
    {
        SqlConnection conn = new SqlConnection(connStr);
        dataTable = new DataTable();
        cmd.Connection = conn;
        cmd.CommandText = "SELECT * FROM Vendor";
        ad = new SqlDataAdapter(cmd);
        ad.Fill(dataTable);
        ResultGridView.DataSource = dataTable;
        ResultGridView.DataBind();

    }

    protected void ResultGridView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        ResultGridView.EditIndex = e.NewEditIndex;
        FillVendorGrid();
    }

    protected void ResultGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        ResultGridView.PageIndex = e.NewPageIndex;
        FillVendorGrid();
    }

    protected void ResultGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlConnection conn = new SqlConnection(connStr);
        cmd.Connection = conn;
        cmd.CommandText = "DELETE FROM Vendor WHERE VendorId='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'";
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
        FillVendorGrid();

    }

    protected void ResultGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox txtFName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtFName");
        TextBox txtLName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtLName");
        TextBox txtCity = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtCity");
        TextBox txtState = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtState");
        TextBox txtCountry = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtCountry");
        TextBox txtDescription = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtDescription");

        SqlConnection conn = new SqlConnection(connStr);
        cmd.Connection = conn;
        cmd.CommandText = "UPDATE Vendor SET VendorFName ='" + txtFName.Text + "',VendorLName ='" + txtLName.Text + "',VendorCity ='" + txtCity.Text + "',VendorState ='" + txtState.Text + "',VendorCountry ='" + txtCountry.Text + "',VendorDescription ='" + txtDescription.Text + "'   WHERE VendorId='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'";
        conn.Open();
        cmd.ExecuteNonQuery();
        ResultGridView.EditIndex = -1;
        FillVendorGrid();
        conn.Close();

    }

    protected void ResultGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        ResultGridView.EditIndex = -1;
        FillVendorGrid();

    }

    protected void ResultGridView_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("AddNew"))
        {

            TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl("txtFName1");
            TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl("txtLName1");
            TextBox txtCity = (TextBox)ResultGridView.FooterRow.FindControl("txtCity1");
            TextBox txtState = (TextBox)ResultGridView.FooterRow.FindControl("txtState1");
            TextBox txtCountry = (TextBox)ResultGridView.FooterRow.FindControl("txtCountry1");
            TextBox txtDescription = (TextBox)ResultGridView.FooterRow.FindControl("txtDescription1");
            SqlConnection conn = new SqlConnection(connStr);
            cmd.Connection = conn;
            cmd.CommandText = "INSERT INTO Vendor(VendorFName, VendorLName,VendorCity,VendorState,VendorCountry,VendorDescription) Values('" + txtFName.Text + "', '" + txtLName.Text + "', '" + txtCity.Text + "', '" + txtState.Text + "', '" + txtCountry.Text + "' , '" + txtDescription.Text + "')";
            conn.Open();
            cmd.ExecuteNonQuery();
            FillVendorGrid();
            conn.Close();
        }
    }
    protected void btn_search_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(connStr);
        conn.Open();
        str = "select * from Vendor where VendorFName like '" + TextBox1.Text + "%'";
        cmd = new SqlCommand(str, conn);
        sqlda = new SqlDataAdapter(cmd);
        ds = new DataSet();
        sqlda.Fill(ds, "Vendor");
        conn.Close();

        ResultGridView.DataSource = ds;
        ResultGridView.DataMember = "Vendor";
        ResultGridView.DataBind();

    }
    protected void ResultGridView_Sorting(object sender, GridViewSortEventArgs e)
    {
        Session["sortBy"] = e.SortExpression;
        FillVendorGrid();
    }
}
Hoang Nguyen13y ago
Problem with inserting data...Although I inserted data into DATABASE successfully..but I couldn't see that data - data that I've just inserted - in gridview....I made all ways...refresh WEBSITE but I still couldn't see...even though I used Bind gridview Method - LoadData()

I realized when I refresh page many times....I opened SQL SERVER again... that data inserted many times in database

example:
ID Name
1          data
2          data
3          data
4          data
...          ..

here is my source code....
download here:

http://www.mediafire.com/?76tlf1ge545frr6
Vithal Wadje13y ago
code is ok, just expalin about problem in detail with profesional gramatical sentences becaue what you want not one understand from above your question
Hoang Nguyen13y ago
public partial class _Default : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCon"].ConnectionString);

SqlCommand cmd = new SqlCommand();

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadData();
}
}

public int MaSPMax()
{
int Ma = 0;
string strSQL = "SELECT MASANPHAM FROM SANPHAM WHERE MASANPHAM >= ALL(SELECT MASANPHAM FROM SANPHAM)";
conn.Open();
SqlCommand cmd = new SqlCommand(strSQL, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{

Ma = int.Parse(dr["MaSanPham"].ToString());
}
conn.Close();
return Ma;
}

public DataTable LayDanhSachSP()
{

DataTable dt = new DataTable();
string strSQL;
SqlConnection myConn = conn;

strSQL = "SELECT * From SanPham s, LoaiMatHang l WHERE s.MaMatHang = l.MaMatHang ORDER BY MaSanPham DESC";

try
{
myConn.Open();

SqlDataAdapter da = new SqlDataAdapter(strSQL, myConn);

da.Fill(dt);

myConn.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return dt;
}

public void LoadData()
{
gvSanPham.DataSource = LayDanhSachSP();
gvSanPham.DataBind();
}

protected void gvSanPham_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvSanPham.PageIndex = e.NewPageIndex;
LoadData();
}

protected void gvSanPham_RowDeleting(object sender, GridViewDeleteEventArgs e)
{

cmd.Connection = conn;
cmd.CommandText = "DELETE FROM SanPham WHERE MaSanPham= " + int.Parse(gvSanPham.DataKeys[e.RowIndex].Values[0].ToString()) + "";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
LoadData();
}

protected void gvSanPham_RowEditing(object sender, GridViewEditEventArgs e)
{
gvSanPham.EditIndex = e.NewEditIndex;
DataBind();
}

protected void gvSanPham_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtTen = (TextBox)gvSanPham.Rows[e.RowIndex].FindControl("txtTen");
TextBox txtGia = (TextBox)gvSanPham.Rows[e.RowIndex].FindControl("txtGia");

cmd.Connection = conn;
cmd.CommandText = "UPDATE SanPham SET TenSanPham ='" + txtTen.Text + "',Gia =" + txtGia.Text + " WHERE MaSanPham=" + int.Parse(gvSanPham.DataKeys[e.RowIndex].Values[0].ToString()) + "";
conn.Open();
cmd.ExecuteNonQuery();
gvSanPham.EditIndex = -1;
conn.Close();
LoadData();

}

protected void gvSanPham_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gvSanPham.EditIndex = -1;
DataBind();
}

protected void gvSanPham_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("AddNew"))
{
TextBox txtTen = (TextBox)gvSanPham.FooterRow.FindControl("txtTen_Add");
TextBox txtGia = (TextBox)gvSanPham.FooterRow.FindControl("txtGia_Add");
string strTen = txtTen.Text.ToString();
string strGia = txtGia.Text.ToString();
if (strGia == "" || strTen == "")
{

}
else
{
string strSQL = "INSERT INTO SanPham(TenSanPham,Gia) Values('" + strTen + "'," + long.Parse(strGia) + ") ";
cmd = new SqlCommand(strSQL, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
this.DataBind();
LoadData();

}



}
}
}