|
Depends on what you want to refresh. No one knows what you are talking about.
|
|
|
|
|
...and STOP YELLING at people. Typing everything in all caps is the equivalent to screaming at people on the internet.
|
|
|
|
|
in the onclick event of the button you write the code to refresh the magic thing you need refreshing.
I hope like hell you are not the accounting firm in London asking such a badly formed question.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Maybe it's the manager who decided to fire their only programmer because he read on a magazine that VB.NET is so easy anyone can write code in it?
GCS d--(d-) s-/++ a C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Mycroft Holmes wrote: I hope like hell you are not the accounting firm in London asking such a badly formed question.
Wait for your coming colonscopy, and see the device running W98. Imagine a dependency on vbrun300.dll.
Have fun 
Bastard Programmer from Hell 
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Hello;
I have image on PictureBox, Cinverted to Base64String string and saved in Database as following:
Dim ms As MemoryStream = New MemoryStream
Dim bmp As Bitmap = New Bitmap(PictureBox1.Image)
bmp.Save(ms, System.Drawing.Imaging.ImageFormat.jpg)
Dim My_Photo_Str As String = Convert.ToBase64String(ms.ToArray)
myqry = "update MYTABLE set COLUMN1=" & "'" & My_Photo_Str & "'" & "where COLUMN2=" & 50
mycmd = New OleDbCommand(myqry, conn)
mycmd.CommandTimeout = 0
mydr = mycmd.ExecuteReader
Now that image need to retrieve it or shows on PictureBox, So I used the following:-
myqry = "select * from MYTABLE where COLUMN2=" & 50
mycmd = New OleDbCommand(myqry, conn)
mycmd.CommandTimeout = 0
mydr = mycmd.ExecuteReader
mydr.Read()
Dim PIC As Byte()
PIC = mydr("COLUMN1")
Dim My_Photo = New MemoryStream(PIC)
PictureBox1.Image = Bitmap.FromStream(My_Photo) <<<<<-----HERE GOT ERROR
the error on last line while try to set image to PictureBox, and error said that cannot convert Byte() to image, If any help will so appreciated
thanks
|
|
|
|
|
|
Why are you converting the image to a Base64 string? You don't have to do that to save it it in the database.
Databases support blobs (Binary Large Objects) natively, so conversion to Base64 is not necessary.
You can't directly use the Base64 string to create a Bitmap object from it. You have to convert the Base64 string back into an array of bytes, then create the Bitmap from that array.
|
|
|
|
|
|
ffmpeg.exe will not save file names with a number since the first "output.avi" and exists but a new one that has "output(1).avi" will not be accepted. What can I do here.
|
|
|
|
|
I figured out how to do it :-) :-D
|
|
|
|
|
Hello,
I am making a VB.NET forms application and need to connect with SQL Server over the internet using the following connection string:
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
From what I could glean from the internet, apparently this kind of connection string is vulnerable to being hacked. Thus what should I do to encrypt this string and also enable decryption only at the remote server.
Whenever I search the internet, I only come across ways to encrypt web.config and app.config. This apparent security flaw does not seem to be covered anywhere.
Thanks in advance,
Khalid.
|
|
|
|
|
An SQL server should never be directly exposed to the internet. You normally expose the database functionality through a securable web service and your application talks to the web service to handle all the database work.
|
|
|
|
|
Dave Kreskowiak wrote: n SQL server should never be directly exposed to the internet. You normally expose the database functionality through a securable web service and your application talks to the web service to handle all the database work.
Ok, can you point me to a webpage or post regarding how to go about this?
I am sorry if my questions appear rather naive but this is the first time I am going about this whole thing.
Khalid.
|
|
|
|
|
Any tutorials on "VB.NET create web api". Then you need the client side, so "VB.NET consume web api".
|
|
|
|
|
Dave Kreskowiak wrote: An SQL server should never be directly exposed to the internet
Sort of. SQL Azure is accessible over the internet.
|
|
|
|
|
True, but your normal SQL Server doesn't have the defenses in front of it like an Azure SQL instance does.
|
|
|
|
|
Member 15377440 wrote: this kind of connection string is vulnerable to being hacked
Not sure what you are asking.
1. Is the string able to be hacked? No, because it sits in app.config and hopefully you have that on a secure server.
2. Can the SQL server be hacked? Yes, anything can be hacked. But, you can certainly secure it. Sql Azure is accessible via IP address.
Is your sql server not in the same place as where your forms application will be running?
|
|
|
|
|
Member 15329613 wrote: 1. Is the string able to be hacked? No, because it sits in app.config and hopefully you have that on a secure server.
If I am understanding this correctly, my app.config file will be on my development/deployment machine. Should not be an issue as long as I am accessing my SQL Server database on the same machine.
My fear is that if I want to keep my SQL Server database in the cloud and try to connect with it through a connection string, that string could be easily be read by a third party over the internet.
Thus, how do I ensure that my connection string containing the database credentials cannot be hacked while being sent over the internet.
If I encrypt the app.config file on my local machine, is that enough to secure this issue. How will the jumbled connection string be de-crypted at the remote server?
Member 15329613 wrote: Is your sql server not in the same place as where your forms application will be running?
Presently it is on the same machine, but as I said above, my plan is to keep in the cloud eventually.
BTW, thank you for addressing my query, else in most cases, people simply write some cryptic answers which lead nowhere!
|
|
|
|
|
Member 15377440 wrote: If I encrypt the app.config file on my local machine, is that enough to secure this issue.
NO! Not even close. Think about it. If your code can decrypt the connection string, so can someone else.
|
|
|
|
|
If you deploy your database to Azure SQL, for example, it will be secure. You only need to encrypt your app.config if you are worried about someone getting onto the machine that has your app.config.
When .Net code makes the connection using the connection string it does it in a secure manner. You do not need to do more.
|
|
|
|
|
Member 15329613 wrote: When .Net code makes the connection using the connection string it does it in a secure manner. You do not need to do more.
Ok, so does this mean that if I deploy the database on some other platform, I have to take additional measures to secure the connection string or does .NET code ensures this security in all cases?
And if it does not secure the string for other platforms(other than Azure), what measures do I need to take to prevent such a hack on the connection string?
|
|
|
|
|
The string is secure as long as know one can get to the machine. If you put your database out on the internet with your own install of sql you'll have to google how to secure it. If you use Sql Azure, it is already secured but there are additional securities you can add to it.
|
|
|
|
|
How do I read XML File and put it in Datagridview and how do I search the content of specific text and re-update the modified the text to all lines and update it back to XML File from Datagridview ?
Here is my XML File content.
<shares>
<country name="india" exchanges="NSE,BSE">
<symbol name="Wipro Technologies" nseid="WIPRO" bseid="12371">
<yahoowatchlist name="Sharesa">
<watchlistlist>
<watchlist name="Sharesa">
<watch symbol="DLF" exchange="NSE">
<watch symbol="ICICIBANK" exchange="NSE">
<watch symbol="INFY" exchange="NSE">
<watch symbol="NSEBANK" exchange="NSE">
<watch symbol="NSEI" exchange="NSE">
<watch symbol="RELIANCE" exchange="NSE">
<watch symbol="SBIN" exchange="NSE">
<mcxdirect>
<worldstockwatchlists>
<worldstockwatchlist name="watch-1">
<stock symbol="MSFT">
<stock symbol="GOOG">
<stock symbol="AAPL">
<stock symbol="INTC">
<stock symbol="^IXIC">
<stock symbol="^GSPC">
<currentworldstockwatch name="watch-1">
<forex>
<watch symbol="USDINR=X">
<watch symbol="EURUSD=X">
<watch symbol="USDJPY=X">
<watch symbol="USDCAD=X">
<watch symbol="USDCNY=X">
<watch symbol="USDCHF=X">
<watch symbol="USDSGD=X">
<fnodirect>
<symbolmapping>
<mapping symbol="BANKNIFTY30SEP2136000CE" name="36000CE" exchange="">
<mapping symbol="BANKNIFTY30SEP2136000PE" name="36000PE" exchange="">
<ncdexdirect>
<currency>
<directlist type="COMMODITY" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="ALUMINIUM-1">
<symbol name="CRUDEOIL-1">
<symbol name="GOLD-1">
<symbol name="LEAD-1">
<symbol name="NATURALGAS-1">
<symbol name="NICKEL-1">
<symbol name="SILVER-1">
<symbol name="ZINC-1">
<directlist type="FNO" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="BANKNIFTY">
<symbol name="BANKNIFTY-1">
<symbol name="NIFTY-1">
<directlist type="CD" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="EURINR-1">
<symbol name="GBPINR-1">
<symbol name="JPYINR-1">
<symbol name="EURUSD-1">
<symbol name="USDJPY-1">
<symbol name="USDINR-1">
<directlist type="WO" active="Watch-1">
<directwatch name="Watch-1">
<symbol name="BANKNIFTY30SEP2136000CE">
<symbol name="BANKNIFTY30SEP2136000PE">
My Question :
How do I import above XML File to Datagridview ?
And also I would like to know, how do I edit the content of any child node text and re-update it to XML for all lines?
Example :
With this reference, I need to modify the text content for the following node
<symbolmapping>
<mapping symbol="BANKNIFTY30SEP2136000CE" name="36000CE" exchange="">
<mapping symbol="BANKNIFTY30SEP2136000PE" name="36000PE" exchange="">
I need to search 30SEP21 and replace 01OCT21 it to all lines. Please suggest me how d I do this as I am new to this.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
