Tom25's Q&A profile

• SQL Server ALTER TABLE ADD Column question

  This has always puzzled me, so I really just wanted to know if it's possible through T-SQL. TableA has 3 columns: ColumnA ColumnB ColumnD Is there anyway through T-SQL to add a new ColumnC *between* ColumnB and ColumnD. ALTER TABLE TableA ADD ColumnC [varchar](1) Thanks. SQL Server GUI might be updating the System Catalogs Instead of the above procedure, In that case It will be faster than the Normal procedure ...Show All

• Visual Studio Express Editions Itemdata problem

  Having come from VB6 where I could use the itemdata was not a problem, but transitioning into VB.Net has been a different story. I have a form with a combobox on it and according to Microsoft's article#: 311340 I have setup the class and everything just as they suggested. It appears to store the data, but when I go to code the retrieval side I get the following error: Option strict on disallows implicit conversion from 'Object' to 'MyList' ( Where MyList is the class created from the example ) This following is the code it is squawking about: Dim mList As MyList mList = ComboBox1.Items(ComboBox1.SelectedIndex) Any thoughts about this I know that ComboBox1.Items does not take a parameter. Do I just need to turn off ...Show All

• SQL Server Two Newbie Reports Questions

  Hi, I have a report with 3 parameters. One of which is Company name. To get the available list for this I use a query: select distinct name from companies, etc. However, I also want the user to be able to select "All" or an equivalent to get all the companies. I tried putting * and % in the default values (non-query), but the drop down list displays "<select a value>". Also I've enabled drill-down, is there a way to auto-expand the results Thanks, Dan Just worked it out, by clicking on the row, edit group, then setting the display setting to initially visible rather than hidden. ...Show All

