public void ExecuteQueryWithNameNavigation() { var err = ""; try { string strConnection = ClsQuickCode.ProviderSQLserver("sa", "123456", ".", DBName); ClsSqlOledb conn = new ClsSqlOledb(); conn.ConnectionString = strConnection; conn.TimeOut = 1000; conn.Execute("select * from pelanggan"); for (int i = 0; i < conn.RowCount - 1; i++) { string szName = (string)conn["kdplgn"]; string CustszContactPerson = (string)conn["nmplgn"]; conn.NextRow(); } } catch (Exception ex) { err = ex.Message; } Assert.AreEqual(err, ""); }
public void ExecuteQuerySetToTableQueryParam() { var err = ""; try { string strConnection = ClsQuickCode.ProviderSQLserver("sa", "123456", ".", DBName); ClsSqlOledb conn = new ClsSqlOledb(); conn.ConnectionString = strConnection; conn.TimeOut = 1000; DataTable table = conn.Execute("select * from pelanggan"); } catch (Exception ex) { err = ex.Message; } Assert.AreEqual(err, ""); }