Do not use the CInsert class directly. Use the preallocated WIDatabase.Insert variable instead.

Functions to Insert data into tables.

Namespace: Wiker.WIDatabase
Assembly: 

Syntax

C#
public class CInsert
Visual Basic
Public Class CInsert
Visual C++
public ref class CInsert

Examples

CopyC#
WIDatabase WIDB;
CDatabaseInfo DBInfo;
int ColumnID;
public int ColumnId;
public bool BoolData;
public byte ByteData;
public Int16 Int16Data;
public Int32 Int32Data;
public Int64 Int64Data;
public decimal DecimalData;
public double DoubleData;
public float FloatData;
public DateTime DateTimeData;
public char CharData;
public char[] VarCharData;
public string TextData;
public Image ImageData;
public byte[] BinaryData;

/* Create CDatabaseInfo object and populate with database login info */
DBInfo = new CDatabaseInfo();
DBInfo.DatabaseType = eDatabaseType.SQL;
DBInfo.Location     = "SqlServer";
DBInfo.DBName       = "TestDatabase";
DBInfo.Username     = "LoginName";
DBInfo.Password     = "LoginPassword";

/* Create new instance of WIDatabase */
WIDB = new WIDatabase(DBInfo);

/*----------------------------------------------------------------------------*/

BoolData = false;
ByteData = byte.MinValue;
Int16Data = Int16.MinValue;
Int32Data = Int32.MinValue;
Int64Data = Int64.MinValue;
DecimalData = -7.92281625142643E+28M;
DoubleData = -1.7976931348623E+308;
FloatData = float.MinValue;
DateTimeData = DateTime.MinValue;

CharData = char.MinValue;
CharData ++;

VarCharData = new char[]{'1', '2', '\0', '\t', 'a', '\b', '5'};
TextData = "MinValue Test data";

BinaryData = new byte[100];
FileStream FS = File.Open("\\Tmp\\Write.exe", FileMode.Open);
FS.Read(BinaryData, 0, 100);
FS.Close();

ImageData = Image.FromFile("\\Tmp\\Alias.png");

/*----------------------------------------------------------------------------*/

WIDB.Insert.Column("Bool", BoolData);
WIDB.Insert.Column("Byte", ByteData);
WIDB.Insert.Column("Int16", Int16Data);
WIDB.Insert.Column("Int32", Int32Data);
WIDB.Insert.Column("Int64", Int64Data);
WIDB.Insert.Column("Decimal", DecimalData);
WIDB.Insert.Column("Double", DoubleData);
WIDB.Insert.Column("Float", FloatData);
WIDB.Insert.Column("DateTime", DateTimeData);
WIDB.Insert.Column("Char", CharData);
WIDB.Insert.Column("VarChar", VarCharData);
WIDB.Insert.Column("Text", TextData);
WIDB.Insert.Column("Image", ImageData);
WIDB.Insert.Column("Binary", BinaryData);

wiDB.Insert.Table("tblDataType");

if (!wiDB.Insert.Execute(out ColumnID))
   return(false);

WIDB.Close();

Inheritance Hierarchy

System..::..Object
  Wiker.WIDatabase..::..CInsert

See Also