DataView with deleting,editing and creation

Question

1.00/5 (1 vote)

See more:

ASP.NET

MVC4

i want to import data from database in a dataview but the hyperlink delete,edit and ceate does not work!!!!

Posted 7-Jan-13 22:25pm

medloyl1

Add a Solution

Comments

Garth J Lancaster 8-Jan-13 4:45am

Have you written any code ? how about providing the smallest code block that displays the errant behaviour, rather than a general 'x, y & z does not work'. What tests have you done, how do you reproduce the error for example ? Only you can supply this information - we cant read your mind or see what's running on your machine !

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ranjeet.waje · Answer 1 · 2013-01-08T00:28:00

I just giving you my solution...I hope it will help you..

In design page in grid view add

<asp:commandfield showeditbutton="True" headertext="Update" xmlns:asp="#unknown">

Then in .cs page

C#

protected void gvDeleteCh_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gvDeleteCh.EditIndex = e.NewEditIndex; 
        strinfo = "Select * from tblname"; // your query to data which u want to edit.
        LoadGrid1(strinfo);
    }

C#

protected void gvDeleteCh_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
       // Page.RegisterStartupScript("MY","function msgAlert()");
        try
        {
               try
                {
                    Ocon = new OracleConnection(OracleconnectionString);
                    Ocon.Open();
                    string Name = (((TextBox)gvDeleteCh.Rows[e.RowIndex].Cells[0].Controls[0]).Text.Trim());
                    string UID = (((TextBox)gvDeleteCh.Rows[e.RowIndex].Cells[1].Controls[0]).Text.Trim());
                    string ID = (((TextBox)gvDeleteCh.Rows[e.RowIndex].Cells[2].Controls[0]).Text.Trim());
                    string ISACTIVE = (((TextBox)gvDeleteCh.Rows[e.RowIndex].Cells[3].Controls[0]).Text.Trim());
                    string strSQuery = "update MASTER_TEST set Name='" + Name + "',"
     + "UID='"+UID+"',ID='" + ID + "',ISACTIVE='" + ISACTIVE + "' where UID='"+ UID +"'";
  //   + "select Name,UID,ID,ISACTIVE from MASTER_TEST";
                    Ocmd = new OracleCommand(strSQuery, Ocon);
                    Ocmd.ExecuteNonQuery();
                    lblMsg.Text = "Successfully Updated";
                    TestLog.WriteLog("Updated Successfully " + DateTime.Now);
                    Ocon.Close();
                 }
                catch(Exception ex)
                {
                    lblMsg.Text = ex.Message;
                    TestLog.WriteLog("Error occured while updating the channel " + DateTime.Now);
                
            }
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
        }
        gvDeleteCh.EditIndex = -1;
    }
    protected void gvDeleteCh_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gvDeleteCh.EditIndex = -1;
        LoadChannels();
    }