Hi guys. i have an editable datagrid that has a edit button next to
each record.once i click on it goes to a new page and loads the specifc record in edit mode and allow me edit the values. one of the values is in drop down box as u can see in the pic below. The problem that i have it always loads the first value from drop downlist not value coresponding to the record. I be happy if some one help me fixt this problem.thanks
http://i5.photobucket.com/albums/y18...7/datagrid.jpg (datagrid pic)
http://i5.photobucket.com/albums/y18...7/editmode.jpg (edit page)
http://i5.photobucket.com/albums/y18...designview.jpg ( edit form in deisign view)
http://i5.photobucket.com/albums/y18...7/19932c0e.jpg (db reletions)
my onload and update code :
Code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
MyConnection = New SqlConnection("server=localhost;database=teniss2;uid=web;pwd=web;")
If Not IsPostBack Then
SqlSelectCommand1.Parameters(0).Value = Convert.ToInt16(Request.QueryString("match"))
SqlDataAdapter1.Fill(DataSet11, "matches")
MatchNolable.DataBind()
TeamNolable.DataBind()
TextBox1.DataBind()
TextBox2.DataBind()
SqlDataAdapter2.Fill(DataSetplayerteamMatches1, "Players")
Me.DropDownList1.DataBind()
End If
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim MyCommand As SqlCommand
Dim UpdateCmd As String = "Update Matches Set Teamno=" & Me.TeamNolable.Text & ", playerno=" & Me.DropDownList1.SelectedValue & ", won=" & Me.TextBox1.Text & ", lost=" & Me.TextBox2.Text & _
" Where MatchNo = " & MatchNolable.Text
MyCommand = New SqlCommand(UpdateCmd, MyConnection)
MyCommand.Connection.Open()
MyCommand.ExecuteNonQuery()
MyCommand.Connection.Close()
Server.Transfer("teamsandmatches.aspx")
End Sub
how to load specific value from dropdown list?
