如何在Sql Compact Edition中使用选择查询？ [英] How Do I Use Select Query In Sql Compact Edition?

问题描述

我使用select语句开发了一个代码。

但它不会给我输出

只是空白gridview？

i have developed a code using select statement.
but it doesn't give me a output even
just blank gridview?

string connectionString = "Data Source=C:\\Users\\Jeewani\\Documents\\rundown.sdf;";

            SqlCeConnection sql = new SqlCeConnection(connectionString);

            sql.Open();

            string query = "select * from ItemsNames";


            SqlCeCommand myCommand = new SqlCeCommand(query, sql);

            SqlCeDataReader reader = myCommand.ExecuteReader();

            Viewer.DataSource = reader;
            //name of the datagridview is viewer      

        
            sql.Close();

推荐答案

使用SqlCeDataAdapter代替SqlCeDataReader并以这种方式更改代码

Use SqlCeDataAdapter instead of SqlCeDataReader and Change the code like this way

SqlCeDataAdapter sqlceda = new SqlCeDataAdapter(myCommand);
           
           DataSet dsData = new DataSet("ITEMNAMES");
           sqlceda.Fill(dsData);
           Viewer.DataSource = ds.Tables[0];

谢谢

thanks

这篇关于如何在Sql Compact Edition中使用选择查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！