/// <summary> /// 查找指定数据表的所有列. /// </summary> /// <param name="tableName">Name of the table.</param> private static void QueryColumns(string tableName) { SqlConnection conn = Main02_AdoNet.GetConnection(); MSSqlHelper helper = MSSqlHelper.GetMsSqlHelper(conn.ConnectionString); SqlParameter param = new SqlParameter("@TableName", tableName); SqlDataReader reader = helper.ExecuteReader(System.Data.CommandType.Text, Gean.Data.Resources.SQLString.GetColumnsByTable, param); while (reader.Read()) { Console.Write(reader["TableName"]); Console.Write("\t"); string str = (string)reader["ColumsName"]; Console.Write(str); if (str.Length <= 7) { Console.Write("\t\t\t"); } else { Console.Write("\t\t"); } str = (string)reader["DbDataType"]; Console.Write(str); if (str.Length <= 7) { Console.Write("\t\t"); } else { Console.Write("\t"); } Console.WriteLine(reader["Length"]); } }
private static void SelectDemo(SqlConnection cn) { SqlCommand command = new SqlCommand(); string cmd = @" SELECT * FROM dbo.Employees "; SqlDataReader reader = MSSqlHelper.GetMsSqlHelper(cn.ConnectionString).ExecuteReader(CommandType.Text, cmd); while (reader.Read()) { Console.WriteLine(String.Format("{0}, {1}", reader[0], reader[1])); } reader.Close(); }