acedog's Q&A profile

• SQL Server Stored Procedure Validation

  Hi All, I am working on a project in which an Integration Services package should be executed 24 times a day. Everytime it is executed, it validates for tables, views etc. I am able to validate for tables, views, partition functions etc. But when I am trying to write a code as If not exists (select name from sys.objects where type='U' and name='SP') Create Procedure SP Begin End I am trying to put the above as a task in Integration Services. When the task is executed, it is throw an error 'Create Procedure should be the first line' etc. How to solve the above problem Can any help me immediately Thanks Have you had the same results in using "Execute SQL Task" (under ...Show All

• .NET Development Error in .net Framework 2.0

  Sorry moderators if I posted this in the wrong section. I use a x86 32bit machine and I am experiencing problems using the new .net framework 3.0 on Windows XP 32bit. Whenever I use a .net web thing like webclient to download a string from a site, I get a pause and Visual Basic freezes and shuts down during compiling. I am using .net framework 2.0 SDK with Visual Basic 2005 Express Edition because it is the only compatible one with my c86 machine as far as I know. Is this because .net framework is intended for Windows Vista Skeletron, Whilst .Net 3.0 may come preinstalled on Windows Vista, it's also fully compatible with 32bit Windows XP. The reason for this is that .Net 3.0 actually uses the runtime provided by .Net 2.0. It's a ...Show All

• .NET Development Web Service receiving parameters

  Hi, i'm new in .net and most in C#. Have a Service, a windows services, developed but i need to upgrade it. The service must write a dinamic xml. Why dinamic ,  well because the service will read a configuration file from a external system like a cfg file or txt file or ini file. Anyone did something like this Exist something like standard process to do this Any info will help me thanks in adv Federico Botto   Federico, When you say "write dynamic xml".... does it means returning a different xml format depending on the config file you read In that case.. your webmethod should return a System.Xml.XmlDocument instance and inside the webmethod you create this document based on t ...Show All

• .NET Development Embed author with code files

  I created a tool that creates the Business and Data layer based on the database design. And a few co-workers want to use it. I don't mind it, but I want my name in the code files so that if anyone else sees the code they will see my name as the creator. Kinda like a self-gratification thing and advertisement for job offers.   I'm using CodeDOM to create these files. Is there a way I can set my name to appear somehow, that they cannot delete it Or maybe some pattern I should employ on the creation. Maybe requiring a DLL instantiation by the IDE or something Anyone have any ideas, suggestions, thoughts, etc...   Thanks, Nick Well this is my custom use. I developed it at hom ...Show All

• Windows Forms Mgbox Function doesn't work in my windows Form ?

  hello guys: I have a windows application for EDI system,my platform is vs.net 2003 , and my application includes some children forms ,now I have a windows form to scan the sticker and save the barcode data in sql 2000 database,but when I scan the sticker I need to check the sticker is correct or not ,if the sticker is wrong,the system will show a warning message,my souce code as below: Private Sub txtScanTxt_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtScanTxt.TextChanged If Len(txtScanTxt.Text) = 12 Then Select Case UCase(Strings.Left(txtScanTxt.Text, 5)) Case Strings.Left(labBuyerPo.Text, 5) If AutoSelectCartonNo(Strings.Right(txtScanTxt.Te ...Show All

• SQL Server Domain group logins failing on SQL 2k5 workgroup

  This question is regarding a brand new out-of-the-box SQL Server 2005 Workgroup Edition install. The old SQL Server 2000 server is working properly with regard to the issue we're having: We are using Windows Authentication, and have created SQL logins for about 40 different groups on our domain. We've given those logins the appropriate permissions on the databases they're supposed to be able to access. The SQL Server is not a domain controller, but is a member of the domain, and domain logins do work for Windows-login purposes on this box. The problem is that when users try to connect to the SQL server, they are denied access. An error 18456 is thrown, and logged in the Application event log stating "L ...Show All

• Visual Studio Team System Ability to incorporate relational data within TFS fields?

  I would like to add role information to a customised work item. When a user is chosen from a dropdown, I would like the role dropdown to default to the chosen user's role. Currently both users and roles are defined in Global Lists, but I wondered if there was anyway that I could move to a relational model. Can this be done Cool, here is the sample and documentation on custom controls: http://blogs.msdn.com/narend/archive/2006/10/02/How-to-use-Custom-Controls-in-Work-Item-Form.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Definition of XNA

  Hi Did you want to know http://www.newsxna.com ...Show All

• Visual Studio Team System TFS Support in Visual Web Developer 2005 Express Edition?

  Hi, I use Visual Web Developer 2005 Express Edition (VWD2K5EE). If I install Team Explorer then TFS source control will be available in VWD2K5EE IDE Can I connect Team Foundation Server via VWD2K5EE Thanks & Regards ...Show All

• .NET Development sending a custom object to a web service

  hello, i have a web service that containts a method which takes a custom object (say of type food) now i want to to consume this web service from a c# windows app. so when i call this method an error occurs ... knowing that i included a dll class library in both ends(win app and web service) so what can i do kbradl1 wrote: whats the exact error I am guessing that you have an object in your DLL that you are trying to pass to the webservice webmethod. Even though these objects have the same name and properties, VS does not see them as the same type (they are different namespaces) and you are getting a type mismatch error. You can't do this. You need to use the object from the VS generated pro ...Show All

• Visual Basic User logged in from LDAP

  Is there any way to get the current user name who logged in from LDAP I have a local account called 'remote' and all LDAP users log in to the system using this local user.   So every time I try to read the current logged in user it returns the local user which is 'remote' Actually I tried that but the same thing it returns the same thing which is the current local user. ...Show All

• Visual C# Passing Command using shortcut

  I want to allow my application to capture some command that the user can pass into the application by define it in my application's shortcut properties, Shortcut Tag, Target field. Just like microsoft access shortcut, you can assign some command on the access shortcut properties. Is it possible for me to write an application that can capture the command assign in the shortcut using C# I, as I assume most of the others here, am having some trouble understanding what it is you want. What is the form of this "command" you wish to capture. Is it text An object Keystrokes Where is it coming from Do you have complete control over the applications this is for, or are parts written elsewhere &am ...Show All

• .NET Development Invoke a Windows Form from a Windows service

  HI I'm posting this question in this forum cause I consider I need to go deeper into .net to acomplish it. I need to call, show , manage a windows application from a windows service. I know that using System.Diagnostigs.Process I can execute an app but it does not work from a Windows service. The process I want to run is executed but I can see the User interfaz and I can control the methods inside my windows form. My question is How can I manipulate or at least trigger a WinApp from my Windows services Any link Thanks Kenny This is really complex! With Win2000/XP/2003 you can have the service run as local system and check the "Allow access to desktop". Then your app might show up on login session 0. Wit ...Show All

• Smart Device Development UDP Client mobile Client For Communicating to desktop pc

  Hi, I developed the socket client application on mobile and socket server application on the desktop pc using the SOCK_STREAM both application commnunicating through active sync . But when i am creating same application for UDP using SOCK_DGRAM the application can not communicate through active sync . in client app sendto function of the winsock is succeeded (not returning any error ) but data not receive at the server end . Whats reasons is active sync not supporting the UDP socket communication how this can achieve Give me any details to make this possible . Thanks in advance This is "by design" - ActiveSync over serial connections like emulator ...Show All

• SQL Server Encryption and bulk insert

  Hello, I need to build a table with encrypted data with the source data coming from a .csv. The account number from the .csv will need to be encrypted in the final table and I will also need to have a hashed or MAC index on the account number. I'm guessing that I can do this with a stored procedure using a temp table to load the unedited data and then load the actual table from there. The table will be built from a download every evening. The key and certificate for the encryption are already set. I have been able to load data directly to the table providing values. But, I have been struggling getting a bulk insert to work. I'd appreciate any ideas or examples. Thanks! Could you please explain w ...Show All