将sqldatareader绑定到datagrid时出现问题 [英] problem binding sqldatareader to datagrid

问题描述

我在显示datagrid中sqldatareader的内容时遇到问题.我尝试过

dataGrid1.DataContext = myReader;
和
dataGrid1.ItemsSource = myReader;

但我看不到数据，只是空行

读者.HasRows是真实的，它告诉它有一些行

I am having problem showing the contents of sqldatareader in datagrid. I tried

dataGrid1.DataContext = myReader;
and
dataGrid1.ItemsSource = myReader;

but the I dont see the data, just empty rows

The reader.HasRows is true which tells that it got some rows

推荐答案

Hello，

尝试将数据从sqldatarepeater放入数据表，然后将该表绑定到grid

希望对您有帮助.
谢谢
sanjeev

Hello ,

try to put data into a datatable from the sqldatarepeater and then bind that table to grid

hoping it will help you.
thanks
sanjeev

DataReader不是可以放入数据上下文中的项目.您需要从DataReader中获取数据并填充适当的类.您绑定*那个*而不绑定读者.

A DataReader is not an item that you can put into a data context. You need to get the data out of the DataReader and populate proper classes. You bind *that* and not the reader.

感谢大家，
我找到了解决方案.我用了SqlDataAdapter

SqlDataAdapter myAdapter =新的SqlDataAdapter(selectStr，connString);
DataSet dset = new DataSet();
int i = myAdapter.Fill(dset);
dataGrid1.ItemsSource = dset.Tables [0] .DefaultView;

问候，
Waqas

Thanks everyone,
I got the solution. I used SqlDataAdapter

SqlDataAdapter myAdapter = new SqlDataAdapter(selectStr, connString);
DataSet dset = new DataSet();
int i = myAdapter.Fill(dset);
dataGrid1.ItemsSource = dset.Tables[0].DefaultView;

Regards,
Waqas

这篇关于将sqldatareader绑定到datagrid时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！