PlItems

ID: 239
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Text in Großschrift oder Kleinschrift
Code: //http://us2.php.net/manual/de/function.strtoupper.php $myString = "my lovely Mr Singing Club"; echo strtoupper($myString); // MY LOVELY MR SINGING CLUB //http://php.net/manual/de/function.strtolower.php echo strtolower($myString);

ID: 250
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Erster Buchstable Groß in Wort
Code: $myString = "nothingspecial"; $uc = ucwords($myString); echo $uc; // Nothingspecial

ID: 3
PlCodelang: VB.NET
PlGroup: GUI, MDI-Fenster
PlItemTitle: Aktives MDIChild und dessen Elemente
Code: If Me.ActiveMdiChild IsNot Nothing Then Dim frm As SubForm = CType(Me.ActiveMdiChild, SubForm) frm.textBox1.Text = "......." End If ' Beispiel: If Me.ActiveMdiChild IsNot Nothing Then If Me.ActiveMdiChild.Name="frmHotel" Then Dim frm As frmHotel = CType(Me.ActiveMdiChild, frmHotel) MessageBox.Show(frm.hotelid) End If End If

ID: 4
PlCodelang: VB.NET
PlGroup: GUI, MDI-Fenster
PlItemTitle: Alle MDIChilds durchlaufen
Code: Dim oForm As Form For Each oForm In Me.MdiChildren If Not TypeName(oForm) = "MDIForm" Then If oForm.Name = "frmHotel" Then ' Es gibt mind. 1 geöffnetes Browser-Fenster ' ... End If End If Next

ID: 5
PlCodelang: VB.NET
PlGroup: GUI, MDI-Fenster
PlItemTitle: Auf ein Object eines MDIChilds zugreifen
Code: Dim oForm As Form For Each oForm In Me.MdiChildren If Not TypeName(oForm) = "MDIForm" Then If oForm.Name = "frmHotel" Then MessageBox.Show(oForm.GetType.ToString + "|" + CType(oForm, frmHotel).hotelid.ToString) End If End If Next

ID: 22
PlCodelang: VB.NET
PlGroup: GUI, Tabelle
PlItemTitle: Tabellenselektion
Code: ' DataGridView ' Man bekommt den Index der Column und der Row Dim counter As Integer For counter = 0 To (DataGridView1.SelectedCells.Count - 1) MessageBox.Show(DataGridView1.SelectedCells(counter).ColumnIndex.ToString & vbCr & DataGridView1.SelectedCells(counter).RowIndex.ToString) Next

ID: 23
PlCodelang: VB.NET
PlGroup: GUI, Datenbank
PlItemTitle: ComboBox mit Datenbank
Code: ' Die Datenbank-Tabelle enthält die Felder titel und id Dim dt As Data.DataTable = myDataTable ' Die DataTable wurde bereits gefüllt aus der Datenbank... comboBox1.DataSource = dt comboBox1.DisplayMember = "titel" ' Der angezeigte Wert für den Benutzer comboBox1.ValueMember = "id" ' Der Wert, den der Benutzer auswählt (id) Dim ausgewaehlteIdAusComboBox As String ausgewaehlteIdAusComboBox=comboBox1.SelectedValue.ToString ' enthält die ausgewählte id

ID: 61
PlCodelang: VB.NET
PlGroup: Schleifen
PlItemTitle: For-Schleife
Code: For i As Integer = 0 To 10 Debug.WriteLine(i) ' 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Next For i As Integer = 10 To 5 Step -1 Debug.WriteLine(i) ' 10, 9, 8, 7, 6, 5 Next

ID: 62
PlCodelang: VB.NET
PlGroup: Array
PlItemTitle: Array definieren
Code: Dim myStrArray(3) As String myStrArray(0)="First" myStrArray(1)="Second" myStrArray(2)="Third" myStrArray(3)="Fourth" ReDim strJahreszeiten(4) myStrArray(4)="Fifth" Dim my2DimStrArray(1,2) As String my2DimStrArray(0,0) = "This" my2DimStrArray(0,1) = "is" my2DimStrArray(0,2) = "a" my2DimStrArray(1,0) = "2" my2DimStrArray(1,1) = "dimensional" my2DimStrArray(1,2) = "matrix"

