|
remember to connect 1st the accdb into the project so you can name the dataset the you want to bring to sql
what are you coding tho VB .NET ? so we have an idea
|
|
|
|
|
Hi,
I need to create a login form application in VB.NET using visual basic 2010, that does the following:
1)Connects to AD server.
2)checks if the user belongs to "Domain Admins" group.
Thanks in advance.
|
|
|
|
|
|
Hi all,
it's been explained many times, I know... still after checking again and again I can't get my DataGridView updated from a custom collection. Here's the relevant piece of code:
Private Sub btnXLRetrieve_Click(sender As Object, e As System.EventArgs) Handles btnXLRetrieve.Click
' add the existing transactions from the spreadsheet after clearing the collection first
tColl.Clear()
For Each trans As Transaction In (From ps In provider.GetSheet(Of Transaction)() Where ps.Transaction_ID <> "" Select ps)
tColl.Add(trans)
Next
' actualize the DataGridView
With Me.dgvExcel
.DataSource = tColl
.Refresh()
End With
End Sub When the button is clicked for the first time, I get the (test) entry shown in the DataGridView. But clicking it again empties / updates the collection (tColl has the correct number of entries then) without updating the DataGridView.
Can someone of you please tell me what might be wrong?
In addition or as an alternative I wanted to get the DGV updated whenever the collection changes. The listener for my 'collectionChangedEvent' catches the event properly, but the DGV also doesn't update (using the same snippet).
Thank you for helping out,
Mick
|
|
|
|
|
I think you have to re-bind.
Try
dgvExcel.Databind
|
|
|
|
|
Hi David,
I didn't use databinding, so defining the datasource should be good enough... and it also works for showing the data for the first time. Maybe I have to check out the databinding approach, but that has other pitfalls with my approx. 25 columns. Still thank you.
EDIT: I tried the approach using the collection as the datasource of a BindingSource. While the collection as well as the BindingSource are filled properly, the DGV still doesn't update.
|
|
|
|
|
Michael Schäuble wrote: While the collection as well as the BindingSource are filled properly, the DGV still doesn't update.
Easiest way to bind a collection to a grid, is a BindingList[^]. I'm often populating it with objects that implement the INotifyPropertyChanged interface; AFAIK, that's the easiest route.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Second that I use it and it works well! +5
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
Thank you, Eddy - with a BindingList it seems to work!
|
|
|
|
|
This may be a very novice question. If so, sorry for that, but the solution is just not coming to me.
I have a form1 with a button and a datagrid in it. When I press the button I have to open another form2 which will accept some information, and then come back to form1 and use information provided by form1 to filter the data in the datagrid in Form1.
My problem is if I give Form2.show in the button click event then the control completely passes to form2 and returning to form1 button.click event is becoming difficult for further processing.
I want to keep the form2 separate since I will be using the same process to filter data in another form3.
Can anyone help me in solving this issue.
|
|
|
|
|
Use the ShowDialog() [^] method, which treats the form as a popup dialog.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Thanks a lot Richard.
It helped
|
|
|
|
|
Dim cAutoit As New AutoItX3Lib.AutoItX3
cAutoit.Send("{DOWN}")
System.Threading.Thread.Sleep(150)
cAutoit.Send("{ENTER}")
Using this code on a hotkey, I'm trying to make the hotkey navigate the halo trial menu to start a server.
The problem is that no natter how I adjust the pause it is always incomplete, (It will skip keypress, or do nothing all together.)
I need it to press: "down, enter, down, down, down, down, Enter" consistently without fail can someone PLEASE help me?
|
|
|
|
|
Here at CP? Probably not.
But, at the AutoIt forums, here[^], yes, they probably could.
|
|
|
|
|
|
Hi
Is there any software using VB on Production Planning for Manufacturing Company with Source Code.
Thanks
|
|
|
|
|
Quite possibly; a Google search would give you some answers.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Google It...
Tarun Mangukiya
|
|
|
|
|
Jagjit Saini wrote: Is there any software using VB on Production Planning for Manufacturing Company with Source Code
Yes
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
I have an MDI Parent with menu strip. There are two MDI Child forms. I want the first MDI Child to fill the parent for which I have used the Dockstyle.Fill which is working fine. But the second child form I want it to be Center screen and have set the Start Position in the properties. But when I open the second child first time from the menu it fills up the Parent. If I close it and open again then it shows center screen. Can anybody help me to solve this problem?
|
|
|
|
|
Set the WindowState of the first MDI-child to Maximized, would work better ith Windows - the docking works better if you're dealing with controls inside a panel-control. Once that is fixed, the other Window will no longer be confused by the Docked Window.
Make sure the second window is neither docked, nor maximised.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Thanks a lot Eddy.
It actually started working after removing the Dockstyle property.
Thanks again
|
|
|
|
|
Great, glad it worked
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
It is a known problem with MDI.
if the first window is set with either dock or windowstate all subsequent windows will inherit that setting.
The only way I have around it I have found is to either change these settings before opening the second window or to set the size of the first window manually, i.e. Form1.size = new size(100,100) where you would replace the "100" with the actual size that you want etc.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
Yes Simon, You are absolutely right. It worked once the Doskstyle settings were removed.
Thanks for the explanation.
|
|
|
|