what is the best approach in VB.NET to get the entire table from the Ms SQL 2008 R2 database and save it in the program (dynamic?) array or something which is easy to translate into bytes and send to other device via socket communication?
View 1 RepliesI want to know how to connect to a remote system having some shared folder.(ex, \myservermysharedfolder).Actually, I was supposed to copy a particular file which is available in a shared location of a system. To copy that file, first i need to connect to that system with an user id and password.I know copying of file (), But not getting clear idea on how to connect to the shared folder. I have tried with System.Management class, but no use..
View 2 RepliesI am having a remote server it has INVENTORY DATABSE , and also iam having same databse in my local system. I want to populate by local database table with my Remote database table through Vb.net code by click a button. How to do this .
View 1 RepliesI am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 RepliesI have 2 tables that are related,both have identity columns for primary keys and i am using a vb form to insert data into them,My problem is that i cannot get the child table to get the primary key of the parent table and use this as its foreign key in my database.the data is inserted fine though no foreign key constraint is made.I am wondering if a trigger will do it and if so how. All my inserting of data is done in vb.The user wont insert any keys. all these are identity columns that are auto generated. If a trigger is my way out please illustrate with an example.
View 2 RepliesI want to know how can I possibly copy a table with multiple columns and rows into an Array or Collection in VB.NET.I want to know the best solution because I want to use the code for 2 different tables and do some comparisons, and the second table has too many records.I was wondering if in VB.NET there is something similar to Hashmap used in java and a table could look like the following
View 1 RepliesI am working on a desktop application in VB.Net (4.0) There will a lot of SQL scripts which contains a lot of insert queries Currenlty we are running the scripts using SMO (http://msdn.microsoft.com/en-us/library/ms162557.aspx)For performance, we have planned to change the sql scripts to xml file ( instead of insert queries, it will have xml data with a proper xsd defined )Loads xml to dataSet and Using SQL Bulk Copy we are trying to insert to SQL Server.
[Code]...
I want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
I've created a Class Library with a Class named Class1 with this source:
Public Class Class1<br/>
Public Function Hello(ByVal name As String) As String<br/>
Return String.Format("Hello, {0}!", name)<br/>
[code].....
I have a VB.NET project which references a dll of another program. dll file location is something like "C:Program FilesAppNameAppName.dll" and on my project's references tab the dll's path shows this. When the copy local property is true, everythings works fine. When it is false, I get a runtime error saying dll cannot be found. The other program is a restricted access application and I can not distribute the dll with my project. How can I force my project to look for dll under "C:ProgramFilesAppName"? I didn't have this issue with VB6.0.
View 8 RepliesHow do I copy a table to another table without overwriting the contents of the second table?
View 2 RepliesI moved my web application to a server and im getting this error below, but on my localhost it works great. Im finding that the error has to have something to do with the dataset not pulling back any data, when I do a for each statement. But the weird thing is that I do a for each statement on another page and it works fine. Here is my for each statement, that im assuming doesnt work. The reason im assuming it b/c when i test it on local it works fine:
Dim retObj As New ClassLibrary1.sql_class
For Each row As DataRow In retObj.sel_all_email_list(company).tables(0).rows
email += row("EMAIL_ADDRESS") & "/"
Next
[code]....
Error:Exception Details: System.IndexOutOfRangeException: Cannot find table 0.
When i copy a table into DataSet is it possible to copy its index's as well? right now i add kinda big table (250k + rows) into dataset and i need to query that DataSet table in my application, the problem is that in some quires it's getting slow.what is the right approch to solve this problem?
View 6 RepliesI have a web url for the image. per example [URL]. I want copy that url in my local folder in "c:images" and also when I copy that file into folde I have rename the image to "c:imagesxyz.jpg".
View 3 RepliesI have a text file on a website that I have the direct URL address to. For example, http://www.example.com/thisFile.txt .
I would like to copy it to a predefined path on the local machine. For example, C:Documents and SettingsAll Users .
What can I use to copy the file from the URL to the predefined path on the local machine. A simple CopyFile doesn't seem to handle URL addresses.
I want to copy a file from a UNC path (ex: \comnamedirnamefilename.txt) to a local destination (c:outputdir)
I have no compile errors, but when I run it, it throws an exception (System.IO.DirectoryNotFoundException). I'm absolutely sure the destination existst (it's referencing the destination directory). I've tried doing it with system.io.file.copy(source,dest)and my.computer.filesystem.copyfile(source,dest). Same result either way.
Is there a way to default the Copy Local property of references that I add to my projects? I figure there has to be some sort of method since adding a reference to a VB componentdefaults to False. (for example, start a project as a class library and then adda reference to System.Windows.Forms, it will default Copy Local False.) Is that somethingin the DLL's settings or configuration that I could replicate in my DLLs to force that
View 14 RepliesI have an array of people stored in a custom structure array... how can i copy this array to a temp array so that the temp array has all the same values as the original custom array?
View 4 RepliesI have a database with one table.I'd like to populate an array with the values in the table so that I can work with the data.How do I copy the data from the table to the array?I am able to view the data with a DataGridView but can't find any info on extracting the data to an array or variable.
View 2 RepliesWe have an app that tracks .DOC and .PDF files (and possibly other file extensions). It stores copies of them on a network share. I want to give the ability to the user to allow them to click the file in a listview, for example, and have that file open in WORD or ADOBE or whatever program is associated with that file type.
[Code]...
When I use:
File.Copy(strRemoteFolder, strLocalFolder)
I get an UnauthorizedAccessException with the following message: "Access to the path ... is denied."In .NET, how do I copy a file from a remote computer that requires authentication to my local machine? I understand that I'm going to need to supply a username and password in some fashion, but I don't know how to supply that information via an API in .NET.
I have a program that must copy a file to 3 locations, the local hard disk, a USB drive, and a network location. I have the file (about 70mb) loaded into a byte array. My quesion is, since I'm not actively modifying the byte array, can I impliment a form of multithreading where all 3 threads read the same byte array at the same time?
View 1 RepliesI am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied.And a progressbar needs to display the entire progress.Here is the code what I have now:
[Code]...
I'm creating a WPF application in VB.NET with the 3.5 Framework. (If you provide an example in C#, that's perfectly fine.)
In my project I have a Template for an MS Access database. My desired behavior is that when the users clicks File-->New, they can create a new copy of this template, give it a filename, and save it to their local directory.
The database already has the tables and some starting data needed to interface with my application (a user-friendly data editor)
I'm thinking the approach is to include this "template.accdb" file as a resource in the project, and write it to a file somehow at runtime?
I am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied. And a progressbar needs to display the entire progress. Here is the code what I have now:
Private Sub StartScreen1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dt As New DataTable()
[Code].....
i need to copy all the rows with data from a existing table to other existing table through button click
View 13 RepliesHow can I search the local disk for a file type and copy the full path to a new location. I am trying to write a backup program that will copy all pst files to the server while maitaining the structure, so if there is a pst located in "C:pstuserpersonal1.pst" it would create the folder "\serverpstuserpersonal1.pst" and copy the file to the correct location. I would need it to do this for each pst on the hard drive no matter the location. The user running the program will not have admin rights, so it will need to skip files it cannot access.
View 13 RepliesI've been trying for hours to do this and can't figure it out.. I'm trying to add a new record to a table in my local database.. Heres the SQL code im using at the minute.. I keep getting this error
"The data was truncated while converting from one data type to another. [ Name of function(if known) = ]" on the line
SQLCom.ExecuteNonQuery() Dim SQLCon As New SqlServerCe.SqlCeConnection
Dim SQLCom As New SqlServerCe.SqlCeCommand
[code]....
I'm creating an occasionally connected application with a local (client) .sdf data cache. I added a new table to my server database and want to include this table in my local data cache and synchronization. Is there an easy way to do this?
View 1 RepliesI create a new web service in VS and I create a function that return a value This the code of my function
[Code]...