redneon's Q&A profile

• SQL Server Merge replication foreign key problem

  Hi there. I'm somewhat new to merge replication, and I've been having an issue with one of the scenarios that I've been trying to get working. I am using SQL 2005 on the server, with 2005 express on the client. I have 2 tables: Photo - which has a PhotoID primary key PhotoData - which has a PhotoDataID primary key, and a PhotoID foreign key both primary keys are int, and set to identity. I only want the Photo table to replicate for the merge, because I want the data in the PhotoData table to only be called by demand through a web service (since the images in that table are too large to be included in the normal replication). However, when a client adds a photo to his local database (which adds a record in the photo table, ...Show All

• Smart Device Development my SDK not avialable in VS2005 target device

  i designed my OS using platform builder and made a SDK for that (by -new SDK,build SDK) than again i installesd that SDK(*.msi file) to my machine. in my vusual studio..this SDK not semms in tools option or in target device.. from where i shoul add this in VS2005 so that it can be seem in my target device for deploying thanks vishal. If you're NETCF C#/VB user (and I would assume that’s the case since you’ve posted to NETCF forum) this SDK is neither required nor used, it's for native C++ projects. For C#/VB simply use Windows CE 5 project type and deploy to CE 5 device. ...Show All

• Windows Live Developer Forums We are considering the purchase of visual earth

  How easy is it to upload locations and data would it be better for us to outsource some development than learn it ourselves That depends on what you want to do, your current skill set and your delivery timeframe. If you have the time and skills, or want to learn. then do it yourself. There are plenty of good resources comming together but it is not quite plug and play. It is a very rewarding technology though in that what you acheive is visual and you can show off to others - as opposed to some accounting login form or something. If you are looking for outsourcing there are some good experienced developers around. I would head over to http://viavirtualearth.com to see the gallery, articles etc. They have a forum for people lo ...Show All

• Visual C++ Vector subscript out of range - can't understand why

  I'm having a problem regarding the 'vector subscript out of range line 756' when popping back a vector after upgrading to VS2005. Pushing back still works perfectly. Searching the web I find many others with the same problem, but no explanation or way to fix it. This is purely in debug mode, no problem with mixing release mode or anything. #include "fire.h" vector < fire > MYFIRE; In main I have this function for(unsigned int i = 0 ; i < MYFIRE.size(); ++i) {     MYFIRE.DoPhysics(MYTIMER.getdelta_time());         if(MYFIRE.Pos().X()>400)         {         for(int j = i; j < MYFIRE.size(); ++j)     ...Show All

• SQL Server sql server express management studio, How do i stay logged in

  Hi: I installed sql server express management studio. i'm able to login with the local user and sa user as well. However when I’m connected and i open a new file to a query window (a sql file for example) the login window prompts me and I need to login again. Do you think there's a way to overcome this problem and login only once Thanks, Tomer This is the expected behavior in Management Studio, it has nothing to do with Auto_Close. You are not losing your connection to SQL Express, most things in SSMS require a separate connection so you are asked to log in. If you are looking to write a query against a specific database I beleive right-clicking on the database and choosing new query will create a query window that is alr ...Show All

• Visual Studio Team System .dbproj files to be read inside a Developer Edition of VSTS?

  At my workplace we have a number of editions of VSTS, one of those being the new Database Projessionals version for our DBA. We used to create a Database project, then had an app to combine all the .sql files into a master file for execution against our development server. It seems now that this new project type can better integrate into our build server and we will no longer need to use this sql joiner app. Regardless, all developers could view the standard Database project, but these new SQL Server 2005 (.dbproj) files are unreadable by the Developer edition of VSTS. While developers won't be doing many database changes, it's nice for us to be able to get latest and do small changes with code review on our databases, but moving to this ...Show All

• Windows Forms Newbie problem: updating data in Win Forms using a BindingSource

  Hi, I have a parent form that contains a data grid of materials. When the user the "update" button, a child form is called where the user can modify the selected record: Private Sub ModificarToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ModificarToolStripMenuItem.Click Dim oid As Long oid = MaterialDataGridView.Item(0, MaterialDataGridView.CurrentRow.Index).Value ' The first column in the grid is a hidden column with the record's ID FormaMantenimiento = New FormMaterialesMantenimiento(FormMaterialesMantenimiento.Modificacion, oid) FormaMantenimiento.ShowDialog() FormaMantenimiento.Dispose() MaterialDataGridView.Refresh() End Sub On the child form I fill the the ...Show All

