ASP.NET

smady18 wrote:

how can fetch record ... from database in random order

smady18 wrote:

if i am select on option, how it can compare wuth correct option.

smady18 wrote:

on my email id...

chilly442 wrote:

cmd.Parameters.AddWithValue("@ID", ID)

chilly442 wrote:

The value that is returned is "__Page"

<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>

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

chilly442 wrote:

cmd.Parameters.AddWithValue("@ID", ID)

chilly442 wrote:

Why ask all the questions then???

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.

chilly442 wrote:

I do know how to debug.

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.