//Default.aspx.cs//---------
using System;
using System.Collections;
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.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlcon = new SqlConnection(System.Configuration.ConfigurationMa nager.ConnectionStrings["ConnectionString"].ConnectionString);
SqlCommand cmd,cmd1;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.NumberOfControls = 1;
this.addcontrol();
}
else
{
if (null != Request.Form["btnsubmit"])
{
this.addcontrol();
}
else
{
this.NumberOfControls = this.NumberOfControls + 1;
this.addcontrol();
}
}
}
public void addcontrol()
{
//j = j + 40;
int count = this.NumberOfControls;
int count1 = Convert.ToInt32(lbldelete.Text);
Control Item1;
for (int i = 1; i <= count; i++)
{
Item1 = LoadControl("my.ascx");
Item1.ID = "Item" + Convert.ToString(i + count1);
Item1.RemoveUserControl += new EventHandler(Item1_RemoveUserControl);
//pnlContainer.Controls.Add(Item);
PlaceHolder1.Controls.Add(Item1);
}
//this.NumberOfControls = this.NumberOfControls + 1;
}
protected int NumberOfControls
{
get {
return (int)ViewState["Numcontrols"];
}
set {
ViewState["Numcontrols"] = value;
}
}
public void Item1_RemoveUserControl(object sender, EventArgs e)
{
Button but = sender as Button;
System.Web.UI.Control Item1 = (System.Web.UI.Control)but.Parent;
PlaceHolder1.Controls.Remove(Item1);
lbldelete.Text = (Convert.ToInt32(lbldelete.Text) + 1).ToString();
this.NumberOfControls = this.NumberOfControls - 1;
}
protected void Button1_Click(object sender, EventArgs e)
{
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
string iclass, iactive;
foreach (my Item in PlaceHolder1.Controls)
{
int count = 0;
iclass = Item.itemclass;
iactive = Item.active;
SqlDataReader reader = null ;
try
{
//reader = null;
String retrieve = "Select class from sample1 where class='" + iclass + "'";
cmd1 = new SqlCommand(retrieve, sqlcon);
sqlcon.Open();
reader = cmd1.ExecuteReader();
while (reader.Read())
{
count++;
}
}
finally
{
if (count != 0)
{
// MessageBox.Show("Class Already there");
reader.Close();
sqlcon.Close();
}
else
{
string sqlstr = "Insert into sample1(class,active) values ('" + iclass + "','" + iactive + "')";
cmd = new SqlCommand(sqlstr, sqlcon);
sqlcon.Close();
sqlcon.Open();
cmd.ExecuteNonQuery();
Response.Write(iclass + " added ");
sqlcon.Close();
}
}
}
}
}
//my.ascx.cs//----------------
Collapse
using System;
using System.Collections;
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;
using System.Data.SqlClient;
public partial class my : System.Web.UI.UserControl
{
public string itemclass
{
get
{
return txtclass.Text;
}
set
{
txtclass.Text=value;
}
}
public string active {
get {
return rdactive.SelectedValue.ToString();
}
set {
rdactive.SelectedValue = value;
}
}
public event EventHandler RemoveUserControl;
protected void Delete_Click(object sender, EventArgs e)
{
if (this.RemoveUserControl != null)
this.RemoveUserControl(this, new EventArgs());
}
}