How to fill Specific data in Dataset ??

Hot Topic

execute external program
Deprecated Compilers - VB4
Toolbox still does not display user controls.
Enumeration of My.Resources
Database/Project Problems
accidentally uninstalled Framework 1.1 first "valid ordering"
Renaming a file with a timestamp
Compile a Visual Basic.NET Application for MAC
Making a picturebox have a transparent background
File I/O to read a specific lineok wait, I've been playing around with the code, but stupid me, I didnt catch this before,

Visual Basic

Error Created when opening beta 1 file in beta 2
Where is the app installed?
Displaying the current location (Line, Col) of a TextBox in a StatusBar
Help C++ and VB
How to set Border color for Label control
How do you open an embedded resource?
Locating a Label Handle
Add Item to ListBox from other form?
Printing forms using VB2005 Express Edition
Digitally sign a .vsi package

How to fill Specific data in Dataset ??

Dear Team
   shortly ... putting a where condition in the sqladapter  raise error or not works 
   " there is a uniqe or not allow null ......"

   any idea 


Answer this question

How to fill Specific data in Dataset ??

  • sameer_goyal

    Thanks for replying
      i will give you an ex:
      if a form include 2 tables parent and child....like Orders , OrdersDeatils
      if the word fill written in the dataset it will gets"select" the whole data
      even for more than 2 or 3 years and this is a lot
      for ex: select orderno,oerderdate,ordersname,ordersEndDate
                where orderEndDate = null
         or : where getdate() - orderDate = 3   'to get the last 3 monthes for ex
     
             All of this inside the sqladapter by adding only the where condition
            i dont want to select the whole data...after i did that the error occered
                                                                                                                    any idea



  • MurrayLang

    It sounds as though you are trying to put a null value into a field that does not allow a null value to be stored.  This could be on an insert or update statement. 

    I'd check the database and dataset properties for each of the fields and ensure that I am passing valid values across to it.   It could be that you have a field that does not allow nulls and you are not writing anything to it and therefore when it tries to write the chnages to the database it would raise and exception.

    Provide the exact error message andwhere in the sqladapter are you putting the where clause...  


  • How to fill Specific data in Dataset ??
Answer this question