mahdi_2490
یک شنبه 05 آذر 1391, 19:31 عصر
سلام من می خوام اطلاعات گرید ویو را در حذف کنم اول یه query حذف براش نوشتم و چون اطلاعات در بانک حذف می شه ولی در گرید ویو نشون نمی ده گرید ویو را در page load بایند کردم ولی روی خط بایندینگ خطا می ده (GridView1.DataBind) مشکل کجاس ؟
با تشکر
using System.Data;
using System.Data.SqlClient;
namespace WebApplication5
{
public partial class managetopic : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "remove")
{
int id = Convert.ToInt32(e.CommandArgument);
SqlConnection con = new SqlConnection("Server = laptap-PC; Database = mahdi; Trusted_Connection = True");
string query = "delete from topic where id=@id";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", id);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
BindGridView();
}
}
protected void BindGridView()
{
SqlConnection con = new SqlConnection("Server = laptap-PC; Database = mahdi; Trusted_Connection = True");
string query = "select * from topic";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader SqlDataSource1 = cmd.ExecuteReader();
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
con.Close();
}
}
متن خطا
{"Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition."}
95575
با تشکر
using System.Data;
using System.Data.SqlClient;
namespace WebApplication5
{
public partial class managetopic : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridView();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "remove")
{
int id = Convert.ToInt32(e.CommandArgument);
SqlConnection con = new SqlConnection("Server = laptap-PC; Database = mahdi; Trusted_Connection = True");
string query = "delete from topic where id=@id";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", id);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
BindGridView();
}
}
protected void BindGridView()
{
SqlConnection con = new SqlConnection("Server = laptap-PC; Database = mahdi; Trusted_Connection = True");
string query = "select * from topic";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader SqlDataSource1 = cmd.ExecuteReader();
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
con.Close();
}
}
متن خطا
{"Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition."}
95575