ReneMiner's Q&A profile

• SQL Server Code Completion of SQL Statements in 2005

  Will the new tools for SQL 2005 give us code completion of SQL Statements, e.g. if I type the following sql USE pubs GO SELECT pub. FROM   publishers AS pub When I type the "pub." will I see a list of the available columns in the publishers table.  This type of feature has been available in TOAD for years and years, will SQL Server programmer finally get this in the 2005 release. Cheers, Colin This may have been the video they saw at the PDC: http://channel9.msdn.com/Showpost.aspx postid=121794 Regard,    Damian ...Show All

• Visual C# Positioning control on a form

  Hello. Your help is very much appreciated. I write Win app using .NET 1.0. I have a form which only has datagrid on it. I want that the datagarid will fill all the space on the form. The dg is always stuck at the top left hand corner. I used the docking property - but it didn't change a thing. this .dg.Dock = DockStyle.Fill; Any suggestions THanks a lot Roy Hi! Strange, Dock=DockStyle.Fill is the right answer. Are you sure this code called Try make new form, drop there DataGrid and set Dock property to Fill in property grid. ...Show All

• Visual Studio Express Editions RSS Screen Saver

  Ok so I want to change the default RSS link and the default IMG, how do I go about this You SUGGEST I do it at the bottom of the tutorial but provide absolutely no guidance on how to do it.. Whats up with that I've tried replacing the images in the resource file with new pictures but keeping the same file name, that did not do a single thing, // The images to display in the background private List < Image > backgroundImages; private int currentImageIndex; There is that in the code, but there is no explanation on what any of the variable means, nor how you edit them. This applicatoin is near useless to a new coder b ...Show All

• Visual Basic Attention: Please Help

  Im not sure if this the right place to put this type of question, but this site has a cluttered GUI. Anyway. Im a Highschool student who is in Computer Programming and Repair. For a closing VB project I have to come up with a project. My question is. I have one form entitled "frm_Main." and created another form "frm_Main2" How do I, using a command, "jump" forms while the program is executed. Im basically asking for the code. So if you can help, much appreciated -Kris. Are you trying to show both forms at once or just switch to the other by clicking a button Is this .net or vb6 ...Show All

• Smart Device Development PocketPC SerialPort and turning off/on the device

  Hi, Here a simple C# example that reads data from a GPS Device Assume two Buttons on the form and one Textbox. Further a SerialPort with the DataReceived Event handled in the form. public class Form1 : Form {     public delegate void SetText ( string strPar);     public SetText myDelegate;     public Form1() { InitializeComponent(); } private void Form1_Load( object sender, EventArgs e) {    myDelegate = new SetText (SetTheText);    serialPort1.BaudRate = 4800;    serialPort1.Handshake = System.IO.Ports. H ...Show All

• SQL Server Returns Nothing, But Executes Fine

  SELECT tblWatchInstance.WatchID,tblWatchBrands.Description,tblWatches.Serial_Number,tblWatches.OwnerFName,tblWatches.OwnerLName, tblClients.Name FROM tblWatchInstance INNER JOIN tblWatches ON tblWatchInstance.Watch_Key = tblWatches.WATCH_KEY INNER JOIN tblWatchColors ON tblWatches.COLOR_KEY = tblWatchColors.COLOR_KEY INNER JOIN tblWatchBrands ON tblWatches.BRAND_KEY = tblWatchBrands.BRAND_KEY INNER JOIN tblWatchTypes ON tblWatches.WATCHTYPE_KEY = tblWatchTypes.WatchType_KEY  INNER JOIN tblClients ON tblWatchInstance.Instance_Key = tblClients.CLIENT_KEY WHERE tblWatchInstance.RepairNumber LIKE '%" + txtRepairNumber.Text + "%' AND tblWatc ...Show All

• .NET Development Problem of reading image contents from xml in XSL

  Hi I am using C# code to read the image contents from one message and i am writing that contents in to one xml file. and also that xml file is having the reference to xsl. in Xsl i coded like this to read the image contents and displaying images <xsl:element name="img"> <xsl:attribute name="src"> <xsl:value-of select="gif_image"/> </xsl:attribute> <xsl:attribute name="width"> <xsl:value-of select="150"/> </xsl:attribute> <xsl:attribute name="height"> <xsl:value-of select="150"/> </xsl:attribute> ...Show All

