Posted on: 11/10/2012 12:55:05 AM | Views : 391

Conversion failed when converting the varchar value 'caID' to data type int............... error is there............ my code is as follows:
-------------------------------------------------------------------------
        DataTable dt = new DataTable();
        string query = "select * from Category";
        SqlConnection con = new SqlConnection(@"Data Source=... ...");
        try
        {
            con.Open();
            SqlCommand cmd = new SqlCommand(query, con);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            ...

Go to the complete details ...