CDList

• Download source files - 24 Kb

Introduction

CDList is a useful application used to locate where your different CD or DVD are.
CDList is writen in C# using SQLCe.

Brief Code Description

public NewForm(MainForm mf, int ID) //Parent (to access to public function 
                                    // to refresh ListView), 
                                    //ID (0 if new, other if modify)
{
    //
    // Required for Windows Form Designer support
    //
    InitializeComponent();
    conn = new SqlCeConnection ("Data Source = CDList.sdf");
    parentForm = mf;
    IDEdit = ID;
    //
    // TODO: Add any constructor code after InitializeComponent call
    //
}

private void NewForm_Load(object sender, System.EventArgs e)
{
    UpdateCmbox(); //Populate ComboBoxes
    if (IDEdit != 0) //If Modify mode, populate all fields
    {
        conn.Open();
        cmd = conn.CreateCommand();
        cmd.CommandText = "SELECT * FROM tbl_CDList WHERE ID = "+IDEdit+";";
        SqlCeDataReader rdr = cmd.ExecuteReader();
        rdr.Read();
        Title.Text = rdr.GetString(1);
        Content.Text = rdr.GetString(2);
        cmbType.Text = rdr.GetString(3);
        cmbLocation.Text = rdr.GetString(4);
        conn.Close();
    } 
}

private void UpdateCmbox() //Reset all fields and populate ComboBoxes
{
    Title.Text = "";
    Content.Text = "";
    cmbLocation.Text = "";
    cmbType.Text = "";
    cmbLocation.Items.Clear();
    conn.Open();
    cmd = conn.CreateCommand();
    cmd.CommandText = "SELECT Title FROM tbl_Locations ORDER BY Title ASC;";
    SqlCeDataReader rdr = cmd.ExecuteReader();
    while(rdr.Read())
    {
        cmbLocation.Items.Add(rdr.GetString(0));
    }
    cmbLocation.Refresh();
    cmbType.Items.Clear();
    cmd.CommandText = "SELECT Title FROM tbl_Types ORDER BY Title ASC;";
    rdr = cmd.ExecuteReader();
    while(rdr.Read())
    {
        cmbType.Items.Add(rdr.GetString(0));
    }
    cmbType.Refresh();
    conn.Close();
}



private void Reset_Click(object sender, System.EventArgs e)
{
    UpdateCmbox();
}

private void Save_Click(object sender, System.EventArgs e)
{
    conn = new SqlCeConnection ("Data Source = CDList.sdf");
    conn.Open();
    cmd = conn.CreateCommand();
    if (IDEdit != 0) //If modify mode
    {
        cmd.CommandText = "UPDATE tbl_CDList SET Title = '"+Title.Text+"',"+ 
                           "Content = '"+Content.Text+"', +
                           "Location = '"+cmbLocation.Text+"', Type = '"+
                           cmbType.Text+"' WHERE ID = "+IDEdit;
    }
    else //else insert mode
    {
        cmd.CommandText = "INSERT INTO tbl_CDList(Title, Content, Location, "+
                           "Type) VALUES ('"+Title.Text+"', "+
                           "'"+Content.Text+"', '"+cmbLocation.Text+"' ,'"+
                           cmbType.Text+"')";
    }
    cmd.ExecuteNonQuery();
    conn.Close();
    parentForm.UpdateLView();
    UpdateCmbox();
}

Resources

MSDN Library January 2004 for how to connect to a SQLCe database.