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