Comments by supriya931 (Top 32 by date)

no there is no authenicated page i am just using a trans id to count transaction through that page and i amke the seesion of trans id till the last page but it open when i copy the url of that page and inserted the valuein database from the copy url page

no it is not fetching the value from the inputbox

it will not shoe the data in list on page
it fectching from database but not shoe in list

yes

i mean radiobuttonlist. i want to select all values of the list by clicking selectall button

yes export screen will come but in the crystal report all the parameter values will be blank

ya it is working right but the problem is that you are making another table to make this i want to modify in same table that is i am using this syntax.

no it give error nera pivot element.
and the above soluation working fine but the problem is that this query is not exist physically . and it is to large how to paste in coding

SELECT ques_idI,[excelllent],[good],[average]
FROM v_feedback
PIVOT
(sum (score) FOR performance IN [excelllent],[good],[average] ) AS p
in this some where erroe near pivot element plz find any one

1 gjhgjhg 10 30 4 like this
above i mentioned the column also

no it will not work like that in gridview

i solved it but now the problem is how to select only one value from four of these in single row of the grid view and how to store it into dataset.

you will send me your gmail id i'll send you a file

no you cant understand me
i want each option value will be display one checkbox in the gird view in each row

no no see
qid qtxt op1 op2 op3 op4

1 are you ready yes&chkbox no&chkbox notyet&chkbox 5min&chkbox

like this

i sent to my code again

Partial Class _Default
Inherits System.Web.UI.Page
Dim con As SqlConnection
Dim da As SqlDataAdapter
Dim ds As DataSet
Dim rst1, rst2, rst3, dt As New DataTable
Dim cm As SqlCommand
Dim cmbd As SqlCommandBuilder
Dim rs1 As MsgBoxResult
Dim dr, dr1 As DataRow
Dim ip, cr, b1, b2, s1 As String
Dim i, c, q, j, trans, p, rowcnt As Integer
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
con = New SqlConnection("Data Source=.;Initial Catalog=appraisal;User ID=sa;Password=database")
con.Open()
getques()
getsub()
'getacdmic_detail()
End Sub
Public Sub getques()
cm = New SqlCommand("SELECT o.option_id,q.ques_id, q.ques_txt, o.option_txt FROM ques_mst q INNER jOIN option_mst o ON q.ques_id = o.ques_id order by q.ques_id ", con)
da = New SqlDataAdapter(cm)
cmbd = New SqlCommandBuilder(da)
ds = New DataSet
da.Fill(ds, "q1")
dt = New DataTable
dt = ds.Tables("q1")
dg_ques.DataSource = ds.Tables("q1")
dg_ques.DataBind()
rst3 = New DataTable
rst3.Columns.Add("quesid")
rst3.Columns.Add("questxt")
rst3.Columns.Add("op1")
rst3.Columns.Add("opt2")
rst3.Columns.Add("opt3")
rst3.Columns.Add("opt4")
cm = New SqlCommand("select * from ques_mst order by queS_id", con)
da = New SqlDataAdapter(cm)
ds = New DataSet
da.Fill(ds, "ques")
rst1 = New DataTable
rst1 = ds.Tables("ques")
If rst1.Rows.Count > 0 Then
i = rst1.Rows.Count
c = 0
While c < i
cm = New SqlCommand("select * from option_mst where queS_id = '" & rst1.Rows(c).Item("ques_id") & "'", con)
da = New SqlDataAdapter(cm)
ds = New DataSet
da.Fill(ds, "opt")
rst2 = New DataTable
rst2 = ds.Tables("opt")
If rst2.Rows.Count > 0 Then
p = rst2.Rows.Count
q = 0
rowcnt = rst3.Rows.Count
rst3.Rows.Add()
rst3.Rows(rowcnt).Item(0) = rst1.Rows(c).Item(0).ToString
rst3.Rows(rowcnt).Item(1) = rst1.Rows(c).Item(1).ToString
While q < p
rst3.Rows(rowcnt).Item(q + 2) = rst2.Rows(q).Item(2).ToString
q = q + 1
End While
End If
c = c + 1
End While
End If
dt = New DataTable
dt = rst3
c = 0
j = 0
While c <= dt.Rows.Count - 1
Me.dg_ques.Rows(c).Cells(0).Text = rst3.Rows(c).Item("quesid").ToString()
Me.dg_ques.Rows(c).Cells(1).Text = rst3.Rows(c).Item("questxt").ToString
Me.dg_ques.Rows(c).Cells(2).Text = rst3.Rows(c).Item("op1").ToString
Me.dg_ques.Rows(c).Cells(4).Text = rst3.Rows(c).Item("opt2").ToString
Me.dg_ques.Rows(c).Cells(6).Text = rst3.Rows(c).Item("opt3").ToString
Me.dg_ques.Rows(c).Cells(8).Text = rst3.Rows(c).Item("opt4").ToString
c = c + 1
End While

'While c <= rst3.Rows.Count - 1
' Me.dg_ques.Rows(c).Cells(0).Text = rst3.Rows(c).Item(0).ToString()
' Me.dg_ques.Rows(c).Cells(1).Text = rst3.Rows(c).Item(1).ToString

' p = rst3.Columns.Count
' q = 2
' While q < p - 1
' Me.dg_ques.Rows(c).Cells(q).Text = rst3.Rows(c).Item(q).ToString
' q = q + 1
' End While
' c = c + 1
'End While
con.Close()
here the format of the gridview is like this

qid qtxt op1 select op2 select op3 select op4 select
this is the format of my gridview

and another problem is that when i add checkbox in itemtemplate of the gridview then when i was run the application then it shows 5 time gerater rows form my database table with blank values

no see the format is like

qid qtxt op1 op2 op3 op4
1 hghg hh then checkbox hg then checkbox gjg then checkbox hhg then checkbox

no i want that checkbox will be display with the option value in the grid view

actually i want to save all ques in one place and when i click on button then all the question inserted in to database at same time from that place on one click only

nops..
i want to display the only selected item from dropdwonlist of perivous page in the textbox of nextpage

thank you

addoption.aspx?l_qid=1&l_ques=tttt it is it show only qid

addoption.aspx?l_qid=1&l_ques=tttt it is the my url which show only qid

ya it is in same manner but it show only quesid not question

but now it will not show the text on second page

no i already did this but it sems same problem