SarahB's Q&A profile

• Windows Forms joining two data DataTables In DataGrid

  I have two data tables  user DataTable: col1= USER_ID  ; col2= USER_NAME order DataTable: col1= ORDER_ID ; col2 = USER_ID ; col3 = PRODUCT_NAME I would like to show the order Datatable in DataGrid with USER_NAME instead of the USER_ID,  how can I do it how can I make the DataGrid show the following fields UserName ; OrderID ; ProductName ...Show All

• Visual Basic Available Training

  This is probably not the right forum for a training question so please point in the right direction.  How do I identify classroom training possibilities for VS2005/ SQL Server 2005 , 2.0 framework, etc for my local area (Seattle)   Thanks, Fred Herring Free for a limited time E-learning classes https://www.microsoftelearning.com/visualstudio2005/ Find training http://www.microsoft.com/learning/training/find/findcourse.mspx ...Show All

• SQL Server SQLiMail - Database Mail

  Hi I am trying to send a mail using database mail. I have enabled it using Surface Area Config for Features and and set up a default public profile usind Management studio. When executing USE AdventureWorks go DECLARE @QueryResult varchar ( 100 ) SET @QueryResult = 'Number of contacts: ' + CONVERT ( varchar ,( SELECT COUNT (*) FROM Person . Contact )) EXECUTE sendimail_sp @profile_name = 'SQLServerProfile' , @recipients = 'alexander.pajer@webvision.at' , @subject = 'Test' , @body = @QueryResult I get an error Msg 2812, Level 16, State 62, Line 7 Could not find stored ...Show All

• Windows Forms how to group items in the listview?

  i want it to look this way group 1 item 1 item 2 item 3 group 2 item 1 i've tried the msdn sample but i get errors, Items.Item ...Show All

• Windows Forms DataGridView - slow

  Hi, this DataGridView is really giving me headaches like you can see in all the topics I start :) This time it's about performance. I'm using a DataBound DataGridView and performance for painting on it, etc. is good as long as it contains no data :) However, as soon as I load 10 columns in it with about 200 rows, performance really drops. Resizing the form that contains the grid becomes real slow even with column auto size off. Painting selection rectangle over columns becomes real laggy, etc. Anybody got some ideas why this could be the case Or is that "to be expected" Thanks, Tom   MortenFraMoss w ...Show All

• Microsoft ISV Community Center Forums Can anyone download VS Team Edition?

  We are a Certified Partner with the ISV Competency. The ISV Competency gives us a license for Visual Studio 2005 Team Edition for Developers but, we can't download that or the Team Server from MSDN. We can download the evaluation editions but not the real thing. Is this a problem for all partners with the ISV Competency or just us Can anyone download the real editions of Team Foundation server and/or VS for Developers Thanks, John Vottero I found a similar thread in the microsoft.public.msdn.general forum. The topic was closed but I was able to contact an MSDN Lead Program Manager directly. T ...Show All

• SQL Server Simulating ORACLE SEQUENCES

  In order to replace an Oracle DB with SQL-Server 2005 i've to find a substitute for the DB-Object "SEQUENCE" used in ORACLE. I tried it with a trigger and a stored procedure. But in both cases the stress-test failed. In case of the trigger the requests blocked each other. In case of the stored procedure "unique" numbers have been assigned twice to the requestors. Main problem may be the fact, that i can't read and write within one command-statement. If I use recordsets with pessimistic locking from my application I've some deadlocks making my Application stall. How can I simulate ORACLE-Sequences in a reliabl ...Show All