• Visual Basic Disconnect The Internet

  How can I find the internet connection and terminate it Private Declare Function InternetGetConnectedState Lib "wininet.dll" (ByRef dwflags As Long, ByVal dwReserved As Long) As Long Public Function IsOnline() As Boolean Dim LFlags As Long IsOnline = InternetGetConnectedState(LFlags, 0&) End Function http://www.freevbcode.com/ShowCode.Asp ID=632 for details http://www.freevbcode.com/ShowCode.Asp ID=632 for details www.codeguru.com/cpp/i-n/ network/tcpip/article.php/c2431/ www.codeproject.com/cs/ internet /tcpdemon. asp df=100&forumid=206340&exp=0&select=1620108 ...Show All

• Visual Studio Express Editions Console Application

  I am building a console application which runs in the background. Can you catch a key press or a key down or a key up in console application like in a window application Yes, you can capture a keystroke character in a Console application using Console.ReadKey().KeyChar.  If you add the True argument, it does not echo back the pressed key.  The variable can be either a string or a char type.   Dim ans As String ans = Console.ReadKey( True ).KeyChar Console.WriteLine() Console.WriteLine( "True Answer: " & ans) ans = Console.ReadKey().KeyChar Console.WriteLine() Console.WriteLine( "No Answer: " ...Show All

• SQL Server SP2 final this year ?

  Does anyone know if the final SP2 will be out this year Really need it for a production enviroment.... I do not believe that a public statement about the RTM availability of SP2 for SQL Server 2005 has been released. However, I did find mention of the CTP2 release of SP2 located here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=760644&SiteID=1 Based on that announcement, it can be assumed that the RTM version SP2 is still under development and is not yet available for public download. Thanks, Sam Lester (MSFT) ...Show All

• .NET Development How to find the last occurence of <p> within a textblock tiltled <h2>??

  I have html files with the following structure: <h2>article title</h2> <p>paragraph 1 - bladiblah di blahblah</p> <p>paragraph 2 - bladiblah di blahblah</p> <p>paragraph 3 - bladiblah di blahblah</p> <p>paragraph 4 - bladiblah di blahblah</p> <p>paragraph 5 - bladiblah di blahblah</p> <h2>article title</h2> <p>paragraph 1 - bladiblah di blahblah</p> <p>paragraph 2 - bladiblah di blahblah</p> <h2>article title</h2> <p>paragraph 1 - bladiblah di blahblah</p> <p>paragraph 2 - bladiblah di blahblah</p> <p>paragraph 3 - bladiblah di blahblah& ...Show All

• Visual Studio 2008 (Pre-release) Audit Trailing SQL Server DB

  How to Use PropertyChanged or SubmitChages to Audit Trail the database. When ChangeProcessor.SubmitChages is called it does check for each object whether it is IsNew or IsDeleted or IsChanged. Is there a way to use this somehow to generate Audit trail object Thanks ...Show All

• Visual Studio Express Editions Copying datarows

  Hi, My project uses SQL Server 2005 Express and is produced in VB 2005 Express. I have a situation where I need to merge certain records from one database into another - schemas are identical. My problem is, I can't seem to add a row that exists in one dataset into the second dataset. code along the lines of Table1.rows.add(drTable2) - where drTable2 is a datarow generates an exception saying that drTable2 is already a datarow in another table. I have tried DIMming an empty datarow and passing drTable2 into it and then assigning it as a new row in drTable1, but the same thing happens. I have tried the following: Dim Newrow as {datasetName}.Table1Row Newrow = drTable2 Table1.rows.add(Newrow) This produces ...Show All

• Visual Studio Tools for Office VSTO 2005 SE: one assembly for Office 2003 and 2007?

  Hi, can I use VSTO 2005 SE to create one Add-In per Office application which supports the versions 2003 and 2007 in one single assembly I would like to query the given Application object which type or which version of a type it is to e.g. create a ribbon element in Word 2007 or a command bar in Word 2003. How would I set up my dev machine if I want to develop for Outlook 2003 and Outlook 2007, as it is not supported to have both versions installed on one machine -- SvenC Any addin that makes use of the ribbon interface must Implement that interface in the same class that Implements IDTExtensibility2. In the case of a VSTO addin that means in the ThisAddin class. So it's not really possible to wor ...Show All

• SQL Server Converting String to Date in Report Expressions

  Hello, I am running a report in RS 2005 and as an expression I have something like that: =DateDiff( "YYYY" , NOW(), CDATE( "2001" )) Unfortunately, I am getting message: Conversion from string "2001" to type 'Date' is not valid. Is there a way to fix it Thanks! The CDATE function wants a valid date format passed to it and not just the year. It would work if you specified something like "1/1/2001" or "Jan 1, 2006". However, it appears all you're trying to do is find the difference between the current year and some specified year. If that's the case, I would suggest using the following expression instead: =Year(Now()) - 2001 or if the specified year is a str ...Show All