|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
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
jyn
|
|
|
|
|
Read the entire file into a string and use the string functions.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 />
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Well actually I never use typed datasets either . 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 can I be more emphatic, nah! kid sister steps in.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
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
|
|
|
|
|
Thanks but I have tried this and it causes another problem if there is only one row in the dataset and you try to edit a cell in that row it does not update the database with the new cell value when you leave the cell as soon as there is a second row it works fine. Any thoughts?
|
|
|
|
|
hi there,
i am trying to check whether the existed folder on disk is readonly or not using vb6.0, i hav done successfuly in case of file i.e. GETATTR("path of foldr) " and vbReadonly but it is nt working in case of folder.
Please help me out
Thanks in advance
i m faisal
|
|
|
|
|
Without seeing the code you used, it's impossible to tell you where you went wrong.
But, you can easily do this with the FileSystemObject and it's Folder object.
Though, I have to question your motivations for using the attributes of a folder. If you're looking to see if the user can create a file in the folder, checking the ReadOnly attribute is not the way to go, since it does not consider the users NTFS permissions.
|
|
|
|
|
Does any one know how to create a windows director using VB code
The below code opens an explorer window to the correct file path, but when try to create a new folder I get an error "Object does not support this property or method"
Any Ideas?
Private Sub Test_Open_Click()
Dim SH, OpenThis, Save_Path
Dim Create_Folder, ThisFolder
SavePath = "c:\Project"
Set SH = CreateObject("shell.application")
OpenThis = SAVE_PATH
SH.Open OpenThis
SH.MkDir (SAVE_PATH & "NewDir")
Set SH = Nothing
End Sub
|
|
|
|