My Vizai's Q&A profile

• SQL Server Proble of view which table is redesigned

  I have a view like vxyz which query is select * from xyz when I add two more column in xyz table then view vxyz doesn't show the new columns. So every time i have to drop view and regenerated. I want solve this problem without droping view. give suggestions Thats by design, the columns are only resolved during creation time, you either have to recreate it or use sp_refreshview to refresh the view. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server DataFlow suggestion

  I am transfering data from a textfile to sql server.I use a data flow task for trasfering my text files. Here is what i do. 1.Add text file source What i want to achieve here is if the text file countains the column name in the first row i should delete them and if it does not contain column name in the first row just transfer it. how can this be achieved 2.add one more column to my text file which should contain the status(insert or update). how can this be done 3.before transfering data ot destination i want to know if the record exists if exists i just want to update it instead of insert.and if new record i want to insert it .and the status in the above new column need to change. please help... ...Show All

• Visual Studio Express Editions Adding Favourites

    Does anyone have a code i can use to add to my internet browsing application that will enable the users to add favourites to a list. And if posible a snippet which will hide the users IP, so it's anoymous browsing.  Also does anyone know of a site which supplies graphics, buttons etc. that can be  used in created applications. Thanks to anyone who replies   Excuse me but your response is not correct at all. Favorites files are simple text files Like so: [DEFAULT] BASEURL=http://www.google.com/ [InternetShortcut] URL=http://www.google.com/ Modified=20D35364DCAAC601F7 IconFile=http://www.google.com/favicon.ico IconIndex=1 IDList= [{000214A0-0000-0000-C000-0 ...Show All

• Windows Forms Delete a row programmatically in DataGridView

  How can I delete a newly added row with code in a DataGridview I cannot find any delete method in any of the features of the DataGridView. I test for correct data in the _RowValidating event that sets cancel to true. But when the user leaves the row without correcting the value, I set e.cancel = True. But the row is still there with the invalid value in one of the cells. I want to delete the row if the data are not correct and the user navigates away from the row. Can this be done Is RowValidating event the correct place to do the delete How and where should I do it The DataGridView is bound to a binding source which is in turn bound to a datatable. There is no delete method in the binding source and the record does not ex ...Show All

• SQL Server command line parameters are invalid

  I have a package that let me to import data from a excel book to a Sql server data base. When I try to run this package like a step into a SQL server Job it show me the next error. "The command line parameters are invalid. The step failed." the "command line" looks like this /FILE "C:\Project\Package.dtsx" /CONNECTION ConexionExcel;"Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source=;Extended Properties =""EXCEL 8.0;HDR=YES"";" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI and in my excel conexion is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties="EXCEL 8.0;HDR=YES"; When i run the "Command Line" in the "Com ...Show All

• Visual Basic Using Folder Browsing Control in ASP.NET

  Hello everybody I have made a User Control in VB.NET 2005 that displays folder browsing control when clicked on button i want to use control in my ASP.NET page as we use activeX control previousl. Is anybody can help Gaurav... Could I suggest that you ask the question on the ASP.NET forums Forums.asp.net these are dedicated to ASP.NET questions and your more likely to get a pertinent answer to Web applications quickly from those folks. ...Show All

• Visual Studio Express Editions How to interrogate a query?

  I wanna to interrogate a single field in side a specific query. Can I to proced I wanna to know before, how to load a single query in a specified object. Please, anybody could to help me Thanks Not sure what you are after...but you can write and call your own query.. MyCommand.CommandText="Select TheField From MyTable Where TheOtherField > 0" MyReader = MyCommand.ExecuteReader While MyReader.Read Console.WriteLine(CStr(MyReader(0))) Loop ...Show All

