GhostDev's Q&A profile

• Visual Studio Team System How do you run a webtest programatically from an add-in or VSIP package?

  Can anyone provide C# code that demonstrates how to run a webtest programatically Assume I have a project item which is named webtest1.webtest. Thnx in advance. There's no api for doing this, you'll have to run the test via the command line, mstest.exe using the Process class. Ed. ...Show All

• SQL Server FixedHeader does not work with Zoom "PageWidth"

  Hi, I have built a report with fixed table header - it works fine in IE- in adition wtih zoom 100%, 75% 200% and so on, but does not work with "PageWidth". Seems to be a bug any workarounds (SSRS 2005 SP1) Thanks HANNES ...Show All

• Visual Studio Team System Install TFS (DE) over TFS (EN)

  Hallo! We installed the english version of tfs workgroup edition and now, the german version is available we thought about installing this version. We allready have multiple team projects within tfs. Our plan was to install the german version right over the english version. Can you guys confirm, that’s it’s possible, or not Thx. Hi We got a similar problem. We got some projects on a RC TFS Server and since there is a german version avaiable we want to "move" to that version. We installed the german version (on a different machine; german win2003) and i tried to res ...Show All

• Windows Forms Change label on one form from another forms code.

  This should be simple. I'm trying to change the label on a form from another forms code. I'm using a function in the first form as follows: Public Function WaitIndicator( ByVal intMin As Integer , ByVal intMax As Integer , ByVal intStep As Integer , ByVal strWaitMsg As String ) As Integer frmWait.lblWait.Text = strWaitMsg frmWait.pbWait.Minimum = intMin frmWait.pbWait.Maximum = intMax frmWait.pbWait.Step = intStep frmWait.Show() End Function It is a wait form that I increment from the calling form. The ProgressBar works fine but the label shows up as a blank. I can change the title text o ...Show All

• Visual Studio Express Editions upload XML file into database table

  I'm trying to create a WEB application that allows the user to upload an xml file. This xml file would then be parsed and loaded into a database. Does anyone know of code samples to get me started Thanks in advance. Well, you need to use a file selection control to upload the file. Then, you'd use an XmlDocument to parse the XML, and depending what database, one of the ADO.NET classes to move the data into the database. You may want to apply an XSD first to see if the file is in the format you expect. There are tons of examples on the web for any one of htese steps. www.codeproject.com is also a good site ...Show All

• SQL Server Understanding ADO

  Hello, I want to use OLE DB in my projects. Since I start my work with ADO, I have some troubles and questions.At first, I have MDAC 2.8 SP1 and SQL Native Client from MS SQL Server 2005. Here's list of them: What difference between "SQL Native Client" and "Microsoft OLE DB Provider for SQL Server" I have troubles with understanding API cursors: all my sql-statements always returns Forward-Only Cursor Type. Here's little test about it written in VisualBasic: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Commd As New ADODB.Command Dim Co ...Show All

