Visual Basic

Datagridview edited by Multiple users

7-Oct-08 3:45

These should do it:

FILE.COPY, FILE.DELETE

Bob
Ashfield Consultants Ltd

helelark1237-Oct-08 2:57

helelark123

7-Oct-08 2:57

Hello,

I am developing with VS2005 (VB)
I wrote a program that is used by mulitple users at the same time. It contains a datagridview and when a user is editing a spcific record I would like that the data will be refreshed autoatically in all the users screen.
I don't want to use timer or flags for refreshing the data but a property like "resync" for example that exists in ADODB.recordset

Is ther e any solution
Please help

Thank you

Shay Noy

Ashfield7-Oct-08 3:15

7-Oct-08 3:15

If you are using SQL Server 2005/2008 take a look at Notification service , but be warned if you have a lot of users there is a substantial overhead.

Bob
Ashfield Consultants Ltd

Mycroft Holmes7-Oct-08 16:28

7-Oct-08 16:28

this is a typical nightmare some developers get into sooner or later. There is no elegant solution to this. Notification services will do the job but the overhead in both system and support is horrible.

Some solutions:
Timer as you have surmised it the standard solution.
Do not allow inline editing - force the user to a dialog for CRUD and reload the grid when they return (I use this)
Test the record BEFORE allowing inline editing and warn the user. Reload the grid when the record is saved.

Never underestimate the power of human stupidity
RAH

helelark1239-Oct-08 20:56

helelark123

9-Oct-08 20:56

Thank you for your reply,
If multiple users open dialog for updating the same record, is there a way to lock the record when the first of them is starting the update?

Shay Noy

Mycroft Holmes9-Oct-08 21:19

How to change the default property of the form

9-Oct-08 21:19

Of course but you are not going to like it. Be VERY sure this is a real world issue and not some BA's fantasy. Most developers percieve this as an issue early in their careers and find out it almost never actually happens.

I usually don't display ALL the information for a record in the grid so when the dialog goes to get the data to fill all the details it gets/sets as locked flag. If the record returned is locked then don't display the save button.

There are HUGE arguments on the best way to implement this, issues such as invalid flags, how to flag time/user/both, how to clear flags. Having said that I have NEVER had to implement this type (or any) of record locking scheme. It has always been an architect who proposes it then the business looks at the likelyhood of data corruption and the cost and hassle of implementing it and chucks it out.

Never underestimate the power of human stupidity
RAH

AR Reddy7-Oct-08 2:53

AR Reddy

7-Oct-08 2:53

Hi,

I want to chnage the default property of the form in VB.NET. Means, when we create a form with out any controls and run, there is an icon will display at top right corner. When we click on that icon, we will get the menu items as follows
Restore
Move
Size
Minimize
Maximize
X Close Alt+F4

Now I want to change these menu Items. How can I do this?
For example
I want to change the menu Item "Close Alt+F4" to "Close Ctrl+F4"
I want to add new menu Item "Next Ctrl+F6"

How can we do this? Please let me know.

Thanks in Advance.

AR Reddy

jzonthemtn7-Oct-08 4:14

jzonthemtn

7-Oct-08 4:14

Have to use the API: SAMPLE: How to Add New Menu Items to the System Menu[^]

The author of Manipulating the System Menu Using C#[^] made a class in C# to do it. You could compile it as a dll to use.

JR2128-Oct-08 2:34

JR212

8-Oct-08 2:34

I was looking for this to.
Thanks this helpt.
Can I also with some api add or modify the icons at the right side of the titlebar. It would be nise when I add or remove a menu option I also add/remove complete the icon at the right side

Jan

jzonthemtn8-Oct-08 3:05

jzonthemtn

8-Oct-08 3:05

You can. See Add Transparent Menus and XP Titlebar Buttons to your application[^].

Re: search within excel file

HemJoshi7-Oct-08 4:19

HemJoshi

7-Oct-08 4:19

Just go through the below article.It may be helpful for you...

http://www.codeproject.com/KB/edit/TNumEditBox.aspx?display=Print[^]

[Message Deleted]

EliottA7-Oct-08 2:33

EliottA

7-Oct-08 2:33

[Message Deleted]

Re: Excel Weird Behavior

EliottA7-Oct-08 3:42

EliottA

7-Oct-08 3:42

