himanshubari

I use the connection timeout property for creating the SQLConnection. I am basically trying to open the connection to my remote database and if that fails I need to switch to my local database. However ADO.net is taking around 40 seconds to figure out that it cannot open the connection. i have specified the connection timeout as 5 seconds. Am i missing anything??? Thanks in advance -Himanshu

Hi, I need some help to get the equivalent behaviour in ADO.NET for using the adLockOptimistic and the ADODB.DataTypeEnum from ADODB Thanks in Advance

oops! I think I am lacking some basoc concepts here. SO I call the endCurrentEdit() method as advised by you. But, I dont have any update method, So here is what my understanding is.. I bind a control to a property in my business object Label1.databindings.Add("Text",myPropertyBean,"Name") SO the value returned by the Name property would appear in the text of the Label1. Now some other UI component changes this text of Label1.....and I expected that automatically the setter for Name property would be called and the appropriate member variable in my 'myPropertyBean' would be updated but I thought This would happen AUTOMATICALLY as its databound. Do i have to manually call this setter method instead as a part of the update method you were talking about?? Sorry for being confusing if I am... Thanks again !!

Thaks a lot for your help, But I wanted to know where should I place this line. and what is teh dataSource object?

I have windows form control bound to a business object. Upon initialization it displays the data from the business object in the text box as its bound. But when I update the vale in the text box the respective data member of my business object doesnt get updated. Any suggestions please? Thanks

Hey, I am looking into starting to use a profiler. If anyone has any experience into using profilers...any suggestions as to which ones are better? I was thinking about the ANTS profiler Thanks in Advance Himanshu

Hey, Try removing the ';' character from your SQL string. I think you dont need that when you run your querries programatically -Himanshu

Thanks!!! Hey !!...I ran the code that demonstrated moving the listbox at run time. Thanks a lot, I think this techniquewill serve my purpose. Actually I am working on a simple UI configurator that will instantialte the control at runtime and allow it to be moved around on the form. The rectangle technique of yours will work great I guess Thanks Again!

Hey, can somebody help me out to avoid the flickering of controls that I am getting while I mobve them on the forma t runtime. here is the code I have added to the mouse events for a button I hav on my form Private Sub Button1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Button1.MouseDown If e.Button = MouseButtons.Left Then moving = True End If End Sub Private Sub Button1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Button1.MouseMove If moving Then Button1.Location = New Point(e.X, e.Y) Button1.Refresh() Button1.Parent.Refresh() End If End Sub Private Sub Button1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Button1.MouseUp moving = False End Sub I also added these lines after the initialize component call to enable double bufferring Me.SetStyle(ControlStyles.DoubleBuffer, True) Me.SetStyle(ControlStyles.AllPaintingInWmPaint, True) Me.SetStyle(ControlStyles.UserPaint, True) HELP WILL REALLY BE APPRECIATED THANKS