Get the latest set of files from system.data.sqlite.org. Binary packages are intended to be used for development and deployment of their applications onto customer machines. Ensure you select the correct version for the .NET Framework version and Windows 32/64bit version your applicaiton targets. Select the version without 'mixed-mode assembly' bundle. (Setup packages are intended for developer machines if […]
All posts by
.SQLite General
https://www.sqlite.org SQLite doesn't require any installation on the client machine. It depends on the Visual C++ runtime, but you don't need to install it on the client machine. The system.data.sqlite download page contains several "static" packages that already contain the runtime. SQLite isn't a full SQL database, it uses a small set of datatypes and doesn't have […]
.Microsoft SQL Server Compact General
SQL Server Compact has been deprecated and is no longer included in VS. "SQL Server compact edition is in deprecation mode with no new releases planned near future. Last release SQL CE 4.0SP1 (and earlier releases that are still in the support cycle) will continue to be supported through its lifecycle and Microsoft is committed […]
VS2008 to VS2013 Changes
Upgrading A Project Make a backup copy and then open the project using VS2013. After the migration delete all of the old ".vcproj" files
.MySQL for Visual Studio General
Product Page http://www.mysql.com/why-mysql/windows/visualstudio/ Download MySQL for Visual Studio http://dev.mysql.com/downloads/windows/visualstudio/ There is the 'MySQL for Visual Studio' installer (V1.2.3 at the time of writing), and also a 'MySQL Installer for Windows' (V5.6 at the time of writing) which installs all MySQL products for Windows. Documentation & Forum http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio.html MySQL Forums :: MySQL for Visual Studio
Newtonsoft Json Library
Download the library from http://james.newtonking.com/json Add Newtonsoft.Json.dll to your main project directory. Right click your project > Properties > Common Properties > Framework & References > Add new reference Select the Browse tab and select the Newtonsoft.Json.dll file Convert Json File To Class using namespace Newtonsoft::Json //—– CLASSES FOR THE JSON DESERIALIZATION —– public ref class Json_global_channels […]
DataGridViewComboBoxColumn
See here for usage example. Changing look so its not a button DataGridViewComboBoxColumn ^DataGridViewComboBoxColumn1 = gcnew DataGridViewComboBoxColumn(); DataGridViewComboBoxColumn1->FlatStyle = FlatStyle::Flat; Reading Value You read the text contents rather than the selected index. Don't use ->ToString() as it causes errors with nulls. if (Convert::ToString(dataGridView1->Rows[0]->Cells[2]->Value) == "")
DataGridViewCheckBoxColumn
Setting State Programatically dataGridView1->Rows[Count]->Cells[COL_MAY_EXPORT]->Value = System::Windows::Forms::CheckState::Checked; Reading State if (Convert::ToBoolean(dataGridView1->Rows[0]->Cells[3]->Value))
Buttons, Images etc in a DataGridView
Programmatically creating DataGridView with customised items in each cell Setup The DataGridView //—– CREATE THE DATAGRID VIEW COLUMNS —– dataGridView1->AutoGenerateColumns = false; dataGridView1->DataSource = nullptr; //Clear the grid if necessary dataGridView1->Columns->Clear(); //TEXT BOX COLUMN DataGridViewTextBoxColumn ^DataGridColumnString1 = gcnew DataGridViewTextBoxColumn(); DataGridColumnString1->HeaderText = "My String Column"; //DataGridColumnString1->ReadOnly = true; //DataGridColumnName->SortMode = DataGridViewColumnSortMode::NotSortable; dataGridView1->Columns->Add(DataGridColumnString1); //BUTTON COLUMN DataGridViewButtonColumn ^DataGridColumnButton1 = […]
.Data Grid View General
Alterntaives to Data Grid View The List View control provides several of the data grid view features including multiple columns per item. If you want to use images in columns other than column 1 or buttons then a datagrid view is usually a better choice. Column Types DataGridView columns can setup as: Text Button CheckBox […]