using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page
{
TextBox mytxt;
OleDbConnection cnn = new OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=" + HttpContext.Current.Server.MapPath("~/App_Data/anket.mdb") + "");
protected void Page_Load(object sender, EventArgs e)
{
}
private int SoruEkle(string soru)
{
cnn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "Insert into AnketSoru (Soru) values ('" + soru + "')";
cmd.Connection = cnn;
cmd.ExecuteNonQuery();
cmd.CommandText = "Select @@Identity";
int donenid =Convert.ToInt32(cmd.ExecuteScalar());
cnn.Close();
return donenid;
}
private void CevapEkle(int anket_id, string[] cevap)
{
cnn.Open();
OleDbCommand cmd;
string str = "";
foreach (string item in cevap)
{
cmd = new OleDbCommand("Insert into Anketcevap (AnketID,Cevap,Hit) values (@anketid,@cevap,@hit)", cnn);
cmd.Parameters.AddWithValue("@anketid",anket_id);
cmd.Parameters.AddWithValue("@cevap",item);
cmd.Parameters.AddWithValue("@hit",0);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
cnn.Close();
}
protected void btnSecenekEkle_Click(object sender, EventArgs e)
{
Olustur(Convert.ToInt32(txtAdet.Text));
}
private void Olustur(int adet)
{
ViewState["CevapSayi"] = adet;
for (int i = 0; i < adet; i++)
{
mytxt = new TextBox();
mytxt.ID = "txtSecenek" + i.ToString();
phTextBoxlar.Controls.Add(mytxt);
phTextBoxlar.Controls.Add(new LiteralControl("<br>"));
phBaslik.Controls.Add(new LiteralControl(" Anket Cevap "+(i+1).ToString()));
phBaslik.Controls.Add(new LiteralControl("<br>"));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (ViewState["CevapSayi"] == null)
return;
int sid = SoruEkle(txtSoru.Text);
string[] str = new string[Convert.ToInt32(ViewState["CevapSayi"].ToString())];
for (int i = 0; i < Convert.ToInt32(ViewState["CevapSayi"].ToString()); i++)
{
str[i] = Request.Form["txtSecenek" + i.ToString()].ToString();
}
CevapEkle(sid, str);
ViewState["CevapSayi"] = null;
lblDurum.Text = "anket Eklendi";
}
}
