Fradam's Q&A profile

• .NET Development SQL selecting mulitiple records

  I am try to create a data grid that will select all users with a surname that is stored in a variable that has been entered earlier. The code below is there to quickly check the database to see if there are any records of that surname, the next section which will compile a DataGrid is going to do the rest of the work. I keep getting an error saying that there is a missing parameter, I have tried varying ways to make this work to no avail. I am wondering if it could be because there are potentially more than one record in the database with the same surname Dim customersurname As String = surnameText.Text 'CHECK TO SEE IF A CUSTOMER EXISTS WITH THE ID ENTERED If surnameText.Text = "" Then MsgBox("Please enter a ...Show All

• .NET Development Dataset.datarow parameters

  Hello there, I have a simple question, any answer will be appretiated. I have recorded a set of values in a datatable, i want to read a coloumn value in each row of that datatable and perform a loop operation to run some more queries and get more data from the database. the problem is that i am not able write a loop to implement this code. so need help...if possible a sample code will be useful thank you Saad We need more information. Looping though a datarow is easy enough.. For Each dr As DataRow in Datatable.Rows PerformQuery(dr.Item("ColumnName")) Next but are you trying to put more data in to the same table Maybe you can write the query so that you don't need to loop through the ...Show All

• Visual Studio Express Editions Simple DataGridView question

  Once I have a DataGridView populated with my data, how do I programatically retrieve the data Lets say I have a DGV with 50 rows & 5 columns. I want to loop through it & retrieve the data from each row so I send it to my print page document. Thanks for any help... Is there a way to reference the rows & columns by index numbers For example, can I say give me the contents of row5,column2 in DGV1 ...Show All

• Visual Studio Express Editions How to delete selected row in datagridview?

  Hi, how do I permanently delete selected row in datagridview as well as permanently deleting it in my .mdb file . Thought of using oledbcommand or something but I am still a beginner in C# so not familiar with Oledb. Thanks. private int sn; private double ps = 60.0, odc = 0.62; private double Q, H, op, odp, pdp; string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\FYP\FYP.mdb;User Id=admin;Password=;" ; private void Form1_Load( object sender, EventArgs e) { // TODO: This line of code loads data into the 'fYPDataSet.Pump1' table. You can move, or remove it, as needed. this .pump1TableAdapter.Fill( this .fYPDataSet.Pump1); sn = 1; pump1DataGridView ...Show All

• Visual Studio Express Editions Need help. Im new ;-)

  Please correct me if im in the wrong place. Anyways im new to c# and i like it alot. Ive added what i want etc but here is my problem. I have one of them ToolStrip menu bars at the top (the blue ones with ability to do drop down) Now what do i do so that when a person clicks on one of the menu things it opens another part of the app but not in a new window. Just so the current window changes to whatever they clicked on. Sorry if thats confusing. Let me know and il try to make it clearer. Thanks Dan I'm not very clear about what you have encountered. Hope it helps: http://en.csharp-online.net/Tool,_Menu,_and_Status_Strips%E2%80%94ToolStrip_Menus BR ...Show All

• Visual Studio Team System TF30177: Team Project Creation Failed

  Hi, I've encounter this error and can't seem to get past it. I created team projects in the past, so I'm not sure what has changed. Can anybody help Here's more info on the error: Error TF30170: The plugin Microsoft.ProjectCreationWizard.WorkItemTracking failed during task WITs from group WorkItemTracking. Explanation Plugin error text: “Could not find stored procedure 'BoxCarIdentityChanges'. ---> Could not find stored procedure 'BoxCarIdentityChanges'. ---> Could not find stored procedure 'BoxCarIdentityChanges'.” User Action Contact your Team Foundation Server administrator. Here's the log file that was generated when trying to create the team project: 2007-01-11 16: ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX Extensions for Alias Maya 7

  When will the export X for maya 7 be released Or is there a way to convert 6 binary or 6.5 binary too work with 7 I've done the same but i get a host of errors specifically related to the .x format in maya. ARe you seeing any of these errors or is it pretty much error free ...Show All

• Visual Studio Team System TFS31002 error

  When I try to connect to our newly installed team foundation server I receive the general error TFS31002 stating that I cannot connect. I'm using the account which i used to install TFS but it just doesn't work. We are using the official version of TFS (so no beta of RC). When I navigate to the url http://<server>:8080/services/v1.0/ServerStatus.asmx i receive a login box. after entering the same credentials as above i see the content of the asmx page. Is there anyway I can troubleshoot this problem. Kind Regards Patrick Severijns I am deeply ashamed to tell you the problem is solved. It turned out that the team system client was not the release version but the beta 3. Someone forgot to pl ...Show All

