Shawn McDowell's Q&A profile

• .NET Development BlackBox for me to renew Data by using Parameters!

  Hi! How to renew a DataSet by using parameters for Command There is a simple Table(contains 3 Columns uses Access), named "Individual". 1. FamilyID (auto numbered) 2. Householder 3. FamilyMemo I made following Code by way of experiment. But, it doesn't operate as I think. I wanted to insert a new Row... !       // Load       da = new OleDbDataAdapter();       cn = new OleDbConnection();       .....       // Displays on the DataGrid1       cmd = new Ole ...Show All

• SQL Server FTP Task not saving password in designer

  I am using CTP 15 and have created an extremely simple FTP task.  I enter three pieces of information: - Server URL - Username - Password Very simple.  I click "Test Connection" and it succeeds.  If I click "Ok", then try to re-open the connection manager and test again it fails.  The password text box is blank, but the properties window in BIDS for the FTP Connection Manager shows "*******" for the password. This seems like a very basic problem, anyone else have any ideas   My FTP task that utilizes this FTP Connection Manager also fails with a "missing password" type error message. Thanks, Josh ...Show All

• SQL Server SQL Server Expess vs SQL Server 2000

  I have SQL Server Express (and VB Express) installed on my computer. My client has SQL Server 2000. Can I develop a database using SQL Express (and VB Express) and later transfer to my client's computer Or can I export from SQL express to SQL 2000 Secondly, and not related to above question, can SQL express be used for large databases. I am aware of its limited features, but that does not matter to me. Thanx. Hi, "Can I develop a database using SQL Express (and VB Express) and later transfer to my client's computer Or can I export from SQL express to SQL 2000 " Sure, you can, but you always have to keep in mind that some ...Show All

• Software Development for Windows Vista Frames ignored (apparently) when delivered to VMR9 on UI thread

  Hi, I'm trying to figure out why samples delivered to the primary VMR9 input pin from a worker thread (originating in DVD Navigator) are rendered properly, but samples delivered from my app's UI thread to the same pin on the same instance of VMR9 in the same graph are seemingly ignored. The VMR9 is using my own AllocatorPresenter to render frames onto a Direct3D surface, and PresentImage() (my code) is called for *all* frames regardless of which thread delivered them to the VMR9, but in the case of the UI thread samples the frame passed to PresentImage() doesn't contain any new data. (More info. I build the following filt ...Show All

• Windows Forms DataGridView DataError argument is wrong

  I'd like to report a DataGridView bug (or at least something that is misleading).  One of my DataGridViews was thorwing an error.  It's DataError event's DataGridViewDataErrorEventArgs parameter (e) said the event occured for column "A" (e.ColumnIndex). However, the parameter's exception message (e.Exception.Message) said the problem (which was a NoNullAllowedException) was with column "B". The exception message had it right. The argument's ColumnIndex was directing me to the wrong column.   See code below.  The two handlers do not point me to the same column. private void dataGridView1_DataError(object send ...Show All

