Overload | Description |
---|---|
Item(Int32) | Gets or sets the SQLiteParameter at the specified index. |
Item(String) | Gets or sets the SQLiteParameter with the specified name. |
Overload | Description |
---|---|
Item(Int32) | Gets or sets the SQLiteParameter at the specified index. |
Item(String) | Gets or sets the SQLiteParameter with the specified name. |
public void CreateSQLiteParamColl(SQLiteCommand sqCommand) { SQLiteParameterCollection myParamCollection = sqCommand.Parameters; myParamCollection.Add("DeptNo", SQLiteType.Int32); myParamCollection.Add("DName", SQLiteType.Text); myParamCollection.Add("Loc", SQLiteType.Text); string myParamNames = ""; for (int i=0; i < myParamCollection.Count; i++) myParamNames += myParamCollection[i].ToString() + "\n"; MessageBox.Show(myParamNames); myParamCollection.Clear(); }
Public Sub CreateSQLiteParamColl(sqCommand As SQLiteCommand) Dim myParamCollection As SQLiteParameterCollection = sqCommand.Parameters myParamCollection.Add("DeptNo", SQLiteType.Int32) myParamCollection.Add("DName", SQLiteType.Text) myParamCollection.Add("Loc", SQLiteType.Text) Dim myParamNames As String = "" Dim i As Integer For i = 0 To myParamCollection.Count - 1 myParamNames += myParamCollection(i).ToString() + ControlChars.Cr Next i MessageBox.Show(myParamNames) myParamCollection.Clear() End Sub