public override DS_Barcode.SP_GetBarcodeDataTable GetBarcode(string barcode, int productID)
{
using (var adapter = SP_GetBarcodeTableAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout))
{
return(adapter.GetData(barcode, productID));
}
}
public static SP_GetBarcodeTableAdapter CreateInstance(string connectionString, int commandTimeout)
{
var adapter = new SP_GetBarcodeTableAdapter();
if (!string.IsNullOrEmpty(connectionString))
{
foreach (var cmd in adapter.CommandCollection)
{
cmd.Connection.ConnectionString = connectionString;
cmd.CommandTimeout = commandTimeout;
}
}
return(adapter);
}
