Search results for query: *

  1. cwnonthehill

    Invalid attempt to read when no data is present.

    Hey guys, I am using an SqlDataReader to gather data for a DataGridView AutoComplete. In the case that one of the rows has a Null value in the database, Visual Studio throws the error "Invalid attempt to read when no data is present." My code is below, any suggestions? wcCon.Open()...
  2. cwnonthehill

    Question Filter DataGridView by string in format of MMddyyyy

    ok, guys, I have a SQL database with a column called "Date" but with a format of "nchar(8)" so examples of field data are... 12112012 01012013 02022013 etc... In VB i have a DGV that is databound to this sql table. So, my second column in the DGV is the same as what i have explained above...
  3. cwnonthehill

    Problem saving New Row's to multiple tables VB/SQLServer

    Hey guys, I'm having a little trouble making multiple row inserts to different tables. Below is my code. The idea is basically to create new rows in the dataset, then Insert those new rows to my SQL database. The first set (tblComplaint) gets inserted fine. Then when it attempts to Insert...
  4. cwnonthehill

    Preparing my app for ERROR

    Hey guys, I have completed work on my application, and during testing here in the office it occasionally will throw an Unhandled Exception error, mainly related to Crystal Reports which I know I can remedy by having CR installed on the end-user's PC. The one thing I find odd is that in those...
  5. cwnonthehill

    Question Parent/Child table's in SQL SERVER?

    Hey guys, I'm new to the forum, so thanks in advance for your time and help!! I will do my best to explain my situation... I have two SQL Tables and am using VB to represent a user interface for adding/editing this data... Below are screenshots of my two tables tblCollection =========== and...
Back
Top