SknkWrkngGrp's Q&A profile

• SQL Server Dynamic FTP Connection

  Hello , I have a table having different ftp url,user name, passwod, port no.I want to copy the file from all the location on my server at. How can I change the connection string/ FTP location for FTP connection manager at rum time in SSIS. Thanks Have you set a breakpoint in the Script Task to verify that the FTP Connection Manager properties are being set to the correct values for each iteration of the loop Once you have dynamically configurated the ftp connection manager in the Script task then the FTP Task itself should have its IsRemotePathVariable set to True and then set the RemoteVariable to the variable which is mapped during the loop. ...Show All

• Windows Forms How to Change color of one Column in a Datagrid

  Hi, I'm Using C#.Net windows Form on VS.NET 2000. (DataGrid Control) 1. I am working with a datagrid and i want one of the columns background color to be red. How to achieve it. For eg; if i am having 15 columns, i want the 6th coloumn BGcolor to be in red at the time of form load event. 2. I want to access the datagrid's built in scrollbar. actually the scenario is i am having 15 columns in the datagrid. The horizontal scroll bar should start from the 5 the column rather than from the first. so that the first 5 columns remains static and the balance columns scrolls. it will b high helpful if provided with sample coding. tu. Hi, If you use DataGridView, I would suggest that several scroll properties are very useful: Firs ...Show All

• Visual C++ ComboBox

  Hi , I have a simple comboBox, and I want to read from a database the written value of an element and assign this value as the selected value of the combo... I tried like this way ,but it doesn't work: * test = a command which return an integer from the database combobox.SetCurSel(test); Have you any better idea, Thanks a lot I think you have first to find the index of the item. This can be done with FindStringExact member, then call SetCurSel . For instance: int value = ReadFromDatabase(...); CString s; s.Format(_T(“%i”), value); int index = combobox.FindStringExact(-1, s); combobox.SetCurSel(index); Note that items are numbered in zero-based manner. I hope this helps. ...Show All

• Visual Studio Express Editions how to use a custom cursor (.cur)

  I have made a .cur file and have embeded it in my.resources so I can easily acess it from in my code but I don't know the correct syntax. Whatever I try never works. Can someone please tell me the few lines of code I need to use my cursor Thanks for the code SJWhiteley , it worked! Dim m As New System.IO.MemoryStream( My .Resources.crosshaircur) Me .Cursor = New Cursor(m) This is the exact code I used. ...Show All

• Windows Forms Combo Box Items Value

  Hi Guys, I wanna have a combo box that returns a value other then its text to its data source. Basically, I have a textbox that has the values 'Male' and 'Female' and I have it bound to a datasource and I want it to return a value of just m or f. Any ideas Thanks in Advance That is what the combobox's ValueMember is for. ...Show All

• Visual C# Using GDI+ to shape forms

  Could someone help me with some code or tutorials on how to shape my form at the top right and top left ...Show All

• Visual C# HELP!!! Unresponsive keys in IDE! All of the special keys, including ENTER, DELETE, Arrows, etc! Very weird!!!

  I'm getting nuts with this! Suddenly, 2 days ago, my Visual Studio IDE stop responding to any control key (Enter, Insert, Delete, the Arrows, Home, End, Page Up, Page Down, all of them!), but still types in any other alphanumeric key (including the numbers in the keypad with NumLock on) Obviously this makes editing impossible, and is making me go out of my mind! This happens with any file type, in any language, even txt files, but only in Visual Studio’s IDE (even god old Notepad behaves perfectly normal and recognizes all keys) I’ve already done everything I could think of, including uninstalling and reinstalling Visual Studio several times (in one of them I “hunted”, and destro ...Show All

• SQL Server replication hangs on one table

  publisher - sql2000 sp4 distributor - sql 2005 sp1 subscribers - mix of sql2005 sp1 and sql 2000 sp4 we have a database with around 300 tables and replicate it to around 10 different subscribers. some in the same datacenter and others in different offices. We have around 50-60 different publications for this. Some have 20 or so tables others have only one table if they are large tables. Tables range in size from a few hundred rows to over 20 million. Some tables replicate a few commands, others 100000 or more commands on a daily basis. Around 6 weeks ago we started having problems with one table. It's 1.4 million rows and replicates around a few thousand commands on a daily basis. We saw a backlog of around 150000 to 400000 commands. We ha ...Show All

