argodev's Q&A profile
SQL Server Scrpting to genrate surrogate keys
This is the code iam using to get the incremental surrogate keys: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent 'Declare a variable scoped to class ScriptMain Dim counter As Integer Public Sub New() 'This method gets called only once per execution 'Initialise the variable counter = 1093 End Sub 'This method gets called for each row in the InputBuffer Public Overrides Sub Input_ProcessInputRow(ByVal Row As InputBuffer ) 'Increment the variable counter += 1 'O ...Show All
Windows Forms Setting up IIS for Web-Deployed
In every article I've found on no-touch deployment, not one of them says exactly how the IIS virual directory should be set up in order to do this (file permissions/web permissions/properties, etc.) Can someone provide this information or point me to a tutorial on the web that I haven't found yet Thanks, --Patrick Here are a couple of things& ...Show All
SQL Server Backing up file system based packages
Hi, What is the best way to backup file system based packages that are running in production Let's say all packages are stored in separate project folders under a common root, such as d:\etl\<project folder name here>. Is there a mechanism via SQL Management Studio to backup these packages Or is it basically resorting to doing something like scheduling a backup via Windows backup or creating a batch that executes via Windows Scheduler to xcopy the packages to another server Thanks, - Joel ...Show All
Visual Basic vb and access
Hello all, Well I am building an application (as for my final project in the university), and I want some help: I have report in Access, how can I have a button in VB that can call that report thanks Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\accessfile.mdb;") Dim dacv As New OleDbDataAdapter("Select * from table", con) Dim dscv1 as new Dataset Dscv1.Clear() dacv.Fill(Dscv1, "table") DataGrid1.DataSource = Dscv1 DataGrid1.DataMember = "table" Dscv1.WriteXml("C:\queryresult.xml", XmlWriteMode.WriteSchema) finally; you can relation crystal rep ...Show All
Visual Basic VB2005 manual
G'day I have been struggling with VB2005 express for the past weeks or so. I have made lots of progress by just referring to "VB2005 for dummies" and some VB6 books. Is there somewhere where I can dowload the full Syntax manual and hopefully lots of code snippets on how to do things I have ordered VS 2005 standard edition but the delivery has been postponed for a week in Australia. Going to the launch on Monday, perhaps I can annoy someone there and try to get some info. Charliem wrote: Here a couple of links that I find helpful Visual basic 2005 Language Specification Thank you very much ...Show All
Visual Studio Express Editions Color text not returning to normal!
I have my text turning a different color when I type a certain thing in, but the problem is that it wont change back to black after I type it. And, after I type it, any key I press will retype what I typed before. Heres my code: Private Sub RichTextBox1_TextChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RichTextBox1.TextChanged Dim Tag As String Tag = "<html>" If RichTextBox1.Text.Contains(Tag) Then Me .RichTextBox1.SelectedText = Tag With RichTextBox1 .SelectAll() .SelectionColor = Color.Blue .DeselectAll() .SelectionStart ...Show All
Windows Forms Center form?
Hi. I want to know how I can programmatically set my form back to the center of the screen in .NET 2.0 (C#) I would have modified the form size etc.. during a user selection but then wish to return the form back to the original size (which is done) and then also center the form back to the center of the screen. Would this be the best way this .Left = ( Screen .PrimaryScreen.Bounds.Width - this .Width) / 2; this .Top = ( Screen .PrimaryScreen.Bounds.Height - this .Height) / 2; Thanks! Hi, You should use method CenterToScreen like: private void Form1_Load(object sender, ...Show All
Windows Forms Get a control by its name in VB 2005
Hi, I have read in some documentation that it is now possible (in VB 2005) to get a control by its names, as it was possible in VB 6 : Form1.Controls("ControlName").SomeProperty = etc. It does not seems to works. Any idea Thanks Patrick Thank you very much for your answer, David. Actually, my code : Form1.Controls("ControlName").SomeProperty = etc does work but I was not using the right Form !! Patrick ...Show All
Windows Forms MenuItem with an icon to the left
How can i create th e subj You will need to draw the MenuItem yourself. Check out the MenuItem.OwnerDraw property. ...Show All
Windows Search Technologies URL Field encoding in 2.6.5?
Hi, I've submitted this again as it may be hidden in the other thread, plus is very important to me as to whether I continue to try to use WDS 2.6.5 as part of my product. I need to make that decision pretty soon to ship on time. Thanks for any help - even if it's just a 'We are trying to find out, hang on a week...' From my app I do a search on Outlook emails via the COM API. In the resultset I get back I need to be able to display the item in Outlook using the StoreId and EntryId values. I can get the Store Id from the first part of the URL field. The EntryId used to be readable, but now, for storage size savings I imagine, it's be ...Show All
Visual C# Inserting Image in my Report (ReportViewer)
I finally have an understanding of how to create simple reports from my dataset using the ReportViewer. I now wonder how I can make custom (SQL-queries) on my dataset that will fill for e.g. a table. For example I have a picture that I like to insert into my report. That picture do I store as a string in my database. (In my program I do have conversions functions for: Image -> byte[] -> string -> byte[] -> Image). I'm assuming that your DB string is the path to the image. If so, in your report's picture control's Value property, do something like this: =" file:/// " & Fields!PictureSrc.Value Whe ...Show All
.NET Development connection string + webservice
Hello, I am trying to make a connection to my SQL2005 database through webservice. For some reason it doesn’t work. Here is the code. I would appreciate it if somebody could help me with this. [ WebMethod ] public bool TestConnection() { OleDbConnection conn = new OleDbConnection (); conn.ConnectionString = @"Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;AttachDbFilename=C:\SQL Server 2000 Sample Databases\NORTHWND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True" ; try { conn.Open(); conn.Close(); return true ; ...Show All
Visual Basic I Need help Debugging
Hi guys I'm new to visual basics and recently installed visual basic 2005 express edition, and as i'm new to it i tried out the getting started build a web browser guide, when i got to the end it said i needed to run the debugger which i did but every time i do i keep getting the following message... The application failed to initialize properly (0xc0000005). Click on OK to terminate the application. I have looked in all the help menu's and cannot find a solution, has anyone out there come across this problem and solved it, i could do with you help. Thanks It sounds like you've hit a bug somehow ...Show All
Visual Studio Tools for Office VSTO Question: Looking for WORD Action Pane example that lists and select contacts from Outlook
Would really appreciate any help or guidence. I want to have an Action Pane in Word that somehow allows the user to select a contact from the Outlook contacts and insert that information in different parts of the document. Are there any examples of integrating contatcs and using the action pane Thanks for any help, VA Actually, you do not need an 'actions pane' example because what you want to do can be done in a variety implementations (winform, user control, etc.). What you are going to do is work with the Outlook OM programmatically to retreive contact names and display them. I have compiled a list of resources to ge ...Show All
Visual Studio Express Editions Forms Designer
I am currently going thru the VB.Net Express Edition 2005 tutorials. In tutorial no. 2 they describe aligning controls and as you move a control a blue line appears to show you the alignment of 1 control to another. I cannot get this line to appear. Can someone tell me the setting to turn this feature on. Thank you It should just work - perhaps it doesn't work in Express It happens as you drag items, for example, place a button, then drag another button next to it. It will show the line when it gets to the right distance apart. ...Show All