System.Data.SQLite

Check-in [6d6e89424f]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Actually, refactor the previous commit to make use of the LoadProperties method override.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | designOptions
Files: files | file ages | folders
SHA1: 6d6e89424fd9217570564a904d3c7fb0eacd33d3
User & Date: mistachkin 2014-08-01 18:21:51.445
Context
2014-08-01
18:58
Remove superfluous line from the previous commit. check-in: a5e6c41c19 user: mistachkin tags: designOptions
18:21
Actually, refactor the previous commit to make use of the LoadProperties method override. check-in: 6d6e89424f user: mistachkin tags: designOptions
18:19
Initially, disable the provider_Changed event in the connection properties user-interface. check-in: 2154db970d user: mistachkin tags: designOptions
Changes
Unified Diff Ignore Whitespace Patch
Changes to SQLite.Designer/SQLiteConnectionUIControl.cs.
︙︙
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41


  /// <summary>
  /// Provides a UI to edit/create SQLite database connections
  /// </summary>
  [ToolboxItem(false)]
  public partial class SQLiteConnectionUIControl : DataConnectionUIControl
  {
    bool enableProviderChanged = false;

    public SQLiteConnectionUIControl()
    {
      InitializeComponent();
      SQLiteOptions.AddProviderNames(providerComboBox.Items);
      SQLiteOptions.SelectProviderName(providerComboBox);
      enableProviderChanged = true;
    }

    private void browseButton_Click(object sender, EventArgs e)
    {
      OpenFileDialog dlg = new OpenFileDialog();
      dlg.FileName = fileTextBox.Text;
      dlg.Title = "Select SQLite Database File";








<
<




<
<








20
21
22
23
24
25
26


27
28
29
30


31
32
33
34
35
36
37


  /// <summary>
  /// Provides a UI to edit/create SQLite database connections
  /// </summary>
  [ToolboxItem(false)]
  public partial class SQLiteConnectionUIControl : DataConnectionUIControl
  {


    public SQLiteConnectionUIControl()
    {
      InitializeComponent();
      SQLiteOptions.AddProviderNames(providerComboBox.Items);


    }

    private void browseButton_Click(object sender, EventArgs e)
    {
      OpenFileDialog dlg = new OpenFileDialog();
      dlg.FileName = fileTextBox.Text;
      dlg.Title = "Select SQLite Database File";
︙︙
58
59
60
61
62
63
64


65
66
67
68
69
70
71

      }
    }

    #region IDataConnectionUIControl Members

    public override void LoadProperties()
    {


      if (ConnectionProperties.Contains("data source"))
        fileTextBox.Text = ConnectionProperties["data source"] as string;
      else
        fileTextBox.Text = String.Empty;

      if (ConnectionProperties.Contains("password"))
        passwordTextBox.Text = ConnectionProperties["password"] as string;








>
>








54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69

      }
    }

    #region IDataConnectionUIControl Members

    public override void LoadProperties()
    {
      SQLiteOptions.SelectProviderName(providerComboBox);

      if (ConnectionProperties.Contains("data source"))
        fileTextBox.Text = ConnectionProperties["data source"] as string;
      else
        fileTextBox.Text = String.Empty;

      if (ConnectionProperties.Contains("password"))
        passwordTextBox.Text = ConnectionProperties["password"] as string;
︙︙
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122

    {
        if (!enableProviderChanged)
            return;

        object item = providerComboBox.SelectedItem;

        if (item != null)
        {
            SQLiteOptions.SetProviderName(item.ToString());
            LoadProperties();
        }
    }

    private void sync_Changed(object sender, EventArgs e)
    {
      string sync = "Normal";
      if (fullRadioButton.Checked == true) sync = "Full";
      else if (offRadioButton.Checked == true) sync = "Off";








<

<
<








103
104
105
106
107
108
109

110


111
112
113
114
115
116
117

    {
        if (!enableProviderChanged)
            return;

        object item = providerComboBox.SelectedItem;

        if (item != null)

            SQLiteOptions.SetProviderName(item.ToString());


    }

    private void sync_Changed(object sender, EventArgs e)
    {
      string sync = "Normal";
      if (fullRadioButton.Checked == true) sync = "Full";
      else if (offRadioButton.Checked == true) sync = "Off";
︙︙