|
You didn't ask any specific questions, so the best anyone can do if refer you to a couple of articles on the subject:
DTS Custom Task in VB.NET[^] on VBDotNetHeaven
Best Practices for Using DTS ...[^] on MSDN
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 11:08 Tuesday 10th January, 2006
|
|
|
|
|
hi
i m getting following error
"QueryInterface for interface DTS.CustomTask failed"
and
my code is
Dim oPackage As New DTS.Package2
Dim oConnection As DTS.Connection
Dim oStep As DTS.Step2
Dim oTask As DTS.Task
Dim oCustomTask As DTS.BulkInsertTask
Try
oConnection = oPackage.Connections.New("SQLOLEDB")
oStep = oPackage.Steps.New
'oTask = oPackage.Tasks.New("DTSBulkInsertTask")
oTask = oPackage.Tasks.New("DTSExecuteSQLTask")
'DTSExecuteSQLTask'
oCustomTask = oTask.CustomTask
With oConnection
oConnection.Catalog = "cdms"
oConnection.DataSource = "SBS-DEVELOPMENT\SQLCLASSIC"
oConnection.ID = 1
oConnection.UseTrustedConnection = True
oConnection.UserID = "cdms"
oConnection.Password = "cdms"
End With
oPackage.Connections.Add(oConnection)
oConnection = Nothing
With oStep
.Name = "GenericPkgStep"
.ExecuteInMainThread = True
End With
With oCustomTask
.Name = "GenericPkgTask"
.DataFile = "E:\PROJECT ASSIGNED\Projects\CDMS\CDMS_Phase_2\CDMS_Phase_2_Requirements\encounter05\encounter05.mdb"
.ConnectionID = 1
.DestinationTableName = "cdms..tblMemberEncounters"
.FieldTerminator = "|"
.RowTerminator = "\r\n"
End With
oStep.TaskName = oCustomTask.Name
With oPackage
.Steps.Add(oStep)
.Tasks.Add(oTask)
.FailOnError = True
End With
oPackage.Execute()
Catch ex As Exception
Finally
oConnection = Nothing
oCustomTask = Nothing
oTask = Nothing
oStep = Nothing
If Not (oPackage Is Nothing) Then
oPackage.UnInitialize()
End If
End Try
|
|
|
|
|
Copy, paste, and pray, huh?
It's obvious that's what you did because there's far more to getting a package to work that just this code. That's 108 page document in the second link has entire section dedicated to building a custom DTS package and getting it to work. There's far more to it than just a little code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi
I have an application where the front end is in ASP and the dll which supports it is written in C#.
I am using 'regasm' command to register it for com inter-operatibility.
C# dll methods are working fine for string type parameters, but not for LONG and INT type parameters. It throws an error saying:
__________________________________________________________________________
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'GetReportsData'
__________________________________________________________________________
I am passing the LONG parameter from ASP. Example:
_________________________
Method in C#
public string takeint(long param)
{
//code
}
________
Call from ASP
var1=object.takeint(Clng("100"))
_________________________
This operation throws above mentioned error.
What are the compatible datatypes for LONG and INT of ASP in C# as I can't change the ASP call, but I can change the C# code?
Thanks.
--------------------------------
From: saurav goel
|
|
|
|
|
A long in ASP corresponds to an int (Int32) in C#. (There is no data type in ASP that corresponds to a long (Int64) in C#.)
---
b { font-weight: normal; }
-- modified at 7:20 Tuesday 10th January, 2006
|
|
|
|
|
C# questions belong in the C# forum, not VB.NET.
Posting the same question in multiple forums (cross posting) is also considered very rude.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
* How to store data in a public variable(global) and make it available throughout the application?
Mayur
|
|
|
|
|
if u r talking about window application then u can use a module and in that module declare a public variable which can be used through out the application
if u r talking about web application then use session variables they can be used throughout user session..
abhinav
|
|
|
|
|
Hi Abhinav,
Thnx for your reply. Actually I want the user to input some data (Month & Year) which I want to use throuhout the application. How can this be done.
With Regards,
Mayur
|
|
|
|
|
Put it in a shared property in a class eg
Public class Globals
private shared myear as string
shared property Year() as string
get
return myear
end get
set(byval value as string)
myear = value
end set
end property
end class
Then you can call it from anywhere in your application by using
globals.Year = "2005"
or
dim newYear as string
newYear = globals.Year
Jon
|
|
|
|
|
Jon, Thnx a lot.
With Best Regards,
Mayur
|
|
|
|
|
Hello,
I have been searching around for a while and haven't been able to find anything to do this. I would like to create a form in VB.NET that performs a HTTP POST request to a web server. Is this possible? I don't want a web page as a text entry page with a submit button, I would like it all to be performed from a simple VB.NET application. Any examples, or pointers in the right direction would be much appreciated - Cheers Matt
|
|
|
|
|
You're looking for the HttpWebRequest[^], specifically, changing it's Method parameter to "POST".
You can find a bunch of examples by Googling for "HttpWebRequest method post[^]"
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi all
I want to have a column in datagridview which is showing the combobox with multiple columns
Can Datagridviewcomboboxediting control class can help in any way
Plz its very urgent to me
Can idea , Clue , Suggestion, Source, way is highly appreciated
Thanks for this help
Hema Chaudhry
|
|
|
|
|
Section 5.9[^] of George Shepherd's Windows Forms FAW shows you how to add a normal ComboBox to a DataGrid.
Now, the .NET Framework doesn't supply a multiple column ComboBox, so you'll have to implement your own control to do it. Once you have the contorl built, you can add it to the DataGrid, just lkike a normal ComboBox.
You can find a multi-column ComboBox here[^] on CodeProject.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks for reply
The links which u suggested r not working with
vb.net 2003 datagrid
I will try in the vb.net 2005
DO u know how to add the custom controls in datagridview of vb.net 2005
Thanks in advance
Hema Chaudhry
|
|
|
|
|
Actually, that code was written in 2003. You can't just copy, paste, and pray it works. You have to fully understand what's going on in that code.
Custom controls are handled by the DataGrid no differently than the standard controls, provided the custom controls are written exposing the correct interfaces.
THe code on those links won't work with 2005 because the DataGrid was replaced with the DataGridView control, which doesn't work the same way the old DataGrid does.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi
I want to know the HOST NAME of a machine.
For that I will input the IP of that machine and it will show me the HOST name.
also the vice versa.
i am able to retrive the localhost IP using WINSOCK control.
plz help me
Paritosh
|
|
|
|
|
What you're looking for can be found in the Dns class, GetHostByAddress[^] method.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
how can i convert the below vbscript into .net ?
thanks
Computer = InputBox("Enter the computer name","Terminate Process",
"localhost")
PName = InputBox("Enter the name of the process","Terminate Process")
Set Processes = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" &
Computer & "\root\cimv2").ExecQuery("select * from Win32_Process where Name
= '" & PName & "'")
For each Process in Processes
Process.Terminate
Next
|
|
|
|
|
The System.Management namesapce has everything you'll need to do this. I wish it was a bit simpler to use though...
Import System.Management
.
.
.
' SELECT * FROM Win32_Process WHERE Name='processName'
Dim query As New SelectQuery("Win32_Process", String.Format("Name='{0}'", processName) )
' Initialize an object searcher with this query
Dim searcher As New ManagementObjectSearcher(query)
' Define arguments for our WMI method call on each object returned, in our
' case, Nothing (null)
Dim methodArgs() As Object = {Nothing}
' Get the resulting collection or Process objects and loop through it
For Each ManagementObject foundProcess In searcher.Get()
Debug.WriteLine( String.Format("Killing process: {0}", foundProcess.Properties("Name") ) )
foundProcess.InvokeMethod("Terminate", Nothing)
Next
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Wao! seems like i need to rewrite my vbscripts !!
is there anyway to import them into VB?
|
|
|
|
|
No. There is no conversion tool to go from VBScript to VB.NET.
You'll have to rewrite them by hand.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How to dispose the allocated memory after closing a windows application using VB.Net?
Even after closing a subform and returning to main form ,the task manager doesn't show me any reduction of memory usage.
i hav used gc.suppressfinalize(me) in finalize method.even then there is no reduction in memory usage
Help me out!
Raji
|
|
|
|
|
When resources are freed during program execution, it does not necessarily mean that the task manager usage will show a decrease. They will only be guaranteed to be reduced when your program ends.
The garbage collection is up to the framework and the o/s.
There is a good article (somewhere) on the Code Project about this subject. Have a bit of a ferrett around and you'll find it. there is also some very good documentation on the MSDN website.
...Steve
"Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
