string selectSQL = "SELECT * FROM sections ";
selectSQL += "WHERE section_active = 1 ";
selectSQL += "ORDER BY section_order ASC ";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(selectSQL, con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet dataset = new DataSet();
try
{
con.Open();
adapter.Fill(dataset, "sections");
cmd.CommandText = "SELECT * FROM questions ORDER BY question_order ASC";
adapter.Fill(dataset, "questions");
cmd.CommandText = "SELECT * FROM options";
adapter.Fill(dataset, "options");
}
catch (Exception err)
{
Lejbl.Text = "Error reading database. ";
Lejbl.Text += err.Message;
}
finally
{
con.Close();
}
DataRelation Sections_Questions = new DataRelation("Sections_Questions",
dataset.Tables["sections"].Columns["section_id"],
dataset.Tables["questions"].Columns["section_id"]);
DataRelation Questions_Options = new DataRelation("Questions_Options",
dataset.Tables["questions"].Columns["question_id"],
dataset.Tables["options"].Columns["question_id"]);
dataset.Relations.Add(Sections_Questions);
dataset.Relations.Add(Questions_Options);
zatim, postavio relacije i slijedece je da napunim gridview:
foreach (DataRow sectionRow in dataset.Tables["sections"].Rows)
{
if (int.Parse(sectionRow["form_id"].ToString()) == DAL.FormDAL.getSelectedFormID())
{
section++;
DataRow drs = datatable.NewRow();
drs[formName] = sectionRow["section_name"].ToString().ToUpper();
datatable.Rows.Add(drs);
foreach (DataRow questionRow in sectionRow.GetChildRows(Sections_Questions))
{
if (int.Parse(questionRow["question_active"].ToString()) == 1)
{
qnumber++;
DataRow drqn = datatable.NewRow();
drqn[formName] = questionRow["question_name"].ToString();
datatable.Rows.Add(drqn);
if (questionRow["question_text"].ToString() != "")
{
DataRow drqt = datatable.NewRow();
drqt[formName] = questionRow["question_text"].ToString();
datatable.Rows.Add(drqt);
}
foreach (DataRow optionRow in questionRow.GetChildRows(Questions_Options))
{
if (int.Parse(optionRow["question_type"].ToString()) == 1)
{
TextBox TextB = new TextBox();
TextB.Height = 80;
TextB.Width = 240;
TextB.ID = optionRow["question_id"].ToString();
DataRow drot = datatable.NewRow();
[b]drot[formName] = TextB; [/b]
datatable.Rows.Add(drot);
}
}
}
}
}
}
gridvju.DataSource = datatable;
gridvju.DataBind();
gridview se napuni kako treba osim polja gdje treba da bude textbox, tu mi pise:
System.Web.UI.WebControls.TextBox, umjesto da se pojavi textbox u koji se moze tipkati, kako hocu da bude
Zna li iko u cemu je problem? Zar nemogu dodijeliti redu datatabele textbox ovako: drot[formName] = TextB;
[Shadowed: dodati [code] tagovi.]
[Ovu poruku je menjao Shadowed dana 26.06.2007. u 09:38 GMT+1]