.NET 2008 MYSQL DUMP Dynamic Path?
Feb 15, 2012
I have this code which saves the dump file in a static path or destination Process.Start("C:xamppmysql inmysqldump.exe", "-u root ipoint -r C:Backupipoint.sql") MsgBox("Backup Database Created")
I want to choose the path by using the folder browser dialog which will put the path on a textbox but this code below doesn't work Dim path2 As String = tb_path.Text Process.Start("C:xamppmysqlinmysqldump.exe", "-u root ipoint -r '" & path2 & "'ipoint.sql") MsgBox("Backup Database Created")
View 2 Replies
ADVERTISEMENT
Jan 23, 2012
I use this code to create dump files of my database. Now what I want, if possible, is to encrypt it so that when it is viewed in notepad or anything similar, average users cannot read it.
Call isDirectoryExist()
Call createDbBackupName()
Dim myProcess As Process = New Process
Dim strUser As String = "superadmin"
[Code] .....
Of course, if it encrypted, it has to be decrypted before querying the dump file. I have no idea what encryption I can do in vb.net and mysql
I modified my first code
Process.Start("C:/MySQL/bin/mysqldump.exe", " --host=localhost --user='" & strUser & "' --password=1234 """ & strDbName & """ -r """ & strPath & newDBName & """, --cipher /e /a '" & newDBName & "' ")
But the output file contains nothing whatsoever.
View 1 Replies
Sep 24, 2009
I am able to browse to a file and save its path in a textbox, but the slashes from path are removed when saved to the database.
C:Program FilesApplicationDocStudio.bmp
becomes
C:Program FilesApplicationDocStudio.bmp
Public Class FormSettings
Dim Result As String
[Code] .....
View 2 Replies
Jan 12, 2012
I am trying to view all the properties of this:
Dim IISOBJ = GetObject("IIS://LocalHost/W3SVC/1")
For the life of me I can't figure out how to display all the property names of this object.
View 5 Replies
Jun 1, 2011
I have a VB.NET 2008 program that crashes about once a month at a customer location. My log file does not include any clues of the crash, the program just dies with the infamous SEND / DONT SEND window.So I need to setup my customers so that in the event of a program crash, a DUMP file is created automatically, without any user intervention. Everything I read on internet indicates that the drwtsn32.exe program does that.
View 3 Replies
Jul 28, 2011
I ahave a excell sheet. for trying the code i set the path like
objWrkBk = GetObject("C:ABC.XLS")
Now i want that when i publish the project include this XLS file.
I copy the file in resources folder and give path as
objWrkBk = GetObject("/Resources/abc.XLS")
But exception occur.
Where i include the file which becomes the part of the application?
View 5 Replies
Jul 25, 2011
I am trying to get the path for my page and I succeed to get it using an HTML image tag:
<img src="images/slider/<%# Eval("BannerImage") %>.jpg" alt="" />
Is there a way to make it dynamic using the asp:Image tag?
I tried to make it like this:
<asp:Image ID="Image1" runat="server" ImageUrl="~/Classified/Images/Slider/'<%# Eval("BannerImage") %>'.jpg" />
And I got an error:
The server tag is not well formed.
View 1 Replies
Feb 15, 2012
I have created a project which takes the database dyanamically....
Means when the application starts it will ask for the database path....the database will already be created in some or the other folder....
The path for database is stored in one text file....
It is an access database....
While creating crystal report I had created the report using the database....but that became static...and the report is not able to fetch the records since it is not getting the database
Now I want that while the application runs....a connection should be set up to the dyanamic database path and the report should be viewed....
how shud I create the database connection for crystal report in vb.net
View 2 Replies
May 6, 2010
I have a dynamic path and every time I want to check it and if it is the root of drive warn user, so I am doing this:
Code:
If MyPath = Directory.GetDirectoryRoot(MyPath) Then
'Warn user
End if
MyPath is returned from a control like FolderBrowseDialog so I'm sure it cannot be an invalid path...
View 4 Replies
Mar 29, 2010
i have a problem in inserting the listbox value into mysql database in vb 2008 i.e
if i select a video file i.e D:videosvideo1.mpg and add a msgbox() event before inserting into data base it shows the exact path i.e D:videosvideo1.mpg but when i check my database it shows me as D:videosvideo1.mpg how can i solve that
View 2 Replies
Jan 15, 2012
I'm doing an app that adds info to a MySQL BD
Imports MySql.Data.MySqlClient
Public Class curso_add
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
OpenFileDialog1.Filter = "Ficheiros de Imagem |*.jpg;*.bmp;*.png;*.gif"
[code]....
but in the image path doesn't appear the slashes [URL]
View 9 Replies
Jun 11, 2011
I'am using vb.net and MySQL as database. How do I save the image path to mysql database. So later when the customer list form when I select a customer and so appear on the customer edit form automatically direct the picture appears too
View 1 Replies
Dec 9, 2009
iam using the following code to store a path to databasetrPhotograph = "photo" & strPotoName & ".jpg"but its getting saved as "Photo6.jpg"The "" symbol is not getting saved
View 5 Replies
Jun 12, 2011
code on storing path image and retrieve path into image using mysql database and vb.net/vs 2008. I only know how to make a browse button and get the image into hard disk and display it in picturebox. I'm done with the the problem is how to store the path and retrieve the path into image.
View 1 Replies
May 24, 2010
I need to represent the following query using LINQ:
DECLARE @PurchasedInventoryItemID Int = 2
DECLARE @PurchasedInventorySectionID Int = 0
DECLARE @PurchasedInventoryItem_PurchasingCategoryID Int = 3
DECLARE @PurchasedInventorySection_PurchasingCategoryID Int = 0
[code]....
Now, I know that a query in .NET doesnt look like this, this is my test in the SQL Design Studio. Naturally VB.NET variables will be used in place of the SQL local variables.My problem is this: All of the conditions after "WHERE" are optional. In that a query might be made that uses one, some, all, or none of the conditions. V.PropertyID and V.Value can also appear any number of times.In VB.NET I can make this query easy enough by simply concatenating strings, and using a loop to append the "V.PropertyID/V.Value" conditions.I can also make a Stored Procedure in MS SQL, which is easy enough.However, I want to accomplish this using LINQ.
View 2 Replies
Feb 19, 2010
Ive managed to dynamically create a form, and dynamically create a timer, but i have not been able to create the timer on the dynamic form. Specifically, i need to be able to have the timer itself create another form with a timer. (I realize that this would create a new form every interval on the timer, that is what i want to do)
1. A way to add the timer to the dynamic form, and maintain the timer sub on my main form.
2. A way to create the whole thing over (dynamic form and timer) through the previous dynamic form and timer.
I was thinking i could use a collection/array to store the forms and timers, but i'm still having trouble figuring out how to add entire forms or timers into a list. (A timer is not considered a control, so i cant use a controlcollection...)
Heres my code;
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim frm As New Form
[Code]....
*EDIT* Btw, my idea was to use i as a variable that increases every time a form is created, then insert the form into the array, with i as the integer. i just need to know how to create a new form with a different name each time. (as with timers)
View 1 Replies
May 15, 2009
I am using this code below:
[Code]...
I thought the %AppData% should find the relative path. When I go 'Start|Run|%AppData% windows explorer takes me to that directory. I can not put the full path in, as the user is different on each client machine.
View 2 Replies
Sep 17, 2009
I've been using some memory profilers to try and track down a memory leak - but am swamped with posibilities.
Am wondering if anyone has a function to dump all memory allocations that are present as a form closes/disposes.
View 1 Replies
Nov 8, 2010
This current project involves dumping parts of WinAD objects into a db to search from.I am trying to make this go a bit faster. there could be 10s of thousands of records to create.So i figured threads would do the job.I have tried straight of creating new threads for each db insert. that does not work for long, after 1700 threads it crashes.
t = New Thread(DirectCast(Sub() MySQLLib.group(dmn1, grpn1, grpd1), ThreadStart))
t.Start()
[code].....
View 2 Replies
Feb 1, 2011
Is there a way in .NET (VB.NET or C#), when an exception happens, to dump the stacktrace of each thread? Basically I would like to reproduce what happens in Visual Studio's Debug->Threads window to see what each thread was doing when the exception happened
View 2 Replies
Jan 20, 2012
I use this code to create dump files of my database.Now what I want, if possible, is to encrypt it so that when it is viewed in notepad or anything similar, average users cannot read it.
Code
Call isDirectoryExist()
Call createDbBackupName()
Dim myProcess As Process = New Process
Dim strUser As String = "superadmin"
[Code]...
View 3 Replies
Jul 16, 2009
I know it sounds an odd request, but in order for others to gain access to an executable's VB.Net source code long after I have left the project I wanted to add something that could output the source code to notepad. This would be triggered by calling the exe with a numbner of parameters passed, like a pass phrase.I know how to pass the parameters and can call a proc based on what is passed, but I don't know if it's possible within that proc to dump the entire program's source code to notepad.
View 3 Replies
Jun 1, 2011
How to search a dump.bin for a pattern then take the point it is at, i.e. 8DB358 and search that string? urls...
View 2 Replies
Feb 4, 2009
I have a third party GIS tool that I'm using to view maps with. Occasionally we have to take a snapshot of a portion of the map and dump it to a bitmap. The third party tool has a function that will give me the upper left and lower right coordinates of the area selected on the map. These coordinates come out as system.drawing.point objects.
The two point objects are then used to generate a new system.drawing.size object that will give the height and width of the area selected. The height and width values are passed to the constructor for the system.drawing.bitmap.All this works fine most of the time. Sometimes, however, when the user selects a particularly large area, the bitmap constructor bombs with a 'parameter is not valid' error. There isn't any documentation on this error, but I'm assuming it means the height and width are too big.
So what I'm wondering is... is there some way to check my height and width values prior to creating the bitmap and make sure they are in acceptable bounds?
View 5 Replies
Jul 28, 2011
I am getting data from my database and I want to have that data as a table in excel file.
So, I have written the following :
[Code]...
View 4 Replies
Jul 5, 2010
In Windows 7 if I launch Task Manager and select a process (eg:Notepad.exe) I can right click on this and select "Create Dump File".
This creates a dump of the file to my hard drive.I would like to do this programmatically.
View 5 Replies
Jul 12, 2010
how can i dump a small html code in a variable? do i need to take array ?i need to write below line to a file "as is"
$a = "<style>"
$a = $a + "BODY{background-color:skyblue;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:thistle}"
[code]....
how can i make VB turn off recognition of it's operative characters like $,<,>,= etc. which appears on above code but i need to dump it "as it is" in a file during runtime.
View 12 Replies
Aug 22, 2006
I have a Access program and I'm using VBA code in the background to run Winunzip using shell command. Well, the path of the .zip file has spaces in it and it's not recongizing the path as a valid path. Is there a another way to tackle this problem besides the shell?I can't us pkzip either. Has you can see I had to use progra~1 instead of Program Files.[code]
View 2 Replies
May 17, 2009
I am trying to create a Random Number Generator (dice roller) that will dump its results into an open chat window. I was lead towards using DDE but have never used it before. Is this the best method? if not, What is?
View 1 Replies
May 8, 2011
i have created a dynamic tabpage and a dynamic tablelayoutpanel inside it then added dynamic textboxes and labels inside the tablelayoutpanel...the thing is , i am having a problem on how to access the value of those textboxes and labels and add them as new columns in the new table(tagpage) in mysql database, i can already create the table in the database but i cant add the new columns in it. heres the code for accessing the values of the labels and textboxes
error: NullReferenceException was unhandled....Object variable or With block variable not set.
sql = "alter table " & tbl_selected(counter) & " add " & frmMain.Controls("TLP_" & SecArrList_sp(counter2)).controls.item(SecArrList_sp(counter2) & "label" & counter).Text & " varchar(100) NULL;"
View 2 Replies