ID: 68
PlCodelang: VB.NET
PlGroup: GUI, Komponenten allgemein
PlItemTitle: Dezimal/Währungseingabe in zwei Textboxen
Code: Sub TextBox1KeyUp(sender As Object, e As KeyEventArgs) If ((e.KeyCode = Keys.Oemcomma) OR (e.KeyCode = Keys.Decimal)) Then CType(Sender,TextBox).Text = CType(Sender,TextBox).Text.Trim(",") CType(Sender,TextBox).SelectionStart = CType(Sender,TextBox).Text.Length For i As Integer = 0 To Me.Controls.Count-1 If Me.Controls.Item(i).TabIndex = CType(Sender,TextBox).TabIndex+1 Then CType(Me.Controls.Item(i),TextBox).Focus End If Next End If End Sub

ID: 133
PlCodelang: VB.NET
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: Dim longStr = "This is a long string" Dim searchFor = "long" position = InStr( longStr, searchFor )

ID: 6
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: SELECT NOW(); INSERT INTO table (datetime) VALUES (NOW());

ID: 10
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Lesen Datensatzes
Code: SELECT * FROM myTable WHERE id=1; SELECT field2,field17 FROM myTable WHERE id=1 AND name='test'; SELECT field3,field1 FROM myTable WHERE city like '%ew Yor%';

ID: 271
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: UPDATE SQL mit JOIN
Code: UPDATE TableToBeUpdated UPD_TABLE INNER JOIN JoinedTable J ON J.id = UPD_TABLE.id SET UPD_TABLE.myField1 = 'Update this field' ;

ID: 287
PlCodelang: MySQL
PlGroup: Strings
PlItemTitle: Anzahl an Zeichen in einem String ermitteln
Link Reference: https://pisceansheart.wordpress.com/2008/04/15/count-occurrence-of-character-in-a-string-using-mysql/
Code: -- Gets only result with 4 "/" in the the field relativePath SELECT id ,albumRoot ,relativePath ,date ,caption ,collection ,icon ,LENGTH(relativePath) - LENGTH(REPLACE(relativePath,'/','')) AS `occurrences` FROM Albums WHERE LENGTH(relativePath) - LENGTH(REPLACE(relativePath,'/',''))=4 ;

ID: 83
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Tabellenstruktur kopieren
Code: CREATE TABLE zieltabelle SELECT * FROM quelltabelle WHERE ID=-1;

ID: 130
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: CSV erstellen
Code: -- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat SELECT R.TITEL AS TITEL ,R.ANLEITUNG AS ANLEITUNG ,GROUP_CONCAT(CONCAT(CAST(RZ.MENGE AS CHAR),' ',RZ.EINHEIT,' ' ,Z.ZUTAT) SEPARATOR ',') AS ZUTATEN ,R.NOTIZ AS NOTIZ FROM REZEPT AS R LEFT JOIN REZEPT_HAS_ZUTAT AS RZ ON R.ID=RZ.REZEPT_ID LEFT JOIN ZUTAT AS Z ON RZ.ZUTAT_ID=Z.ID AND RZ.REZEPT_ID=R.ID

ID: 205
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Tagesname
Code: SELECT DAYNAME(NOW()); -- Monday SELECT DAYNAME('2014-08-10'); -- Sunday -- To get localized names switch the parameter, e.g. to German SET lc_time_names = 'de_DE'; SELECT DAYNAME('2014-08-10'); -- Sonntag

ID: 206
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Tabelle DB übergreifend kopieren
Code: DROP TABLE IF EXISTS `DestinationDB`.`Table1`; CREATE TABLE `DestinationDB`.`Table1` SELECT * FROM `SourceDB`.`Table1`;

ID: 218
PlCodelang: MySQL
PlGroup: Datenmengen
PlItemTitle: Anzahl Zeilen Resultset begrenzen
Code: SELECT * FROM tableA LIMIT 100;