public bool validate()
{
if (
String.IsNullOrWhiteSpace(name) ||
String.IsNullOrWhiteSpace(host) ||
String.IsNullOrWhiteSpace(user) ||
String.IsNullOrWhiteSpace(password))
{
return(false);
}
switch (type)
{
case database_type.MSSQL: mssql_adapter ms = new mssql_adapter(); if (ms.test_connect(ms.connection_string(host, user, password)))
{
return(true);
}
break;
}
return(false);
}
public MainWindow() : base(Gtk.WindowType.Toplevel)
{
Build();
textview2.Buffer.Text = "START";
mssql_adapter mssql = new mssql_adapter();
string conn = mssql.connection_string(@"10.0.0.229\ND", "monarch", "p825amwX$");
string query = "SELECT top 100 * FROM shipit.dbo.enr_txn_shipping";
Hashtable param = new Hashtable()
{
{ "id", "6" }
};
data_set ds = mssql.fetch_all(conn, query, param, true);
var serializer = new JavaScriptSerializer();
var serializedResult = serializer.Serialize(ds);
textview2.Buffer.Text = serializedResult;
}
