J. Clark's Q&A profile

• SQL Server Visual basic calling a DTS Job

  I am working on a Visual basic program and wanted to know if someone can help me. Is it possible to save the file you are creating with DTS in a user defined place instead of where the DTS job specifies I can create a DTS job, but are having issues getting VB to call the job. Any help with that would be great as well. ...Show All

• .NET Development Folder Copying

  Hi,     i have a requirement where i have to transfer files between two pcs and also update the transfered files in both pcs whenever they are updated in any of the pcs. Am able to transfer the files. but now i have to monitor the files for any updates(i.e.renamed,changed).There is a component Filesystemwatcher in .net to monitor changes occured to files in a directory(It monitors all files in a particular directory).But i want to monitor a particular file in a directory. Is there any other method other than filesystemwatcher to accomplish this task If there is no alternative then how to accomplish Folder copying instead of file transfering You can use Filter property of ...Show All

• Visual Studio 2008 (Pre-release) xbap database application

  Hello, does xbap allowed us to make database management applications where database located on different server, i have tried with database interaction with xbap but i got error like 'Request for the permission on type 'System.Data.SqlClient.SqlClientPermission'' failed. can anybody help me with this. regards, vijay prajapati i ashish, yes, i got it, but have some confusion regarding third party call and represent result to client, can u show me with example , how to call third party domain and get data and represent it at client side on specific event say button_click . ...Show All

• Visual C# Why C#

  I know this is very basic question. But why one should select C# over VB.net Hi, Vikram There are a lot of articles about it, since it is a frequently asked question: http://blogs.msdn.com/csharpfaq/archive/2004/03/11/87816.aspx http://www.codeproject.com/dotnet/vbnet_c__difference.asp http://www.dnjonline.com/article.aspx ID=mar05_vbvscsharp Thanks. ...Show All

• Windows Forms how to add combobox in datagrid

  there are 2 datagrid combobox columns country and capital if i select country the capital of the country automatically display. if i select capital the country display accordingly... Note: i want to fill the comboxbox value from the table(sql). how we add datagrid combobox column thanks I think what you want is a master-details list in datagrid, please refer to this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbtskcreatingmasterdetailslistwithdatagrid.asp ...Show All

• Visual Studio Express Editions How to compile and ave to exe

  If i compile my console aplications hes saving it into source code again. How can i compile to .exe Hello Could you please supply a few details on exactly what you want to achieve here please Thanks Damien ...Show All

• Visual Basic Dealing with directory permissions while recursing the file system

  I am working on some code that displays the filesystem in a treeview. I want to avoid showing any directories or files for which the user does not have permissions. I tried the following code but it is not working. The last tree node displayed is one that causes an UnauthorizedAccessException Any help would be greatly appreciated. Private Sub BuildFromFS(ByVal node As TreeNode) Dim strDir As String = node.FullPath node.Nodes.Clear() Dim currFldr As DirectoryInfo Dim fldr As DirectoryInfo currFldr = New DirectoryInfo(strDir) Try If currFldr.GetDirectories.Length > 0 Then For Each fldr In currFldr.GetDirectories() If Not (File.GetAttributes(fldr.FullName) And F ...Show All

• SQL Server using text file data in a SQL Task

  I have some fields in text file that I want to use in a SQL Task. What is the best way to read these fields and then plug them into the SQL Task Thanks Aref Can you explain this a bit more Perhaps show us what the text file looks like What will the SQL statement be that you want to use -Jamie ...Show All

• Visual Basic unknown software exception on exit

  I have just upgraded a Visual Studio 2002 Windows application project to Visual Studio 2005, including upgrading to the latest custom controls. The compiled application runs fine but on exit I get a windows message box with my application's title in the title bar and the message: The exception unknown software exception (0xc0020001) occurred in the application at location 0x7c812a5b This happens after the last line of code has run so as a total guess it's something to do with garbge collection. Then I run in the Visual Studio 2005 environment I don't get this error (or any others). The application uses Crystal Reports, Dundas, Devexpress and Infragistics controls. My only lead so far is that if I get the application to display ...Show All

• SQL Server Who has dropped SQL table?

  Somebody has dropped my SQL table in (multiuser environment),now I want to know who has done that. Is there any way by which I can retrieve that(user name or machine name) I am using SQL 2005. IF you have a fully logged database, AND you still have all of the log files, you could use one of the third party log tools to read the log files. See Tibor's list for possibilities: Third Party Tools (Tibor's List) http://www.karaszi.com/SQLServer/links.asp ...Show All

• Visual Studio "Unable to start debugging" error on x64

  I'm using Visual Studio 2005 (SP1 beta) on Windows Server 2003 Enterprise x64 Edition. If I create a new project (Console or Windows application) and then press F5 I get an error dialog stating: Error while trying to run project: Unable to start debugging. Either the applicaiotn has not called WSAStartup, or WSAStartup failed. This happens with the active solution platform set to either "Any CPU" or to "x64". If I change the active solution platform to "x86" everything works fine. Does anyone know what might be causing this problem and how to fix it Thanks, John. Hi, This is a known issue in Whi SP1 Beta that will be fixed in the RTM version. Having the Start Page on in ...Show All

• Windows Forms Bound ComboBox not displaying correct value on form load

  I have a form whose fields are bound to a table. I have one lookup ComboBox, MfrIDComboBox, which is bound to a field called MfrId. The ComboBox is populated from a datatsource on my form. The ComboBox popluates with values fine, and if I select a value and update the record, the correct value is saved to the database. However, when the form loads, the correct value is not displayed. I have tried everything I can think of, inlcuding setting the value with the following code. Me .MfrIDComboBox.SelectedValue = dr.Item( "MfrId" ) For reference, here is the generated code from the designer. Aside from the code above, I am not adressing the ComboBox programatically at all. Me .MfrIDComboBox.DataBindings.Add( New System ...Show All

• Visual C++ How to add message map entry?

  In MFC/VS2005, a dialog has an existing message map. How can I add more entries to the message map, other than by editing the files by hand This function used to be in ClassWizard, but now seems to have disappeared. ClassWizard and WizardBar were removed in Visual C++ .NET 2002. http://msdn2.microsoft.com/en-us/library/6761383e.aspx ...Show All

• SQL Server Restricting access to certain folders?

  Hi all, I have a user who I only want to provide access to a single folder within RS2005. I don't seem to be able todo this, they can either see everything or nothing at all. What am I missing Any help much appreciated. Kind regards Tarun Hi, thanks for all the replies. If I give the user access to the Home page, suddenly they can see everything within it, not just the folder I gave them access to. As it stands I seem to get everything or nothing, i must be doing something wrong! Kind regards Taz ...Show All

• Visual Studio 2008 (Pre-release) Why no DLINQ for eSQL/Mapping Provider - instead of LINQ to Entities

  Hi there, I am investigating DLINQ vs. LINQ for Entities. Reading several posts people say the generated Object Models shall be similar. To be honest the Entity Object Model seems not to be that nice and clean compare to the DLINQ model. And to be honest at the current stage i think DLINQ is much more mature altought it lacks the Flexible Mapping. My suggestion is to enable DLINQ to generate eSQL instead of SQL and name this variant LINQ for EnitySQL. Then we will have mapping and a clean API. What do you think PS: Also please change the DataContext.Init method to visibility protected. Thank you very much Tim --- Tim F. Fischer, CEO tangible engineering - the model driven development company www.tangiblearchitect ...Show All