.NET (Core and Framework)

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Data;


namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            Test1();
        }

        public static void Test1()
        {
            DataTable dt1 = new DataTable();
            //
            dt1.Columns.Add("col0");
            dt1.Columns.Add("col1");
            dt1.Columns.Add("col2");
            //
            dt1.Columns[0].DataType = typeof(Int32);
            dt1.Columns[1].DataType = typeof(String);
            dt1.Columns[2].DataType = typeof(String);
            //
            DataRow dr = dt1.NewRow();
            dr["col0"] = 1;
            dr["col1"] = "Column 2";
            dr["col2"] = "Column 3";
            dt1.Rows.Add(dr);
            //
            dr = dt1.NewRow();
            dr["col0"] = 1;
            dr["col1"] = "Column 2";
            dr["col2"] = "Column 3   ";
            dt1.Rows.Add(dr);
            //
            try
            {
                dt1.PrimaryKey = new DataColumn[] { dt1.Columns[0], dt1.Columns[2] };
            }
            catch (ArgumentException ae)
            {
                MessageBox.Show(ae.Message);
            }
        }
    }
}

calhuskerfan wrote:

Here is a very quick (and sloppy) example that reproduces the behavior.

Type   Value  Data                                               
------ ------ -------------------------------------------------- 
1      2      ABC                                                

insert into Table1 (Type, Value, Data) VALUES(1, 3, 'ABC ')

Scott Dorman wrote:

The original post is here[^].

Mark Salsbery
Microsoft MVP - Visual C++

Application.SetUnhandledExceptionMode(UnhandledExceptionMode.ThrowException);

shraddhapingale wrote:

What if i write api which is same like windows serach api; but for database?Coes that sound good?

<?xml version='1.0' encoding='UTF-8' standalone='yes'?>
<assembly xmlns='urn:schemas-microsoft-com:asm.v1' manifestVersion='1.0'>
  <assemblyIdentity version="1.0.0.0" processorArchitecture="X86" name="Test1.exe" type="win32"/>
  <description>Description of your application</description>
  <trustInfo xmlns="urn:schemas-microsoft-com:asm.v3">
    <security>
      <requestedPrivileges>
        <requestedExecutionLevel level='requireAdministrator' uiAccess='false' />
      </requestedPrivileges>
    </security>
  </trustInfo>
</assembly>

Mark Salsbery
Microsoft MVP - Visual C++