updateform in wpf

Install the necessary NuGet packages:

• System.Data.SqlClient for connecting to SQL Server.
• System.Configuration.ConfigurationManager for accessing the connection string from the configuration file.

Add a connection string to your App.config or Web.config file:

Create a class to handle database operations:

   using System;
   using System.Configuration;
   using System.Data.SqlClient;

   public class DatabaseHelper
   {
       private static string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

       public static void UpdateData(string tableName, string columnToUpdate, string newValue, string condition)
       {
           using (SqlConnection connection = new SqlConnection(connectionString))
           {
               connection.Open();
               string sql = $"UPDATE {tableName} SET {columnToUpdate} = @newValue WHERE {condition}";

               using (SqlCommand command = new SqlCommand(sql, connection))
               {
                   command.Parameters.AddWithValue("@newValue", newValue);
                   command.ExecuteNonQuery();
               }
           }
       }

       public static void DeleteData(string tableName, string condition)
       {
           using (SqlConnection connection = new SqlConnection(connectionString))
           {
               connection.Open();
               string sql = $"DELETE FROM {tableName} WHERE {condition}";

               using (SqlCommand command = new SqlCommand(sql, connection))
               {
                   command.ExecuteNonQuery();
               }
           }
       }
   }

In your WPF code, you can call the methods from the DatabaseHelper class to update or delete data:

   DatabaseHelper.UpdateData("YourTableName", "ColumnName", "NewValue", "Condition");
   DatabaseHelper.DeleteData("YourTableName", "Condition");

Replace "YourServer" with the server name, "YourDatabase" with the database name, "YourTableName" with the table name, "ColumnName" with the column to update, "NewValue" with the new value, and "Condition" with the condition for update or delete operation.

To delete table data in WPF code, you can use the following steps:

1. Get the data row that you want to delete.
2. Call the DataGridView.Rows.Remove() method.

Here is an example of the code:

// Get the data row that you want to delete.
DataGridViewRow row = dataGridView1.Rows[0];

// Call the DataGridView.Rows.Remove() method.
dataGridView1.Rows.Remove(row);

You can modify this code to fit your specific needs. For example, you could delete multiple rows at once, or you could delete all rows in the DataGridView.

You can update and delete table data in WPF code:

To update table data in WPF code, you can use the following steps:

1. Get the data row that you want to update.
2. Set the values of the data row's properties to the new values.
3. Call the DataGridView.Update() method.

// Get the data row that you want to update.
DataGridViewRow row = dataGridView1.Rows[0];

// Set the values of the data row's properties to the new values.
row.Cells["Name"].Value = "John Doe";
row.Cells["Address"].Value = "123 Main Street";

// Call the DataGridView.Update() method.
dataGridView1.Update();

To update or delete table data in WPF (Windows Presentation Foundation) code, you can use ADO.NET or an Object-Relational Mapping (ORM) tool such as Entity Framework. Here is an example using ADO.NET:

private void UpdateOrDeleteData(bool isUpdate, int id, string newValue)
{
    string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;";
    string commandText = isUpdate ? "UPDATE TableName SET Column1=@Value1 WHERE ID=@ID" : "DELETE FROM TableName WHERE ID=@ID";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(commandText, connection);
        command.Parameters.AddWithValue("@ID", id);
        
        if (isUpdate)
        {
            command.Parameters.AddWithValue("@Value1", newValue);
        }

        connection.Open();
        command.ExecuteNonQuery();
        connection.Close();
    }
}

To update data, call the method with isUpdate set to true, and provide the id of the row to update and the new value for Column1:

UpdateOrDeleteData(true, 1, "NewValue");

To delete data, call the method with isUpdate set to false and provide the id of the row to delete:

UpdateOrDeleteData(false, 1, null);

Thanks

To update or delete table data in WPF using code, you need to perform the following steps:

1. Create a connection string to your database
2. Create a SQL query to update or delete the required data from the table
3. Create a SQLCommand object and assign the SQL query and connection string to it
4. Use the ExecuteNonQuery() method of the SQLCommand object to execute the query and update or delete the table data.