• Visual C# ArrayList Error

  Im using the listboc control from the sampleFramework using directX and I want to create a remove function that will remove a string object from the listbox but I keep geting this error System.InvalidOperationException: Collection was modified; enumeration operation may not execute. at System.Collection.ArrayListEnumeratorSimple.MoveNext() here is the code I did public void Remove( string s) { int i = -1; foreach (ListBoxItem li in itemList)<---the error is thrown here { i = i + 1; if (li.ItemText == s.ToString()) { itemList.RemoveAt(i);   scrollbarControl.SetTrackRange(0 ...Show All

• Windows Forms Change Font Color While Typing

  How do I change the font color on a rich textbox while I'm typing If you handle the TextChanged event, you can parse the text whenever you type something. -Ari ...Show All

• Visual C# Writing value to Immediate window affects the actaul program?????

  Hi, Writing some values to the output window affects the actual data. What happened is I've one dataset component and I set it's FillOnRequest=false. (if it's false, then i need to call dataset.Fill() explictly) But when i called that method it doesn't fill with data. But if I set break point on that line of code and I write 'dataset.Table[0].Rows.Count' in the Immediate window. After that data are filled in the dataset. So I was wondering the code that we write in the Immediate window acutally affect the application Any help is appreciated.. Thanks Julia168 Yes it does a ...Show All

• Windows Forms Clickonce deployment error trying to download

  I am getting the following error when I tried to install a Windows application using clickonce deployment The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.1.2 {version} Running checks for package 'Microsoft Data Access Components 2.8', phase BuildList Reading value 'FullInstallVer' of registry key 'HKLM\Software\Microsoft\DataAccess' Read string value '2.81.1117.0' Setting value '2.81.1117.0 {string}' for property 'MDACVersion' The following properties have been set for package 'Microsoft Data Access Components 2.8': Property: [MDACV ...Show All

• SQL Server knowledge about SQL Server Express

  I don't have any knowledge about SQL Server at all... I wanna know: 1. What is SQL Server 2. Have SQL Server something to do with databases and Microsoft Access to do 3. What is the link between Visual C++ Express Edition and SQL Server Express Edition 4. Where on the web can I learn (tutorials) how to use SQL Server Express Edition 1. What is SQL Server SQL Server is a DataBaseManagementSystem used to store and manipulate data. 2. Have SQL Server something to do with databases and Microsoft Access to do SQL Server and Access are both DBMS. SQL Server is just a much or advanced DBMS. 3. What ...Show All

• .NET Development Is Typed DataSet is better option than DataSet in a large Enterprise application

  hi there, Me and My team is currently in a process of desigining an enterprise application. Basically it is a web based nTier application. At this time I have to take decision which option is better "DataSet or Typed Dataset". I know both have there own pros and cons. I also already studied many articles like http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnbda/html/BOAGag.asp . So from you i just wants to know which option is better for Enterprise level application and why Regards, Farukh.  Typed DataSet is derived from a DataSet . As such, it inherits all the methods, events, and properties of a DataSet . ...Show All

• .NET Development DataGrid Populating Columns manually

  Hi I am beginning to Use Visual Studio 2005, have a question on how to populate a DataGrid, not using the datasoure and binding method, but to individually assign the coluimn values returned from a query individually. Can this be down, reason I am building a Photographis app for use in my buisness and need to display a image associated with the data retrieved. hi,    I dont know much but i hope it should solve your problem. create a dataset with a new table and new columns and datatype as large object. create a new datarow and assign the values retrieved from the query to that datarow.   ...Show All

• .NET Development problmes with xml attribute

  I need to represente an xml documment on trreViewer i use this code: try { // Create a DOM Document and load the XML data into it. XmlDocument dom = new XmlDocument(); dom.Load(textBox1.Text); // Initialize the TreeView control. treeView1.Nodes.Clear(); treeView1.Nodes.Add( new TreeNode(dom.DocumentElement.Name)); TreeNode tNode = new TreeNode(); tNode = treeView1.Nodes[ 0 ]; // Populate the TreeView with the DOM nodes. AddNode(dom.DocumentElement, tNode); treeView1.ExpandAll(); } catch (XmlException xmlEx) { MessageBox.Show(xmlEx.Message); } catch (Exception ex) { MessageBox.Sh ...Show All