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