Do not use the CInsert class directly. Use the preallocated WIDatabase.Insert variable instead.
Namespace: Wiker.WIDatabaseFunctions to Insert data into tables.
Assembly:
Syntax
C# |
---|
public class CInsert |
Visual Basic |
---|
Public Class CInsert |
Visual C++ |
---|
public ref class CInsert |
Examples

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();