C# WebControls.SqlDataSourceStatusEventArgs類代碼示例

        protected void uxJobSql_Inserted(object sender, SqlDataSourceStatusEventArgs e)
        {
            //get user id
            MembershipUser usr = Membership.GetUser();
            Guid uid = (Guid)usr.ProviderUserKey;

            //setup database connection
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MYCHURCH"].ConnectionString);

            //setup a way to talk to the database
            SqlCommand command = new SqlCommand();
            command.Connection = connection;

            try
            {
                command.Connection.Open();
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "ChurchJobs_Insert";

                command.Parameters.Add(new SqlParameter("@UserId", uid));
                command.Parameters.Add(new SqlParameter("@JobID", e.Command.Parameters["@JobID"].Value));

                command.ExecuteNonQuery();

            }
            catch
            {

            }
            finally
            {
                command.Connection.Close();
            }
        }

        protected void SqlDataSourceTurma_Inserted(object sender, SqlDataSourceStatusEventArgs e)
        {
            DataTable dt = new DataTable();

            using (SqlConnection SQLconn = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ToString()))
            {

                SqlCommand cmd = new SqlCommand("Select Id_Disciplina from Tb_Disciplina Where Id_Curso = " + ddlCurso.SelectedValue, SQLconn);

                cmd.CommandType = CommandType.Text;

                SQLconn.Open();

                SqlDataAdapter da = new SqlDataAdapter(cmd);

                da.Fill(dt);

                SQLconn.Close();

            }

            if (dt.Rows.Count != 0)
            {

                foreach (DataRow dr in dt.Rows)
                {
                    SqlDataSourceCurso.InsertParameters["Id_Disciplina"].DefaultValue = dr[0].ToString();
                    SqlDataSourceCurso.Insert();
                }

            }
        }

 protected void SqlDataSourceEscola_Inserted(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.Command.Parameters["@Id_Escola"].Value.ToString() != "")
     {
         Response.Redirect("/Patrimonio/Escola.aspx?Id=" + e.Command.Parameters["@Id_Escola"].Value.ToString());
     }
 }

 protected void sqlAddRepair_Inserted(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.Exception == null || e.ExceptionHandled)
     {
         Response.Redirect("~/admin/admin.aspx");
     }
 }

		protected internal override IEnumerable ExecuteSelect (
						DataSourceSelectArguments arguments)
		{
			oleCommand = new OleDbCommand (this.SelectCommand, oleConnection);
			SqlDataSourceSelectingEventArgs cmdEventArgs = new SqlDataSourceSelectingEventArgs (oleCommand, arguments);
			OnSelecting (cmdEventArgs);
			IEnumerable enums = null; 
			Exception exception = null;
			OleDbDataReader reader = null;
			try {
				System.IO.File.OpenRead (dataSource.DataFile).Close ();
				oleConnection.Open ();
				reader = (OleDbDataReader)oleCommand.ExecuteReader ();
			
				//enums = reader.GetEnumerator ();
				throw new NotImplementedException("OleDbDataReader doesnt implements GetEnumerator method yet");
			} catch (Exception e) {
				exception = e;
			}
			SqlDataSourceStatusEventArgs statusEventArgs = 
				new SqlDataSourceStatusEventArgs (oleCommand, reader.RecordsAffected, exception);
			OnSelected (statusEventArgs);
			if (exception !=null)
				throw exception;
			return enums;			
		}						

        protected void dbServiceSql_Inserted(object sender, SqlDataSourceStatusEventArgs e)
        {
            //setup database connection
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MYCHURCH"].ConnectionString);

            //setup a way to talk to the database
            SqlCommand command = new SqlCommand();
            command.Connection = connection;

            try
            {
                command.Connection.Open();
                command.CommandType = CommandType.Text;
                command.CommandText = "INSERT INTO SPScheduleService(ScheduleID, ServiceID) VALUES(@ScheduleID, @ServiceID)";
                
                command.Parameters.Add(new SqlParameter("@ServiceID", e.Command.Parameters["@ServiceID"].Value));
                command.Parameters.Add(new SqlParameter("@ScheduleID", sbo.sid.ToString()));

                command.ExecuteNonQuery();

            }
            catch
            {
                litScheduleInfo.Text = "error";
            }
            finally
            {
                command.Connection.Close();
            }
        }

 // DXCOMMENT: This handler is called when a datasource insert operation has been completed
 protected void SchedulingDataSource_Inserted(object sender, SqlDataSourceStatusEventArgs e)
 {
     // DXCOMMENT: This method saves the last inserted appointment's unique identifier
     SqlConnection connection = (SqlConnection)e.Command.Connection;
     using (SqlCommand cmd = new SqlCommand("SELECT IDENT_CURRENT('Appointments')", connection)) {
         this.lastInsertedAppointmentId = Convert.ToInt32(cmd.ExecuteScalar());
     }
 }

 protected void SqlDataSourceModifica_Deleted(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.Exception != null)
     {
         LabelErrorMessage.Text = "Impossibile eseguire la cancellazione probabilmente l'emento è in uso dalla tabella Strumenti.\n" + e.Exception.Message;
         e.ExceptionHandled = true;
     }
 }

 protected void allUserGroupsDataSource_Inserted( object sender, SqlDataSourceStatusEventArgs e )
 {
     if ( e.Exception == null )
       {
     int newGroupId = ( int ) e.Command.Parameters["@NewGroupId"].Value;
     Response.Redirect( "~/manageGroup.aspx?group=" + newGroupId );
       }
 }

 protected void SqlDataSource1_Deleted(object sender, SqlDataSourceStatusEventArgs e)
 {
     if(e.Exception != null)
     {
         LabelErreur.Text = "Vous ne pouvez pas supprimer ce champs car il est en commande!";
         e.ExceptionHandled = true;
     }
 }

 protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.AffectedRows == 0)
     {
         this.lblGames.Visible = true;
         this.Wizard1.Enabled = false;
     }
 }

 protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.AffectedRows == 0)
     {
         this.lblTeam.Visible = false;
         this.ddlTeams.Visible = false;
     }
 }

 protected void Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     int n = e.AffectedRows;
     if (n > 0)
         Label2.Text = string.Format("Numero de Registos {0}", n);
     else
         Label2.Text = "Não existem Registos ";
     return;
 }

 protected void SqlDataSource1_Deleted(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.Exception != null)
     {
         //ADMIN CANNOT DELETE
         lblError.Text = "YOU CANNOT DELETE USER,   ALREADY IN USE!";
         e.ExceptionHandled = true;
     }
 }

 protected void SqlDataSource1_Deleted(object sender, SqlDataSourceStatusEventArgs e)
 {
     //if (e.Exception != null)
     //{
     //    //ADMIN CANNOT DELETE
     //    lblError1.Text = "YOU CANNOT DELETE QUESTION,   ALREADY IN USE!";
     //    e.ExceptionHandled = true;
     //}
 }