For those utterly interested in the topic, all you have to do is excelObj.IgnoreRemoteRequests = True and handle for when application closes / windows closes to save and quit excel.

search within excel file

jhyn7-Oct-08 2:23

jhyn

7-Oct-08 2:23

is it possible to search or look any character or phrase within the file..

like what google search engine do?

hope you can give me some hint about this..

thank you so much Big Grin | :-D

jyn

Ashfield7-Oct-08 3:09

7-Oct-08 3:09

Read the entire file into a string and use the string functions.

Bob
Ashfield Consultants Ltd

Combobox in DataGrid

neha.lad7-Oct-08 1:05

neha.lad

7-Oct-08 1:05

I want to use a combobox in Datagrid.
and in that combobox i want to display data from database with coding not from its property datasource.
Pls give me reply

Re: Combobox in DataGrid

Ashfield7-Oct-08 1:18

DataGridView HELL!!! what am I doing wrong

7-Oct-08 1:18

neha.lad wrote:
in that combobox i want to display data from database with coding not from its property datasource

Well don't bind it, just populate it in code then.

Bob
Ashfield Consultants Ltd

GDMFSOB6-Oct-08 20:56

GDMFSOB

6-Oct-08 20:56

Ok have a simple datagridview well at Least I thought so.... its bound to a typed dataset, it does not do what its supposed to do, when I edit a cell in the row just above the new row line at the bottom and hit ENTER it creates a new bloody row but not really it only actualy creates the new row if I type something, I only wanted to edit the cell I was just in, but now eveytime I change a cell and hit enter it tries to validate the new row with no input in it after it has updated the database, how the hell do you get arroud this, also previuosly, one of my other problems was I would edit a cell and then on CellEndEdit I wanted it to update the database but it would not really run the update I stepped through the code and could see the data in the cell had changed and the tableadapter.update had run but no change to the DB at All, until I edited another cell.

Please if any of you know what is goig on with the first problem of createing a new row on hitting enter in a non new row please assist.

Thanks

 <br />
Private Sub TRecieptsTableBindingSource_ListChanged(ByVal sender As Object, ByVal e As System.ComponentModel.ListChangedEventArgs) Handles TRecieptsTableBindingSource.ListChanged        <br />
If Me.StockDB.HasChanges Then<br />
            Me.UpdatePending = True<br />
        End If<br />
    End Sub<br />
<br />
    Private Sub DataGridView1_RowValidated(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.RowValidated<br />
        If UpdatePending And ValidRow = True Then<br />
            Me.TRecieptsTableTableAdapter.Update(Me.StockDB.tRecieptsTable)<br />
            Me.UpdatePending = False<br />
            ValidRow = False<br />
        End If<br />
    End Sub<br />

Mycroft Holmes6-Oct-08 23:09

6-Oct-08 23:09

Sorry, I have no idea, that's because I do not allow in line editing in any grid, I force the user to edit in either a detail panel or another form. The VERY few exceptions to this I only allow editing so the DGV addrows is disabled.

IMHO the management of grid inserting/editing is a bloody nightmare, always has been and I'm not convinced they have it right yet.

Never underestimate the power of human stupidity
RAH

GDMFSOB6-Oct-08 23:28

GDMFSOB

6-Oct-08 23:28

Yeah I reckon it's the only way that actually works using external forms for editing and adding rows, as the events do not fire as expected, also if I disable the addnewrows and the dataset has only one row the update does not fire on cell_leave or cellendedit at all, and I have to save the changes on an button event, bloody microsoft expect us to use this crap, it diffinatley does not work like it should I have also searched high and low for documentation in the SDK on how to implement a real world working example of the DataGridView that vaildates user input on editing and adding new rows. with no matter how many rows you have or what keystrokes you use to leave a cell and then actually send the update to your database using typed datasets.

Mycroft Holmes7-Oct-08 0:47

7-Oct-08 0:47

Well actually I never use typed datasets either Blush | :O

. I'm afraid I like to manage all the processes myself and am happy to pay the penalty with the additional code to achieve the level of control I require.

All the wizards in MS will never get me to use their built in data tools, they just suck Dead | X|

can I be more emphatic, nah! kid sister steps in.

Never underestimate the power of human stupidity
RAH

dan!sh 6-Oct-08 23:31

dan!sh

6-Oct-08 23:31

Set AllowUserToAddRows property as false and add a row through code whenever required.

"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry