tonyerfer's Q&A profile

• .NET Development How to call a stored procedure with parameters??

  Hi, I'm trying to call a stored procedure with parameters from my code, I also want to populate a dataset so I'm using the method dstRes = db.ExecuteDataSet(spName, arrPrms) but arrPrms is an array of SqlParameter and when the code gets to the line above throws a cast exception (Unable to cast from SqlParameter to Int16) the problem is that spName can be any stored procedure from my data base (have about hundreds) and I recieve the params on an Array List and convert it to SqlParameter. I have read that I have to send an object array with ONLY the values in the SAME ORDER the stored procedure has them! not posible for me, could be a lot of parameters. Is there a way similar to the SQLHelper class that receives an array of S ...Show All

• Windows Forms treeView and listView

  Hello, Please help me ... I want to make win application something like explorer with treeview and listview. I make treeview to show me rootdir C and when i click it expand al directory which have and so on. When i click on same folder in treeview i want to see it's contents in listview. this is the code i wrote... namespace DatabaseSearch { public partial class Form1 : Form { public Form1() { InitializeComponent(); } public bool createTree( TreeView treeView) { bool returnvalue = false ; try { foreach ( DriveInfo drv in DriveInfo .GetDrives()) { TreeNode fchild = new TreeNode (); fchild.Text = drv.Name; fchild.Nodes.Add( "" ...Show All

• SQL Server SSIS package listing by name

  I have 100s of packages under one project and finding it difficult to locate a package since it is not in any order. Is there a way to list packages by its name - alphabetically sort Thanks Sorting SQL Project Files in SQL Server Management Studio ( http://www.sqldbatips.com/showarticle.asp ID=78 ) ...Show All

• .NET Development Error in using Registry function in C#

  Hi, I am a beginner for C# program I want to write a program that is read the data from registry I have added " using Microsoft.Win32;" at the begining but when I try to start my code " RegistryKey rk = Registry.CurrentUser;" I meet the error "The type or namespace name 'CurrentUser' does not exist in the class or namespace 'Registry' (are you missing an assembly reference ) " Where does this error comes from and how can I solve it Thank you so much~ I have fixed the problem close the delete the project then create a new project.......... I don't know it work fine now hahahaha ...Show All

• SQL Server The Fastest way to perform an update ... advice needed :)

  Hi all, I have a situation where my Visual C# application presents a number of fields. In order to update a student object, I wish to call a stored proc. 1 or more fields can be updated... And If one is left null, then I don't want to update it, but instead I want to keep the old value. I am really wondering if I am approaching this the right way. The following stored proc does what I want it to do, however I'm thinking there may be a faster way... Here it is: -- Update a student, by ID. DROP PROCEDURE p_UpdateStudent CREATE PROCEDURE p_UpdateStudent @ID INT , @NewFName VARCHAR ( 25 ), @NewOName VARCHAR ( 25 ), @NewLName VARCHAR ( 25 ), @NewDOB DATETIME , @NewENumber VARCHAR ( 10 ), ...Show All

• SQL Server server groups

  is there a way to enumerate through existing server groups Im trying to create children server groups. Hi Chuck, I'm not sure I knwo what you mean Can you give an example Are you just trying to populate a treeview with all servers registered in SSMS Cheers, Rob ...Show All

• .NET Development dotnet 3.0 general question

  I just installed the .net 3.0 sdk on my home computer with visual studio 2005. Does installing the framework have any effect on 2.0 projects Like will i have to say in visual studio what to compile under I'm confused about if there is a compile as 3.0 option, or if everything still compiles as 2.0. Also, if it is 2.0, what do you include to use new language features like var I'm confused about this and i also want to install it at work, but i don't want to mess up any of our projects. .Net 3.0 is another Microsoft marketing blunder to confuse everyone, so you are rightfully confused. It's just .Net 2.0 with WCF, WWF, and WPF libraries added. When you go to c:\windows\microsoft .net\framework, you'll still ...Show All

• SQL Server SQL Server 2005 Surface Configuration Tools

  After installing sql server 2005 Developer Edition on my Windows xp professional that has Service Pack 2, I am getting error whenever I click --> The sql server configuration tools --> surface area configuration tools: sqlsac.exe - Application error The application failed to initialze properly (0xc0000005). Samething happens if I click the Report Server Configuration tool . Anyone has encounter this type of problem and have a solution for it... I have used this link http://www.tech-pro.net/howto_015.html before when had similar error, it is a common one in windows platform. ...Show All

