hi i have a datagrid, and i have binded it to a dataset, i have a column called srno and its autogenerated, it works fine,

the problem is when i enter the data for the first time in a row the srno is 1, after entering the data i navigate to the second row, at that time srno is 2, before entering the data in the 2nd row do some alterations in the first row, after finishing alterations in the 1st row i return back to the 2nd row, and suprisingly the srno is now 3,

need help

thanks

Prasenna

Hi Folks,

I have a win forms application used in the aviation industry with a very customized UI.

I'm using a web control to display some HTML docs within the forms app. I'm trying

to build in some print preview functionality. The print preview dialog UI has to match

the app's look and feel.

Does anybody know how I can get print preview info from the web control Info such as

number of pages. Better yet, if I could get some sort of a collection of page objects, that

would be just grand.

Thanks much,

Jake

For the past few months we have be using the TableAdapter wizard to generate Procs with optimistic concurrency under these procedures, running Visual Web Developer Express, C#:

a) Table has a primary, autoinc identity key
b) Set objectdatasource.conflictdetection = CompareAllValues in the ODS for the DetailsView
c) Change ID field readOnly from True to False in DetailsView, per http://www.geekzilla.co.uk/ViewF9581DAE-CCF8-49FF-844C-7498603E0005.htm

Then we hit this roadblock: This table has 5 NULLABLE fields. The wizard generates the UPDATE PROC with TWO additional params:

@IsNull_Disposition nchar(10),
@IsNull_OwnerDiv nvarchar(50),

The objectDataSource does not add these params, so the mismatch causes the "Update not found" exception.

Comments welcome. We have burned weeks on these wizards and hope some patch is forthcoming. This is close to being awesome.

BTW the Wizard should also create a _SelectByPrimaryKey PROC, which we manually do by tweaking the generated _Delete proc.

Kim

GO
/****** Object: Table [dbo].[Applications] Script Date: 11/29/2006 13:13:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Applications](
[App_ID] [int] IDENTITY(1,1) NOT NULL,
[Application] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Disposition] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OwnerDiv] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Purpose] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Technology] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Comments] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [PK_Applications] PRIMARY KEY CLUSTERED
(
[App_ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

TableAdapter Wizard with optimistic concurrency generates this:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_dsPat_Applications_Update]
(
@Application nvarchar(50),
@Disposition nchar(10),
@OwnerDiv nvarchar(50),
@Purpose nvarchar(MAX),
@Technology nvarchar(MAX),
@Comments nvarchar(MAX),
@Original_App_ID int,
@Original_Application nvarchar(50),
@IsNull_Disposition nchar(10),
@Original_Disposition nchar(10),
@IsNull_OwnerDiv nvarchar(50),
@Original_OwnerDiv nvarchar(50),
@App_ID int
)
AS
SET NOCOUNT OFF;
UPDATE [Applications] SET [Application] = @Application, [Disposition] = @Disposition, [OwnerDiv] = @OwnerDiv, [Purpose] = @Purpose, [Technology] = @Technology, [Comments] = @Comments WHERE (([App_ID] = @Original_App_ID) AND ([Application] = @Original_Application) AND ((@IsNull_Disposition = 1 AND [Disposition] IS NULL) OR ([Disposition] = @Original_Disposition)) AND ((@IsNull_OwnerDiv = 1 AND [OwnerDiv] IS NULL) OR ([OwnerDiv] = @Original_OwnerDiv)));

SELECT App_ID, Application, Disposition, OwnerDiv, Purpose, Technology, Comments FROM Applications WHERE (App_ID = @App_ID)

Bind the objectDataSource and it does not find those params:

<asp:ObjectDataSource ID="ObjectDataSource2" runat="server" ConflictDetection="CompareAllValues"
DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}"
SelectMethod="GetData" TypeName="dsPatTableAdapters.Applications1TableAdapter"
UpdateMethod="Update">
<UpdateParameters>
<asp:Parameter Name="Application" Type="String" />
<asp:Parameter Name="Disposition" Type="String" />
<asp:Parameter Name="OwnerDiv" Type="String" />
<asp:Parameter Name="Purpose" Type="String" />
<asp:Parameter Name="Technology" Type="String" />
<asp:Parameter Name="Comments" Type="String" />
<asp:Parameter Name="Original_App_ID" Type="Int32" />
<asp:Parameter Name="Original_Application" Type="String" />
<asp:Parameter Name="Original_Disposition" Type="String" />
<asp:Parameter Name="Original_OwnerDiv" Type="String" />
<asp:Parameter Name="App_ID" Type="Int32" />
</UpdateParameters>

Several time-delay properties are exposed for the ToolTip component - AutoPopDelay, InitialDelay, ReshowDelay. These properties are not members of the ErrorProvider class. It seems as though they might be available somehow because the ErrorProvider displays what look like ToolTips, but I can't find the technique. Is there a way

Thanks,
Gus

Using VS.Net 2003

Yes, haven't upgraded here at home yet, only at work... cost $ :P

But, not sure if this is possible.

A MessageBox:

string message = "Delete " + lblTitle.Text.ToString() + " ";

Is if possible to format the lblTitle.Text above

Bold, underline, color, or anything will do.

Thanks,

Zath

Hi All,

I have a windows 'Master frame' in which a number of forms can be instantiated (upon the selection of a menu item, or pressing a button in the master toolbar. All of these can be moved around within the boundaries specified in the master frame.

However, I don't want the user to be able to instantiate two instances of the same form in the frame! (E.g. One form is for "Student Details". If they press the student details button once, the form will appear. If they press it again, another form will appear.) Is there an easy way to do this (say in the properties of the form object) Also, if the form already exists, I would like it to set focus to the existing form.

Thanks heaps

Chris

(Moderator: Thread moved to Windows Forms General for better responses)

Ok, new problem.

I can not find where I did this before.

Dyamically adding menu items:

string sql = "Select * From myTable";

OleDbCommand myCommand = new OleDbCommand(sql, conn);

while(myReader.Read())

I need to add a handler to each menu item for a click event.

Check/uncheck and other actions I already have written.

It's like right on the tip of my mind, but just can't see it... must be late.

Thanks,

Zath

Hi

I have painted a line using GDI+ and would like to capture the color and location of the cursor when the user mouse clicked on the line. Does anyone got any suggestion as to how to do it

Thank you.

Soh