C# – Create/Display DataGrid from a table (database) C#

cdatabasedatagridsqlwindows-mobile

I'm trying show a DataGrid in C# (for app WindowsMobile). I have a database ("pruebaDB.sdf") in DataConnections and one table ("tablaMercancia").

Also in DataSource I have "pruebaDBDataSet" and "tablaMercancia".

How I can show data table in a DataGrid?

I use a SmartDevice project (I can't to use DataGridView, only I use DataGrid).

I can show a new table (created for code) in a DataGrid, but I don't know to show an existing table in my database.

string conSTR = "Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "\\pruebaDB.sdf;Persist Security Info=False";

SqlCeConnection connection = new SqlCeConnection(conSTR);

string sql = "SELECT * FROM tablaMercancia";
connection.Open();

SqlCeCommand cmd = new SqlCeCommand(sql, connection);
SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);

//...............
//...Any idea?
//...............

connection.Close();

Any ideas please?

Thanks!!!

Best Answer

Please, Change Datagridview name as per below :

    string conSTR = "Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "\\pruebaDB.sdf;Persist Security Info=False";

    SqlCeConnection connection = new SqlCeConnection(conSTR);

    string sql = "SELECT * FROM tablaMercancia";
    connection.Open();

    SqlCeCommand cmd = new SqlCeCommand(sql, connection);
    SqlCeDataAdapter da = new SqlCeDataAdapter(cmd);
    DataSet ds=new DataSet();
    da.Fill(ds);


    //datagridview1 is name of datagridview in form:
    datagridview1.DataSource=ds.Tables[0];

    connection.Close();
Related Topic