CODEWITHSUNDEEP
c#sqldatabasedatagridwindows-mobile
esoj
esoj

Reputation: 27

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

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!!!

Upvotes: 0

Views: 10453

Answers (3)

elayaraja
elayaraja

Reputation: 1

designing page track the gridview or data grid

1st use namespace using System.Data,SqlClient;

sqlconnection con=new sqlconnection("string path");
con.open();
sqldataadapter da=new sqldataadapter("select * from emp",con);
dataset ds=new dataset();
da.fill(ds,"emp");
gridview1.datasource=ds;
gridview1.databind();

Upvotes: 0

Azhar Khorasany
Azhar Khorasany

Reputation: 2709

Try this.

string sql = "SELECT * FROM tablaMercancia";
connection.Open();
//SqlCeCommand cmd = new SqlCeCommand(sql, connection);
SqlCeDataAdapter da = new SqlCeDataAdapter(sql, connection);
DataSet ds=new DataSet();
da.Fill(ds);

Upvotes: 0

Vikram Jain
Vikram Jain

Reputation: 5588

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();

Upvotes: 2

Related Questions