Hi guys,

this is the error I get when I execute this code,

SqlConnection objConnection;
            string strSQL;
            SqlCommand objCommand;

            string strConnection = "server=(Local)\\NetSDK;uid=sa;pwd=password;databa se=Northwind";

            objConnection = new SqlConnection(strConnection);

            objConnection.Open();
            strSQL = "SELECT CustomerID, CustomerName FROM Customers WHERE Region = 'WA'";
            //strSQL = "SELECT * FROM CustomerID";
            objCommand = new SqlCommand(strSQL, objConnection);
            //objCommand.CommandType = CommandType.StoredProcedure;
            SqlDataReader objDR = objCommand.ExecuteReader();
            if(objDR.HasRows)
            {
            datagrid.DataSource = objDR;
            datagrid.DataBind();
            }
            else if(!objDR.HasRows)
            {
            Response.Write("oh no!");
            }

does anyone know why??

Adz - The World is not enough

__________________
Adz - Learning The J2EE Ways.

Please do not submit new article if it already has a topic.
Tnx in advance.
I hope I could help u at http://p2p.wrox.com/topic.asp?TOPIC_ID=12959

Always:),
Hovik Melkomian.