C#

<br />
    private const int WM_HSCROLL = 276; // Horizontal scroll<br />
    private const int WM_VSCROLL = 277; // Vertical scroll<br />
    private const int SB_LINEUP = 0; // Scrolls one line up<br />
    private const int SB_LINELEFT = 0;// Scrolls one cell left<br />
    private const int SB_LINEDOWN = 1; // Scrolls one line down<br />
    private const int SB_LINERIGHT = 1;// Scrolls one cell right<br />
    private const int SB_PAGEUP = 2; // Scrolls one page up<br />
    private const int SB_PAGELEFT = 2;// Scrolls one page left<br />
    private const int SB_PAGEDOWN = 3; // Scrolls one page down<br />
    private const int SB_PAGERIGTH = 3; // Scrolls one page right<br />
    private const int SB_PAGETOP = 6; // Scrolls to the upper left<br />
    private const int SB_LEFT = 6; // Scrolls to the left<br />
    private const int SB_PAGEBOTTOM = 7; // Scrolls to the upper right<br />
    private const int SB_RIGHT = 7; // Scrolls to the right<br />
    private const int SB_ENDSCROLL = 8; // Ends scroll<br />
<br />
 <br />
    [DllImport("user32.dll", CharSet=CharSet.Auto)]<br />
    private static extern int SendMessage(IntPtr hWnd, int wMsg, IntPtr wParam, IntPtr lParam);<br />
<br />
<br />
    private void btnScrollLeft_Click(object sender, System.EventArgs e)<br />
    {<br />
      SendMessage(this.textBox.Handle, WM_HSCROLL, (IntPtr)SB_LINELEFT, IntPtr.Zero);<br />
    }<br />

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