C# Discussion Boards - CodeProject

Re: Wanted: MultiColumn Expandable/Collapsable TreeView/ListView

15-Aug-04 19:43

Bompus wrote:
does anybody know of a control/component that will do this or how to go
about making/modifying one?

I'm sure I have seen an article on this right here on CP a while back Smile | :)

(could be wrong!)

^{top secret xacc-ide 0.0.1}

yetanotherchris17-Aug-04 5:45

Control of database entry

17-Aug-04 5:45

there's a couple of owner drawn listviews right here on codeproject.com - glacial listview is probably what you need, or carlos' articles

tzewei15-Aug-04 14:37

tzewei

15-Aug-04 14:37

The primary key for table Attachment is AttachmentID. I wanted the file path to be unique,meaning if you have entered the repeated filepath,the system will pop up a error msg,and the file path record will be denied.
Here is the stored procedure with C#:
CREATE PROCEDURE FilePath
{
@AttachmentPath Varchar(50)
}

AS

Select AttachmentPath from Attachment where AttachmentPath=@AttachmentPath
IF @@ROWCOUNT = 0
BEGIN
INSERT INTO ATTACHMENT VALUES(@AttachmentPath)
END

RETURN @@ROWCOUNT

GO

It still can't work,why?Please help me!

Thank you!

Re: Control of database entry

S Sansanwal15-Aug-04 16:47

S Sansanwal

15-Aug-04 16:47

Make sure you have your AttachmentID column in Attachment Table set as Identity(autonumber)
CREATE TABLE [dbo].[Attachment] (
[AttachmentID] [int] IDENTITY (1, 1) NOT NULL ,
[AttachmentPath] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Attachment] ADD
CONSTRAINT [PK_Attachment] PRIMARY KEY CLUSTERED
(
[AttachmentID]
) ON [PRIMARY]
GO

Change Stored Procedure as

CREATE PROCEDURE FilePath
@AttachmentPath Varchar(50)
AS
Declare @count int
Select @count = count(*) from Attachment where AttachmentPath = @AttachmentPath
if @count =0
BEGIN
INSERT INTO ATTACHMENT(AttachmentPath) VALUES(@AttachmentPath)
END
GO

Note: An easiest way would be to have AttachementPath column set as Unique. Then, stored procedure would automatic generate an error in case of duplicate data

Sanjay Sansanwal
www.sansanwal.com

showing dataset progress

slundstrom15-Aug-04 13:52

slundstrom

15-Aug-04 13:52

Hello,

I'm building an application were I need to fill a large dataset before using it to display a crystal report. I has been taking up to 30 sec. to retrieve all the data from the server and I need a way to assure the user that the application has not froze up during this time. I cannot get a progress bar to work in this case and have also tried to display a form with an animated gif, but the gif does not animate during the data retrieval. I would like to be able to show the user a true progress if possible, any suggestions?

-Scott

Re: showing dataset progress

Dave Kreskowiak15-Aug-04 15:49

Dave Kreskowiak

15-Aug-04 15:49

You can'y unlress you writ your own code to fill the dataset a set number of records at a time, kind like paging in 10 records at a time until you get all, say 1,000 records into your dataset.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

owner drawn listview

yetanotherchris15-Aug-04 12:08

15-Aug-04 12:08

I'm trying to do a custom draw on listview items, when a listview is in large icon mode. I've found lots of samples, one here on codeproject, but none seem to be geared towards the icon mode. The problem I'm getting is i'm not getting given an 835 (CUSTOMDRAW) message in the WndProc function, which the listview sends to itself (reflected message), I only get an 870 in it, which is a NOTIFY message.

I basically want to right my own listview that customises the large icon view of a listview, so for example, I could do a photo gallery with descriptive text underneath each item.

If anyone can point me in the right direction, that'd be much appreciated. I've hit a bit of a brick wall with it.

leppie15-Aug-04 19:55

15-Aug-04 19:55

smallguy78 wrote:
The problem I'm getting is i'm not getting given an 835 (CUSTOMDRAW) message in the WndProc function, which the listview sends to itself (reflected message), I only get an 870 in it, which is a NOTIFY message.

Why you doing that? Just set the OwnerDraw property to true, and use the MeasuerItem and DrawItem overrides.....

^{top secret xacc-ide 0.0.1}

yetanotherchris15-Aug-04 22:59

15-Aug-04 22:59

Listview doesn't have MeasureItem and DrawItem, which is why I need to use p/invoke to do it.

There's a few examples out there, like I said, none of which work with large icon view.

leppie15-Aug-04 23:16

15-Aug-04 23:16

OOOPSS, my bad Blush | :O

^{top secret xacc-ide 0.0.1}

yetanotherchris16-Aug-04 0:38

Delete Image File Showed in PictureBox

16-Aug-04 0:38

With the help of ListViewEx's implementation, I've got it working. The NOTIFY message is being called ok, and the -12 (CDDS_ITEMPREPAINT) is also being called. It's all painting okay, so if anyone ever needs to do this, send me an email and I can help out (I'm doing large icons listview though, remember)

My only problem is the rectangle I'm getting back doesn't contain any width information (the Right property is the same as the Left, x same as y). I can work around this as I'm doing a custom draw, but it's a tad annoying.

amgad_fathy15-Aug-04 5:11

amgad_fathy

15-Aug-04 5:11

I want to delete a file for an image but before deleting it the image is shown in a picturebox control so when i try to delete the file it tells me tht this file already in use
i tried the following but gives the same Error
First Trial
pictureBox.Image.Dispose();
Second Trial
pictureBox.Image = null;
GC.Collect()

but both trials failed
thx

Re: Delete Image File Showed in PictureBox

Stefan Troschuetz15-Aug-04 6:01

Stefan Troschuetz

15-Aug-04 6:01

Try to load your image from the file by using streams and then close the stream before you want to delete the file.

www.troschuetz.de

how can i down the datagrid scorller?

kings_115-Aug-04 3:55

kings_1

15-Aug-04 3:55

hi there
i have a Form Whit a DataGrid on it
in the datagrid i have a lot of data
when the Form is load
i want to see in the datagrid the last data that enterd
the last page
i dont want to scroll down the datagrid scroller any time the form is loaded
i want it to be automaticely .

how can i do it ?

thanks ... i hope somebady to help me Smile | :)

i am in c# - my DB is Accses

Re: how can i down the datagrid scorller?

partyganger15-Aug-04 16:03

partyganger

15-Aug-04 16:03

Set the DataGrid's CurrentRowIndex property to the number of Items in the DataGrid's DataSource property - 1. Minus one, because the row index starts at zero.

e.g.:

datagrid1.CurrentRowIndex = ((DoCastHereToTypeOfDataSource)datagrid1.DataSource).Count - 1 //Count could be Length if you use an array

Microsoft Chart Control 6.0

sreejith ss nair15-Aug-04 2:28

sreejith ss nair

15-Aug-04 2:28

hi,

Now i am trying to use Microsft Chat control 6.0 (COM) into my C# application. I want to bind lot of numeric data with chart control. I don't have any prior experience with vb. And i can't find any material which will give alteast little about this idea.

What about you ? You know any material which deal these senario....

**************************
S r e e j i t h N a i r
**************************

Re: Microsoft Chart Control 6.0

leppie15-Aug-04 5:18