以表格形式显示sqldatasource [英] display sqldatasource in form

问题描述

有人知道如何在dataviewgrid中的表单上显示它吗?我可以在控制台应用程序中做到这一点，但我想在表单中点缀它

Does any one know how to display this on a form in a dataviewgrid I can do it in an console app but I want to dot it in a form

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
              // Retrieve the enumerator instance and then the data.
    SqlDataSourceEnumerator instance =
      SqlDataSourceEnumerator.Instance;
    System.Data.DataTable table = instance.GetDataSources();

    // Display the contents of the table.
    DisplayData(table);

    Console.WriteLine("Press any key to continue.");
    Console.ReadKey();
  }

  private static void DisplayData(System.Data.DataTable table)
  {
    foreach (System.Data.DataRow row in table.Rows)
    {
      foreach (System.Data.DataColumn col in table.Columns)
      {
        Console.WriteLine("{0} = {1}", col.ColumnName, row[col]);
      }
      Console.WriteLine("============================");
    }
  }

推荐答案

您只需在表格上放置一个gridview或类似图片，设置其datasource属性并调用databind()

You just put a gridview or similar on your form, set it''s datasource property and call databind()

这篇关于以表格形式显示sqldatasource的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！