asp.net show selected gridview data in 2nd area on page
Hi Experts,
I currently have a gridview that shows information from a db2 database, the SQL is a little messy but given how I have been asked to pull the data it works and will be refined shortly..
The new requriement is that the data is selectable and the selected data shows in a second area.
The way this has been laid out in the spec shows that is must not be a second gridview, but more a table with textfields
the code used to bind the data to the gridview is
txtSuName.Text = txtSuName.Text.ToUpper 'If txtSuName.Text.Length = 0 And txtSupNo.Text.Length = 0 And drp20.SelectedValue = "" And drp21.SelectedValue = "" And drp22.SelectedValue = "" And drp23.SelectedValue = "" And drp23.SelectedValue = "" Then If txtSuName.Text.Length = 0 And drp20.SelectedValue = "" And drp21.SelectedValue = "" And drp22.SelectedValue = "" Then Exit Sub End If Dim supNo, supName, cat20, cat21, cat22 As String If rdoSupName.SelectedValue = "Name" Then If txtSuName.Text = Nothing Then supName = Nothing Else supName = "and a.ABALPH like '%" & txtSuName.Text & "%'" End If End If If rdoSupName.SelectedValue = "Number" Then If txtSuName.Text = Nothing Then supNo = Nothing Else supNo = "and a.ABAN8 like '%" & txtSuName.Text & "%'" End If End If If drp20.SelectedValue = Nothing Then cat20 = Nothing Else cat20 = " and b.drdl01ac20 = '" & drp20.SelectedValue & "'" End If If drp21.SelectedValue = Nothing Then cat21 = Nothing Else cat21 = "and c.drdl01ac21 = '" & drp21.SelectedValue & "'" End If If drp22.SelectedValue = Nothing Then cat22 = Nothing Else cat22 = "and d.drdl01ac22 = '" & drp22.SelectedValue & "'" End If sqlstr = "select distinct a.ABAN8 as Number, a.ABALPH as Name, a.ABAT1 as Type, g.aladdz as PostCode, " & _ "b.drkyac20 as Level_1, b.drdl01ac20 as Level_1_Description, " & _ "c.drkyac21 as Level_2, c.drdl01ac21 as Level_2_Description, " & _ "d.drkyac22 as Level_3, d.drdl01ac22 as Level_3_Description, " & _ "g.aladd2 as Address, g.aladd3 as Address, g.aladd4 as Address, g.alcty1 as City, g.alcoun as County, g.alctr as Country " & _ "FROM TRDTA.F0101 as a, trdta.f0005_ac20 as b, trdta.f0005_ac21 as c, trdta.f0005_ac22 as d, trdta.f0005_ac23 as e, trdta.f0005_ac24 as f, trdta.f0116 as g " & _ "where ABAT1 IN ('V', 'VF', 'VM', 'VH') " & _ "and trim(a.abac20) = trim(b.drkyac20) " & _ "and trim(a.abac21) = trim(c.drkyac21) " & _ "and trim(a.abac22) = trim(d.drkyac22) " & _ "and a.aban8 = g.alan8 " & _supNo & _ supName & _ cat20 & _ cat21 & _ cat22 sqlconn.ConnectionString = connstr sqlconn.Open() sqlcmd.Connection = sqlconn sqlcmd.CommandText = sqlstr sqldr = sqlcmd.ExecuteReader GridView1.DataSource = sqldr GridView1.DataBind() sqldr.Close() sqlconn.Close()
I have seen this but this looks like it is using bound datafields,
i would like to user this example, but cannot for the life of me seem to bind the datafields in the gridview. If you could help me with that I would be most grateful and could use this as the solution.
thanks
Simon
SimonPrice33
ASKER
trying to use bound fields i get this error
SQL0104 Token . was not valid. Valid tokens: , FROM INTO.
i would like to user this example, but cannot for the life of me seem to bind the datafields in the gridview. If you could help me with that I would be most grateful and could use this as the solution.
thanks
Simon