public override DS_Barcode.SP_IsValidBarcodeDataTable IsValidBarcode(string barcode, int productID, byte[] b) { using (var adapter = SP_IsValidBarcodeTableAdapter.CreateInstance(ConfigurationManagerEx.ConnectionString, ConfigurationManagerEx.CommandTimeout)) { return(adapter.GetData(barcode, productID, b.GetXmlData())); } }
public static SP_IsValidBarcodeTableAdapter CreateInstance(string connectionString, int commandTimeout) { var adapter = new SP_IsValidBarcodeTableAdapter(); if (!string.IsNullOrEmpty(connectionString)) { foreach (var cmd in adapter.CommandCollection) { cmd.Connection.ConnectionString = connectionString; cmd.CommandTimeout = commandTimeout; } } return(adapter); }