adding new record with MS data form wizard???

Question

I have some problems with the data from wizard item

the wizard asks for dataset, connection, tables, & in lst view, since i want the add, delete updata all buttons, i select the non grid view [individual records that is]

Now i have been succesfull in updating any record MashaAllah, haven't tried the delete for some reasons, but the code seems to be understandable

but i can't figure out how to add new recordds????

when i press the add button, it either says column "columnName" can't be NULL or simply UPDATES the existing selected record
]

I want to add new record, am i suppose to add some code for this??? whats the shortest possible way???

Answer 1

Hi,

 If you are dealing with a SQL database use INSERT.

See these results.>>

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=sql+insert&localechoice=9&SiteID=1&searchscope=forumgroupscope&ForumGroupID=10

 

By the way you say "Muslims are not terrorists"

Anyone who uses violence in defence of their religion or uses violence to shut people up about religion

using any kind of weapon is seen as a terrorist, NO MATTER WHICH COUNTRY THEY ARE IN or

 WHERE THEY COME FROM.

 

 

Regards,

S_DS.