SQL查询以选择范围并显示在datagrid中 [英] SQL query to select a range and display in datagrid

问题描述

我需要编写一个SQL查询(在C#中)，以从C19开始的"C"列中选择Excel工作表数据.但是我无法指定结束单元格号，因为更多数据正添加到该列中.因此，我需要知道如何指定列的结尾.请帮忙.下面给出的是我正在使用的代码.但是它在datagrid中不显示任何值

I need to write an sql query (in c#) to select excel sheet data in "C" column starting from C19. But i cant specify the ending cell number because more data are getting added to the column. Hence i need to know how to specify the end of the column. Please help. Given below is the code that I''m using. But it doesn''t display any value in the datagrid

OleDbCommand ccmd = new OleDbCommand(@"Select * From [SPAT$]", conn);
OleDbDataAdapter da = new OleDbDataAdapter(ccmd);
DataTable dt = new DataTable();
da.Fill(dt)

for (int i = 19; i < dt.Rows.Count; i++)
{
    var value = dt.Rows[i]["C"].ToString();
    dataGridView1.DataSource = value;
    
}

推荐答案

"，conn)； OleDbDataAdapter da = 新 OleDbDataAdapter(ccmd); DataTable dt = 新 DataTable(); da.Fill(dt) for ( int i = 19 ; i < dt.Rows.Count; i ++) { var 值 = dt.Rows [i] [" C"].ToString(); dataGridView1.DataSource = 值; }

", conn); OleDbDataAdapter da = new OleDbDataAdapter(ccmd); DataTable dt = new DataTable(); da.Fill(dt) for (int i = 19; i < dt.Rows.Count; i++) { var value = dt.Rows[i]["C"].ToString(); dataGridView1.DataSource = value; }

请参阅以下链接.

http://stackoverflow.com/questions/3814065/oledb-command-to-get-data-from-excel-sheet-uing-where-clause [ http://www.daniweb.com/software-development/csharp/threads/145027/excel-and-c [ ^ ]

您可以将where 条件与like 一起使用，并且只能获取所需的记录.
像这样:

Hi,

See the below links.

http://stackoverflow.com/questions/3814065/oledb-command-to-get-data-from-excel-sheet-uing-where-clause[^]
http://www.daniweb.com/software-development/csharp/threads/145027/excel-and-c[^]

you can use where condition with like and you can get only that records which you want.
like this :

OleDbCommand ccmd = new OleDbCommand(@"Select * From [SPAT

中选择*，其中[列名称]如'C19 *'" ，conn);

where [column Name] like 'C19*'", conn);

谢谢，
Viprat

Thanks,
Viprat

这篇关于SQL查询以选择范围并显示在datagrid中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！