/// <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();
}
