|
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
|
|
|
|
|
There's no such method as Mkdir in the Shell.Application object. it helps to read the documentation on these things instead of just assuming they understand DOS commands.
You're looking for this[^].
|
|
|
|
|
Hi ALL,
I have code in vb.net which is to be converted to VBScript. ow can i do it?
Do we have converter to do it? If so can you please provide me the link plzz ..help me out.
Waiting for reply..... thanks in advance.
Thanks.
|
|
|
|
|
You really cannot do this since VBScript and VB.NET are two different things.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