• SQL Server Output Multivalue Parameters

  I'm trying to output all the values selected through a multivalue parameter, but I am having difficulties. In the text box, the parameter contains only four member functions (value, label, count, ismultivalue). However, to output a value or label for the parameter you need to specify an index in the form of: Parameters!Names.Value(0) Ideally, I would like to be able to obtain all these values with a function call, but it doesn't look like there is one. Any ideas of how to get all the values Thank you!! Hi. I have been trying to get this to work. I am fairly new to reporting services. This is what ...Show All

• Visual Studio Team System to check the disponse method is used when dataset is used in a method.

  i want to create a custom rule for my company. my custom rule is if the user has used dataset then they should have used dispose method to destory the dataset object. please tell me how to create that one. is it possible. if it is possible means . please explain. i am really waiting for your reply. this work has to be done by thursday. please help me on this. i am waiting for your reply. Hi Vinoth, This kind of analysis is extremly tough to implement. It requires dataflow as you need to track how the local of the DataSet is used throughout the method. E.g. will it be disposed in all locations the method has a return statement, o ...Show All

• Windows Forms Copy Datagrid data to clipboard

  I can open a form - populating the datagrid with the required data, select the upper left corner (which highlights the entire datagrid), then ctrl-c to copy the data to the clipboard.   Does anyone know how I can make these last two events happen programtically (the Mouse click and the ctrl-c to the clipboard) Thanks, bob DataGrid or DataGridView (2003 or 2005) -mark DataGridView Program Manager Microsoft This post is provided "as-is" ...Show All

• Visual Basic Where can I download Visual Basic 6.0 ?

  Really dumb question, but I couldn't find any download link for Visual Basic 6.0. And I don't want to use Visual Basic 2005, because I got a lot of learning material for Visual Basic 6.0.   i need to know this aswell because my disk broke and my teachers won't give me one because i have 2005 express........ i still have the Registration Number Key......... but its not usefull without the files..... i can't do anything the old fashioned way now..... everything is more confusing ...Show All

• SQL Server How to mimic replmerg.exe in vb.net

  Hello, On an existing Merge Pull Subscription (Subscriber: SQL Express) via websync how can we start replication via vb.net We can use the cmd line replmerge.exe and all works fine however we would like this to be cleaner as it's going to be on demand sync. I saw in BOL about the RMO and how to create pubs/subs but nothing telling me how to actually start the replication process. Is there a sample of how to start the replication process in vb.net for websync Thanks in advance. John See if these code examples help which are listed in: http://msdn2.microsoft.com/en-us/library/ms147890.aspx ...Show All

• Visual Studio Team System Strange Email Problem

  I've installed and configured TFS Beta 3 refresh on a clean-built server. Email notifications are acting a bit strange. Project alerts are working fine and email is being sent. However, there is no email sent when someone becomes the owner of a work item. The last time I installed TFS (on a test server) this worked, but it's not working on the new build. Any insights I not seeing any errors in the event logs (other than a strange DCOM one, and I've made the recommended permission adjustments to that). Thanks for any help. Which DCOM error are you getting Is it netman Have you run a trace ...Show All

• Visual Studio 2008 (Pre-release) Control Sizing during Instantiation

  Here's my situation: I'm dynamically inserting the following custom control into a grid at run-time: <Grid x:Name="containerGrid"> <Grid.ColumnDefinitions> <ColumnDefinition Width="50" /> <ColumnDefinition Width="*" /> <ColumnDefinition Width="50" /> </Grid.ColumnDefinitions> <Canvas Grid.Column="1" x:Name="Canvas1" RenderTransformOrigin="0.5,0.5"> </Canvas> <Button Grid.Column="0" x:Name="ButtonRight" RenderTransformOrigin="0.5,0.5" Content="Arrow1"/> ...Show All

• Visual C++ Sharing Data between DLLs

  I have dll, common.dll, which has global data. I want to share this global data with another dll. I've set the linker options on the common.dll as follows: /SECTION:.bss, rws /SECTION:.data, rws. When I step into the code it appears that both dlls have their own copy of the global data. What am I doing wrong Thanks. Omar Canon Use #pragma dataseg(".shared") in the source code. See this webpage and this webpage for a examples. ...Show All