ASP.NET

30-Mar-09 6:22

I have a Web Form (VB) that a user can bring in data based on drop down boxes. If the data in the grid needs changed, then the user can click on the edit button for the row and make a change. The problem is, that the change is not reflected in the DB. I know that I am missing something somewhere.

This fills the Grid with the info that the user has selected:

Dim sql As String = "SELECT ID FROM TEST"
        Dim da As New OleDbDataAdapter(Sql, Con)
        Con.ConnectionString = connString
        Con.Open()
        da.Fill(ds, "Events")
        GridView1.DataSource = ds
        GridView1.DataBind()
        count = ds.Tables("Events").Rows.Count
        Con.Close()

This is the update that I am trying to use:

Dim sql As String
        sql = "UPDATE TEST SET ID = @ID WHERE (ID=@ID)"
        Using con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WebSite1\App_Data\ODRT.mdb")
            Using cmd As New OleDbCommand(sql, con)
                cmd.CommandText = sql
                cmd.Parameters.AddWithValue("@ID", ID)
                con.Open()
                cmd.ExecuteNonQuery()
                con.Close()
                GridView1.EditIndex = -1
                DataBind()
            End Using
        End Using

Any Ideas??? Mad | :mad:

Thanks,
Chilly

Yusuf30-Mar-09 6:42

30-Mar-09 6:42

chilly442 wrote:
cmd.Parameters.AddWithValue("@ID", ID)

what is the value of ID? did you debug it to see you are using the right value?

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

chilly44230-Mar-09 6:45

30-Mar-09 6:45

The value that is returned is "__Page" Confused | :confused:

. It should be an assigned number.

Yusuf30-Mar-09 7:31

30-Mar-09 7:31

chilly442 wrote:
The value that is returned is "__Page"

there you have your problem

chilly44230-Mar-09 7:37

30-Mar-09 7:37

How do I fix the problem. What is this telling me? I have never done an update in gridview before. Confused | :confused:

Yusuf30-Mar-09 9:36

30-Mar-09 9:36

How are you getting the value of ID, show us the your code

chilly44230-Mar-09 9:42

30-Mar-09 9:42

Here is the code that I am using on the front end:

<asp:GridView 
     ID="GridView1" 
     runat="server" 
     Font-Size="X-Small" 
     Font-Names="Arial"
     AutoGenerateColumns="False" 
     OnRowEditing="GridView1_RowEditing" 
     OnRowUpdating="GridView1_RowUpdating" 
     OnRowCancelingEdit="GridView1_RowCancelingEdit" 
     OnRowDataBound="GridView1_RowDataBound" BorderColor="Black">
      <Columns>
       <asp:CommandField ShowEditButton="True" />
       <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"/>     
      </Columns>
     </asp:GridView>

Here is the code that I am using on the back end:

Dim sql As String = "SELECT ID FROM TEST"
       Dim da As New OleDbDataAdapter(Sql, Con)
       Con.ConnectionString = connString
       Con.Open()
       da.Fill(ds, "Events")
       GridView1.DataSource = ds
       GridView1.DataBind()
       count = ds.Tables("Events").Rows.Count
       Con.Close()


Dim sql As String
       sql = "UPDATE TEST SET ID = @ID WHERE (ID=@ID)"
       Using con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\WebSite1\App_Data\ODRT.mdb")
           Using cmd As New OleDbCommand(sql, con)
               cmd.CommandText = sql
               cmd.Parameters.AddWithValue("@ID", ID)
               con.Open()
               cmd.ExecuteNonQuery()
               con.Close()
               GridView1.EditIndex = -1
               DataBind()
           End Using
       End Using

Chilly

Yusuf30-Mar-09 9:45

30-Mar-09 9:45

chilly442 wrote:
cmd.Parameters.AddWithValue("@ID", ID)

where are you getting/setting ID?

chilly44230-Mar-09 9:46

30-Mar-09 9:46

Maybe that is the problem. I am not sure. Where should I be doing it? How should it look?

Yusuf30-Mar-09 9:56

30-Mar-09 9:56

I have no freaking clue. You have the code, not me.

chilly44230-Mar-09 11:33

30-Mar-09 11:33

