none
database problems RRS feed

  • Question

  • using vusual studio 2010 C# express.

    sql queries using the connection string exposed in the database properties window results in wrong stuff, such as;

        sqlCeConnection conn = new sqlceconnection(".......");

        con.open();

        sqlCeDataAdapter da = new sqlCeDataAdapter("select * from tblChecks");

        dataTable dt = new DataTable();

        da.Fill(dt);

        int foo = dt.Rows.Count;

    foo does not match the number of rows in the datagrid in another form with the datagridview all set up and

    running just fine. But it does match the number of rows in the window exposed with the "view table data"

    thingy. Very frustrating since soo to be written sql queries will be rendered crap.

    Thanks for any help, Glennwampus.

    Friday, April 4, 2014 12:51 AM

Answers

  • Hello Glenn,

    It looks like your question is not related to VTSO. I think the problem is related to SQL server and common for all .Net based applications. That's why I'd recommend asking such questions on the SQL Server forums. There you will get the most qualified feedback.

    Friday, April 4, 2014 11:50 AM