• Visual Studio 2008 (Pre-release) Default value?

  I have the below contract but it does not seem to work. When the client calls this api without specifying the optional argument instead of setting the value to the default it is always null. I have included the datacontract and a portion of the service reference from the client. The client service reference code seems to "know" that this parameter is optional but it does not seem to "know" about the default value. What am I doing wrong Kevin < xsd:element name =" Culture " type =" xsd:string " default =" en-US " minOccurs =" 0 "/> [ DataContract ()] public class GetPaymentTypesRequestType { private string cultureField; public GetPa ...Show All

• Windows Forms DataGridView Button click

  Hello all, I have a Datagridview with some of the columns as buttons..I want to write a function when a particular button is clicked. Can anyone suggest which event I should use as there is no "click" event for normal buttons. Thanx in advance Private Sub MyDataGridView_CellEnter( ... ) Handles MyDataGridView.CellEnter Dim dgv As DataGridView = CType (sender, DataGridView) If dgv.Columns(e.ColumnIndex).Name = "Column1" Then MySub(e.RowIndex) End If End Sub Private Sub MySub( ByVal rowIndex As Integer ) Console.WriteLine( "blah blah blah at row " & rowIndex) End Sub ...Show All

• Windows Forms SaveFileDialog how to use?

  I have a richtextbox1 on a child form inwhich I write a small bit of text in. I then want to save the text from this richtextbox into a .txt file. I have got the saveDialog menu at the bottom of my screen But I am unsure how to correctly make this all work. I know there should be some dialog.filter and index for txt files code somewhere but I dont know where. The code i have done so far is :- private void saveToolStripMenuItem_Click( object sender, EventArgs e) { DialogResult dr = saveFileDialog1.ShowDialog(); if (dr != DialogResult .OK) return ; else { StreamWriter sw = new StreamWriter ( "filename" ); sw.Write( ); //What should I put in the Write function } } Also is ope ...Show All

• Windows Forms Displaying a message.

  Hi How can i display a message in messagebox like the following. "Hi, Welcome to .NET World" send me a solution........ Hi I got the Solution. The soln is : MessageBox.Show((Chr(34) & "srinivas" & Chr(34))) Thank u. ...Show All

• Windows Forms Second DataGrid Problem & Column's header...

  Hi again, how can i change column header text And when i want to remove second grid's columns. It can't removed Why.. http://img144.imageshack.us/img144/1368/problemscgx2.png Regards, Witkey ...Show All

• Silverlight (formerly WPF/E) Where are the user interface controls? ie: Menu, TreeView, ListView, TextBox, ...

  I cannot see any user interface controls in the WPF/E reference. When I try to instantiate something as simple as a button, it throws an exception when loading the XAML. What is the status of the support of TabPanel, TreeView, Menu, Button, ListView, TextBox, RadioButton, ... Without these, I cannot see how it would be possible to build an application user interface with WPF/E. when will be the rest of the subset control and the slim down version of .net framework avilable, will it be the jan ctp or the feb ctp. thanks prasanth ...Show All

• Visual Studio Tools for Office OL Addin problems (two of them)

  OL Addin problems (two of them) Hi all, I have written an OL addin using VS2005 VSTO. Currently it prints something to log file and displayes a message box when in ThisApplication_Startup(). 1 If i run the addin project using the VS debugger everything works. Things continue to work even if i later run outlook from the Start->All Programs->Microsoft Office->Microsoft Office Outlook 2003. (as long as i run OL at least once from the debugger) If instead, i install the addin using the setup project (which was created automatically) then the addin is not loaded. My question is : How do i make my addin work using the installer and not just using the debugger 2 I have written an application which is supposed to ...Show All

• Visual Studio 2008 (Pre-release) Different endpoints for Service hosted in IIS

  I'm creating a WCF Web Service hosted IIS. I need to install the web service in an existing web root (not a web service) so it has to work with different security settings in the virtual directory. I need the service to work with Windows Integrated Security, Anonymous Access and Basic Authentication. Different customers can configure the security settings differently. I tried to create different endpoints for the service with no success. I've read that it's possible to create some kind of base url and have different endpoints pointing to the same service implementation. Is this right How can I do this If this is possible, how should I create/configure my client so it dynamically will bind against different endpoints depending on the cur ...Show All

• .NET Development add an element to a xml file

  I want to add another language to my following xml file: < xml version="1.0" > - < languages > < language language =" Nederlands " /> - < language language =" English " > - < categorie > < Word English =" banana " Spanish =" platano " /> < Word English =" apple " Spanish =" manzana " /> </ categorie > < categorie /> </ language > </ languages > How can I do that with j# If you want to ma ...Show All

• Windows Forms How to set toolbar in window taskbar

  Dear All, I want to set my application's toolbar on window's taskbar while minimizing my application. If anyone helps that would be help me to go further   Thanks  Balaji K.J. '     Hi, Could you please try this link.Hope this helps. http://msdn2.microsoft.com/en-us/library/062478za.aspx Also check out the link in the bottom of the page where it has info about adding menu items to Notify Component. Thank you, Bhanu. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vibrate the controller for 1 second?

  Hi, I've just starting playing around with XNA for xbox 360 and have a noob question I want to vibrate controller 1 for a single second. I know to set vibration on I can use the code: GamePad .SetVibration( PlayerIndex .One, 1.0f, 1.0f); and to turn it off: GamePad .SetVibration( PlayerIndex .One, 0f, 0f); But how do you set the length of time for it to vibrate I have experience in programming with C++ but have not yet had the chance to fully immerse myself into C#. Thanks You could also try something like setting the value in a static DateTime object when your start the motor, and then use a TimeSpan to find the number of seconds that have passed since the rumble ...Show All

• Visual C# Class constructor with null Date parameter

  I am trying to figure out the best work around for the following senario. I have an application that accesses a SQLServer DB. I have a "Job" class that represents a Job our company is working on. The constructor for a Job looks like... public Job(string JobName, int CustomerID, DateTime DueDate); There is a "Due Date" field in the Jobs table in the DB that allows nulls (not all jobs have a due date). When I pull a record from the DB and create a Job object with the record, I get an error is the DueDate field is null. Obviously you can't convert null to a DateTime value type. Now, the only solution I can think of is to pass a date like "1/1/1900" into the db if the user leaves the DueDate blank, and display th ...Show All