• SQL Server Populate a variable

  During a dataflow - I like to populate a variable with True or False based on a value in one of the data records. How do I do this excercise  if I use a script - can someone provide me with simple script on how to populate one variable   Thanks heaps         Thanks for all the answers. Guess my brain is turning soft because I am still unable to get it to work :) Let me try to explain again. I have a single record in a table - the Value can be 1 or 0. Let us call the field "Check" I like to use this value to make a check in my control flow in the Constrain Editor. So if value is 1 then continue with workflow and if value eq 0 ...Show All

• Windows Forms MouseMove Problem...

  Hi everyone.. I have a strange problem in a form... I've added in the FormMouseMove event some code (MessageBox.Show("I've been moved")) to be execute... and I find that the event is fired everymoment... also whe the mouse is stoped... Maybe I'm wrong but the MouseMove event don't must be fired everytime that the mouse is moved over a control I'm trying to catch when the mouse is stoped and when is starting to move... I thought that is pretty easy but I found this kind of whatever is happen... Thanks Yes.. you are right about that the event is raised continuously as the mouse is moved within the form, but If I don't move the mouse, the event is raised too... So... How could I know when the mouse is really moved with ...Show All

• Visual Studio Express Editions Problem with outlook - "messaging interface error"

  I am receiving the following error message: The messaging interface has returned an unknown error. If the problem persists, restart Outlook. This has work before so I'm not sure what happened. Even worse, when I open outlook on its own, and click new mail, I get the same error message. So currently I cannot create new mails, forward or reply. Please help. bw12117, It seems to be a product issue. I guess the version of your Outlook is not 2003 but the previous version. Please take a look at the following two suuport articles: "The messaging interface has returned an unknown error" error message when you forward a message in Outlook 2000 SR-1 http://support.microsoft.com/kb/275186 ...Show All

• SQL Server Capture date and timestamp of a file?

  Hi, I am pulling files from the FTP site using the FTP task. I want to also capture the date and timestamp of each of these files so that I can insert the values into a database and track when are these files get created normally on the FTP server. Any ideas Thanks in advance for your help. $wapnil No the transfer of files do not preserve the date and time. When i download the files all the files show the same date and timestamp. Can the FTP task be configured to preserve the date and time Thanks! $wapnil ...Show All

• Visual Basic Showing a form in a tabcontrol

  Hello All, I'm using VB 2005. Can someone tell me how to "Show" a form in a tabcontrol I have a form with a tabcontrol, as well as other controls, and I need to show a small form via ShowDialog(). However, I want the form to appear in the current tab area of the tabcontrol. I can't seem to find the right combination of commands! Thanks, Carl Yes, you can. Not with the designer though, you have to do it a run-time. For example: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim f2 As New Form2 f2.TopLevel = False f2.Visible = True Me.TabControl1.TabPages(0).Controls.Add(f2) End Sub ...Show All

• Visual Studio 2008 (Pre-release) Mixing DataContract with Serializable attributes

  The documentation at http://windowssdk.msdn.microsoft.com/en-us/library/system.runtime.serialization.datacontractserializer.aspx indicates that the DataContractSerializer will throw an exception when asked to serialize a class decorated with both the DataContract and Serializable attributes. However when attempting this myself I didn't experience any such problem. Is the documentation incorrect The reason I ask is that I need to be able to store objects retrieved from public Web services via WCF (i.e. decorated with the DataContract attribute) in the ASP.NET session state server (which requires the object to be decorated with the Serializable attribute). Actually, it is allowed to mix [DataContract] ...Show All

• Visual Studio 2008 (Pre-release) How to remove control box from Window?

  <Window x:Class="MyWindow" xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " Title="Test" Width="518" Height="502" ResizeMode="NoResize" Icon="{x:Null}" Name="window" SizeToContent="WidthAndHeight" > I have defined a Window using the above code. However I don't see a way to remove the ControlBox (upper left) from it. In Windows Forms it was Form.ControlBox. I do want to keep the title bar and the close X on the right. I just don't want the control box showing. Any ideas I do not think there is a way to control that as its outside th ...Show All