ASP.NET PageIndexChanging Event

Bineesh Viswanath

Sir, I am in PageIndexChanging Event in asp.net.

I am using this within a Multiview State.

Here is the view1 Page:-

And the View2 Page:-

The task in which i need your help is PageIndexChanging Event.

you can see the link button Select in the gridview.

when I select one row, I need to go to the view1 page. I did the coding for this function.

My task is when I click the movieName Hollowman, I want to display data in the concerned fields.

15 Replies

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

Sanjeeb Lenka13y ago
Accepted answer
i modified your aspx and code just check that:

in grid design write this code:

                            BorderStyle="Solid" DataKeyNames="movieId" OnRowCommand="dgvMovie_RowCommand"
                        AutoGenerateColumns="false">
























                                                                            runat="server">Select




                                                                            CommandName="Delete">Delete



                                                    VerticalAlign="Middle" />


in .cs write this code in rowcommand:

protected void dgvMovie_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Select")
            {
                int id = Convert.ToInt32(e.CommandArgument);
                if (sqlCon.State == ConnectionState.Closed)
                {
                    sqlCon.Open();
                }
                SqlDataAdapter sqlDa = new SqlDataAdapter("select * from tbl_Movie where movieid='"+id+"'", sqlCon);
                DataSet sqlDS = new DataSet();
                sqlDa.Fill(sqlDS);
                txtMovieName.Text = sqlDS.Tables[0].Rows[0]["movieName"].ToString();
                cmbLanguage.SelectedValue = sqlDS.Tables[0].Rows[0]["Languge"].ToString();
                cmbGenre.SelectedValue = sqlDS.Tables[0].Rows[0]["Genre"].ToString();
                cmbYear.SelectedValue = sqlDS.Tables[0].Rows[0]["movieYear"].ToString();
            }

        }
Sanjeeb Lenka13y ago
hi,

check this code:

in aspx grid:
                        BorderStyle="Solid" DataKeyNames="movieId" OnRowCommand="dgvMovie_RowCommand"
                        AutoGenerateColumns="false" OnRowDeleting="dgvMovie_RowDeleting">

in .cs:

protected void dgvMovie_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int id = Convert.ToInt32(dgvMovie.DataKeys[e.RowIndex].Value);
            if (sqlCon.State == ConnectionState.Closed)
            {
                sqlCon.Open();
            }
            SqlCommand cmd = new SqlCommand("Delete from tbl_Movie where movieid='" + id + "'", sqlCon);
            cmd.ExecuteNonQuery();
            sqlCon.Close();
            GridFill();
        }
Bineesh Viswanath13y ago
Thank You Sanjeeb for helping mt to find output.

Now I want the RowDeleting event in this same program. Could you send me the code?
Sanjeeb Lenka13y ago
look this make the autogeneratedcolumn to false.

BorderStyle="Solid" DataKeyNames="movieId" OnRowCommand="dgvMovie_RowCommand"
AutoGenerateColumns="false">
Bineesh Viswanath13y ago
The code is working. But the Result is Doubled gridView.

Here is how it look like.

Please rectify this malfunction.
Iftikar Hussain13y ago
not able to find your page where you added the grid for the below screen shot
Bineesh Viswanath13y ago
Here is the complete code(with database)

Extract ZIP file and go through all codes.

and try to find the solution.
Sanjeeb Lenka13y ago
is it possible to attach the form here....
Iftikar Hussain13y ago
share the code for the first page. Have you used redirect or not?
Bineesh Viswanath13y ago
Sir, The function is still very far As I want to function the selectedIndexChanging Event.

The form would be look like when I press the link button:-

give me a solution for this.
Sanjeeb Lenka13y ago
hi bineesh,

So you given your screen shot its good . but if you share your code then only we can understand what you written and what to do.
Iftikar Hussain13y ago
yes. this is correct way to display the link text

Regards,
Iftikar
Bineesh Viswanath13y ago
Sir the code is created a link button.

now my form look like:-

now how can i go to view1 and display correspondent data in the fields?
Iftikar Hussain13y ago
Hi,
Please refer the below link

http://hightechnology.in/how-to-redirect-to-another-page-by-click-on-linkbutton-in-gridview/

Regards,
Iftikar
Sanjeeb Lenka13y ago
plz share your Aspx and .cs code so we can able to solve your problem