I have three dataviews (dataview1, dataview2, and dataview3). These are of type System.Data.DataView, and all three have the same columns. Is there an easy way to merge them into one, so I have one dataview with rows from dataview1, followed by dataview2, and then dataview3?
View 1 RepliesI am trying to merge multiple datacolumns in a datatable. Eg. The address data is stored in a different columns such as, Housename, street, city and postcode. I want to merge those datacolumns in to one and put it into one datacolumn as "Address".
View 1 RepliesEvery Morning, we are getting multiple PDF files and our Executive needs to see in one PDF files.
Right, now I am diong manually PDF Merge process using Acrobate Profetional. But Now, my client asking to convert this into automated process every morning.
How can we Merge PDF processing using programming language .NET / Java Script and automate this every morning ?.
(My client is not allowing to use any third paty tool for this process.)
I have multiple <body> tags from an word document. I do this with the open xml sdk. So the new document should generated with openxml The body's comes from
WordprocessingDocument.Open("C:TempTest.docx").MainDocumentPart.Document.Body.OuterXml
I have so different body's in a list. With al different values. Changed some text in the xml. And saved them in a new list. Now must that list in an new word document. How can i do that? I tried altChunk. But my word document is always corrupt.
I have a multiple text files that I need to merge. but I need to compare the reference number before merge it.[code]What will be the fastest way to deal it read line by line to compare. the text file consist of thousand of line
View 1 RepliesHere is a sample piece of my code, the problem that I am have is that I can only selected one record at a time to mail merge, regardless if I select 5 rows from the datagrid. Or I can mail merge the entire datagrid, but I want my users to be able to select the data that they want, whethere it is 1 or 5 rows and be able to mail merge based off the selection. I've been pulling my hair out over this, I know it is something simple that I am missing....Please help...I am working in VB.NET visual studio 2008
Private Sub btnMailMerge_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnMailMerge.Click
Dim objWordDoc As Microsoft.Office.Interop.Word.Document
'Dim objWordDoc As New Microsoft.Office.Interop.Word.Application
[code]....
I have a data table a simplified version of which is represented below:
Number | Group | Date | Client | Amount
--------+-------+-------+--------------+--------
1 | 220 | 28/12 | Company A | 0.345
--------+-------+-------+--------------+--------
2 | 220 | 29/12 | Company B | 0.451
--------+-------+-------+--------------+--------
3 | 240 | 26/12 | Company A | 0.510
--------+-------+-------+--------------+--------
4 | 240 | 27/12 | Company A | 0.510
--------+-------+-------+--------------+--------
5 | 220 | 30/12 | Company C | 0.151
etc.
I have a default view which represents the whole table.
But I need also a different view which represents the summary of the same data.
Code | Amount
------+--------
220 | 0.947
------+--------
240 | 1.02
In other words, I need grouped totals.
The question is - is it possible to accomplish by preparing a dataview for the datatable and assign it to the .DefaultView property (I need a user to be able to switch between detailed and summary views). Normally I always prepare views in a database but now I need to do it with DataTable and I simply have no experience of working with DataView class.
First is a windows form application:
vb
Public Class Form1
Dim ds As New DataSet
[Code]....
Now is there a way to merge this into one application? So that the second application doesnt have to have a file as the output, but that the output, (the decoded file) can be stored in local memory or something and be read by first program?
In VB6 I load a recordset containg all of the records (6 fields per record)in a table into an XArray and then manipulate the records in the array and then write them back to the original table. The array issorted by the first field (1 to maybe 8000 or more) I need to find records in the array by an ID field and then move them (because of some external criteria that happens many times) from say number 400 to number 375. Then all of the other records between 375 and 399 were renumbered up 1 to fill the gaps left by the move.
The XArray worked well as it could find and also move to a next record easily to facilitate the revisions to each record quickly. Everything is done in VB6 in code and nothing visual needs to be shown to the user until say 2000 of these external changes are complete. What is the best, most efficient way to do this in the .Net framework in VB2010. Datasets, Dataviews. tableadapters, arrays. enums ?
I'm trying to copy multiple excel source files into one excel file. My current code is working only for 3 source files..If more than 3 files are there, it doesn't copy the data but creates blank work sheet in the output excel file. Lets say I have a source folder with 5 excel files. Each workbook contains one worksheet with data. It copies upto 3 worksheets along with data into output excel file.
Lets say excel1 contains A as work sheet, excel2 contains B as work sheet ,excel3 contains C as work sheet ,excel4 contains D as work sheet ,excel5 contains E as work sheet .Now my output excel file should look like..OutputExcel with A, B, C, D, E along with respective data.But my current code is giving output as A,B,C worksheets along with respective data but its creating blank sheet1,sheet2 in place of D & E.
SSIS Script Task Vb.Net Code:
Public
Sub Main()
Dim filePath
As
String =
[code].....
I've been using the VBE for about 10 years now, but when I started using VBE under Excel 2007 I can't seem to find a way to display two windows at the same time. If I have two workbooks open and I want to compare macros from each workbook or maybe to copy a macro from one workbook to another, I can never seem to be able to view contents from both modules. What must I do to turn on multiple module viewing?
View 1 Replieshow do you close a program if it has multiple forms? Me.close doesn't seem to be
working...
I'm not great with VB and I'm having some trouble with my University assignment at the moment.I'm trying to code a multiple choice program with several forms with different questions and then a scoring form
I'm not sure how to tell VB what the correct answer should be and how to display the scores in another form, the answers need to show how many correct in each section out of how many the user attemped to answer, so they can check scores before completing all the questions.
I want to learn the code to load multiple accounts in to the program in the format "username:password" and have them auto sign in.
View 3 RepliesI would like to loop over two string arrays but does not work.[code]...
View 4 RepliesIs there any way that I can tell if a second version of the same program is opened by the user.
View 5 RepliesHow would I output a sentence with VB.NET?
Example: Your program and Internet Explorer are open, your program outputs [URL] and presses "{ENTER}", and it will go to the page.
Example: An auto-talking bot for MSN.
I have written a program for cleaning my pc. I want to be able to start the Form1 (which opens the entire program) from the start menu. And I would like to run Form2 (which runs just the scan) from the context menu of the recycle bin. How can I open Form1 from one shortcut and Form2 from another?
View 1 RepliesIs it possible to create a multiple line string in vb.net?
View 7 RepliesI've tried hiding one tabpage in the form and it was somehow successful. However, it was not the one i'm planning to do with my program. I don't know if there exists any code that could make the tabpages(two actually) automatically hide when the form loads and would only be visible after some passing some conditions.
View 1 RepliesI have built and deployed an application in VB2008. If I start the program from the start menu a new session will start and there 'll be multiple sessions of the same programming running. I dont want this behaviour! I want the program to start only when no other session of the same program is running. How can I do that in VB2008?
View 9 RepliesSo I have been working on this small project for a little while now Basically I need this program to be able to delete a single folder or multiple folder depending on the text in the textbox.So far, I can do the single file just fine, this is the code for that.[code]Simple as it sounds...I haven't figured it out...then again I am pretty new to VB, being I started programming in it literally 2 weeks ago.I am guessing that I have to set a variable for the textbox...which leads me to believe I need to use something other than a textbox to do this...I was thinking of using a DataGridView...I not sure how I would make it check if there is anything in a cell then delete it if there is.
View 13 RepliesI have a 4 table database and need to query at least 2 tables (the single table query works fine). The output goes in textboxes / labels on an existing form.
I'm trying something like this:
Private
Sub AddCustomer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I tried to do this like i would in C#, with an anonymous type but the result is just not correct.[code]...
View 1 RepliesHow can i use Multiple winsocks to let my program communicate over a network? if i use more than one. only one of them works?
View 7 RepliesWe currently have some big projects coming up which we will be creating in visual studio using vb.net There will need to be most likely three developers working on different parts of a particular project at any one time.I was just wondering if there is any sort of platform we can use so this is possible as currently each person is using a different copy of the work and then we are transferring this over onto a master copy.
View 5 Repliesi am making mp3 player. i didn't wanted to use open buttons so i've associated my app with .mp3 filetype (with If (My.Application.CommandLineArgs.Count > 0) Then...)
The problem is when i want to play next song while the first one is playing it opens my program again so it plays 2 songs at the same time.
I want to do is when im opening new mp3 make it shut down the old one
I guess there is more methods that open in same app but just change the url.
I have a program that works when, a file is opened with it using the right click menu in explorer. But if I select multiple files and then right click and open with my program then it opens multiple instances of my program, instead of just passing the multiple files as arguments to a single instance. The program is written in vb.net but is not a windows form, it is just a module, so I can to tick the Single instance option in the properties in Visual Studio.So how do I open multiple files from explorer context menu in a single instance.
View 2 Repliesi need to create multiple threads to improve a function on my program. it is a simple thing really but it's slow and if multithreaded it can improve the speed some thousand times. my program uses a dll to check the MX record of an e-mail from a textbox called emails if the mx record is correct then it validates that domain, if not, it sends to an error textbox with that mail my problem is that im reading a lot on multithreading and i dont have an idea how to make something like this: for x=0 to emails.lines.count -1' start a thread that runs my function next if i can limit the number of threads to avoid crashing it would be good.
View 5 Replieshow would I go about making the user access different local SQL databases. As in they use a GUI program to access / read / write data in a database but can also use that same GUI program to do the same to multiple database files.Is that sort of setup easy to integrate into a VB program? or does a VB program by nature only try to access one database? To integrate the open and close dialogs into a VB GUI in terms of different database files, is there much involved?
View 10 Replies