C#

this.providersAdapter = new SqlDataAdapter("SELECT * FROM Providers", this.dbCon);
this.providersTable = new DataTable();
providersAdapter.Fill(this.providersTable); // an exception occurs on this line

An unhandled exception of type System.Data.SqlCliend.SqlException occured in System.data.dll

Additional Information: System error.

<br />
protected override void DoDiscoverParameters(char parameterToken)<br />
        {<br />
            this.parameterToken = parameterToken;<br />
            using (IfxCommand newCommand = CreateNewCommandAndConnectionForDiscovery())<br />
            {<br />
                IfxCommandBuilder.DeriveParameters(newCommand);<br />
// I get "Specified cast is not valid." Error at above line.<br />
                foreach (IDataParameter parameter in newCommand.Parameters)<br />
                {<br />
                    IDataParameter cloneParameter = (IDataParameter)((ICloneable)parameter).Clone();<br />
                    cloneParameter.ParameterName = BuildParameterName(cloneParameter.ParameterName);<br />
                    this.command.Parameters.Add(cloneParameter);<br />
                }<br />
                newCommand.Connection.Close();<br />
            }<br />
        }

            else if (dane[0]==komunikat.PLPobierzRekord)<br />
            {<br />
                BinaryFormatter bf = new BinaryFormatter();<br />
                MemoryStream ms=new MemoryStream();<br />
                bf.Serialize(ms,Poldane[0]);<br />
                byte[] buffer = ms.ToArray();<br />
               <br />
                System.Text.ASCIIEncoding encoding=new System.Text.ASCIIEncoding();<br />
                byte[] bajt=encoding.GetBytes(komunikat.PLZwrocRekord);<br />
                byte[] dana=new byte[bajt.Length+buffer.Length];<br />
                for (int a=0;a<buffer.Length;a++)<br />
                {<br />
•1                   dana[a+bajt.Length+1]=buffer[a];<br />
                }<br />
                for (int a=0;a<bajt.Length;a++)<br />
                {<br />
•2                  dana[a]=bajt[a];<br />
                }<br />
               <br />
                dana[bajt.Length]=149;<br />
               <br />
•3               MessageBox.Show(this,"a");<br />
            }<br />