Why ask all the questions then???

Yusuf30-Mar-09 11:52

30-Mar-09 11:52

chilly442 wrote:
Why ask all the questions then???

Look, we all do this because we love to help. But I can't do your work. It is expected you will be doing most of the heavy lifting.

I asked you where is ID set and how is it set. You said you don't know. Well, what the hell do you want me to do then? I don't have an access to your source code. I am blindly debugging your code, heck you were suppose to debug your code in the first place. If you have slight idea of how to debug, you would not have run into this in the first place.

Now get your arse off that chair get a decent book and learn the fundamentals of programming, before asking such trivial questions.

chilly44230-Mar-09 12:02

30-Mar-09 12:02

I provided all the code that deals with this problem. I do know how to debug. There is no value getting passed to ID. We have already established that. My question is how to set ID. Not asking for a miracle. Just a bit of experience. You are here to help, and I am here to learn. I don't want you to do the work for me, just help to guide me in the right direction.

Chilly Wink | ;)

Yusuf30-Mar-09 12:35

30-Mar-09 12:35

chilly442 wrote:
You are here to help, and I am here to learn. I don't want you to do the work for me, just help to guide me in the right direction.

Look as long as you are willing to learn, people here will be more than happy to help you. I like the fact that you came back after my earlier post. But you need to understand that, if you don't have the fundamentals of the programming, you will find it very hard to get learn just by posting questions. You need to bring up yourself to speed by reading books.

chilly442 wrote:
I do know how to debug.

well what else can I say?

chilly442 wrote:
There is no value getting passed to ID. We have already established that. My question is how to set ID. Not asking for a miracle.

You said that ID have a value of __Page. Where did that came from? Look all over the place where ID is used.

You can not simply set ID. You need to know what to set it to. I can't tell you what to set it to, because I have no freaking clue of your code.

Start with looking all the places where ID is used. then try to understand what is going on.

How to debug asp.net applications[^]

chilly4429-Jun-09 8:40

9-Jun-09 8:40

I had to go somewhere else to get help with this question.
I have the solution working.
Thanks

Yusuf9-Jun-09 10:05

9-Jun-09 10:05

wow, it has been more than two months. Did you learn and solve the problem by yourself or you asked people to give you the solution?

Yusuf
May I help you?

chilly4429-Jun-09 10:12

9-Jun-09 10:12

Went to another forum that was willing to help. You are just trying to get a high number of posts.

Yusuf9-Jun-09 13:06

How can I attach object like flash file??

9-Jun-09 13:06

I never cared for the number of posts or votes. Look at my posts, you have down voted them all Ones. I did not touch yours. You see the difference.

You Simply had no clue and asking people to do the job for you is unacceptable. You admitted not knowing web application, not knowing how to debug the code. So, tell me, how did you expect to do your job? I don't see any problem with not knowing, but you have no willingness to learn. Had you shown any willingness you would have seen the help that comes your way.

I challenge you, you knew nothing from what you have gotten from the other forums. If you learned something, you would have shared what you learned rather than stating, I solved it.

Yusuf
May I help you?

lsh486love30-Mar-09 6:05

lsh486love

30-Mar-09 6:05

Hello.

I'm making a website with flash files with ASP.NET ver 2.0.

But I don't know how to attach the flash files(.swf) on the website.

Please let me know if anyone know that.

Or is there a sample of that I'm asking?

I tried to make that with using codes like this.

<embeded src="c:\\temp\\test.swf" .......=""></embeded>

But there is not happened what I want.

I appreciate if you could let me know.

Thanks.

Re: How can I attach object like flash file??

Yusuf30-Mar-09 6:22

Capture IP once per site visit

30-Mar-09 6:22

did you try this[^]

Mort.Strom30-Mar-09 5:29

Mort.Strom

30-Mar-09 5:29

My default.aspx page captures client IP/browser data for all users, then records to a sql table. I'm finding that there may be several records inserted per visit because I see 2~3 entries within a minute or so.

How do I ensure that cient IP is captured only once per session?

The default.aspx page has no post-back controls or AJAX calls.

Thanks for any direction,

Mort

Re: Capture IP once per site visit

Yusuf30-Mar-09 6:50