I'm using VB.NET to open DTS packages and do some verification on their contents. Getting to global variables, tasks, steps and their properties poses no problem. However, datapumps are giving me significant problems. how to create an object of a datapump and get to it's properties (ie source columns and destination columns). If anyone has any suggestions (code samples welcome!) that would be terrific.
View 1 RepliesI've got a form - CMCConsole It pops up a dialog form for adding a new case.If the matter number in a textbox on that dialog form matches an existing cases matter number I would like to find it in the binding source of the CMCConsole form
Private Function CheckMatter(ByVal MtrNum As String) As Boolean
Dim cfIndex As Integer = CMCConsole.caseBS.Find("MatterNumber", MtrNum)
Dim cfIndex2 As Integer = CMCConsole.casefileBS.Find("MatterNumber", MtrNum)
[code]....
But it appear the filter for the CASE we were just on that is set on the binding source is keeping the FIND from seeing other cases.
caseBS.Filter = "CaseId=" & e.Node.Tag.ToString
Do I have to clear the filter in order to find a matter number in some other case??
I want to filter 2 columns in binding source o
1.- sucursal by watever is in textsucursal
2.- tipo has more then 7 valuyes..but i want to filter by only 4 the ones shown in query..[code]
I re-wrote this to make it more readable. If you want to skip right to the chase, look at the ALL CAPS comments in the code blocks. All necessary code has been included for debugging. I've searched multiple forums (including ASP.NET), and the MSDN library and cannot fix this >.<
[Code]....
I use Visual Studio 2010 and SQL Server 2008 R2. I have created an Entity Model in a class library which I have referenced in a VB Winforms project. I created a data source in the project based on the entity model in the dll. However, all columns in the data source are listed in alphabetical order instead of the native order from the SQL Server database. I cannot locate the cause of this as much as I try.
This might not seem a huge problem, but it is costing me valuable time in rearranging controls dragged to forms and reindexing their tabstop indexes.
GridView SORTING of DYNAMIC Columns and Data Source Scope
View 2 Repliesthis code using an OLEDB source will populate the OutputColumnCollectionbelow it, the code using a flatfile source will not populate the OutputColumnCollection.
Why not?
Microsoft.SqlServer.Dts.Runtime.Application a = new Microsoft.SqlServer.Dts.Runtime.Application();
[code]......
I've been working on my A2 Computing project for the past few months - and was working on one form.My computer crashed (for some unknown reason) and subsequently the form no longer works.
I can open up the designer for it, and see all the declarations - but I can't open the source code.[code]...
I have a bindingsource that is connected to a table where tho fields determine uniqueness. During a refresh I would like to return to the row that the user was on when he clicked the refresh button. BindingSource.find only supports one column in so far as i have been able to infer. So how doi do it. Altering the table is out of the question. Besides searching on multiple fields is a common event. Like for example first and lastname or perhaps company and journal number.
View 15 RepliesI am working on a task in which I have to download all flash objects swf and flv files running in web page. I have got no clue to find he source of .swf file, as mostly swf files comes from other servers. I want to find out some way to find the source / url of .swf currently running. Kindly suggest me some way.
I have 2 ideas in mind, but currently unsuccessful in implementing them
1. Using WebBrowser class and somehow find url of swf.
2. Using Pcap to fetch all http packets and after decoding, some how try to find url coming.
I am trying to replace the vb source code in our application by using a streamreader and a loop.
the reason for this is, we've upgraded to a later version of 3rd party grid controls and the properties of the controls changed, so we have to change the code 13 XXX times.[code]...
i got a web browser the code was:
[Code]...
does anyone know where i could find the source code for dial a fix
View 7 RepliesI cannot find a class library source codes where I can create the sliverlight player so I could input them in the program.
View 4 RepliesLast month (i think) i needed help with regex which i used to find MP3 urls in the source code of a site.Now the code doesn't function properly
[Code]...
Can you find your source code about plagiarism detector by Using the language of Visual Basic 6
View 1 RepliesI'm building a vb project using vb 2008 and I am trying to get a specific data from the source of a webpage. I am now trying to have the vb project access the below source of the webpage [URL] and retrieve the word "Dublin" from the code from the following line:
</tr><tr><td class="s7 li ou"><a href="dorf1.php?newdid=106467">Dublin</a></td>
The word "Dublin" should be stored in the string villagename1 (I will use that string several times later in the project) and it should at NO time open a IE page as to make it as invisible as possible.
Webpage Source:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "[URL]">
<html><head> <title>Travian uk5</title>
<meta http-equiv="cache-control" content="max-age=0" />
<meta http-equiv="pragma" content="no-cache" />
[Code] .....
i want to compare the two data table columns and find duplicates for example
dataTable1
autoid ponbr polinenbr quantity
1 0001 10 5
2 0002 12 6
[code]....
in the above two dataTable i would like to compare the ponbr and polinenbr column and find the duplicates and get the autoid..
I'm beginner programmer in the amazing world named ".Net".I've a lot of questions
well, what I should learn C# or Vb.net What's the best blogs which talk about .Net technology and Open source projects Where can I find good tutorials, free books and ideas of projects how can I progress in ".Net" please, share your knowledge , your OPML of your favorite blogs or web sites about ".Net "
I am looking for the standard source code for a keyboard. Is there any where that I can download this source code so that I can modify it for my own use?
View 2 RepliesI am trying to add two features to my webbrowser: View Source and Find. Does anyone know how to get the webpages source code and a method to perform a search in the webpage? I was thinking one might lead to the other.
View 1 RepliesI am making an sql search engine. I need it to find a row of data take some of the columns and paste it to some labels or textboxes.Need some help with the code got my connection, command, I am thinking on how to split the notes and the username onto two different controls or should I get two different sql statements for them ?
Private Sub btnFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFind.Click
Dim con As New SqlConnection
Dim cmd As SqlCommand = New SqlCommand("select owner, notes from orders where orderref = '" + txtReference.Text + "'", con)
[code]....
I am using datagridview to show the data when the form load.Datagridview have a template checkbox column also where the user will select the class to attend.I want to loop the datagrid and find the selected row ro columns value when the user click the save button How i do this am using vb.net 2008?
View 8 RepliesI have a VB.Net app which scans the Outlook Inbox for specific emails with specific subject lines and adds the details to a listview. One of my beta testers received this error yesterday:
|+--JDMils|+--VB6 & XL VBA+--VB Dot Net 2K8|
I am trying to program a noise reduction algorithm that works with a set of datapoints in a VB.NET DataTable after being helped with my other question. Basically, I want to take two integers, a coordinate value (yCoord for example) and a threshold smoothing value (NoiseThresh), and take the average of the values in the range of (yCoord - NoiseThresh, yCoord + NoiseThresh) and store that number into an array. I'd repeat that process for each column (in this example) and end up with a one-dimensional array of average values. My questions are:
1) Did anything I just say make any sense ;), and
2) Can anyone help me with the code? I've got very little experience working with databases.
[Code]...
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
Imagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?