C# SqlDataSourceCommandEventArgs类代码示例

 protected void DSData_Updating(object sender, SqlDataSourceCommandEventArgs e)
 {
     if (Session["attach"] != null)
     {
         e.Command.Parameters["link"].Value = Session["attach"].ToString();
     }
 }

    protected void AccessDataSource1_Deleting(object sender, SqlDataSourceCommandEventArgs e)
    {
        // Delete the image files

        // Get the image file name
        string picture1FileName;
        using (OleDbConnection connection = ExamplesHelper.GetNewOpenDbConnection())
        {
            using (OleDbCommand command = connection.CreateCommand())
            {
                command.CommandText = "SELECT [Picture1_FileName_thumbnail] FROM [Ex_A_507] WHERE [ID][email protected]";
                command.Parameters.AddWithValue("@Id", e.Command.Parameters["Id"].Value);
                picture1FileName = Convert.ToString(command.ExecuteScalar());
            }
        }

        if (!string.IsNullOrEmpty(picture1FileName))
        {
            // Delete the main image
            string picture1FilePath_main = System.IO.Path.Combine(Server.MapPath("~/repository/store/ex_A_507/picture1/main/"), picture1FileName);
            if (System.IO.File.Exists(picture1FilePath_main))
            {
                System.IO.File.Delete(picture1FilePath_main);
            }

            // Delete the thumbnail
            string picture1FilePath_thumbnail = System.IO.Path.Combine(Server.MapPath("~/repository/store/ex_A_507/picture1/thumbnail/"), picture1FileName);
            if (System.IO.File.Exists(picture1FilePath_thumbnail))
            {
                System.IO.File.Delete(picture1FilePath_thumbnail);
            }
        }
    }

    public void OnInserting(Object source, SqlDataSourceCommandEventArgs eventArgs)
    {
        FileUpload fileUpload = (FileUpload) BulletinDataGrid.FindControl("bulletinPdf");
        DateTime pubDate = (DateTime) eventArgs.Command.Parameters["@pubDate"].Value;

        if (fileUpload != null && pubDate != null && fileUpload.PostedFile != null && fileUpload.PostedFile.ContentLength > 0)
        {
            String filename = System.IO.Path.GetFileName(fileUpload.PostedFile.FileName);
            filename = pubDate.ToString("yyyy-MM-dd") + ".pdf";
            String saveLocation = Server.MapPath("~\\bulletins") + "\\" + filename;
            try
            {
                fileUpload.PostedFile.SaveAs(saveLocation);
                status.InnerHtml = "Uploaded Succesfully";
                status.Style.Add(HtmlTextWriterStyle.Color, "Red");
            }
            catch (Exception exception)
            {
                status.InnerHtml = "Error: " + exception;
                status.Style.Add(HtmlTextWriterStyle.Color, "Red");
            }
        }
        else
        {
            status.InnerHtml = "Please select a file to upload.";
            status.Style.Add(HtmlTextWriterStyle.Color, "Red");
        }
    }

 protected void DSData_Updating(object sender, SqlDataSourceCommandEventArgs e)
 {
     if (Convert.ToBoolean(e.Command.Parameters["tsfeat"].Value) == false && Convert.ToBoolean(e.Command.Parameters["winner"].Value) == true)
     {
         GVEditor.JSProperties["cpShowPopup"] = "لا يمكن تحديد الفائز بدون تصفيات";
         e.Cancel = true;
     }
 }

	protected void sourceEmployees_Updating(object sender, SqlDataSourceCommandEventArgs e)
	{
		e.Command.Parameters["@First"].Value = e.Command.Parameters["@FirstName"].Value;
		e.Command.Parameters["@Last"].Value = e.Command.Parameters["@LastName"].Value;
		e.Command.Parameters.Remove(e.Command.Parameters["@FirstName"]);
		e.Command.Parameters.Remove(e.Command.Parameters["@LastName"]);

	}

 protected void OnClubMemberDataSourceModifying(object sender, SqlDataSourceCommandEventArgs e)
 {
     if(DemoSettings.IsSiteMode) {
         rpReadOnlyError.Controls.Add(new LiteralControl(DemoSettings.ReadOnlyErrorMessage));
         rpReadOnlyError.Visible = true;
         e.Cancel = true;
     }
 }

    protected void DSData_Inserting(object sender, SqlDataSourceCommandEventArgs e)
    {
        string NewID = string.Empty;
        OleDbDataAdapter da = new OleDbDataAdapter(@"Select Max(servisetypeid) From servisetype", ConnectionStr("faservice.mdb"));
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count == 0)
            NewID = "1";
        else
            NewID = (Convert.ToInt16(dt.Rows[0][0].ToString()) + 1).ToString();

        e.Command.Parameters["servisetypeid"].Value = NewID;
    }

 protected void DataSourceBrokerList_Inserting(object sender, SqlDataSourceCommandEventArgs e)
 {
     e.Command.Parameters.Clear();
     foreach (SqlParameter p in InsertParameters) e.Command.Parameters.Add(p);
 }

    protected void dsSelectedCompany_Updating(object sender, SqlDataSourceCommandEventArgs e)
    {
        //check to see if the image is in session and if it is use it for pictureURL
        if (Session["newImage"] != null)
        {
            //use uploaded image name
            string imageName = Session["newImage"].ToString();

            //add the value to the insert command (available thru event args)
            e.Command.Parameters["@CompanyLogo"].Value = imageName;

            //remove the image from session variable
            Session["newImage"] = null;//removing the newImage from Session
        }//end if
        else
        {
            //if there was an image uploaded on this editing of the record
            //then we used the same if as we did w inserting a record, but
            //in this case while editing the record if you wind up in this else
            //they have no uploaded a new image. We can assume they had a pictureURL
            //value before.
            //If we skip this step, then the "empty string" will be passed.
            //So if we want to let them keep their old pic, we need to  find
            //that value and reset it.

            //grab what is currently being used and re-use it
            DataClassesDataContext ctx = new DataClassesDataContext();

            string currentImage = (from co in ctx.JFCompanies
                                   where co.CompanyID.ToString() ==
                                   gvCompanies.SelectedValue.ToString()
                                   select co.CompanyLogo).Single();

            //assign back to the pictureURL
            //@ calls on the parametes of the command. we are calling on the update command
            e.Command.Parameters["@CompanyLogo"].Value = currentImage;

        }
    }

    protected void dsSelectedCompany_Inserting(object sender, SqlDataSourceCommandEventArgs e)
    {
        //right before this really does get inserted, we need to make sure the
        //appropriate pictureURL value is included.

        //check to see if the image is in session and if it is use it for pictureURL
        if (Session["newImage"] != null)
        {
            //use uploaded image name
            string imageName = Session["newImage"].ToString();

            //add the value to the insert command (available thru event args)
            e.Command.Parameters["@CompanyLogo"].Value = imageName;

            //remove the image from session variable
            Session["newImage"] = null;//removing the newImage from Session
        }
        else
        {
            //use our noImage image
            e.Command.Parameters["@CompanyLogo"].Value = "NoPhoto.jpg";
        }
    }

 protected void DSData_Inserting(object sender, SqlDataSourceCommandEventArgs e)
 {
     e.Command.Parameters["picpath"].Value = Session["attach"].ToString();
 }

 protected void sdsEliminarAjuste_Updating(object sender, SqlDataSourceCommandEventArgs e)
 {
     //utiles.debugClass.muestra(e.Command,Server.MapPath("log.txt"));
 }

 protected void DSData_Inserting(object sender, SqlDataSourceCommandEventArgs e)
 {
     //e.Command.Parameters["dataid"].Value = MCcontact.GetNewID("alldata", "dataid");
 }

 protected void DSData_Inserting(object sender, SqlDataSourceCommandEventArgs e)
 {
     e.Command.Parameters["UserID"].Value = MCTEFollowUp.GetNewID("FollowupUsers", "UserID");
 }

 protected void customerSqlDataSource_Inserting(object sender, SqlDataSourceCommandEventArgs e)
 {
     //SqlParameter insertedKey = new SqlParameter("@PK_New", SqlDbType.Int);
     //insertedKey.Direction = ParameterDirection.Output;
     //e.Command.Parameters.Add(new SqlParameter("@PK_New", SqlDbType.Int));
 }