Kennon2005's Q&A profile
Visual Studio Express Editions FileSystemWatcher.Filter questions
Looking at the MSDN documentation's examples, they only show how to specify certain types of documents. For example, using *.* for all files, *.txt for just text files, *doc.txt for files ending in doc.txt and so on. I'd like to know if I would be able to specify multiple document types in the filter. For example, I would like to find all types *.txt and *.doc I understand that I can just find all files and then filter out the ones I want in other ways, but since the class contains a property to filter types, I'd just like to know if multiple types can be specified in the filter property. Thanks, Bill ...Show All
Visual C++ need a help regarding dwmapi.dll and DwmExtendFrameIntoClientArea function
Dear All, My compiled code asking dwmapi.dll, which is nowhere to find on my windows XP box. using dependency walker, it reports that the "c:\windows\system32\urlmon.dll" is looking for this dll, and the function name is DwmExtendFrameIntoClientArea. I searched internet, and some people say that the IE7 is making this problem. and I am kind of agree, and I have it on my machine. So I need this dll badly, or somebody can give me a way to un-install IE7 quickly Thanks a lot. rcen Upon further research, scratch my previous message. The real culprit is IE7. It appears my install of IE7 includes a version of IEFRAME.DLL that has this missing dependency. This is throwing an exception in a 2002 dl ...Show All
Visual Studio Team System connectstring help.
string connectString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + filename + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1;\""; string parameterName = "["+excelSheet+"$]"; string selectCommand = "SELECT * FROM " + parameterName; how can i use the parameterName as if it was a parameter FxCop is giving me the following : CA2100 : Microsoft.Security : Review if the query string "SELECT * FROM [____$]", passed to OleDbCommand.OleDbCommand(String, OleDbConnection) in ExcelImport.GetDataSet(String, String):DataSet, accepts any user input. If so, consider using a parameterized Sql query instead of building up the query via stri ...Show All
SQL Server Urgent:Conditional One-to-Many Mapping of Columns
Hi, I am new to using SSIS. I am supposed to move data from a text file to a SQL Server table. I did that successfuly when I simply mapped column one-to-one, but when I could not conditionally map one column to different destination column depending on some criteria. Example: I want to make SSIS map the column A depending on the value of field X: If X= Value1 Map A -> B if X= Value2 map A -> C and so on. This is an urgent situation. I will really appreciate instant help. Thanks, Aref Use a Derived Column component to create new columns that will be inserted into B & C The expression for columnB should be something like: X == Value1 A : NULL(<data-type>) The expression for columnC should b ...Show All
Software Development for Windows Vista Custom Composite Activity & ActivityBind
Hi there, I'm trying to build a custom composite activity that allows to execute it's child activities in any order. It should be possible to run a child activity more than once (e.g. the flow "Activity1 -> Activity2 -> Activity1 -> Finished" should be possible. I've tried to build such a composite activity based on the GraphActivity sample ( http://blogs.msdn.com/vkalra/archive/2006/08/12/696132.aspx ) which works great, except when i try to bind properties (DependencyProperty) between activities: If I bind a property of type 'System.String', all works fine: the property is set before the activity executes. If I try to bind a property of a custom type (e.g. List<Order>), the property is null when the acti ...Show All
.NET Development Serialized file corrupted aftert TCP file transfer
Hi there, I need to send the contents of a TreeView from one server on a network to another. I can serialize and deserialize the TreeView just fine locally, but after I send it to the target process via TCP, the file gets corrupted; the data containing the BinaryHeader info for the BinaryFormatter is getting stripped out. Here's a small excerpt of the original data (viewed in Notepad) yyyy System.Collections.ArrayList _items _size _version And after the TCP transfer: System.Collections.ArrayList _items _size _version The data is not being corrupted per se, but bytes are being dropped. If it'll help, here's what I'm doing to transfer the files: Server: public class MainIOServer { private T ...Show All
Visual Studio Team System Can the comments for the requests be seen?
Hi, I have entered comments for each requests.On play back wheter i am able to see the comments in that window also or in anywhere Kindly suggest. Thanks in advance - Vijay. ...Show All
Visual Basic Passing Parameter from MDI Menu to Child Form (Urgent)
Hi all. I am new to VB programming. I have been commissioned to do some work on VB/SQL server and as such will be asking some basic question. Please do keep your answers very simple to help me get into VB. -----Question I have an application I am developing, a menu (MDI) with a lot of child forms. I will navigate to any of the forms from the sub menus in the menu(MDI). Assuming that I want to pass a parameter from a sub-menu in the menu(MDI) to a child form when called from the sub-menu. Please how can I do this A simple code will be appreciated. Just add a Public variable in the Childform like \\\ Public myVar as string /// In the Click-Event in the Menu just fill this one like: \\\ dim f2 as new form2 f2.mdipa ...Show All
SQL Server Cannot find file or assembly error.....
I created an assembly to access my SSRS web service in a Script task. The package runs fine on my machine but gets the following error from the production box..... The script threw an exception: Could not load file or assembly 'Microsoft.SqlServer.ReportingServices2005, Version=0.0.0.0, Culture=neutral, PublicKeyToken=3bd4760abc5efbcb' or one of its dependencies. The system cannot find the file specified. I followed the exact same procedures for creating the .dll on the production box as I did developing on my machine...strong name, load to gac etc....but it still cannot find it. My production SQL Server is 64 bit so perhaps there is another step I need to take Anyone have a clue as to what I may be missing TIA ...Show All
SQL Server Problem with &
Hai Iam using asp.net 2.0 with sql server 2005 as back end.. i need to pass the data to stored procedure via parameter containg (&) symbol for ex: If i pass string like "sample&ss" it gives the error xml parsing how to avoid this..welcome for your suggestion. Regards Senthil If the error is in parsing XML try this: "sample&ss" '&' is a special character in XML, and if you catually want to use it you need to represent it as & ...Show All
Visual Studio Visual Studio 2003 setup issue !
I havent found a forum for VS 2003 install issue, so i am posting here. Pls let me know if there is one for 2003. I am trying to install VS 2003 Ent Architect 2003 , and i am getting error with while Visual J# 1.1 prereq. The error is as follows : [09/07/06,10:15:54] Microsoft Visual J# .NET Redistributable Package 1.1: \\rossam01\devtools\microsoft\visual studio .net 2003 windows prerequisites\jsharpredistcore\vjredist.exe exited with return value -2147024893 [09/07/06,10:15:54] Microsoft Visual J# .NET Redistributable Package 1.1: ***ERRORLOG EVENT*** : Error code -2147024893 for this component means "The system cannot find the path specified. " [09/07/06,10:15:54] Microsoft Visual J# .NET Redistributable Package 1.1 ...Show All
.NET Development Securing SqlConnectionString
Hi, I want to secure my confidential data in database. So i have written a function. It will initially changes the user's (which i have created for data access) password and gives me the encrypted one of the new password. So the developer won't know the password. To get the connection i have to pass the username and the encrypted password into one module which i have written. It will decrypt the password, creates a connection and returns the SqlConnection object. Here i am facing the problem. After decrypting the password i have to attach the username and password in ConnectionString that can be readable by the developer. How can i overcome this. Please advice. Thanks in Advance. once the ...Show All
SQL Server SQL2005 Active\Passive Cluster Install ?
yesterday i installed sql2k5 on a active\passive cluster and for some strange reason the mssqlserver service does not want to start up on the node that i installed it on but if i fail it over to the passive node it will start fine. system info below: system info: * win2k3 enterprise r2 (x64) cluster active\passive* * sql2k5 enterprise (x64) clustered* the win2k3 cluster works fine. i installed the msdtc service running as a cluster as well and that works fine. both servers are identical to each other. sql virtual server is running on the passive node which is now the active node. any ideas --alan well after reading through the event logs i discovered that we had a dns issue with one of th ...Show All
Visual Basic How To Automate The KeyBoard?
I've gotten Code on how to automate a mouse...Now is there a way to automate the Keyboard, where it will type perform commands I know this probabbly will be a little harder to do. If it is possible can you make it so it can use Combonation of keys such as alt-tab to still work The information was very usefull. However I can't get the Alt Tab to work that way Dim Keys As String Keys = "%({tab})" ' alt + Tab SendKeys.SendWait(Keys) When I try to run that it dosn't do anything. I don't uderstand why it Wont work. ...Show All
.NET Development How to remove columns from DataView but not from DataSet table
Hi, I use DataSet only one times and then I create DataView many times in the cycle . This DataView is used for generating individual client offers. I want to hide RegionID from DataView, but not from DataSet dv.Table.Columns.Remove("RegionID") ' this doesn`t work Does exists something like ColumnFilter Example: Dim dsNews as DataSet Dim saGenerator As SqlClient.SqlDataAdapter Dim dv as DataView ... saGenerator.Fill(DsNews.Offers) 'only once For Each ClientID In ClientIDs dv = New DataView(DsNews.Offers) dv.RowFilter = "RegionID IN (" & IndividualOffer(ClientID) & ")" 'Each dv converting and saving to *.CSV file Next Notes: IndividualOffer - returns comma separated string ex. "1,5,10 ...Show All