|
I keep coming back to this one, I don't use MDI but the 2 action process brings the event orders to mind. If you use the selectedindexchange on a list control it fires the event 2 times for each row change, 1st to remove the selection and the 2nd to apply the next selection. Could this be the culprit with your forms. What event are you using!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Very good guess. I am using a button click event but events are not the cause. It's the weirdest problem. When I am debugging I have a watch on child.Location and also the new location. I step over and the new location does not get assigned to the child.Location for some odd reason. On the next try it does assign it and then again it doesn't.
I am totally lost!
|
|
|
|
|
I can't seem to duplicate this but I can tell you that you need to set the location of a form after you call the form.show methode (if you do it before it doesn't work (at least not at my end))
|
|
|
|
|
The problem was WindowState should be set to Normal and before I had it sit to Maximized---URRRRRRRGH. Still confused as to why this property will prevent the form from displaying at the correct location.
|
|
|
|
|
Don't ya hate it when it is the simple ones, one of the reasons I like working with a team is that I can bounce the problems at them before resorting to CP (public humiliation);P
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
For the last two months I have been fighting an issue with a multithreaded vb.net progran that for no apparent reason goes into a deadlock condition. When the progrm enters this state the only way to break the deadlock is to doubleclick on the main screen and then the screen goes black and a second later the program returns to a normal state and all is well. This typically hapens after about six hours of runtime and the process is in cycle doing measurements and reporting results. Any ideas would be greatly appreciated.
rcombs
|
|
|
|
|
The action of double clicking the main screen obviously changes some state somewhere which causes one of the threads to stop interfering with another.
My suggestion is to follow through on the debugger the event that handles the double click event and see what it changes that releases the deadlock.
|
|
|
|
|
Please I'need help.
how to call my stored procedure in SQL 2000 using VB.NET 2008
with parameter, date range.
thank you
|
|
|
|
|
|
|
|
So? It's the same general idea.
"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
|
|
|
|
|
Very Easy.
Dim con as SQlConnection(ConnectionString)
con.open()
dim cmd as new sqlcommand("StoredProcedureName",cn)
cmd.CommandType=Commandtype.StoredProcedure
'if Stored procedure return rows
dim dr as sqldatareader=cmd.ExecuteReader
'if Stored procedure do not return rows then
cmd.executenonquery
'if stored procure has parameters
cmd.parameters.add(new sqlparameter("@parameterName1",value))
cmd.parameters.add(new sqlparameter("@parameterName2",value))
..........................
'then excute it by Executereader or executenonquery
Hope This will solve your problem
|
|
|
|
|
Thank you for you help me,
I'm run this but return this msg:
Syntax error converting datetime from character string.
I'have this format in my SQL data base field
2005-06-21 00:00:00.000
I'have in my form two datetimepicker
cmdOrders.Parameters.Add(New SqlParameter("@StartDate", Dtpicker1.Value))
cmdOrders.Parameters.Add(New SqlParameter("@EndDate", Dtpicker2.Value))
how format the date.
thank you.
|
|
|
|
|
There is a lot of documentation and examples already available covering what you are asking for. Specifically what is it that you have problems with?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
I'have this.
Dim sConnectionString As String = _
"server=rs500001\rptsrv;uid=user;pwd=pass;database=rpt"
Dim cnNorthwind As New SqlConnection(sConnectionString)
Dim cmdOrders As New SqlCommand("sp_Sales", cnNorthwind)
cmdOrders.CommandType = CommandType.StoredProcedure
cmdOrders.Parameters.Add(New SqlParameter("@StartDate", SqlDbType.DateTime))
cmdOrders.Parameters"@StartDate").Value = "2008-01-01"
cmdOrders.Parameters.Add(New SqlParameter("@EndDate", SqlDbType.DateTime))
cmdOrders.Parameters("@EndDate").Value = "2008-0-10"
I'm using SQL 2000 and VB.NET 2008, but this not work, I'm want run my stored procedure, the name for this is "sp_sales".
thank you
|
|
|
|
|
reynaldosp wrote: but this not work
That's not a useful description. What happens? Does it compile? Do you get an error message? What do you expect it to do, what does it do, and how does that differ from what you expect?
reynaldosp wrote: cmdOrders.Parameters"@StartDate").Value = "2008-01-01"
You are missing a starting parenthesis after cmdOrders.Parameters.
As the data type for the parameter is DateTime, you should assign it a DateTime value, not a string.
The Add method returns a reference to the parameter, so you don't have to access it by name. Also, it has an overload that creates the parameter for you.
cmdOrders.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = new DateTime(2008, 1, 1)
reynaldosp wrote: cmdOrders.Parameters("@EndDate").Value = "2008-0-10"
That's not a valid date. I suppose you meant "2008-01-10"?
cmdOrders.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = new DateTime(2008, 1, 10)
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
I hope they were typos in the message posted and not the code he was trying to compile. 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You never know... The variable name cnNorthwind is clearly from code taken directly from an example using the example database Northwind...
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hey guys currently i have this setup.
1. Enter say "123" in textbox1.text
2. click button will search datarow in datagrid1
3. copy datarow and append it to datagrid2
4. will delete the line it copied from
for the first click it will work but the 2nd one it prompts "cannot access delete row" when what i type in textbox1.text is "345" totally different
Dim dr As DataRow, drNew As DataRow<br />
Dim dt As DataTable = objDataSet.Tables(0)<br />
<br />
For Each dr In dt.Rows<br />
For i As Integer = 0 To dt.Columns.Count - 1<br />
If dr(i).ToString = TextBox1.Text Then<br />
drNew = dt2.NewRow<br />
drNew(0) = dr(0)<br />
drNew(1) = dr(1)<br />
drNew(2) = dr(2)<br />
<br />
dt2.Rows.Add(drNew)<br />
drNew = Nothing<br />
dr.Delete()<br />
Exit For<br />
End If<br />
Next<br />
Next<br />
DataGrid2.DataSource = dt2<br />
End Sub
|
|
|
|
|
I didn't go through the code, however a couple of points when managing datarows. After changing a row(s) do Table.AcceptChanges this resets the rowstate back to current. This causes post delete processes to fail.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have seen in various custom controls that you purchase where after you drag and drop the control onto a form, a small popup screen appears where you can modify the various properties of that control by choosing items on that popup screen such as check boxes or choosing items from dropdown lists, etc.. Sort of like a wizard. Can someone show me with code how I can create such a popup screen like this where I can modify the properties of cutom control? Or give me a link where I can see an example how this is done in VB?
|
|
|
|
|
One of my articles can help you with that: Targeting Design-Time Events of UserControls[^]
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
This looks like everything I am looking for except that it is C# and I don't know c#. Do you have a version in VB?
|
|
|
|
|
The only thing different is the syntax; take away all the semicolons the braces {} and rename some of the keywords and it is VB. Basically, you can use this article as a reference for what namespaces/classes/principles you will need in your solutions (as all of the classes/namespaces are discussed in the article).
I will not convert the program to VB, frankly because I do not have the time at present, but if you have specific questions in understanding the contents of the article then you can post questions in that article forum and I will be glad to answer them. If you have a few snippetts of code that you don't undestand then I may convert those few snippetts to VB.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
