|
Sorry Ralf, but I haven't yet worked on Dialogs. However, I would try it once this issue is resolved. I can't start it afresh as the existing code I am working upon is quite huge for me to handel at the moment!
If you could please suggest an edit for my EXISTING code, it would be of great help! Thanks again!
|
|
|
|
|
It's very difficult for me to do that with your code - there a so many things missing, what a necessary. That's the reason why I made my Suggestion.
When you create a Button you also have to create an Eventhandler for the Button-Action. Each dynamcly created control (and also the handlers) must be dynamicly removed/disposed when finishing.
I seriously suggest you to think over the way, you are working/developing.
Why don't you try what I have suggested (before doing nothing) ?
|
|
|
|
|
Sure I would give it a try, however, it would take some time as I am preoccupied with some other assignments at the moment. Would get back for more suggestions/discussion once I am done. Thanks for the help.
|
|
|
|
|
No matter ... you are welcome.
If you want to go further you know where to find me ... 
|
|
|
|
|
Hello,
I have sershed long time to fix a flickering when I'm open a Mdi forms and I found that code
Protected Overrides ReadOnly Property CreateParams() As CreateParams
Get
Dim cp As CreateParams = MyBase.CreateParams
cp.ExStyle = cp.ExStyle Or &H2000000
Return cp
End Get
End Property
but the problem is when I'm trying to moving my form it was a very lagging happen or zigzag in my form it moving a very slowly.
Thanks
|
|
|
|
|
Instead of that hard to read code, why not use the "double buffered" property of the form?
How many controls are on there? Images? Yes, how big?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I'm not using images Just use textbox, Combobox and group box a lot of it, and I already used Double Buffered but it's not fixed my problem All I need a code to fix a lagging in form when I'm trying to move it manually.
|
|
|
|
|
Mohamed Hamdy wrote: I need a code to fix a lagging in form when I'm trying to move it manually.
Unfortunately there is not a simple code solution to the problem. You have to take into account the number of different controls on the form, the speed of the processor and video card, and available memory space. Double buffering helps to reduce the problem, but when dragging a complex Window/Form across the screen there are still many repaints to be done as it moves.
|
|
|
|
|
Hello !
If the sql server is on my office's server , and I'm outside , is there any chance to connect to my database using my vb.net program ?
( the server doesn't have a real ip , but a dynamic ip from ISP ).
Thank you !
|
|
|
|
|
If the TCP/IP address changes I take it the name still stays the same? If that is the case then use the DNS name instead of the IP address in the connection string for the server. Of course you need to have a type of a connection that allows you to communicate with the inside network.
For the connection string format refer to https://www.connectionstrings.com/sql-server/[^]
|
|
|
|
|
Sorry , I'm not speaking for a website or a webserver. The server is on my office. In the office I use a ADSL internet connection that use a dynamic IP address. For what "Name" do you speak ?
|
|
|
|
|
So from what I gather, the database server has a fixed IP address inside your network but the IP address for your office that is shown from outside is changing? If that's correct, I believe that you need to contact you ISP and ask if you can get a fixed address etc.
The naming I'm referring to is DNS[^]
|
|
|
|
|
yes you're correct.
Even the ip from ISP is fixed , it's still an static ip address inside the ISP. So it's not a real ip address.
|
|
|
|
|
Also be sure the correct port is open.
BUT that's not really very secure; hosting a web service that connects to the database and having clients access the web service tends to be a better choice.
|
|
|
|
|
How can i host a web service ?
Any example ?
|
|
|
|
|
Dial in on the LAN?
Exposing your DB to the outside is definitely a bad idea.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
ok , but what do you suggest because I need to give users this possibility ?
|
|
|
|
|
Let them access the database over a webservice as PIEBald suggested. Don't make those public/accessible to anyone have some authentication in there.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Get your network admin to set up a VPN[^]. If the public IP address is liable to change, use a Dynamic DNS[^] service to keep a DNS record updated with the correct address.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hello ,
I want to ask a question First I'm using VB.NET and I want to know How to Call Stored Procedure parameters in Class ?
What I mean I have a lot of parameters in my Stored Procedure and I want to call it in my form by using that Function but I can't put parameters because it's approximately 15 params.
this my code in class :
Public Function Add_Ne(ExecQ As String) As Boolean
Try
con.Open()
With cmd
.CommandType = CommandType.Text
.CommandText = ExecQ
.Connection = con
' .Parameters.AddWithValue(paramxx, TextN)
.ExecuteNonQuery()
End With
con.Close()
Return True
Catch ex As Exception
MessageBox.Show(ex.Message)
Return False
End Try
End Function
Thanks.
|
|
|
|
|
I'm not sure about your question.
Please show your class-definition to make it clearer ...
|
|
|
|
|
That's a Function again
Public Function Add_Ne(ExecQ As String, paramxx As String, TextN As String) As Boolean
Try
con.Open()
With cmd
.CommandType = CommandType.StoredProcedure
.CommandText = ExecQ
.Connection = con
.Parameters.AddWithValue(paramxx, TextN)
.ExecuteNonQuery()
End With
If con.State = ConnectionState.Open Then
con.Close()
End If
Return True
Catch ex As Exception
MessageBox.Show(ex.Message)
Return False
End Try
End Function
That's work but for 1 params and 1 textbox I call it in my form by
xo.Add_Ne("INSERT_ACCOUNT", "@AccountID", TXTAccNumber.Text)
And it's work What I mean If I have 15 params Is it true to put 15 params and 15 textbox as string in main of function or there are easier ways?
|
|
|
|
|
Mohamed Hamdy wrote: If I have 15 params Is it true to put 15 params and 15 textbox as string in main
of function
Yes.
Why is that a problem?
Mohamed Hamdy wrote: or there are easier ways?
Ask someone else to write them.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Mohamed Hamdy wrote: What I mean If I have 15 params Is it true to put 15 params and 15 textbox as string in main of function or there are easier ways?
Basically no. Each parameter need to be given a proper value. This mapping has to be done somehow. Some ORM tools allow different kinds of mappings but in the end a parameter needs a value, regardless how it's done.
Of course you can simplify the situation. If this is for example Windows Forms use for example Tag property and store the name of the database field in it. Then when inserting or updating, loop through the objects in a window and gather the values to proper parameters based on the tag.
Better yet, derive your own object where you define all the properties you need and define necessary values for those and voila you have a dynamic value gathering from UI.
|
|
|
|
|
There are quite some examples on how to execute stored procedures 
- Change the commandtype to CommandType.StoredProcedure.
- Change "ExecQ" to "ProcedureName". Assign that to .CommandText.
- Add a Parameter.WithValue for all 15 parameters. (Yes, 15 lines of code).
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
