Grant Holliday's Q&A profile

• Windows Forms datagridview currentrowindex and select & Unselect

  hi in old days i used datagrid and currentrowindex to navigate recordes in datagrid , but now i want to convert from datagrid to datagridview but i found some properties are not the same her is my function i used: private int iRowIndex; private void fnSelectUnSelectCurrentRowIndex( int num1, int num2) { this .iRowIndex = this .dataGrid1 .CurrentRowIndex ; this .iRowIndex = this .iRowIndex + num1; this .dataGrid1. Select ( this .iRowIndex); this .iRowIndex = this .iRowIndex + num2; this .dataGrid1. UnSelect ( this .iRowIndex); } i still missing these static methods is there something equal Hi, Mohamed Assaf Use statement like this: this .dataGridView1.Rows[1].Sel ...Show All

• SQL Server Oracle 7 query

  Within a VS 2003 BI project, I can create a parmeterized query against an Oracle 7 database by using a for the parameter(s). Example: SELECT LTrim(RTrim(SWO_ISS.REF)) ACCT, CUS_LOC.NAME CUSTOMER, SWO_ISS.TRAN_DATE, SWO_ISS.ITEM, ITM_DESC.ITEM_DESCRIPTION, SWO_ISS.QTY, LSTPRC.AMT FROM MYDB.SWO_ISS, MYDB.CUS_LOC, MYDB.ITM_DESC, (SELECT LP.ITEM, LP.REVISION, LP.AMT FROM MYDB.LIST_PRC LP WHERE LP.EFFEND > SYSDATE) LSTPRC WHERE SWO_ISS.REF = CUS_LOC.CUS_LOC(+) AND SWO_ISS.COMP_ITEM = ITM_DESC.ITEM(+) AND SWO_ISS.COMP_ITEM = LSTPRC.ITEM(+) AND SWO_ISS.COMP_REV = LSTPRC.REVISION(+) AND SWO_ISS.REF = AND SWO_ISS.TRAN_DATE >= TO_DATE( ,'MM/DD/YYYY') AND SWO_ISS.TRAN_DATE <= TO_DATE( ,'MM/DD/YYYY') Unfortunately, as soon as the dataset is ...Show All

• SQL Server File System Task Error - Process in use

  Hi, In the integration services package i'm working on i connect to an excel database and have two data flows which deal with two work sheets in the excel spreadsheet. The data flows do some transformation and then write the data out to a SQL database (two differnet tables). This is all working great however what i want to do once both data flows are complete is to move the directory which contains the current file that is being looped through. At present there is a foreach loop going through a number of directories. I have tried to implement the File System Task object to move the directory but get the following error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file be ...Show All

• Windows Search Technologies highlighting seach terms

  Hi, How can i highlight the search terms in the results Thanks, Ariel Ariel, You can see highlighted search terms in email results if you install WDS version 3.0 and are using Microsoft Office 2007. Unfortunately, there currently isn't a good way to see highlighted search terms in all results. On the brightside (no pun intended) we are looking at adding the highlighting fucntionality in later versions of our search technology. Paul Nystrom - MSFT ...Show All

