|
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
|
|
|
|
|
Actually I am talking about C# windows form. I have a grid in one panel, other grid in other panel. One of the columns contains comboboxes, ComboBox list, of course appears over the second grid, I want my custom control wich contains some textboxes and other crap show up in similar way. Way I am using - is separate form without close and minimize buttons, but it is not Control added to grid cell, it is separate windows form and it is not good solution, because it shows up in a taskbar and acts like form, but I want to attach it to the grid cell as a normal control
|
|
|
|