SIYAULHAQU's Q&A profile

• SQL Server Transform data task (DTS2000) and SSIS

  My first period using SSIS in a real-world application convinced me that there is a lack of support in migration of SQL2000 DTS packages, expecially in a star schema transformation scenario. Most of my actual DTS packages are combinations of SQL Execute Task and Transform Data Task. 90% of Transform Data Task are so composed: - SELECT from Data Source - mapping from source to destination with "copy column" (source and destination columns have the same name) - SQL Fast Load with a defined batch size (1000 or 2000 tipically) and Table Lock - Log to text file of source and destination rows that fail transformation (tipically when I try to put ...Show All

• .NET Development how to implement login from code to other site (hidden login)

  hi there , i want to login to another site using httpWebreqwest & httpWebResponse classes & i used the falwing code : public string Crawl_UsingPost(string postData) { req = (HttpWebRequest)WebRequest.Create(url); req.Method = "POST"; req.Credentials =new NetworkCredential(username,password); req.ContentType = "text/html"; req.Headers.Add("username",username); req.Headers.Add("password",password); req.PreAuthenticate=true; req.Pipelined=true; req.ContentLength= postData.Length; CookieContainer cookies = new CookieContainer(); req.CookieContainer=cookies; req.KeepAlive=true; StreamWriter stOut = new StreamWriter(req.GetRequestStream ...Show All

• .NET Development Establishing a connection... TCP/IP ___

  Hello friends , I am new to vb.net and need help in sockets. I need to create an application (console) which will act as a server. Then I will have clients that will connect to the server and send data to the server.    1) Client connects to server 2) Client sends data to server 3) Server processes data 4) Server send back data to specific client (as there will be more than on clinet at the same time) My problem is how to establish a connection and how I can have 10 connections at the same time with the server communicating back to a specific client (probably using an ArrayList) Can someone please help Thank you MeRovingia ...Show All

• Visual Basic Iterating through text boxes using loops

  **This is copied / pasted from the "Language" forum. **Moderator please leave this post here and delete the other if necessary. I'm writing a program for class (so please don't help TOO much with the logic) but I'm not familiar with all I can do with VB yet. The program is a window with 10 virticle text boxes with corresponding labels. These represent the floors of an elevator. Each text box is prepopulated with a number representing people. The elevator needs to start at the first floor, go up, stop at each floor, fill to its capacity and go back down. It then "drops the people" off on the first floor. First ...Show All

• Visual Studio Express Editions Desktop Shortcuts for Application

  Hi, When packaging an application I cannot find any option that allows the creation of desktop shortcuts, has this facility been removed from Express Thanks Jae It never was in the Express version. You will either have to create your own installer (many third party installers, free and for fee), or upgrade to Visual Studio. ...Show All

• Visual C# Shortcut

  Hai, I am working with a project developed in Visual Studio.Net 2003 under Windows XP.I have assigned short cut to the textfields and buttons with "&" in front of the letter,which should be used as the shortcut key. When the window gets displayed,the letter which can be used as short cut is not underlined which must be the case,but the shortcuts are working. But surprisingly when i just press the "Alt" key the letters will be underlined.Could anybody explain me what i did wrong or why it happens Has that anything to do with the version of the program Thanks n Regards swingme Thank u Daniel for ur repl ...Show All

• .NET Development SignedCms.ComputeSignature() gives "The recipient certificate is not specified" exception

  The following code gives: An unhandled exception of type 'System.InvalidOperationException' occurred in System.Security.dll Additional information: The recipient certificate is not specified. SignedCms cmsMsg; ContentInfo cInfo; byte [] content; content = new byte [] { 0, 1, 1, 2, 4, 6, 6, 23, 123 }; cInfo = new ContentInfo (content); cmsMsg = new SignedCms ( SubjectIdentifierType .IssuerAndSerialNumber, cInfo, false ); MessageBox .Show( Environment .UserInteractive.ToString()); cmsMsg.ComputeSignature(); What do I need to do to make it pop a certificate selection window and proceed with signing Why and wh ...Show All

