Windev 26, C#, SQL Server Insert

SqlServerInsert.wd

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

public static bool InsertCSharp(String sql)
{
	try {
	string connectionString;
	SqlConnection cnn;
	connectionString = @"Data Source=MYSQLSERVER;Initial Catalog=;User ID=username;Password=password123";
	cnn = new SqlConnection(connectionString);
	cnn.Open();
	//MessageBox.Show("Connection Open  !");
	
	SqlDataAdapter adapter = new SqlDataAdapter();
	SqlCommand command = new SqlCommand(sql, cnn);
	adapter.InsertCommand = command;
	adapter.InsertCommand.ExecuteNonQuery();
	
	//command.Dispose();
	//cnn.Close();
	
	return true;
	}
	catch(Exception ex)
	{
		return false;
	}
}