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