Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
T

Tyquaun Hunter

@Tyquaun Hunter
About
Posts
21
Topics
0
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • creating a folder on a remote server via VB.Net Web Application
    T Tyquaun Hunter

    Use the ftp protocol it should be some where under the system.web namespace in 1.1 if 2.0 use system.net

    Visual Basic csharp sysadmin tutorial

  • HowTo copy a folder with its contents to a target folder?
    T Tyquaun Hunter

    Hey sorry it took so long to get back to you, but i have been busy. Here you go. This will copy directories recursively. Just replace the CopyEntireDirectory method I gave you with this: Public Shared Sub CopyEntireDirectory(ByVal SourceDir As String, ByVal DestinationDir As String) 'Create Directory Directory.CreateDirectory(DestinationDir) 'Declare a variable to recieve file name Dim FileName As String 'Iterate through source directory For Each FileName In Directory.GetFiles(SourceDir) 'Copy file with each iteration as long as the file does not exist If File.Exists(DestinationDir & GetFileName(FileName)) = False Then File.Copy(FileName, DestinationDir & GetFileName(FileName)) End If Next 'Create directory recursively Dim SubDirectory As String For Each SubDirectory In Directory.GetDirectories(SourceDir) If Not Directory.Exists(DestinationDir & GetFileName(SubDirectory)) Then CopyEntireDirectory(SubDirectory, DestinationDir & "\" & GetFileName(SubDirectory) & "\") End If Next End Sub Tyquaun Hunter

    Visual Basic help question

  • How To Replicate Data Between Two Databases
    T Tyquaun Hunter

    Cool. Keep me updated.

    Visual Basic database tutorial csharp design

  • Clearing Session variables??
    T Tyquaun Hunter

    try this Session.Contents.Remove()

    Visual Basic help question

  • ComboBox MouseMove
    T Tyquaun Hunter

    vb or vb.net?

    Visual Basic question

  • Databases [modified]
    T Tyquaun Hunter

    what database exactly?

    Visual Basic database help question

  • Find Function? [modified]
    T Tyquaun Hunter

    Try using regular expression. Once your value has been found exit the loop. Here is an article in MSDN http://support.microsoft.com/default.aspx?scid=kb;en-us;818802[^] -- modified at 15:27 Monday 31st July, 2006

    Visual Basic question help tutorial

  • Find Function? [modified]
    T Tyquaun Hunter

    Try exit sub Tyquaun

    Visual Basic question help tutorial

  • Ms Access
    T Tyquaun Hunter

    I am certainly not going to damper your spirits and tell you not to strive for what you want. Look under the system.data namespace in MSDN library. This is the namespace where you can do all kinds of data manipulations using databases. There is something called an oledb provider. There for it should be system.data.oledb This is the only way you can access the Microsoft access database engine. You can use something like this 'OleDbConnection object used for connecting to a database Private _ConnectionObj As New OleDbConnection() 'OleDbCommand object used for executing a command Private _Command As OleDbCommand _connectionObj.ConnectionString = [Shared].ConnectionString _ConnectionObj.Open() _Command = New OleDbCommand("Select * From Registrants", _ConnectionObj) Where you see [Shared].ConnectionString, this is the string you should pass in Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Visual Studio Projects\AnnualMeetingRegistration\Database\Registrants.mdb;User Id=admin;Password=; Normally, you would want to store you connection string in the app.config file, but don't do that right now. Just use the string example I showed you. As you get more experienced, you will find better methodologies of programming. Then you open the connection object and pass the connection object to the command object. After, you have finished close the connection object. If you decide to use a data reader you will have to close that as well. Here is an excellent website for connection strings. http://www.connectionstrings.com/[^] I hope this helps, Tyquaun

    Visual Basic question csharp help

  • Bind a data set in an HTML table
    T Tyquaun Hunter

    Yes, but you have to construct the datagrid yourself and not use the control that visual studio provides for you. Also, which probably makes more sense, is if you use a datareader and build the table yourself. This is much more efficient than a datagrid. Tyquaun

    Visual Basic question html help

  • How To Replicate Data Between Two Databases
    T Tyquaun Hunter

    Ian, I hope I am not too late. However, this is what I think. Maybe you should use the triggers as I suggested before. Also, for the databases that not SQL server. Create a windows service that will call a webservice and from there you can sync the data. Tyquaun

    Visual Basic database tutorial csharp design

  • vb
    T Tyquaun Hunter

    One way is create a main menu or a context menu and specify which shortcut keys should be used. Also, the obvious route would be to create an object that captures keypress events to launch the form you want. -- modified at 11:29 Friday 28th July, 2006 Tyquaun

    Visual Basic tutorial question

  • Clearing Session variables??
    T Tyquaun Hunter

    You can just set it to nothing.

    Visual Basic help question

  • How To Replicate Data Between Two Databases
    T Tyquaun Hunter

    What other database is the ERP using?

    Visual Basic database tutorial csharp design

  • HowTo copy a folder with its contents to a target folder?
    T Tyquaun Hunter

    Yes. Get the name of each sub-folder and copy it over. If you are going to get nested folders(a sub-folder of a sub-folder) than it is going to get pretty complicated. Is that something you want to do?

    Visual Basic help question

  • Bind a data set in an HTML table
    T Tyquaun Hunter

    Why would you want bind to an HTML table and not a datagrid?

    Visual Basic question html help

  • How To Replicate Data Between Two Databases
    T Tyquaun Hunter

    If I am understanding you correctly, then you should just use a triggers on the ERP server and perform inserts, updates, and deletes accross databases. You can do something like the following: INSERT INTO DatabaseName.[owner].TableName (CompanyName, Phone) VALUES ('Snowflake Shipping', '(503)555-7233') - Where database name is, use your database name - Where owner name is, use the owner name of your database. The default is dbo - Where TableName is, use the table name on your database where you want to insert. If I am correct in my assumption, then this solves your problem of processing data across databases easily. However, The biggest problem you are going to run into is associating the records that are in the ERP database with your database. For that purpose, you should have ids that are in your database that corresponds to the ERP database. That way you can perform updates and deletes. If associating records through ids becomes a hassle, then you should probably use replication. Tyquaun -- modified at 23:55 Thursday 27th July, 2006

    Visual Basic database tutorial csharp design

  • calculating the size of all the files present in a folder
    T Tyquaun Hunter

    Actually, you are right. However, what I have noticed is when people say VB.net they mean winforms and asp.net, well it is assumed I am talking about ASP.net/VB.net because I am in a VB.net forum. -- modified at 22:44 Thursday 27th July, 2006

    Visual Basic

  • HowTo copy a folder with its contents to a target folder?
    T Tyquaun Hunter

    Try this. It is a two step process. 1. Create your destination directory with the same name as your source directory. 2. Get all of the files in your source directory and copy it over to your newly created destination directory. * Note: You should prompt the user that destination directory already exists and if it does, give them an option to overwrite it. If not, it will overwrite automatically. Also, you should prompt the user that the file exist that you are about to overwrite. I just bypass existing files. You might have to perform some other types of error handling, but fundamentally, everything you need is there. Good Luck Public Shared Sub CopyEntireDirectory(ByVal SourceDir As String, ByVal DestinationDir As String) 'Create Directory Directory.CreateDirectory(DestinationDir) 'Declare a variable to recieve file name Dim FileName As String 'Iterate through source directory For Each FileName In Directory.GetFiles(SourceDir) 'Copy file with each iteration as long as the file does not exist If File.Exists(DestinationDir & GetFileName(FileName)) = False Then File.Copy(FileName, DestinationDir & GetFileName(FileName)) End If Next End Sub Tyquaun -- modified at 22:54 Thursday 27th July, 2006

    Visual Basic help question

  • How to get information about/from controls in another process
    T Tyquaun Hunter

    Have you tried using remoting?

    Visual Basic csharp tutorial question
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups