Database

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#

UPDATE table                     -- The updates are on the table
                                 -- named "table"

SET field = field + intvariable  -- The field named "field" is being updated
                                 -- The new value is the addition of the
                                 -- existing "field" value plus the value in
                                 -- field named "intvariable"

WHERE otherfield = yes           -- Apply this update only on records where
                                 -- the field "otherfield" is yes

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#

1  void Button1_Click(Object sender, EventArgs e)
2  {
3      string str = TextBox1.Text;
4      int num = Convert.ToInt32(str);
5      string strConnect = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source="+Server.MapPath(".\\db\\tstdb.mdb");
6      string strupdate = "UPDATE tsttbl SET value = value + str";
7
8      // ... Remainder of method here ...
9  }

string strupdate = string.Concat("UPDATE tsttbl SET value = value + ",num.ToString());

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#

[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Data Source= (etc)

Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
    
Dim rs As ADODB.Recordset
    
conn.ConnectionString = _
    "connection string from UDL file"
 
conn.Open
    
cmd.CommandText = "select command"
cmd.CommandType = adCmdText
cmd.ActiveConnection = conn
 
Set rs = cmd.Execute(, , adOpenForwardOnly Or adLockReadOnly)

SELECT (MSD + Methods + Analysis + Architectures + Models + 
    Studio + Elective1 + Elective2 + Elective3) As PersonTotals, 
    FirstName, LastName, WeekNo, ProgramName, StudioTeamName
FROM tblpersons

SELECT SUM(MSD + Methods + Analysis + Architectures + Models + 
    Studio + Elective1 + Elective2 + Elective3) As PersonTotals, 
    FirstName, LastName, WeekNo, ProgramName, StudioTeamName
FROM tblpersons
GROUP BY FirstName, LastName, WeekNo, ProgramName, StudioTeamName

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#