how to show and edit parameters in a windows form

Is there somebody who has used a windows form and a suitable control (Like
Datagrid) to extract parameters of an specific report and let user edit
them?
I 've done the exctracting the parameters ,,but I don't know how to extract
each parameter values(which are based on the different queries) and show it
to the user.
Thanks for your help.
ALISee the Report Wizard demo code in the AwReporterWin WinForm app that
accompanies my book source code.
http://www.manning-sandbox.com/thread.jspa?threadID=10393&tstart=45
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"ALI-R" <newbie@.microsoft.com> wrote in message
news:eqEm5q1yEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Is there somebody who has used a windows form and a suitable control (Like
> Datagrid) to extract parameters of an specific report and let user edit
> them?
> I 've done the exctracting the parameters ,,but I don't know how to
extract
> each parameter values(which are based on the different queries) and show
it
> to the user.
> Thanks for your help.
> ALI
>|||Thank you very much indeed,,I was actually doing the same thing ,but it
helped a lot.
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:%23rF5hT4yEHA.2788@.TK2MSFTNGP15.phx.gbl...
> See the Report Wizard demo code in the AwReporterWin WinForm app that
> accompanies my book source code.
> http://www.manning-sandbox.com/thread.jspa?threadID=10393&tstart=45
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:eqEm5q1yEHA.2624@.TK2MSFTNGP11.phx.gbl...
> > Is there somebody who has used a windows form and a suitable control
(Like
> > Datagrid) to extract parameters of an specific report and let user edit
> > them?
> >
> > I 've done the exctracting the parameters ,,but I don't know how to
> extract
> > each parameter values(which are based on the different queries) and show
> it
> > to the user.
> >
> > Thanks for your help.
> > ALI
> >
> >
>

How to set a primary key constraint in a View table using SQL Server 2005

Hi All,

I have created a table using VIEWS in SQL server 2005, now i want to be ablle to edit it in a datagrid but i cannot do so as i there is no primary key!

now does anybody know how to set a primary key constraint so i can set one of the fields as a primary key to identify the row?

many thanks

You can't apply PRIMARY KEY constriant on views.|||

Hi,

Is there any way in which i can state one of the columns to be a unique identifier? as i want to be able to edit my datagrid which is populating a VIEW table from SQL '05 but i cannot do so as i do not have a unique number to identify the row, even though one of the columns in the table is a PK in its original table.

any ideas?

|||

If you just want a unique column to identify a row,newid() function is good for you, which can be used in your CREATE VIEW statements:

use northwind
go
create view v_test as
select o.OrderID, C.ContactName,newid() as ColID
from Orders o join Customers c
on o.CustomerID=C.CustomerID