document.write('<script type="text/javascript" src="../../js/jquery-1.7.1.min.js"></script>');
function GetInfo() {
//jQuery.noConflict();
jQuery.support.cors = true;
//var jq = jQuery.noConflict();
var $res;
$.ajax({
type: "POST",
url: "http://10.1.10.103:8888/JsonServiceSample.asmx/GetOneUserInfo",
contentType: "application/json; charset=utf-8",
async: false,
cache: false,
dataType: 'json',
data: "{name:'Test',age:29}",
success: function (data) {
if (data.hasOwnProperty("d")) {
$res = data.d;
}
else
$res = data;
},
error: function (xhr, ajaxOptions, thrownError) {
alert('WS status = ' + xhr.status );
alert('WS Error =' + thrownError);
}
});
return $res;
}
function btnEdit_onclick() {
var res = GetInfo();
alert(res.Name);
alert(res.Age);
}
WebService
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Script.Services; using System.Web.Services; using System.Web.Services.Protocols; //加上這個預備給 Java Call namespace JQueryWebService { public class User { public string Name { get; set; } public int Age { get; set; } } /// <summary> /// 移除 NameSpace /// 每一個 Methods 上面必須加上 /// [ScriptMethod(ResponseFormat = ResponseFormat.Json)] /// </summary> [WebService(Namespace = "", Description = "For Donma Test")] [System.ComponentModel.ToolboxItem(false)] [ScriptService] public class JsonServiceSample : System.Web.Services.WebService { [WebMethod] [SoapRpcMethod(Use = System.Web.Services.Description.SoapBindingUse.Literal)] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public string GetUserInfoString(string name, int age) { return name + "," + age; } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public User GetOneUserInfo(string name, int age) { return (new User { Name = name, Age = age }); } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public User[] GetUsers(string name, int age) { List<User> res = new List<User>(); res.Add(new User { Name = name + "1", Age = age }); res.Add(new User { Name = name + "2", Age = age }); return res.ToArray(); } } }
不含世紀 (yy) (1)
|
含世紀 (yyyy)
|
標準
|
輸入/輸出 (3)
| ||
|---|---|---|---|---|---|
-
|
0 或 100 (1,2)
|
預設
|
mon dd yyyy hh:miAM (或 PM)
| ||
1
|
101
|
美式英文
|
1 = mm/dd/yy
101 = mm/dd/yyyy
| ||
2
|
102
|
ANSI
|
2 = yy.mm.dd
102 = yyyy.mm.dd
| ||
3
|
103
|
英式英文/法文
|
3 = dd/mm/yy
103 = dd/mm/yyyy
| ||
4
|
104
|
德文
|
4 = dd.mm.yy
104 = dd.mm.yyyy
| ||
5
|
105
|
義大利文
|
5 = dd-mm-yy
105 = dd-mm-yyyy
| ||
6
|
-
|
6 = dd mon yy
106 = dd mon yyyy
| |||
7
|
-
|
7 = Mon dd, yy
107 = Mon dd, yyyy
| |||
8
|
108
|
-
|
hh:mi:ss
| ||
-
|
9 或 109 (1,2)
|
預設值 + 毫秒
|
mon dd yyyy hh:mi:ss:mmmAM (或 PM)
| ||
10
|
110
|
美國
|
10 = mm-dd-yy
110 = mm-dd-yyyy
| ||
11
|
111
|
日本
|
11 = yy/mm/dd
111 = yyyy/mm/dd
| ||
12
|
112
|
ISO
|
12 = yymmdd
112 = yyyymmdd
| ||
-
|
13 或 113(1、2)
|
歐洲預設值 + 毫秒
|
dd mon yyyy hh:mi:ss:mmm(24h)
| ||
14
|
114
|
-
|
hh:mi:ss:mmm(24h)
| ||
-
|
20 或 120 (2)
|
ODBC 標準
|
yyyy-mm-dd hh:mi:ss(24h)
| ||
-
|
21 或 121 (2)
|
ODBC 標準 (含毫秒)
|
yyyy-mm-dd hh:mi:ss.mmm(24h)
| ||
-
|
126 (4)
|
ISO8601
|
yyyy-mm-ddThh:mi:ss.mmm (無空格)
| ||
-
|
127(6, 7)
|
具有時區 Z 的 ISO8601。
|
yyyy-mm-ddThh:mi:ss.mmmZ (無空格)
| ||
-
|
130 (1,2)
|
回曆 (5)
|
dd mon yyyy hh:mi:ss:mmmAM
| ||
-
|
131 (2)
|
回曆 (5)
|
dd/mm/yyyy hh:mi:ss:mmmAM
|
 重要事項 |
