Here is a quick example on using an autocomplete combobox in the DataGridView. In this example I load all the possible values for the combobox into a AutoCompleteStringCollection and make that the DataGridViewComboBox's datasource. In the editingControl showing event you need to set the ComboBox's DropDownStyle, and the auto complete settings.
Imports System.Data.SqlClient
Public Class Form1
Dim scAutoComplete As New AutoCompleteStringCollection
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim strConn As String
Dim da As SqlDataAdapter
Dim conn As SqlConnection
Dim ds As New DataSet
strConn = "Server = .\SQLEXPRESS;Database = NorthWind; Integrated Security = SSPI;"
conn...
The easiest way to upload a database to dotster is to use the sql hosting toolkit. Visual studio 2008 installs the sql hosting toolkit for you otherwise you need to download and install from the link.
Steps to do this
1) Create a database in the dotster control panel.
2) In the server explorer create a link to the database you want to upload.
3) Right click on the database and select publish to provider in the wizard make sure you select sql 2000 as the target database schema.
4) On the codeplex website they use to have a webpage available to use to help...