This article explains the following:

Database Chamber

Use the following table and Stored Procedure to demonstrate this concept.

  1. Create table Mas_Employee
  2. (
  3. Id int primary key identity(1,1),
  4. Name varchar(50)
  5. )
  7. --To get all the employees
  8. Create Procedure USP_Select_Mas_Employee
  9. @Id int = null
  10. AS
  11. Begin
  12. Select E.Id, E.Name
  13. From Mas_Employee E
  14. Where Id = Isnull(@Id, Id)
  15. End
  17. --To Insert employee details
  18. Create Procedure USP_Insert_Mas_Employee
  19. @Name varchar(50)
  20. AS
  21. Begin
  22. Insert into Mas_Employee(Name) Values(@Name)
  23. End
  25. --To Delete employee details
  26. Create Procedure USP_Delete_Mas_Employee
  27. @Id int
  28. AS
  29. Begin
  30. Delete From Mas_Employee
  31. where Id=@Id
  32. End
Application Chamber

To create the project -

Web.Config:

Create the connection string in the Web.Config file as in the following code snippet:

  1. <connectionStrings>
  2. <add name="conStr"
  3. connectionString="Password= 1234; User ID=sa; Database=DB_CsharpCorner; Data Source=."
  4. providerName="System.Data.SqlClient"/>
  5. </connectionStrings>
Next: Right-click on Solution Explorer and add a web form to your project.

Webform Design:

Design you Webform (.aspx page) as in the following:
  1. <form id="form1" runat="server">
  2. <div style="width: 100%;" align="center">
  3. <fieldset style="width: 40%;">
  4. <legend>Delete Selected item from ListBox and Database</legend>
  5. <table style="width: 100%;">
  6. <tr>
  7. <td>
  8. Name:
  9. </td>
  10. <td>
  11. <asp:TextBox ID="txtEmpName" runat="server"></asp:TextBox>
  12. </td>
  13. <td>
  14. <asp:Button ID="btnAdd" runat="server" Text="Add" OnClick="btnAdd_Click" />
  15. </td>
  16. </tr>
  17. <tr>
  18. <td colspan="3" style="text-align:center;">
  19. <asp:Label ID="lblMsg" runat="server"></asp:Label>
  20. </td>
  21. </tr>
  22. <tr>
  24. <td colspan="2">
  25. <asp:ListBox ID="lstEmployee" runat="server"></asp:ListBox>
  26. </td>
  27. <td>
  28. <asp:Button ID="btnDelete" runat="server" Text="Delete Selected Item" OnClick="btnDelete_Click" />
  29. </td>
  30. </tr>
  31. </table>
  32. </fieldset>
  33. </div>
  34. </form>
CodeBehind:

Add the following namespaces:
  1. using System.Data;
  2. using System.Data.SqlClient;
  3. using System.Configuration;
  4. using System.Drawing;
Invoke the ConnectionString from Web.Config as in the following:
  1. SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);
User Defined Functions:
  1. #region User Defined Methods
  3. //To Clear the fields
  4. private void Clear()
  5. {
  6. txtEmpName.Text = string.Empty;
  7. lblMsg.Text = string.Empty;
  8. }
  10. //To bind listBox from Database
  11. private void BindListBox()
  12. {
  13. SqlDataAdapter adp = new SqlDataAdapter("USP_Select_Mas_Employee", con);
  14. adp.SelectCommand.CommandType = CommandType.StoredProcedure;
  15. DataSet ds = new DataSet();
  16. adp.Fill(ds);
  17. if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
  18. {
  19. lstEmployee.DataSource = ds;
  20. lstEmployee.DataValueField = "Id";
  21. lstEmployee.DataTextField = "Name";
  22. lstEmployee.DataBind();
  23. }
  24. }
  26. //To delete the selected item from Database
  27. private void DeleteSelectedItem(int Id)
  28. {
  29. SqlCommand cmd = new SqlCommand("USP_Delete_Mas_Employee", con);
  30. cmd.CommandType = CommandType.StoredProcedure;
  31. cmd.Parameters.AddWithValue("@Id", Id);
  32. if (con.State == ConnectionState.Closed)
  33. {
  34. con.Open();
  35. }
  36. int result = cmd.ExecuteNonQuery();
  37. if (result > 0)
  38. {
  39. Clear();
  40. //BindListBox();
  41. lblMsg.Text = "Employee deleted successfully";
  42. lblMsg.ForeColor = Color.Green;
  43. }
  44. }
  46. //To add the employee from textbox to listBox
  47. private void AddEmployee(string Name)
  48. {
  49. SqlCommand cmd = new SqlCommand("USP_Insert_Mas_Employee", con);
  50. cmd.CommandType = CommandType.StoredProcedure;
  51. cmd.Parameters.AddWithValue("@Name", Name);
  52. if (con.State == ConnectionState.Closed)
  53. {
  54. con.Open();
  55. }
  56. int result = cmd.ExecuteNonQuery();
  57. if (result > 0)
  58. {
  59. Clear();
  60. BindListBox();
  61. lblMsg.Text = "Employee added successfully";
  62. lblMsg.ForeColor = Color.Green;
  63. }
  64. }
  66. #endregion
Page Event Handlers:
  1. #region Page Event Handlers
  3. protected void Page_Load(object sender, EventArgs e)
  4. {
  5. lblMsg.Text = string.Empty;
  6. if (!Page.IsPostBack)
  7. {
  8. BindListBox();
  9. }
  10. }
  12. protected void btnAdd_Click(object sender, EventArgs e)
  13. {
  14. if (txtEmpName.Text.ToString() != string.Empty || txtEmpName.Text.ToString() != null)
  15. AddEmployee(txtEmpName.Text.ToString());
  16. else
  17. {
  18. lblMsg.Text = "Please provide the Name";
  19. lblMsg.ForeColor = Color.Red;
  20. return;
  21. }
  22. }
  24. protected void btnDelete_Click(object sender, EventArgs e)
  25. {
  26. if (Convert.ToInt32(lstEmployee.SelectedValue) < 0)
  27. {
  28. lblMsg.Text = "Please select an item";
  29. lblMsg.ForeColor = Color.Red;
  30. return;
  31. }
  32. else
  33. {
  34. for (int i = lstEmployee.Items.Count - 1; i >= 0; i--)
  35. {
  36. if (lstEmployee.Items[i].Selected)
  37. {
  38. DeleteSelectedItem(Convert.ToInt32(lstEmployee.Items[i].Value));
  39. lstEmployee.Items.Remove(lstEmployee.Items[i]);
  40. }
  41. }
  42. }
  43. }
  44. #endregion
Output:

Enter the name and click on Add.

Enter the name

Then the output will be as in the following screenshot:

output

Select the ListBox Item and click Delete Selected Item button then it will be Deleted in ListBox as well as in the database.

Select the ListBox

I hope you enjoyed this article. Please provide your valuable suggestions and feedback to make this article much reliable.