• SQL Server Reason for Limitation and Work around for referencing Table Group fields in Footer!

  I'm gonna try this again, Microsoft, Please help! There has to be a solution for this!!!!  How can I get around the limitation in SSRS 2005 of being able to SUM on a Table's Group field from my group footer expression! Keep in mind, I'm talking about a table here, not the global Report Footer, a Table object's footer! It's driving me nuts My table footer GrossGoal_gt   's field expression (non of these work and throw the error below): =SUM(Fields!GrossGoal1.Value, "CustomerNumber_Grp" ) neither does this: =RunningValue(ReportItems!ProjFee_AZ.Value, Sum , "Custo ...Show All

• Visual Basic how do i....textbox?

  Well basically i want to know how i can write an IF...THEN decision structure based on the contents of a textbox. for example lets say i want to say something like IF textbox1.text (has no text in the field) THEN textbox1.text = 0 Also how do i write a code that only allows integers of a positive value to be typed and accepted into the textbox // IF textbox1.text (has no text in the field) THEN textbox1.text = 0 You want to text to equal "0" You should put it in quotes. VB, being weakly typed, will do this for you, but it's better to say what you mean :-) if string.isnullorempty(te ...Show All

• Smart Device Development How to cast a byte[] to TimeZoneInformation struct?

  Have to programmatically set the correct time-zone. Reading the time-zone from the registry PPC2003 results in a byte[]. The time-zone struct for the Win32API has the signature: [ DllImport ( "coredll.dll" , CharSet = CharSet .Unicode)] public static extern bool SetTimeZoneInformation( ref TimeZoneInformation lpTimeZoneInformation); [ StructLayout ( LayoutKind .Sequential)] public struct TimeZoneInformation { public int bias; [ MarshalAs ( UnmanagedType .ByValTStr, SizeConst = 32)] public string standardName; public SystemTime standardDate; public int standardBias; [ MarshalAs ( ...Show All

• Visual Studio Team System Displayed name of parameter in custom validation rules

  Hello, When you declare a public property it's name should be ofcourse without spaces, and it's displayed as it is in the parameters list in the properties window. When I look at the built in validation rules I see that the displayed names of the parameters contains spaces how can I do that. Also I want to add description comments to these parameters. thanks You can use the DisplayNameAttribute and DescriptionAttribute with each property. The VSTT rule dialog will use these values if they exist. For example [DisplayName("Number of users")] [Description("some descriptions")] public int NumUsers To s ...Show All

• SQL Server Custom Task Properties

  So I've built my own custom task and it has a selection of properties. I drop it onto designer and can see the properties (VS Property Grid not custom UI ). The properties window retracts and I decide to reopen the property window.  My Properties have now disappeared (mine - not inherted).  Never do they return for that instance of the task.  add another task and we can see the second instance's properties but suffer the same fate as with #1 when we want to see them on > 1 occasion. I can see the properties in Expressions which leads me to think the task is correct and it is a VS grid thing. Jamie, Myself and Darr ...Show All

• Visual Studio ToolBoxItems.Add does nothing

  Hello, Using Whidbey Beta 2, I'm trying to add a control to the toolbox using a windows forms application. All goes well, and no error found, but the control does not appear after the application finishes, even after I restart VS.NET. I'm also adding a new toolbox tab, which works fine. First I tried using the sample code provided in the documentation, but it din't compile because it expects an object instead of a class. Since I had this working with VS 2003, I borrowed some that seems to work, at least for creating the tab. The code I'm using is the following: Dim latestDTE As Type latestDTE = Type.GetTypeFromProgID( "Visu ...Show All

• .NET Development Possible to add to a strongly type collection, an item of not the same type?

  In 1.1 given a collection w/c accepts only a specific type, is it possible to add an item that isn't of the same type ex. public class myType { public int myField;} public class MyCollection:CollectionBase { public int Add(myType m) {return List.Add(m)} ... } here is the trivia: public class MyItemCollection : CollectionBase { public int Add(MyItem myItem) { return List.Add(myItem); } public void Remove(MyItem myItem) { List.Remove(myItem); } public void Insert(int index, MyItem myItem) { List.Insert(index, myItem); } public int IndexOf(MyItem myItem) { return List.Index ...Show All

• .NET Development Need XOML only sequential workflow example called by ASP.NET Client?

  Tom, I am trying to implement several custom and one composite activity within an XOML only sequential workflow (called by ASP.NET client).  I am unable to view the xoml in the designer and am not able to load multiple activities at the same time. Can you provide an XOML only sequential workflow example (called by ASP.NET using WWF Beta 2.2) that loads an xoml only workflow with several custom activities and one composite activity and passes parameters between the activities in the xoml I am willing to provide my code if necessary to resolve this problem.  Let me know if you need it I look forward to hearing from you so ...Show All

• SQL Server SELECT INTO OUTFILE?

  Hi, how do I redirect the output from a SELECT to a text-file, or Excel-file It is possible in MySQL, but what about Transact-SQL Thanks YOu have to use the OPENDATASOURCE method or a linked server to insert data in another destination than the local SQL Server. More information (including a sample can be found in the BOL) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Tools for Office Can't Create VSTO project

  Dear all, I just installed VS2005 + VSTO and want to create a new VSTO Excel workbook project. However, a dialog come out: You must explicitly enable access to the Microsoft Office Visual Basic for Applications project system before you can create or open a Visual Studio Tools for the Microsoft Office System project. By default, access is disabled to help stop the spread of macro viruses. After enabling access, you will still be protected by Microsoft Office macro security levels. Do you want to allow access to the Visual Basic for Applications project system After clicking 'Yes', another dialog come out: (Exception from HRESULT: 0x8004015 ...Show All