ASP.NET

yftah1989 wrote:

my father was right
i am a failure...

gavindon wrote:

combined with a finger twitch...

DataSet   dsTable    = new DataSet();
adapter.Fill(dsTable);                       // u need to create connection string and query string to fill the data from database.
DataTable dtQuestion = dsTable["Question"]; // assign data result from question dataset
DataTable dtAnswer   = dsTable["Answer"]; // assign data result from answer dataset
DataTable dtBind = dtQuestion.Clone();  // copy all data from Question
dtBind.Columns.Add("Answer",System.Type.GetType("System.Boolean"));  // create new column "Answer" with Boolean type, 1 for yes and 0 for no

for(int index=0;index < dtBind.Rows.Count;index++)
{
    for(int j=0; j < dtAnswer.Rows.Count; j++)
    {
      if(dtBind.Rows[index]["QuestionId"].Equals(dtAnswer.Rows[j]["QuestionId"])  // i assume that u used QuestionId as primary key for both Tables
      {
         dtBind.Rows[index]["Answer"] = dtAnswer.Rows[j]["Answer"];
         break;                                                      // break from inner loop
      }
    }
}

GridView1.DataSource = dtBind;
  GridView1.DataBind();

<ItemTemplate>
  <asp:RadioButton ID="rdbYes" runat="server" Text="Yes" Checked='<%# Eval("Answer") %>' GroupName="Answer" />
  <asp:RadioButton ID="rdbNo" runat="server" Text="Yes" Checked='<%# !Eval("Answer") %>' GroupName="Answer" />
 </ItemTemplate>

adapter.Update(dsTable);   // this will save all changes back to database

dr2<br />

Dim cmdQuery2 As String = "SELECT Career FROM Analysis WHERE Marks= (SELECT MAX(Marks) FROM Analysis ) AND UserID = '" + kp + "'"

Dim cmd2 As SqlCommand = New SqlCommand(cmdQuery2, con)
Dim dr2 As SqlDataReader = cmd2.ExecuteReader()

'con.Open()
For i As Integer = 0 To labelCount - 1 '//** u can also u while loop in here the result will be same
' Create the label control and set its text attribute
Dim Label1 As New Label

 dr2.Read()

career= dr2("Career").ToString()
Label1.Text = career                  '//** u can also directly assign the value from dr2 here

Dim Literal1 As New Literal
Literal1.Text = "<br />"

' Add the control to the placeholder
PlaceHolder1.Controls.Add(Label1)
PlaceHolder1.Controls.Add(Literal1)

Next
dr2.Close()