private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
string strcon=System.Configuration.ConfigurationSettings. AppSettings["str_connection"];
this.sqlCon.ConnectionString=strcon;
this.sqlCom.Connection=sqlCon;
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dataSet1 = new System.Data.DataSet();
this.sqlCon = new System.Data.SqlClient.SqlConnection();
this.sqlDataA = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCom = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize )(this.dataSet1)).BeginInit(&# 41;;
//
// dataSet1
//
this.dataSet1.DataSetName = "NewDataSet";
this.dataSet1.Locale = new System.Globalization.CultureInfo("fa-IR");
//
// sqlDataA
//
this.sqlDataA.SelectCommand = this.sqlCom;
this.Button4.Click += new System.EventHandler(this.Button4_Click);
this.Button3.Click += new System.EventHandler(this.Button3_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize )(this.dataSet1)).EndInit() ;;
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
this.sqlCon.Open();
this.sqlCom.CommandText="insert about values (N'"
+this.TextBox1.Text
+"',N'"
+this.TextBox2.Text
+"')";
this.sqlCom.ExecuteNonQuery();
this.sqlCon.Close();
this.TextBox2.Text=null;
this.TextBox1.Text=null;
this.dataSet1.Clear();
}
private void Button2_Click(object sender, System.EventArgs e)
{
this.TextBox2.Text=null;
this.TextBox1.Text=null;
}
private void Button3_Click(object sender, System.EventArgs e)
{
this.sqlCon.Open();
this.sqlCom.CommandText="select * from about";
this.sqlDataA.Fill(dataSet1);
this.DataGrid1.DataBind();
this.sqlCon.Close();
this.dataSet1.Clear();
}
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.sqlCom.CommandText="delete from about where aboutname=N'"
+((TextBox)e.Item.Cells[0].Con trols[0]).Text.Trim()
+"'";
this.sqlCon.Open();
this.sqlCom.ExecuteNonQuery();
this.sqlDataA.Fill(dataSet1);
this.DataGrid1.DataBind();
this.sqlCon.Close();
}
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEvent Args e)
{
this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
}
private void Button4_Click(object sender, System.EventArgs e)
{
this.sqlCon.Open();
this.sqlCom.CommandText="delete from about";
this.sqlCom.ExecuteNonQuery();
this.sqlCon.Close();
}
}