|---|
public static string ValidateUser(string ComputerName, string UserName, string Password) { string strPath; if (ComputerName.IndexOf('.') != -1) { strPath = string.Format("LDAP://{0}:389/DC=alchip,DC=com",ComputerName);
UserName = string.Format("uid={0},ou=Users,DC=alchip,DC=com",UserName); } else { strPath = string.Format(@"WinNT://{0}/{1}, user", ComputerName, UserName); } DirectoryEntry entry = new DirectoryEntry(strPath, UserName, Password,AuthenticationTypes.ServerBind); try { //string objectSid = // (new SecurityIdentifier((byte[])entry.Properties["objectSid"].Value, 0).Value); //return objectSid; if (entry.NativeObject != null) return "true"; else return null; } catch// (DirectoryServicesCOMException) { return null; } finally { entry.Dispose(); } }
留存備查!!
//=============================================================================== // Microsoft patterns & practices Enterprise Library // Data Access Application Block Examples //=============================================================================== // Copyright © Microsoft Corporation. All rights reserved. // THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY // OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT // LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND // FITNESS FOR A PARTICULAR PURPOSE. //=============================================================================== using System; using System.ComponentModel; using System.Linq; using System.Data; using System.Data.Common; using System.Data.SqlClient; using System.Threading; using System.Xml; using System.Transactions; using DevGuideExample.MenuSystem; // references to configuration namespaces (required in all examples) using Microsoft.Practices.EnterpriseLibrary.Common.Configuration; // references to application block namespace(s) for these examples using Microsoft.Practices.EnterpriseLibrary.Data; using Microsoft.Practices.EnterpriseLibrary.Data.Sql; namespace DataAccessExample { class Program { static Database defaultDB = null; static Database namedDB = null; static SqlDatabase sqlServerDB = null; static Database asyncDB = null; static void Main(string[] args) { #region Resolve the required objects // Resolve the default Database object from the container. // The actual concrete type is determined by the configuration settings. defaultDB = EnterpriseLibraryContainer.Current.GetInstance<Database>(); // Resolve a Database object from the container using the connection string name. namedDB = EnterpriseLibraryContainer.Current.GetInstance<Database>("ExampleDatabase"); // Resolve a SqlDatabase object from the container using the default database. sqlServerDB = EnterpriseLibraryContainer.Current.GetInstance<Database>() as SqlDatabase; // Resolve a SqlDatabase object that has "Asynchronous Processing=true" in the connection string. asyncDB = EnterpriseLibraryContainer.Current.GetInstance<Database>("AsyncExampleDatabase"); #endregion new MenuDrivenApplication("Data Access Block Developer's Guide Examples", ReadSQLStatement, ReadStoredProcWithParams, ReadSQLOrSprocWithNamedParams, ReadDataAsObjects, ReadDataAsXML, ReadScalarValue, ReadDataAsynchronously, ReadObjectsAsynchronously, UpdateWithCommand, FillAndUpdateDataset, UseConnectionTransaction, UseTransactionScope).Run(); } [Description("Return rows using a SQL statement with no parameters")] static void ReadSQLStatement() { // Call the ExecuteReader method by specifying the command type // as a SQL statement, and passing in the SQL statement using (IDataReader reader = namedDB.ExecuteReader(CommandType.Text, "SELECT TOP 1 * FROM OrderList")) { DisplayRowValues(reader); } } [Description("Return rows using a stored procedure with parameters")] static void ReadStoredProcWithParams() { // Call the ExecuteReader method with the stored procedure // name and an Object array containing the parameter values using (IDataReader reader = defaultDB.ExecuteReader("ListOrdersByState", new object[] { "Colorado" })) { DisplayRowValues(reader); } } [Description("Return rows using a SQL statement or stored procedure with named parameters")] static void ReadSQLOrSprocWithNamedParams() { // Read data with a SQL statement that accepts one parameter string sqlStatement = "SELECT TOP 1 * FROM OrderList WHERE State LIKE @state"; // Create a suitable command type and add the required parameter using (DbCommand sqlCmd = defaultDB.GetSqlStringCommand(sqlStatement)) { defaultDB.AddInParameter(sqlCmd, "state", DbType.String, "New York"); // Call the ExecuteReader method with the command using (IDataReader sqlReader = namedDB.ExecuteReader(sqlCmd)) { Console.WriteLine("Results from executing SQL statement:"); DisplayRowValues(sqlReader); } } // Read data with a stored procedure that accepts one parameter string storedProcName = "ListOrdersByState"; // Create a suitable command type and add the required parameter using (DbCommand sprocCmd = defaultDB.GetStoredProcCommand(storedProcName)) { defaultDB.AddInParameter(sprocCmd, "state", DbType.String, "New York"); // Call the ExecuteReader method with the command using (IDataReader sprocReader = namedDB.ExecuteReader(sprocCmd)) { Console.WriteLine("Results from executing stored procedure:"); DisplayRowValues(sprocReader); } } } [Description("Return data as a sequence of objects using a stored procedure")] static void ReadDataAsObjects() { // Create an object array and populate it with the required parameter values object[] paramArray = new object[] { "%bike%" }; // Create and execute a sproc accessor that uses default parameter and output mappings var productData = defaultDB.ExecuteSprocAccessor<Product>("GetProductList", paramArray); // Perform a client-side query on the returned data // Be aware that the orderby and filtering is happening on the client, not the database var results = from productItem in productData where productItem.Description != null orderby productItem.Name select new { productItem.Name, productItem.Description }; // Display the results foreach (var item in results) { Console.WriteLine("Product Name: {0}", item.Name); Console.WriteLine("Description: {0}", item.Description); Console.WriteLine(); } } [Description("Return data as an XML fragment using a SQL Server XML query")] static void ReadDataAsXML() { // Specify a SQL query that returns XML data string xmlQuery = "SELECT * FROM OrderList WHERE State = @state FOR XML AUTO"; // Create a suitable command type and add the required parameter // NB: ExecuteXmlReader is only available for SQL Server databases using (DbCommand xmlCmd = sqlServerDB.GetSqlStringCommand(xmlQuery)) { xmlCmd.Parameters.Add(new SqlParameter("state", "Colorado")); using (XmlReader reader = sqlServerDB.ExecuteXmlReader(xmlCmd)) { // Iterate through the elements in the XmlReader while (!reader.EOF) { if (reader.IsStartElement()) { Console.WriteLine(reader.ReadOuterXml()); } } } } } [Description("Return a single scalar value from a SQL statement or stored procedure")] static void ReadScalarValue() { // Create a suitable command type for a SQL statement using (DbCommand sqlCmd = defaultDB.GetSqlStringCommand("SELECT [Name] FROM States")) { // Call the ExecuteScalar method of the command Console.WriteLine("Result using a SQL statement: {0}", defaultDB.ExecuteScalar(sqlCmd).ToString()); } // Create a suitable command type for a stored procedure using (DbCommand sprocCmd = defaultDB.GetStoredProcCommand("GetStatesList")) { // Call the ExecuteScalar method of the command Console.WriteLine("Result using a stored procedure: {0}", defaultDB.ExecuteScalar(sprocCmd).ToString()); } } [Description("Execute a command that retrieves data asynchronously")] static void ReadDataAsynchronously() { if (!SupportsAsync(asyncDB)) return; using (var doneWaitingEvent = new ManualResetEvent(false)) using (var readCompleteEvent = new ManualResetEvent(false)) { try { // Create command to execute stored procedure and add parameters DbCommand cmd = asyncDB.GetStoredProcCommand("ListOrdersSlowly"); asyncDB.AddInParameter(cmd, "state", DbType.String, "Colorado"); asyncDB.AddInParameter(cmd, "status", DbType.String, "DRAFT"); // Execute the query asynchronously specifying the command and the // expression to execute when the data access process completes. asyncDB.BeginExecuteReader(cmd, asyncResult => { // Lambda expression executed when the data access completes. doneWaitingEvent.Set(); try { using (IDataReader reader = asyncDB.EndExecuteReader(asyncResult)) { Console.WriteLine(); Console.WriteLine(); DisplayRowValues(reader); } } catch (Exception ex) { Console.WriteLine("Error after data access completed: {0}", ex.Message); } finally { readCompleteEvent.Set(); } }, null); // Display waiting messages to indicate executing asynchronouly while (!doneWaitingEvent.WaitOne(1000)) { Console.Write("Waiting... "); } // Allow async thread to write results before displaying "continue" prompt readCompleteEvent.WaitOne(); } catch (Exception ex) { Console.WriteLine("Error while starting data access: {0}", ex.Message); } } } [Description("Execute a command that retrieves data as objects asynchronously")] static void ReadObjectsAsynchronously() { if (!SupportsAsync(asyncDB)) return; using (var doneWaitingEvent = new ManualResetEvent(false)) using (var readCompleteEvent = new ManualResetEvent(false)) { try { // Create an object array and populate it with the required parameter values. object[] paramArray = new object[] { "%bike%", 20 }; // Create the accessor. This example uses the simplest overload. var accessor = asyncDB.CreateSprocAccessor<Product>("GetProductsSlowly"); // Execute the accessor asynchronously specifying the callback expression, // the existing accessor as the AsyncState, and the parameter values array. accessor.BeginExecute( asyncResult => { // Lambda expression executed when the data access completes. doneWaitingEvent.Set(); try { // Accessor is available via the asyncResult parameter var acc = (DataAccessor<Product>)asyncResult.AsyncState; // Obtain the results from the accessor. var productData = acc.EndExecute(asyncResult); // Perform a client-side query on the returned data. // Be aware that the orderby and filtering is happening // on the client, not inside the database. var results = from productItem in productData where productItem.Description != null orderby productItem.Name select new { productItem.Name, productItem.Description }; // Display the results Console.WriteLine(); Console.WriteLine(); foreach (var item in results) { Console.WriteLine("Product Name: {0}", item.Name); Console.WriteLine("Description: {0}", item.Description); Console.WriteLine(); } } catch (Exception ex) { Console.WriteLine("Error after data access completed: {0}", ex.Message); } finally { readCompleteEvent.Set(); } }, accessor, paramArray); // Display waiting messages to indicate executing asynchronously. while (!doneWaitingEvent.WaitOne(1000)) { Console.Write("Waiting... "); } // Allow async thread to write results before displaying "continue" prompt. readCompleteEvent.WaitOne(); } catch (Exception ex) { Console.WriteLine("Error while starting data access: {0}", ex.Message); } } } [Description("Update data using a Command object")] static void UpdateWithCommand() { string oldDescription = "Carries 4 bikes securely; steel construction, fits 2\" receiver hitch."; string newDescription = "Bikes tend to fall off after a few miles."; Console.WriteLine("Contents of row before update:"); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 84")); // Create command to execute stored procedure and add parameters DbCommand cmd = defaultDB.GetStoredProcCommand("UpdateProductsTable"); defaultDB.AddInParameter(cmd, "productID", DbType.Int32, 84); defaultDB.AddInParameter(cmd, "description", DbType.String, newDescription); // Execute query and check if one row was updated if (defaultDB.ExecuteNonQuery(cmd) == 1) { Console.WriteLine("Contents of row after first update:"); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 84")); } else { Console.WriteLine("ERROR: Could not update just one row."); } // Change the value of the second parameter defaultDB.SetParameterValue(cmd, "description", oldDescription); // Execute query and check if one row was updated if (defaultDB.ExecuteNonQuery(cmd) == 1) { Console.WriteLine("Contents of row after second update:"); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 84")); } else { Console.WriteLine("ERROR: Could not update just one row."); } } [Description("Fill a DataSet and update the source data")] static void FillAndUpdateDataset() { string selectSQL = "SELECT Id, Name, Description FROM Products WHERE Id > 90"; string addSQL = "INSERT INTO Products (Name, Description) VALUES (@name, @description);"; string updateSQL = "UPDATE Products SET Name = @name, Description = @description WHERE Id = @id"; string deleteSQL = "DELETE FROM Products WHERE Id = @id"; // Fill a DataSet from the Products table using the simple approach DataSet simpleDS = defaultDB.ExecuteDataSet(CommandType.Text, selectSQL); DisplayTableNames(simpleDS, "ExecuteDataSet"); simpleDS = null; // Fill a DataSet from the Products table using the LoadDataSet method // This allows you to specify the name(s) for the table(s) in the DataSet DataSet loadedDS = new DataSet("ProductsDataSet"); defaultDB.LoadDataSet(CommandType.Text, selectSQL, loadedDS, new string[] { "Products" }); DisplayTableNames(loadedDS, "LoadDataSet"); // Update some data in the rows of the DataSet table DataTable dt = loadedDS.Tables["Products"]; dt.Rows[0].Delete(); object[] rowData = new object[] { -1, "A New Row", "Added to the table at " + DateTime.Now.ToShortTimeString() }; dt.Rows.Add(rowData); rowData = dt.Rows[1].ItemArray; rowData[2] = "A new description at " + DateTime.Now.ToShortTimeString(); dt.Rows[1].ItemArray = rowData; DisplayRowValues(dt); // Create the commands to update the original table in the database DbCommand insertCommand = defaultDB.GetSqlStringCommand(addSQL); defaultDB.AddInParameter(insertCommand, "name", DbType.String, "Name", DataRowVersion.Current); defaultDB.AddInParameter(insertCommand, "description", DbType.String, "Description", DataRowVersion.Current); DbCommand updateCommand = defaultDB.GetSqlStringCommand(updateSQL); defaultDB.AddInParameter(updateCommand, "name", DbType.String, "Name", DataRowVersion.Current); defaultDB.AddInParameter(updateCommand, "description", DbType.String, "Description", DataRowVersion.Current); defaultDB.AddInParameter(updateCommand, "id", DbType.String, "Id", DataRowVersion.Original); DbCommand deleteCommand = defaultDB.GetSqlStringCommand(deleteSQL); defaultDB.AddInParameter(deleteCommand, "id", DbType.Int32, "Id", DataRowVersion.Original); // Apply the updates in the DataSet to the original table in the database int rowsAffected = defaultDB.UpdateDataSet(loadedDS, "Products", insertCommand, updateCommand, deleteCommand, UpdateBehavior.Standard); Console.WriteLine("Updated a total of {0} rows in the database.", rowsAffected); } [Description("Use a connection-based transaction")] static void UseConnectionTransaction() { Console.WriteLine("Contents of rows before update:"); Console.WriteLine(); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 53")); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 84")); Console.WriteLine(MenuDrivenApplication.Underline); string newRow53Value = "Third and little fingers tend to get cold."; string newRow84Value = "Bikes tend to fall off after a few miles."; // Must specifically create the connection for the command // to be able to create a transaction for the operations. using (DbConnection con = defaultDB.CreateConnection()) { // By default, data access methods will create and manage the connection. // When the connection is created manually, it must be managed in the code. con.Open(); // Create a transaction on the open connection for the operations using (DbTransaction trans = con.BeginTransaction()) { // Create command to execute stored procedure and add parameters DbCommand cmd = defaultDB.GetStoredProcCommand("UpdateProductsTable"); defaultDB.AddInParameter(cmd, "productID", DbType.Int32, 53); defaultDB.AddInParameter(cmd, "description", DbType.String, newRow53Value); // Execute two updates and check if each updated one row as expected, // specifying that they execute within the current transaction if (defaultDB.ExecuteNonQuery(cmd, trans) == 1) { Console.WriteLine("Updated row with ID = 53 to '{0}'.", newRow53Value); } else { Console.WriteLine("ERROR: Could not update just one row."); } // Change the values in the command parameters defaultDB.SetParameterValue(cmd, "productID", 84); defaultDB.SetParameterValue(cmd, "description", newRow84Value); if (defaultDB.ExecuteNonQuery(cmd, trans) == 1) { Console.WriteLine("Updated row with ID = 84 to '{0}'.", newRow84Value); } else { Console.WriteLine("ERROR: Could not update just one row."); } // Roll back the transaction trans.Rollback(); } Console.WriteLine(MenuDrivenApplication.Underline); Console.WriteLine("Contents of row after rolling back transaction:"); Console.WriteLine(); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 53")); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 84")); } } [Description("Use a TransactionScope for a distributed transaction")] static void UseTransactionScope() { Console.WriteLine("Contents of rows before update:"); Console.WriteLine(); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 53")); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 84")); Console.WriteLine(MenuDrivenApplication.Underline); string newRow53Value = "Third and little fingers tend to get cold."; string newRow84Value = "Bikes tend to fall off after a few miles."; // Create a transaction scope for the distributed operations using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew)) { // Create command to execute stored procedure and add parameters DbCommand cmdA = defaultDB.GetStoredProcCommand("UpdateProductsTable"); defaultDB.AddInParameter(cmdA, "productID", DbType.Int32, 53); defaultDB.AddInParameter(cmdA, "description", DbType.String, newRow53Value); // Execute first update and check if it updated one row as expected. // No distributed transaction will be created for this operation. if (defaultDB.ExecuteNonQuery(cmdA) == 1) { Console.WriteLine("Updated row with ID = 53 to '{0}'.", newRow53Value); } else { Console.WriteLine("ERROR: Could not update just one row."); } // Wait for a keypress. At this point there is no distributed transaction. // Open Component Services in MMC and view Local DTC Transaction List. Console.WriteLine("No distributed transaction. Press any key to continue..."); Console.WriteLine(); Console.ReadKey(true); // Create second command to execute stored procedure and add parameters. // Must use a different connection string to force creation of a new connection. DbCommand cmdB = asyncDB.GetStoredProcCommand("UpdateProductsTable"); asyncDB.AddInParameter(cmdB, "productID", DbType.Int32, 84); asyncDB.AddInParameter(cmdB, "description", DbType.String, newRow84Value); // Execute second update and check if it updated one row as expected. // This will automatically create a new distributed transaction and // enrol both this and the original command. if (asyncDB.ExecuteNonQuery(cmdB) == 1) { Console.WriteLine("Updated row with ID = 84 to '{0}'.", newRow84Value); } else { Console.WriteLine("ERROR: Could not update just one row."); } // Wait for a keypress. At this point there is a new distributed transaction. Console.WriteLine("New distributed transaction created. Press any key to continue..."); Console.ReadKey(true); } // TransactionScope now disposed without executing TransactionScope.Complete // method to commit changes. Therefore changes will be rolled back automatically. Console.WriteLine(MenuDrivenApplication.Underline); Console.WriteLine("Contents of row after disposing TransactionScope:"); Console.WriteLine(); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 53")); DisplayRowValues(defaultDB.ExecuteReader(CommandType.Text, "SELECT * FROM Products WHERE [Id] = 84")); } #region Auxiliary routines private static bool SupportsAsync(Database db) { if (db.SupportsAsync) { Console.WriteLine("Database supports asynchronous operations"); return true; } Console.WriteLine("Database does not support asynchronous operations"); return false; } private static void DisplayRowValues(DataTable table) { Console.WriteLine(MenuDrivenApplication.Underline); Console.WriteLine("Rows in the table named '{0}':", table.TableName); Console.WriteLine(); DisplayRowValues(table.CreateDataReader()); } private static void DisplayRowValues(IDataReader reader) { while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { Console.WriteLine("{0} = {1}", reader.GetName(i), reader[i].ToString()); } Console.WriteLine(); } } private static void DisplayTableNames(DataSet ds, string methodName) { Console.WriteLine("Tables in the DataSet obtained using the {0} method:", methodName); foreach (DataTable t in ds.Tables) { Console.WriteLine(" - Table named '{0}' contains {1} rows.", t.TableName, t.Rows.Count); } Console.WriteLine(); } #endregion } }