• Visual Basic Getting "project location not trusted" with downloaded project but not after renaming it.

  If I download a project and add it to an existing solution and save/reload the solution, I get an error that the location is not trusted. However, it's not that LOCATION that's a problem, because if I resave the project with a new filename, the error msg goes away. (Also, I've applied the fixes for the location being untrustworthy). Any thoughts as to why this would be This has already been discussed here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=478711&SiteID=1 ...Show All

• SQL Server Loops and building comma delimited strings

  The problem: I have 2 tables, with a one to many relationship - lets say customers, and order items. Each order record has a field that is meant to be a comma delimited list (they are reference numbers) that is driven by the quantity field. So, say in the order record, an item has a quantity of 3. The reference number will look like this: 1, 2, 3 And if the next order item for that customer has a quantity of 4, the reference number value is 4, 5, 6, 7 And the final item with quantity of 2: 8, 9 Reference numbers can either be auto assigned (and are in my web application) or manually set. If manually set they will NOT be numeric. In my web application, it is possible for users to return to a customer's order and ...Show All

• SQL Server Transforming Tables in Sql 2005

  Does anyone know how i can transform the following table: ID Name StartQuantity EndQuantity Price 1 Title1 1 10 2.55 1 Title1 11 999999999 1.35 2 Title2 1 10 2.55 2 Title2 11 35 1.55 2 Title2 36 999999999 0.55 3 Title3 1 999999999 5.55 4 Title4 1 10 2.32 4 Title4 11 999999999 2.00 5 Title5 1 999999999 1.99 Into multiple tables like so: ID Name 1-10 11+ 1 Title1 2.55 1.35 1 Title4 2.32 2.00 ID Name 1-10 11-35 36+ 2 Title2 2.55 1.55 0.55 ID ...Show All

• .NET Development Finding difficulty reading from xml file

  Hi all, I'm trying to read an xml file. I'm using xmltextreader for this purpose. I don't want to use XmlDocument. From this xml file, i want to get the details of all the entity node into an entity object with all the information from the xml file. Now my problem is while using xmltextreader, i'm not able to get all the details of the attributes and childnodes of the current node. So how do i do it The structure of the xml file is something like this: <Entities> <Entity Name="" MappindId="" TableName="" TableOwner=""> <Properties> <Property> <ColumnName></ColumnName> <IsPrimaryKey></IsPrimaryKey> ...Show All

• Windows Forms Datagrid rows remove at problem

  Dear All, I have a small form where there is several text box n a submit button. When I click the submit button the values are populate into a datagridview using dataGrid.rows.Add method. Then I also have column of checkbox where user can select which of the rows to be delete. Thus I run a for loop to determine which of the checkbox is checked and by using dataGrid.Rows.RemoveAt() I perform the delete. The problem is over here. For example I have 6 items and I select item 5 and 6. During the for loop first item 5 gets deleted and then the datagrid size becomes 5 and item 6 cant be delete How can I solve this problem of the datagrid refresh Hope some one can help me pls. Thanks in advance. For ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. lame....

  Well....finally downloaded it about 30 min ago and all its good for is making u mad.....doesnt know how to do anything but crash.....biggest disappointment ever. i know i was dealing with that a**hole........anyways......i cant run spacewars for example..if i run it with debugging it says nosuitablegraphicsdevice which i dont understand cause im pretty sure my graphics card supports shader model 2 or whatever.....and if i run without debugging it just says spacewars has encountered an error.... ...Show All

• SQL Server Cannot show the editor for this task. Specified cast is not valid

  This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM =================================== Cannot show the editor for this task. (Microsoft Visual Studio) =================================== Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT) ------------------------------ Program Location:    at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()    at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()    at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()  & ...Show All

• .NET Development getting info from a database

  I am trying to get info from a database, this info will be stored in variables, my question, is there any difference with binding the data to a variable that binding the data to a textbox for instance. well it depends on how you want to present your data. There are many ways of doing what you are asking. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=753872&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=691305&SiteID=1 one would be getting the data and filling it into a dataset then bind that to a datagridview as shown above or bind it to a textbox: Me.theTextBox.DataBindings.Add("Text", theDataSet.Tables(0).DefaultView, " FieldName ", true, DataSourceUpdateMode.OnPropert ...Show All

• Visual Studio Express Editions Can't find compiled program

  I compiled the Hello World program with no erors, but i can't find the .exe file for the program Kyle Mck, Do you know where you stored the whole project If you stored the project bu default, the folder is in the following path: C:\Documents and Settings\[Your Login Name]\My Documents\Visual Studio 2005\Projects When you open it, you will find many folders which contains all the projects you have compiled. For example, if you project is called HelloWorld, the exe file is in HelloWorld\HelloWorld\bin\Debug. Use the command line of SDK Command Prompt, when you compile the project here by the cvb command line, you will also get the exe file in this folder: C:\Program Files\Microsoft Visual Studio ...Show All

• Visual Studio Express Editions Calculation Question

  I'm trying to do a calculation/query that will allow me to give a name to X,Y coordinates. I have a grid that is spaced evenly 10 units and each line has a name ie. A,B,C 1,2,3, etc. I have an xml file that has coordinates and I want to calculate how far one point is from the closet 2 grid lines. I was thinking I could add/subtract a distance from each grid line to this point and then has an IF statment that somehow figures out which one is the least. Some projects may have hundreds of Grid lines and hundreds of points that need to be calculated, so I wanted to see if anyone else has a better idea or if Visual Basic has some kind of built in tool to make this work. Thanks dustinto, Have you considered sort your grid page Or why do ...Show All

• SQL Server Not quite right...

  We keep a database of events that are classified by severity. I've got a good, efficient query that gives me the grand total for these events. And I have a bad slow query that breaks down the information into daily totals. My fast query will count the totals for 3213586 events in 4 seconds. The slow daily query takes about 60 seconds for each day. Please help optimize my slow query! ------ Database schema is: Column Name Data Type Length Allow Nuls 1 msrepl_tran_version uniqueidentifier 16 0 0 [time] GMTtime (int) 4 0 0 msec int 4 1 0 offset GMToffset (smallint) 2 0 0 type nameType (varchar) 15 ...Show All