User-218090889 posted
I have in my GridView some dynamic created buttons inside custom template. When I click on any of the buttons the entire button in the GridView disappears and the page will not fire. I guess all the dynamic created buttons are losing view state on postback.
Please how do I put my code to have the buttons maintain View state and get fired?
Below is some of my codes ( item 1 and 2 below are working very well)
1) The page load.
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!object.Equals(Session["UserId"], null))
{
//**my connection and sql query here;
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
2) GridView Rowdatabond
public void GridViewUserLots_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
PlaceHolder ph = (PlaceHolder)e.Row.FindControl("ph1");
Button bt1 = new Button();
bt1.ID = "GameCall" ;
bt1.Text = "Game Call";
bt1.CommandName = "GameCall";
bt1.EnableViewState = true;
ph.Controls.Clear();
ph.Controls.Add(bt1);
}
3) GridView RowCommand
public void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "GameCall")
{
Button bt1 = (Button)e.CommandSource;
GridViewRow row = (GridViewRow)bt1.NamingContainer;
Label CallNote = (Label)row.FindControl("Label1");
TextBox PlayerID = (TextBox)row.FindControl("PlayerId");
string PlayerId = PlayerID.Text;
if (bt1 != null)
{
string ID1 = null;
string ID2 = null;
string ID3 = null;
string connetionString = null;
SqlConnection con;
SqlCommand cmdd;
string sql = null;
SqlDataReader rdr;
connetionString = "Data Source=Myserver;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False";
sql = "SELECT (Id) FROM Table_A WHERE (ABS(CAST((BINARY_CHECKSUM(Id, NEWID())) as int))% 100) < 8 ";
con = new SqlConnection(connetionString);
try
{
con.Open();
cmdd = new SqlCommand(sql, con);
rdr = cmdd.ExecuteReader();
int i = 0;
while (rdr.Read())
{
switch (i)
{
case 0:
ID1 = Convert.ToString(rdr.GetValue(0));
break;
case 1:
ID2 = Convert.ToString(rdr.GetValue(0));
break;
case 2:
ID3 = Convert.ToString(rdr.GetValue(0));
break;
}
i += 1;
}
rdr.Close();
cmdd.Dispose();
}
finally
{
con.Close();
}
string GameCalls = "INSERT INTO [Table_B] (PlayerId,ScID) VALUES('" + PlayerId + "','" + ID1 + "'),('" + PlayerId + "','" + ID2 + "'),('" +
PlayerId + "','" + ID3 + "')";
dbClass.ConnectDataBaseToInsert(GameCalls);
} CallNote.Text = "Game Call has been sent";
//ph.Controls.Clear();
Response.Redirect("~/GamePage.aspx?Id=" + Session["UserId"].ToString());
};