• Visual Basic How can I clear the clipboard using VB coding?

  Hiiiiii. Can someone tell me a code which will enable me to clear the clipboard completely after use in a particular application I would be very grateful if you could give me the code in VB 6 version. Thanks and regards, Arun A quick bit of Googling turns up this page with code. Please note though that these Visual Basic forums are intended for discussion related to the .NET versions as the VB 6 (aka VB Classic) is no longer supported, I'd suggest taking a look at one of the VB Classic forums out there. ...Show All

• Visual C++ wating progressbar

  how can i create a wating progress bar or busy progress bar where the progressbar dont now when the work will finshe in mfc c++ do i need to use the CProgressCtrl or another way thanks Yes, Marquee style ( PBS_MARQUEE   progress bar style in C++) is the way to go but watch out that it is only supported on Windows XP and later (it also requires comctl32 version 6.0 so you need to have a manifest for your app).     ...Show All

• Visual C# connect SQL server 2005 to Visual C#

  Hello everyone... Pls help me to connect SQL server 2005 to visual C# in Windows Application. I have already the database... Thanks. Ron. SQL server instances are installed as "default" instance or "named" instance (SQL express by default is installed as a named instance). A default instance's server attribute looks like: yourmachinename or just a . (dot) Where a named instance looks like: yourmachineName\InstanceName or: .\InstanceName Given this info an SQLExpress installtion typically have a connection string as (if using SqlClient): string strCon = @"server=.\sqlexpress;Integrated Security=SSPI"; with an OleDbConnection: string s ...Show All

• Visual Studio System.IO.FileNotFoundException: File or assembly name CrystalDecisions.CrystalReports.Engine, or one of its dependencies, was n

  I have an application done with Vs.2003 and I want to access report over the network,for this I used crystal report which integrated in vs.net 2003 on my post the crystal report run normaly but over another post on the network it gives me this message System.IO.FileNotFoundException: File or assembly name CrystalDecisions.CrystalReports.Engine, or one of its dependencies, was not found. I try all the solution that I found on the help of Vs.net 2003 I had the crystal report Merge Module on my setup application I had the .exe file of my application file in the shortcut Add-File in the Application Folder,I also used the .Net wizard to trust the assembly over the network I create embedded report .All function on my pos ...Show All

• SQL Server Odd null behavior

  I am writing an upsert proc that should detect the change in state for a record. The change in state happens when a particular date field (default null) is populated. However, I can not get a record set that detects the changes properly. Here is an example set ANSI_NULLS on go create table #t1 ( ID int, DateField datetime ) create table #t2 ( ID int, DateField datetime ) insert into #t1 (ID, DateField) values (1, '7/20/2006') insert into #t2 (ID, DateFIeld) values (1, null) select * from #t1 join #t2 on #t1.ID = #t2.ID where #t1.DateField <> #t2.DateField drop table #t1 drop table #t2 The select should return a record because NULL does not equal '7/20/2006' but it doesn't. What am I missing Thanks in advance. ...Show All

• .NET Development how to solve this connection problem

  hello... when i open my connection(sql connection ) am geting this problem... can any one tell how to solve this An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) am using sql server 2000 for my database am getting this error how to solve this.. plz help me Try to enable remote connections at the SQL Server. See next screenshot about it at http://www.sqlserver2005.de/SharedFiles/remoteconnection.jpg Next blog could help as well http://blogs.msdn.com/sql_protocols/arc ...Show All

• SQL Server SQL Express and SQL 2000

  Hi We are new to ASP.Net, but have a lot of experiance with relational databases. We have developed a web application that goes against a SQL 2000 database which works very well. We now would like to impliment the ASP.Net 2.0 login tools to control and manage access to the website. In doing so, a new database is created using SQL Express. Everything works fine until we deploy to the host. Then the login connection does not work. I get a connection error #26. The host only runs SQL 2000. Questions: Is there a way to run both Is there a way to convert the ASPNETDB.mdf database and publish it to the host Can I set up ASP.Net to create the login database in SQL 2000 Any help will be greatly appreciated. Rick Damselfly Solutions Inc. ...Show All