• Visual Basic Buttons

  Hi, I would like to use round buttons on my forms and wondered if there was a way to do this in Visual Basic Any assistance would be much appreciated. Best regards, Jae Hi, I`m just learning my way around in MVS2005 Express Edition and I need to create a form with : 1. A round red "Stop" button : 16mm dia approx 2. A round green "Go" button : 16mm dia approx At present I only have the choice of a rectangular button from the common controls toolbox. Can I import buttons in or create my own Also I need the apply a 5mm radius to the corners of groupboxes..how can thi ...Show All

• SQL Server How to use Excel to browse cube

  I have created a cube. Now when I open excel so that to browse the cube in the excel pivot table i am getting connection refused error I am using olap 9.0 to connect to my cube which is deployed on the sqlserver 2005 analysis server. server is up and running. ok i found the solution. we need to reregister the olap 9.0 provider before we can use it to connect SQL Server 2005 Analysis Service Cube with Excel Pivot Table : regsvr32 "c:\program files\common files\system\ole db\msolap90.dll" ...Show All

• Visual FoxPro How to perform group by and order by AFTER union?

  Hi, I have a SQL statement like this: SELECT * FROM (    SELECT * FROM A     UNION     SELECT * FROM B) GROUP BY 1, 2 ORDER BY 1, 2 Is there any way to translate it to FoxPro 2.5 compatible Thanks. I think you can use this : SELECT * from A ; UNION ; SELECT * from B ; group by 1, 2 ; order by 1, 2   ...Show All

• Visual C# Splitting a string using multiple delimiter error

  Hi guys, I am using C# express august edition, i get this error when trying to do this string t = "Once,Upon:A/Time\\In\'America" ; char[] seps = new char[]{ '/', '\'}; foreach ( string ss in t.Split(sep2)) Console.WriteLine(ss); it says too many character in character litral what do i do but i have a string that has \r\n\r at its end, and i want to remove that from the upper bound of the arraay, like This\r\n\r, how do i remove it, if i cant use '\' as delimiter ...Show All

• Visual Studio Team System "Review unused parameters" shoudn't apply for deserialization constructor

  ... and for GetObjectData(SerializationInfo, StreamingContext) method as well. What do you think public HandleBoxProperties(SerializationInfo info, StreamingContext context) : this() { // if (settings == null) throw new DeserializationException(); settings = (Hashtable) info.GetValue("data", typeof (Hashtable)); } Andrew, I can't reproduce this, this rule should already ignore these. Can you post the full class Does it implement ISerializable Regards David ...Show All

• .NET Development Problem copying dataset from one Database to another

  Hello, I m trying following code to copy a dataset created from one database to another database. Code runs errorless but data doesn't update in another database. Where am i going wrong Please help private void Page_Load( object sender, System.EventArgs e) {       this .insertDataR(); } //This function returns Dataset public DataSet getDataR() //return Data Set { string conStr="Provider=msdaora;" + "Data Source=abc;" + "User ID=sss;" + "Password=uuu"; OleDbConnection a = new OleDbConnection(conStr); a.Open(); OleDbDataAdapter da= new OleDbDataAdapter("selec ...Show All

• Windows Forms Connection Strings in Machine.Config and Table Adapter?

  Note this question was originally asked by some one else on the ADO forum (not me). However I want to know how to do this as well and he saved me typing the problem! Any ideas I have added a DataSet to my project and then dragged one of the Data Connections from the Server Explorer and dropped it on the DataSet Designer. This gives me a schema to work with. My problem is that I want to use a connection string from the machine.config file and not the connection associated with the Data Connection I setup in the Server Explorer. When I try to modify the connection, the only options to Log on to the server are 1) Use Win ...Show All

• Visual Basic Getting primary key of record just INSERTed

  Hi. What is the best way of inserting a row of data to an SQL Server database and getting the primary key (identity) of the record you just inserted - preferably in as few statements as possible I've not managed to find any examples of this on MSDN. Is there a method that does this without requiring another SELECT statement following the INSERT Thanks, Mark Hi, You could try something like: strSQL="SET NOCOUNT ON; " &_ "INSERT INTO tblOrders (customerID,created) values (" &_ ""&session("customerID")&"," &_ "'" & fixdate(date()) & " " & time() & "');" &_ "SELECT SCOPE_IDENTIT ...Show All

• SQL Server Export and Import Database from Sql 2000 to Sql 2005

  Need help exporting a database from Sql 2000 Exterprise and Import it to Sql 2005 using Sql Developer. I have tried to do a detach - copy mdf & ldf to new syatem and then do an attach - This doesn't seem to work Also tried backup on 2000 and then Resore on 2005. This doe not seem to work. Source system is 64bit and destination system is 32bit Not 100% certain but the problem is probably with the 64bit to 32bit conversion problem.  The binary files are probably incompatible. Try and straight db copy Management Studio by right clicking the on the database | Tasks | Copy DB.  Make sure not use the detach and re-attach metho ...Show All