• .NET Development Thanks, but my question was different

  I am trying to run an application (Smartermail, a mail server built on the .NET framework), which uses a .NET component to manage its TCP connections. The application does not specify a local port, so apparently the component chooses one it considers open, from the range of 1024 to 5000 I think. Is there any way, as an administrator of the machine, I can predict, constrain, or influence what port will be chosen For example, how does the component decide a port is open Can I configure the machine to declare all but a few ports closed, so the component will always choose the ones I want it to use Can the component itself be configured at the machine level Is there some other utility in Windows 2003 server, the platform in questi ...Show All

• Visual Studio Team System Cannot databind a csv file

  I am trying to databind a csv file to a webtest. I am entering the connection properties as "Microsfot Jet 4.0 OLE DB Provider" and advanced extended properties as "Text" and entering the path of the folder in which the .csv file is located. I am not including the name of the .csv file in the path. No tables show up after the data binding is done, a blank "Choose tables from datasource" box appears. This happens no matter how many times i try. The same functionality works on a different system. Any ideas are appreciated....Thanks! I tried doing that option too, creating a new folder with just the .csv file in it, tried at different places, like on a share and also on the lo ...Show All

• Windows Forms how to change the layout of the form

  Hi, it seems we can change the background color and image of a form. However, I could not find how to change the whole layout of the form...that is, how to change the color of the top strip with "minimize/maximize/close" on the right.. It will look strange or not consistence if I change the background image and color with the original top strip... Besides, there are 3 forms in my application, how can I use the methods and values from one form to another The 3 forms are different... Also, how to make one form minimize when I load another main window Since there are 3 forms, I want to put them in suitable position on the screen, how to change the form's loaction Thanks a lot! I simply solved my probl ...Show All

• Visual Studio Express Editions Reversing a list order

  Hi there. Does anyone know how to reverse the order of a list. I have a column set up of names. How can i select this list and have it reverse the list in a separate column. I dont want it reversed alphabetically, or numerically... my example would be this... Cell A1 - A5 Paul Barry John Steve Jim i would like to either select the 5 cells and have click a button to reverse this order, or have it return the reversed order in column B1 - B5... giving me the result of Jim Steve John Barry Paul The only way ive seen how to do it is with the offset function but ive had alot of trouble with that for some reason and hoped someone had an idea. Thankyou! These forums are for VB.NET questions. ...Show All

• SQL Server Data Conversion Error on Excel Destination

  I am inserting rows using OLEDBDestination and want to redirect all error rows to EXCEL Destination. I have used Data Conversion Transformation to Convert all strings to Unicode string fields before sending it to Excel Destination. But its gives the following error. [Data Conversion [16]] Error: Data conversion failed while converting column 'A' (53) to column "Copy of A" (95). The conversion returned status value 8 and status text "DBSTATUS_UNAVAILABLE". [Data Conversion [16]] Error: The "output column "Copy of A" (95)" failed because error code 0xC020908E occurred, and the error row disposition on "output column "Copy of A" (95)" specifies failure on error. An error ...Show All

• SQL Server SQL Server 2005 and SQLMAINT.EXE with no output

  When starting SQLMAINT.EXE from the command line on a SQL Server 2005, I get no useful output at all: >sqlmaint.exe / See SQL Server 2005 Books Online topic: sqlmaint Utility http://msdn2.microsoft.com/en-us/library/aa214022(sql.80).aspx ...Show All

• .NET Development XPATH : How do I implement a better code ??

  Hi Folks, Here is the Environment context for the problem: Development done in VS 2003 using .NET Framework 1.1 Problem: We are trying to implement a product whose C# business logic uses XPATH for data manipulation( Please don't ask me why but consider this as a constraint) The problem is that with a bunch of developers and no coding statndards , we have created a very messy code with string variables and XML node being created as and when required. In order to avoid this in future , I want to create a helper class where I can have all the XPATHS for the XML document declared as static final strings. So then I can use XmlNodeList vehicleNodeList = this .ISOSSINode.SelectNodes(Static final string) instead of XmlN ...Show All