• SQL Server OLE DB or ADO?? plz give me a suggestion!

  i am learn database access with native vc++, so ADO.NET is not electable for me. i wonder whether i should study OLE DB first or ADO. i've been working with ADO under VB for some time, it's very simple to use. but i dont think it's the best choice for vc++, i think it's OLE DB. but OLE DB is really difficult, too many interfaces, and properties!!! could u give a suggestion should i learn ADO with vc++ first and then OLE DB, or sould i learn OLE DB directly yes, i want to be a COM expert! but the OLE DB interfaces are really difficult for starters, however, ATL make it much easier to use! i think i can use thos ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I need some spiritual DirectX guidance.

  I've been learning from a book titled Tricks of the Windows Game Programming Gurus by Andre' Lamothe. It's outdated using DirectX 7.0a SDK, and I believe his second volume creates software rasterization with DirectX 8.0 SDK. I really enjoy his books because it is very in depth and low leveled. My question is should I continue reading it if I'm geared on becoming a professional in graphics Since 60% of our life is maintaining and upgrading previous games/multimedia, especially MMORPG games that have a long life, you'd be working with older SDK versions, no matter if it's DirectX or not. The idea is to learn this now and migrate over to D ...Show All

• Visual C# C# adding a record to an access Database

  DataRow dr = _dsComment.Tables[ "Comment" ].NewRow(); dr[ "OrdNo" ] = _Order; dr[ "Name" ] = UserName; dr[ "Date" ] = System. DateTime .Now.ToShortDateString(); dr[ "Comment" ] = frm.Comment; _dsComment.Tables[ "Comment" ].Rows.Add(dr); OleDbCommandBuilder cb; cb = new OleDbCommandBuilder (_DaComment); _DaComment.Update(_dsComment, "Comment" ); I already filled the dataset on the form load event. I am getting an error saying Syntax error in INSERT TO statement.  I thought that the commandbuilder builds those commands.   I am trying to add a new record to a database table which is in Access.  ...Show All

• Windows Forms default toolbox tab for usercontrol

  Is it possible though an attribute or any other way to specify the default tab for a usercontrol to be added to the toolbox instead of defaulting to the "Windows Forms" tab  I am developing an application that implements many user controls and I would like them grouped together in the toolbox instead of mixed in with all the standard controls ...Show All

• SQL Server Smart App to Endpoint Kerberos Authentication

  We have a smart app client application that leverages SQL Server Endpoints for data access. Clients use this application from several cities in the US across a corporate WAN. The endpoint is secured using kerberos authentication. Users of the application are added to a domain group which is granted rights to the endpoint. Procedures in the database are granted to a SQL role, and the domain group has been added to the database as a login and added to the role. Everything works fine for users in the home city where the data center resides. The problem is that when users from a remote office try an connect up, there is anywhere from a 15 ...Show All

• Visual Basic Webbrowser Control - Add Html Code or detect scroll

  Hi, I am trying to use a Webbrowser control which loads our Intranet page but need to detect that the user has scrolled to the bottom of the page. Can it be done The idea is that the user is forced to scoll to the bottom of the page and then a Button will be displayed from which they can launch our ERP application. We use the intranet page as a means of communication between Head Office and our branches but want to ensure that the user scrolls through the page. Once they have reached the bottom I would then like a button to appear, not necessarily in the Browser, but on a panel in the windows form. Then they can click on the button and ...Show All

• .NET Development Multithreading on database server side

  Hi, should I take a care of threading synchronization when accessing the database I mean, what happens if one thread executes SELECT and the other one DROP at the same time What about transactions If I have transaction, some DROP and DELETEs within it, isn't it possible that both fails if executed parallely Thanks. The database is designed to handle all this for you. Think about it. There is no difference in having a single application with 2 threads and 2 applications with one thread as far as this goes. Databases are designed to handle concurrent requests from 1000s of clients. The database handles th ...Show All

• Visual C# C# and Lotus Notes

  Does anyone have any suggestions for using C# to do a lookup in Lotus Notes address book Any Help would be apppreciated Thank You It's actually very simple. Create a new project in VS.Net 2003/2005. Add a reference to to Domino to it (right click on the References in the Solution Explorer, switch to the 'COM' tab, locate "Lotus Domino Object" and click OK). Now in your code add a 'using Domino' statement on top of your class. In your method you can now create a new NotesSession object as follows: NotesSession session = new NotesSession (); session.Initialize( "" ); NotesDatabase db = ses ...Show All