Update query not working properly in asp.net

[Linoo]

Hello to all,
I am new to this forum. I am developing a website for one company. I get problem in updating query. When I use that code in query analyzer it works fine, but nothing happens using the webpage. I don't know why my code doesn't update properly. I don't know why update query not working properly in asp.net. Can anyone tell me. Please help me.
Thanks in advanced.

[Praetor]

Hey you are getting this problem due to missing command " myCmd.ExecuteNonQuery();" You can include this command as follows.

Dim ConStr1 As String = ConfigurationManager.ConnectionStrings("SqlDataS1").ConnectionString<br>    
Dim myConn1 As New SqlConnection(ConStr1)<br>   <br>    
'open connection'<br>      myConn1.Open()<br>    <br>                    <br>                         
Dim q As String = "UPDATE pages SET pagetitle ='" & Trim(title.text) & "', pagesummary= '" & Trim(summary.value) & "' , pagebody='" & Trim(body.value) & "' WHERE pageid =" & qvalue<br>                   
Dim myCmd As SqlCommand = New SqlCommand(q, myConn1)
myConn1.Close()

[Katty]

You have to use following code to for update query. It is one of the most simple and basic code to update query in Asp.net.

private Boolean InsertUpdateData(SqlCommand cmd)
{

    String strCS = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionString;

    SqlConnection c1 = new SqlConnection(strCS);

    cmd.CommandType = CommandType.Text;

    cmd.Connection = c1;

    try

    {

        c1.Open();

        cmd.ExecuteNonQuery();

        return true;

    }

    catch (Exception ex)

    {

        Response.Write(ex.M1);

        return false;

    }

    finally

    {

        c1.Close();

        c1.Dispose();

    }

}

[kelfro]

I also had the same problem then I able to fix this problem by using following code. I think you also use this code to get rid out of this problem. Just don't vopy paste following code in your project, try to understand that.

While (reader.Read())
       {        
mydata &="<vid id='leftsite'><b2>" & reader.Item("title") & "</b2>" & reader.Item("summary") & reader.Item("pagebody") & "</vid>"

if pagesub != 0

// display subpages here

}

[Zecho]

Have you try following type of code in your query? If not, then try to use following code in your project. This code is used to update and insert query in asp.net.

if reader.Read()
    mydata &= reader.Item("title") & "</ br>"
        if reader.Item("subpage") = reader.Item("idpage")
            SD = "<div class='menusub'>"
                While reader.Item("subpage") = reader.Item("idpage")
                SD &= reader.Item("title") & "<br />"
                End While
            SD &= "</div>"
        end if
End If