• .NET Development how to retrieve from existing file

  hi, I'd like to get data from existing file. I downloaded yahoo! logo to my computer. Then I go back to Visual Studio, go add item, existing item, then yahoo.jpg. Then go to Form2.cs I'm trying to something like shown below; m_BrowserLogoPictureBox.Image = Image.FromFile("yahoo.jpg"); But if I run it, it says "FileNotFoundException". When I test the other project, I successfully compile. I though I did the same thing but it doesn't compile. If anyone can help, I appreciate it. Thanks. Let's assume your namespace is WindowsApplication1 m_BrowserLogoPictureBox.Image = Image.FromStream(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("Win ...Show All

• Software Development for Windows Vista Application architecture

  I have started work onto developing an application that shall be supporting all the business flows within my organization. The end-user shall have access to the application via asp.net page, which shall showing him/her all their awaited flows (clicking on which he/she shall be shown details of what the user needs to do in order to make the flow move on) or they can instance a new one. I am looking for a comprehensive example in order to understand the architecture which i need to implement in order to acheive the above mentioned application. In other words, what would be the best way to implement it Can i initiate a workflow in Sharepoint without attaching it to an item such as list ...Show All

• Visual Studio Team System CriticalError, Certainty 95, for DoNotNestGenericTypesInMemberSignatures on return typs

  Hi i get CriticalError, Certainty 95, for DoNotNestGenericTypesInMemberSignatures Resolution : "Consider a design where TNode`1.BreadthFirstNodeEnumerator:IEnumerable`1<PPSD.BL.Decomposition.TNode`1<Element>> doesn't nest generic type 'System.Collections.Generic.IEnumerable`1<PPSD.BL.Decomposition.TNode`1<Element>>'. " Info : "Avoid API that require users to instantiate a generic type with another generic type as type argument. The syntax gets too complex." on the code below. I can *not* see where the syntax gets too complex when i use this definition for a return type. public IEnumerable < TNode <Element>> BreadthFirstNodeEnumerator { get { Queue < TN ...Show All

• Visual Studio September CTP?

  Anyone have any idea as to when the Sept CTP will be released Thanks John Yes and I have documented this in our FAQ at http://blogs.msdn.com/sandcastle/archive/2006/07/30/683352.aspx Anand.. ...Show All

• Visual Studio 2008 (Pre-release) MapConnection and friends

  So, I've just installed the Jan Orcas CTP, and can not for the life of me find MapConnection, MapCommand etc. Are they gone, have they been hidden somewhere, just not there I did however find EntityConnection and EntityCommand, is that the same or ... Niels Yes, MapConnection & friends have been renamed EntityConnection, etc. There have been other renaming efforts since earlier CTPs as well. ObjectCache, for example, has been renamed ObjectStateManager to more accurately reflect its true purpose. - Danny ...Show All

• Visual C# How to delete the cookies create by a WebBrowser?

  Hello, I use a WebBrowser (C# .Net 2.0) and i don't know how i can delete the cookies created by the WebBrowser Thanks for your help! Thank you. But why my cookie is stored for my application but not used by IE Example: I a use a WebBroser to go to Hotmail.com and set to store my mail and my password, if i close the application and run it again, hotmail don't ask me again my password. But when i open IE hotmail ask me my password! It's not the same cookie There is a different cookie by application ...Show All

• Windows Forms Navigating by Year on the Calendar function?

  Is there a way to navigate by year as well Having to click on each month to get several years ahead is awfully inconvenient. Just add two small buttons to your form. Use code like this: private void btnNextYear_Click(object sender, EventArgs e) { DateTime cur = monthCalendar1.SelectionStart; cur = cur.AddYears(1); monthCalendar1.SelectionStart = cur; } private void btnPrevYear_Click(object sender, EventArgs e) { DateTime cur = monthCalendar1.SelectionStart; cur = cur.AddYears(1); monthCalendar1.SelectionStart = cur; } Moved to Windows Forms General forum. ...Show All

• Visual Studio Team System Create Db Project by Schema vs By Object

  I tried creating a project of each type of organization and both appear to have the same structure. Are they different What is the folder structure of each The difference is mainly that 1 scenario you would like to have your local file system organized according to schemas or alternatively you can organize your project system and local file system simply by object types<i.e. tables> This was an important customer request that we got, in that certain folks want to put security on the a number of schema folders when checked into source control system As Sachin mentioned this option has been enabled and will be availible within the upcoming CTPs. Hope this helps mairead ...Show All