DataSet bug

[Aleksey Timonin]

Hi guys,
I'm using Dataset in my project. In design time I configure TableAdapter in
the Dataset and set to the adapter as an Insert query following sql:

INSERT INTO UserInterface.ViewFields
(createdBy, createdOn, modifiedBy, modifiedOn, viewId,
fieldId, logicalFieldName)
SELECT @currUserId, GETUTCDATE(), @currUserId, GETUTCDATE(), @viewID,
fld.id, clmn.name
FROM UserInterface.Fields AS fld INNER JOIN
DBMetaData.Columns AS clmn ON fld.columnId = clmn.id
WHERE (clmn.tableId = @tableID)

The problem is that the method automaticaly generated by VS for this only
sql (with others I don't have such a problem) has no parameters!!! I was
more confused, when by click on "Query Builder..." -"Execute Query" in
"TableAdapter Query Configuration Wizard" VS asked me to enter these
params!!!
Does anybody know about the bug, and know how can I resolve it?

Thanks a lot
Aleksey

[Nicholas Paldino [.NET/C# MVP]]

Aleskey,

I think part of the reason is the name of the table (i.e.
UserInterface.ViewFields).

Try changing "UserInterface.ViewFields" to "[UserInterface.ViewFields]".
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Aleksey Timonin" <al******@mdgmedical.comwrote in message
news:Od**************@TK2MSFTNGP02.phx.gbl...

Hi guys,
I'm using Dataset in my project. In design time I configure TableAdapter
in the Dataset and set to the adapter as an Insert query following sql:

INSERT INTO UserInterface.ViewFields
(createdBy, createdOn, modifiedBy, modifiedOn,
viewId, fieldId, logicalFieldName)
SELECT @currUserId, GETUTCDATE(), @currUserId, GETUTCDATE(), @viewID,
fld.id, clmn.name
FROM UserInterface.Fields AS fld INNER JOIN
DBMetaData.Columns AS clmn ON fld.columnId = clmn.id
WHERE (clmn.tableId = @tableID)

The problem is that the method automaticaly generated by VS for this only
sql (with others I don't have such a problem) has no parameters!!! I was
more confused, when by click on "Query Builder..." -"Execute Query" in
"TableAdapter Query Configuration Wizard" VS asked me to enter these
params!!!
Does anybody know about the bug, and know how can I resolve it?

Thanks a lot
Aleksey

[Aleksey Timonin]

I have tried it. It doesn't make defference. I still have the same problem.
And as I have said below QueryBuilder is see these params!
Any idea?

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:%2****************@TK2MSFTNGP03.phx.gbl...

Aleskey,

I think part of the reason is the name of the table (i.e.
UserInterface.ViewFields).

Try changing "UserInterface.ViewFields" to
"[UserInterface.ViewFields]".
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Aleksey Timonin" <al******@mdgmedical.comwrote in message
news:Od**************@TK2MSFTNGP02.phx.gbl...

>Hi guys,
I'm using Dataset in my project. In design time I configure TableAdapter
in the Dataset and set to the adapter as an Insert query following sql:

INSERT INTO UserInterface.ViewFields
(createdBy, createdOn, modifiedBy, modifiedOn,
viewId, fieldId, logicalFieldName)
SELECT @currUserId, GETUTCDATE(), @currUserId, GETUTCDATE(), @viewID,
fld.id, clmn.name
FROM UserInterface.Fields AS fld INNER JOIN
DBMetaData.Columns AS clmn ON fld.columnId = clmn.id
WHERE (clmn.tableId = @tableID)

The problem is that the method automaticaly generated by VS for this only
sql (with others I don't have such a problem) has no parameters!!! I was
more confused, when by click on "Query Builder..." -"Execute Query" in
"TableAdapter Query Configuration Wizard" VS asked me to enter these
params!!!
Does anybody know about the bug, and know how can I resolve it?

Thanks a lot
Aleksey