Netoblivion's Q&A profile
SQL Server simple question creating duplicates
Hi, I'm trying to create duplicates in a copy of a table in the same database by inserting rows from the original table. Seems easy but I can't get any sql to work. help hi kat, Seems like you love northwind very much. here's a code anyway use northwindCopy insert categories(categoryid,CategoryName, Description, Picture) SELECT CategoryID+100, CategoryName, Description, Picture FROM dbo.Categories regards, joey ...Show All
.NET Development Marshaling a struct?
Hello everyone! I hope this is the correct part of the forum to ask this question, if not I apologize! What I am asking is completely foreign to me, so I also apologize if I say anything wrong or incorrect... I am currently developing a component in C# that implements a TLB... A majority of our code is in C#, but we have a few COM components that need access to it so our interfaces were coded as an IDL. So the code will be accessed from both our COM and C# components. Within the IDL I have a few structs that some of the methods return, like this: interface IPresetData : IDispatch { typedef struct { BSTR name; BSTR surname; }MyStruct; HRESULT GetNextRecord([out, retval] MyStruct* pMyStruct); } Now, from what I have read ...Show All
Visual Basic item in Listbox
I'm trying to figure out what I'm missing here in this piece of code: dim s as string ="" for each item In me.listbox1.items s=s & item.tostring & vbcrlf ... i get this error msg: "Name 'item' is not declared" Any help would be appreciated. aLEX Hi, try changing the following code line [assuming your listbox is filled with string items]: For Each item As String In Me.listbox1.Items ... Andrej ...Show All
Smart Device Development Removing PDA's proxy settings programatically
Good morning. In my company's project (CF1.0 , WM5.0, VS2003) , we run our app both in the cradle and out of it. When in the cradle, it automatically picks up the proxy server we use for internet access. When we take it out of the cradle, those settings remain and the app obviously can't access the web service on the net because it's trying to use a 192.168.X.X proxy address. At the moment we just go in and disable the proxy whenever we take it out of the cradle - which obviously isn't an option when the app goes into production useage and we give it to our techs. Is there a way to disable it via code (perhaps native API ) I've seen on MSDN the HttpWebRequest.Proxy Property but I couldn't see how to apply this to invoking a standard web ...Show All
Visual Studio Team System Business Intelligence Development Studio (BIDS) Unavailable in Visual Studio 2005
My computer had been running great for the past two years until now. I had VS2005 installed, with BIDS and VS For Database Professionals CTP6. I was trying to install Database Professionals CTP7 and it asked me to remove CTP6. I removed CTP6, and again tried to install CTP7. It said that I needed Visual Studio Team System installed (but I already had it installed!) After that, everything started taking a *** and I couldn't open anything anymore - it seemed all my project types were screwed. I started uninstalling everything, all of Visual Studio, the .Net framework 2.0, and SQL 2005 because nothing was working anymore. After reinstalling .Net Framework 2.0, Visual Studio 2005 and SQL 2005, I don't see the Business Intelli ...Show All
SQL Server Registering AdventureWorks
The organization I work for will be converting to SQL Server 2005 in the near future so I downloaded the free 90 day trial to familiarize myself with the software. I've installed the software and my plan now is to go through the Tutorials. I need to access AdventureWorks sample database. AdventureWorks did not download upon initial setup so I've downloaded/installed it into what appears to be the correct folder: c:\ProgramFiles\Microsoft SQL Server\90\Tools\Samples. I cannot, however, seem to locate it within SQL Management Studio. As advised by the tutorial I've tried setting up a New Server Registration but I can't seem to locate AdventureWorksDB when I'm browsing for it under the Connect to Database:' option under the "Connection P ...Show All
Windows Forms about datagrid in vs 2003???
hi, everybody, I have a problem about datagrid in VS 2003. I want to make a datagridcell's forecolor different from the next datagridcell's forecolor. How I do this.... Look at this, it may be helpful http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_thread/thread/9b21b7f08f2320df/e5a71221edf2f0a8 lnk=gst&q=forecolor+datagrid&rnum=3&hl=en#e5a71221edf2f0a8 ...Show All
Visual Basic Watching a process.
I'm having trouble with this. Basically what I'm trying to accomplish is a server restarter. It needs to look for the server to close. I was thinking just look for the process to close. But I'm not sure how to do it. Could someone help please If you write the server code you could also add a named Mutex (see MSDN Mutex class), which your server creates. When the server crashes the mutex will also die. Check the existence of that mutex in your watcher. If you come up with a really unique mutex name, that collides not as easily as process names might do. -- SvenC ...Show All
Visual Studio 2008 (Pre-release) Attached Property not "attaching"
This is driving me crazy. I've carefully followed all the examples I could fine, used Reflector to look at some of the System.Windows.Controls code, but still can't figure out why this isn't working. Seems like it should be easy... In the example below, SetSiteId never gets called; however, if I change the name or remove the SetSiteId, the XAML parser complaines about it. Any help would be greatly appreciated... Here is the class that defines the property ... public static class CommandService { public static readonly DependencyProperty SiteIdProperty = DependencyProperty.RegisterAttached("SiteId", typeof(string), typeof(CommandService), new PropertyMetadata(string.Empty)); public static string GetSite ...Show All
Visual Basic Is there a way to call information thats in a database
Is there a way to call information from a database and place it in a rich text box With a loop type of thing Or would i have to make some...wierd query and place each value into a text box 1 by 1...or... i dont know help would be nice...thanks The method im using is this: Dim count As Integer = 0 Dim var2 As Integer Dim count2 As Integer = 0 var2 = (ProductsTableAdapter.GetDataByALL.Rows.Count + 3) * (ProductsTableAdapter.GetDataByALL.Columns.Count + 3) Do While count < var2 Do While count < ProductsTableAdapter.GetDataByALL.Columns.Count RichTextBox1.Text += "Title: " & CStr (ProductsTableAdapter.GetDataByALL.Columns.Item(count).ToString) RichTextBox ...Show All
Visual C++ Help writing code to read a GPIO Port (bit)
Does anyone know how to read a GPIO Port (including configuring it as well as enabling it). I know the commands must exist, but have not been able to find any source/sample code that would show me how to do it. It is for an Intel chipset 852/855 running Windows XP. Thanks I'm afraid the question is outside the scope of this forum. The C++ General forum deals with the VC++ 2005 IDE, libraries, setup, debugger, samples and documentation -- but not the use of all libraries and technologies. While most borderline issues are answered, and followed up, a great deal of these off topic questions are simply not given their fair attention. The reason is that many of the people here are specialized in their field ...Show All
Visual Studio Team System Team Foundation Server - Deleted project asks to unshelve...
Hello! From VisualStudio .NET, I right-clicked on an open solution and added the solution to source control. Then I deleted the folder from the TFS server b/c it was added in the wrong place in the tree. Then I right-clicked on the solution again to add it back, but the TFS server, but the option "Add to source control" is not there. Now there's an option "Unshelve Pending Changes...", but when i go there, there are no shelvesets to unshelve. How can I fix this problem so the solution can be added to the TFS server Thank you in advance, Richard Any chance you still have the pending changes If so, try to undo the delete (or just undo all changes in the workspace). If ...Show All
Visual Studio 2008 (Pre-release) EntityFramework + LINQ vs. O/R-Mappers with UML and Schema Generation Support
Hi, I understand that Microsoft is now heading to support concepts most people understand like ER-Models instead of UML and availability of an SQL-like language that even allows to do mapping without objects. My question is however how much OO one can get out of Entity Framework in combination with LINQ. Please let me know if the following is supported: - Issue Query agains ER-Model (Mapping) using LINQ and get Objects of a predefined (modeled) typed that includes business logic. I understand that technically any type can be annotated with business logic but my question is if the ER-Modeler will understand this - Will Entity Framework support DDL Generation like ObjectSpaces d ...Show All
Windows Forms Get Item in ListView
Before posting this i did search but couldnt find a solution so i am asking for help........ again Lets say you had on a ListView 5 Items(user names) and each have 2 SubItems (age, gender). The view is set to Details with click event enabled. Ok if i click on a user name (Item) in the Items list, how can i make the name i clicked on appear in a textBox1 Any useful links would also be great. thanks Im using VC++ Hi, have you got my mail of course, you can. e.g. this ->label1->Text = e->Item->SubItems[2]->Text; ...Show All
Visual C++ "Out Of Memory" Message
Hi, I have recently taken over responsibility for an application. I have been developing it for a while now and recently a change i made required me to add something to the list of "undos" that the program will do. This was the first time that i had done this. Its reasonably simple stuff, moving something and then undoing it or typing something and then undoing it. When an undo event is created its added to a stack and on some occasions information is saved to a file, which is temporary. Then when you wish to undo an event we run through the stack and pop each at a time. I'm sure this is basic undo stuff. My problem is occasionally when using the application i undo something and receive an "Out of Memory" error. T ...Show All
