将存储的数据表加载到datagridview中

本文关键字：datagridview 加载数据表存储 | 更新日期: 2023-09-27 18:08:26

如果已经创建了SQL连接，并且创建了从excel工作表输入的数据表，我如何使用SP以便将数据表加载到我的桌面应用程序(Visual Studio 2008, SQL Server 2005正在使用)的datagridview ?

try this:

DataTable t = new DataTable();//in your case it's filled already like below or any other method
c.Open();
using (SqlCeDataAdapter a = new SqlCeDataAdapter("SELECT CO_COMP_ID as Company_Id,CO_COMP_NAME as Company_Name, CO_ACTIVE as Active_Status, CO_FILE_TYPE as Using_File_Type, CO_DESC as Description  FROM CompRegister", c))
{
     a.Fill(t);
     //dgvCompDet.DataSource = t;
     fnDeselectRow();
  }
 c.Close();

将数据表作为数据网格的数据源

dgvCompDet.DataSource = t;