Search Results

Search found 6 results on 1 pages for 'rezzie'.

Page 1/1 | 1 

  • System.Data.SQLite parameterized queries with multiple values?

    - by Rezzie
    I am trying to do run a bulk deletion using parameterized queries. Currently, I have the following code: pendingDeletions = new SQLiteCommand(@"DELETE FROM [centres] WHERE [name] = $name", conn); foreach (string name in selected) pendingDeletions.Parameters.AddWithValue("$name", centre.Name); pendingDeletions.ExecuteNonQuery(); However, the value of the parameter seems to be overwritten each time and I end up just removing the last centre. What is the correct way to execute a parameterized query with a list of values?

    Read the article

  • C# Path Ellipsis without Win32 API call

    - by Rezzie
    I have a long path I'd like to shorten for displaying on a form using the ellipsis character(s?). I know there is the PathCompactPathEx Win32 API call, but I know there is a built-in .NET equivalent. I have used it previously, but cannot find it any more. Any hints, please?

    Read the article

  • Thin-border on WPF window?

    - by Rezzie
    I'd like to create a window, using WPF, that has a thin border all the way around the form - i.e. no space for the title bar with the icon/caption and min/max/close buttons. For example, the "extra" icons form of the new Windows 7 taskbar: How can I do this with WPF (I don't mind resorting to the Win32 API, if not supported natively by WPF)?

    Read the article

  • Conditional SQLite check constraint?

    - by Rezzie
    I have a table defined by the following SQL: CREATE TABLE test ( id integer PRIMARY KEY NOT NULL UNIQUE, status text NOT NULL, enddate date, /* Checks */ CHECK (status IN ("Current", "Complete")) ); I'd like to add a constraint that requires enddate to be non-null if the status is "Complete". Is this possible? I am using SQLite v3.6.16.

    Read the article

1