|
I am trying to use objectdatasource control binded to a dataset in VS 2005.
I have clicked the Refresh dataset option and in the designer.cs generated code it generates below statement.
how do I retreive the autoincrement coloumn of _ENTITYID from the objectdatasource ?
Also when I run this SQL statement it gives me the last entered row to the table which is cool but
, I could not find it the @_ENTITYID in select parameters and insert parameters while debugging the objectdatasource control.
What should I do ?
____________
exec sp_executesql N'INSERT INTO [LEAD] ([_ENTITYOWNER], [_ENTITYUSER], [_ENTITYMODIFYDATE], [_ENTITYCREATEDATE], [_ENTITYSTATUS], [_NAME], [_ISACTIVE], [_STATE], [_DESCRIPTION], [_CATEGORY], [_SECURITYCODE], [FIRSTNAME], [LASTNAME], [PREFIX], [COMPANYNAME], [INDUSTRY], [TITLE], [ANNUALREVENUE], [NUMBEROFEMPLOYEES], [RATING], [STATUS], [SOURCE], [HOMETEL], [FAXTEL], [MOBILETEL], , [NONSOLICITATIONINDICATOR], [COUNTRYNAME], [CITYNAME], [POSTALCODE], [STREETNAME], [DISTRICTNAME]) VALUES (@_ENTITYOWNER, @_ENTITYUSER, @_ENTITYMODIFYDATE, @_ENTITYCREATEDATE, @_ENTITYSTATUS, @_NAME, @_ISACTIVE, @_STATE, @_DESCRIPTION, @_CATEGORY, @_SECURITYCODE, @FIRSTNAME, @LASTNAME, @PREFIX, @COMPANYNAME, @INDUSTRY, @TITLE, @ANNUALREVENUE, @NUMBEROFEMPLOYEES, @RATING, @STATUS, @SOURCE, @HOMETEL, @FAXTEL, @MOBILETEL, @EMAIL, @NONSOLICITATIONINDICATOR, @COUNTRYNAME, @CITYNAME, @POSTALCODE, @STREETNAME, @DISTRICTNAME);
SELECT _ENTITYID, _ENTITYOWNER, _ENTITYUSER, _ENTITYMODIFYDATE, _ENTITYCREATEDATE, _ENTITYSTATUS, _NAME, _ISACTIVE, _STATE, _DESCRIPTION, _CATEGORY, _SECURITYCODE, FIRSTNAME, LASTNAME, PREFIX, COMPANYNAME, INDUSTRY, TITLE, ANNUALREVENUE, NUMBEROFEMPLOYEES, RATING, STATUS, SOURCE, HOMETEL, FAXTEL, MOBILETEL, EMAIL, NONSOLICITATIONINDICATOR, COUNTRYNAME, CITYNAME, POSTALCODE, STREETNAME, DISTRICTNAME FROM LEAD WHERE (_ENTITYID = SCOPE_IDENTITY())', N'@_ENTITYOWNER nvarchar(4000),@_ENTITYUSER nvarchar(4000),@_ENTITYMODIFYDATE datetime,@_ENTITYCREATEDATE datetime,@_ENTITYSTATUS int,@_NAME nvarchar(4000),@_ISACTIVE bit,@_STATE nvarchar(4000),@_DESCRIPTION nvarchar(4000),@_CATEGORY nvarchar(4000),@_SECURITYCODE int,@FIRSTNAME nvarchar(4000),@LASTNAME nvarchar(4000),@PREFIX nvarchar(4000),@COMPANYNAME nvarchar(4000),@INDUSTRY nvarchar(4000),@TITLE nvarchar(4000),@ANNUALREVENUE nvarchar(4000),@NUMBEROFEMPLOYEES nvarchar(4000),@RATING nvarchar(4000),@STATUS nvarchar(4000),@SOURCE nvarchar(4000),@HOMETEL nvarchar(4000),@FAXTEL nvarchar(4000),@MOBILETEL nvarchar(4000),@EMAIL nvarchar(4000),@NONSOLICITATIONINDICATOR nvarchar(4000),@COUNTRYNAME nvarchar(4000),@CITYNAME nvarchar(4000),@POSTALCODE nvarchar(4000),@STREETNAME nvarchar(4000),@DISTRICTNAME nvarchar(4000)', @_ENTITYOWNER = NULL, @_ENTITYUSER = NULL, @_ENTITYMODIFYDATE = NULL, @_ENTITYCREATEDATE = NULL, @_ENTITYSTATUS = NULL, @_NAME = NULL, @_ISACTIVE = NULL, @_STATE = NULL, @_DESCRIPTION = NULL, @_CATEGORY = NULL, @_SECURITYCODE = NULL, @FIRSTNAME = NULL, @LASTNAME = NULL, @PREFIX = NULL, @COMPANYNAME = NULL, @INDUSTRY = NULL, @TITLE = NULL, @ANNUALREVENUE = NULL, @NUMBEROFEMPLOYEES = NULL, @RATING = NULL, @STATUS = NULL, @SOURCE = NULL, @HOMETEL = NULL, @FAXTEL = NULL, @MOBILETEL = NULL, @EMAIL = NULL, @NONSOLICITATIONINDICATOR = NULL, @COUNTRYNAME = NULL, @CITYNAME = NULL, @POSTALCODE = NULL, @STREETNAME = NULL, @DISTRICTNAME = NULL
|
|
|
|