lou_RUS's Q&A profile

• SQL Server problem with custom conflict resolution

  Hi Well.. I implemented the business logic handler. It was registered successfully and my table was changed to use this business logic. Below the part of the code I use: public override ActionOnUpdateConflict UpdateConflictsHandler(DataSet publisherDataSet, DataSet subscriberDataSet, ref DataSet customDataSet, ref ConflictLogType conflictLogType, ref string customConflictMessage, ref int historyLogLevel, ref string historyLogMessage) { customDataSet = publisherDataSet.Copy(); DataRow rowCustom = customDataSet.Tables[0].Rows[0]; DataRow rowSubscriber = subscriberDataSet.Tables[0].Rows[0]; DataRow rowPublisher = publisherDataSet.Tables[0].Rows[0]; for( int i = 0; i < rowCustom.ItemArray.Length;i++ ) { if( rowPublisher[ i ...Show All

• Visual Studio Team System Not all projects are shown in source control explorer

  Hello, I have some strange situation here, I have one group of users in specific team project, all users of this group can work with sources in this project, except one who can not even see this project in source control explorer, when I click Source Control folder in Team Project in Team Explorer , I get error about missing permissions or source control folder is not configured for this project and suggestion to create this folder , if I click "OK" to create this folder I get the message that it already exists ( it is exists just I can not see it!) Only if I give to this user project administrator permissions and restart his computer, only after this the project appears in source control explorer. Please help me w ...Show All

• .NET Development .Net Runtime fails when App Domain is used and ComVisible attribute is set to true on assembly level

  I have problem with system writen on .Net Framework 2.0. It fails from time to time with ExcecutionEngineException: .NET Runtime version 2.0.50727.42 - Fatal Execution Engine Error (7A05E2B3) (80131506) I was able to reproduce this problem in my test environment, I think I found just one way how to crash it, and there are another ways to do it. In my case it happens when I do following steps: create new app domain Create instance of class in new domain Invoke method of that class, which trying to make .Net Remote call Remote server does not exist, so I have every time Socket exception I pass to remote call instance of the class from assembly with [assembly: ComVisible ( true )] attribute as parameter I do unlo ...Show All

• Architecture 2-Tier Problems Accessing Remote Data

  I have a 2-tier architecture question. What are the problems associated with accessing data remotely in a situation where a client application is directly accessing a SQL Server database over the internet There are obviously security issues related to preventing unwanted access to the database, but what about performance issues Are there connection reliability issues, network limitations, etc., related to the effectiveness of a direct remote connection to SQL Server An alternative architecture we are considering is a 3-tier model with a middle-tier application server (web service). Thanks. if u r developing a serious application, go for the 3 tier model, and her is why: - More secure, becau ...Show All

• Windows Forms How do I invoke a form control event w/o params?

  How do I invoke this event to make it execute: label1_Click(); It requires params (Object sender, EventArgs e) But I don't have any info to give it. The method doesn't need the params to perform the code I've written for the event. Sloppy, I know, but I'm learning! Actually, all you need to do is create a delegate to the event handler: MyButton.Click += new EventHandler(Click_Handler); Then when the event is raised (when the user clicks on MyButton), the event handler will be executed. [UPDATE] - However, if all you want is to get the click event handler to run from code rather than a user clicking it, you can call the MyButton.PerformClick() method. ...Show All

• .NET Development ASP.NET web site publishing via command line

  Hello! Does anybody know how to publish ASP.NET web site via command line. I want to automate this process, but I did not find tool (in Visual Studio 2005 or .NET Framework 2.0) to perform this action. Does anybody know another way to publish web site (for example via COM or SDK assemblies), if such tool does not exist L.G. For ASP.NET 2.0 web sites you can use the "aspnet_compiler.exe" tool. http://msdn2.microsoft.com/en-us/library/ms229863.aspx Rgds Rodrigo ...Show All

• Visual Studio Debugging custom project type

  Can anyone offer any tips for debugging a custom project type project I have my custom project type project set up to automatically register the package as a post-build event. The project is also set up to run devenv.exe with the experimental hive as its debugging action. When the debugger starts, the breakpoints I have set in my custom project type code all say that the debug symbols can't be found. I am not sure if I need to copy the symbols to a new location as part of the post-build event Devin Hi Devin, Are you sure that you are using command line arguments "/rootsuffix Exp" in Project Properties -> Debug -> Start Options Also please check that you are using the same registry hiv ...Show All

• SQL Server Grouping Question

  HI there all Here is my question for the day. I am creating a report based of a table where i have employee information and hours that he has worked, I need to have the total of all hours, and also the total of Billable hours. there is a field called Billable hours. Anyways, In my layout section, I get the correct total hours, due to the groupin g which is easy. I also added a new field to my Query for the field hours with an alias of billable hours. I need to put some sort of filter for this field. so that This will add up the hours that are billable, (bullable =true.). I tried to do this with the query and I had no success. I tried thought the report layout, on the properties of that field something along the lines of =Field ...Show All

• Visual Basic IPAddress.ToString expected to return a.b.c.d but returns d.c.b.a

  I have a function from a third party vendor which returns an IPAddress in the form of a VB.NET UInteger. I am trying to convert this into the dotted decimal form by doing the following: Dim oAddress as New System.Net.IPAddress( [IP in UInteger form] ) Dim sAddress as String = oAddress.ToString I would expect the above to work, but where I am expecting to see "10.1.0.21", what I am getting is "21.0.1.10". Am I not using this right IP-addresses in binary format are stored in an unusual, non-Intel CPU compatible way called BigEndian . The bytes are in reversed order. If the 3rd party vendor gives you the address stored in an UInteger, you better watch out for software quality iss ...Show All

• SQL Server SQl Server to Xml Files

  I need to export a table from SQL Server to an XML file using SSIS. Using the SSIS wizard I see no way of exporting to an XML file. Can someone point me to an article that shows me how to do this. Thanks Danny One of the DataSet component destination's options is to save to xml. While the DataSet destination not a stock component, it available in the set of SQL SSIS examples from http://www.microsoft.com/downloads/details.aspx FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en Typically, this component's source installs to to folder C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Programming Samples\Data Flow\DataSetDestination Component Sample. If you have a V ...Show All

• Visual Studio Express Editions How to make a search box in an application

  Hi. I have a database that has a table named "Main", this table has 4 elements "ID, Blue Number, Year, Description" . What i need is how can i make a form that has only a search box to search using any given blue number, and once the blue number is entered into the text box the program will search the database for all other elemnts to that blue number. Anyone can help plz Here I am ... A couple of problems...First get rid of the 'Do loop' and second... Set your connection string: Dim MyConnection As New OleDb.OleDbConnection (" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = C:\mydatabase.mdb ; User Id = admin ; Password = ;") instanti ...Show All

• Visual Basic How to put headers in a listbox

  Hi, I am pretty new to Visual Studio, but know enough about SQL. I am working on creating some applications with VB to access my SQL database. I created a listbox that is extracting some data from a table. I am trying to Save that data to a .CSV file, but I am having major issues. I would really appretiate it if someone could help me and explain why my code is not working. I used examples to get to this code, but lack of experience is helping me to get stuck at this point. Thanks!!! Code: Try With sdlgTextFile .AddExtension = True .CheckPathExists = True .CreatePrompt = False .OverwritePrompt = True .ValidateNames = True .ShowHelp = True .DefaultExt = "txt" .FileName = filename .Filter = _ "CSV Fil ...Show All

• Visual Studio How does assembly ref debugging work?

  I copied a dll I had created to another folder and then attached a reference to it (from a WinApp). If the dll build is Debug I am able to step into it and it even finds the original path of the source code. A Release config, obviously, cannot be stepped into. I opened up the dll in ildasm and I didn't see anything that helps VS2005 track this. How exactly does this happen Thanks for that pointer. I looked at the modules window, and yes, the symbols file was loaded. But it is from obj/Debug folder of the original project that contains the source for this assembly. I copied the dll alone to another folder. How does the debugger manage to figure where the original symbols file was created ...Show All

• Internet Explorer Development Still another report on this...

  Having an intermittent problem printing To: From: CC: Subject: Attachments: headers on emails. Usually happens with larger emails or emails with large attachments or emails that have been replied to or forwarded from other people. Have installed Generic/text printer and sent the email to this printer but sometimes the headers are still missing even printing this way. I have if I open the offending email and highlight just one or two words in the text of the email eg Dear John and then print the email using my HP printer (not as text on Generic printer) - the headers then print and so does the selected words. Don't suggest using Outlook as often we only print the first page of emails as we already have the rest of the email on file especial ...Show All

• Windows Forms How to create Multiple instances of a form with dynamic names

  Hi,    Am into developing a lan messenger.Now my requirement goes like this.   I  designed a form(for ex:User) which is used to receive and send messages.As multiple users send messages at same time to a single user(For ex:Both ravi and rahul send message to user raju).For each user i must open an instance  of the so created above form(User).How to approach towards this Can anyone help me in this regard Bharath   if I understand correctly, you have 1 form but want to open up several instances but with a different form name correct Simply open that form/create a new instance of the form and set a different Name property for this new form instance so its ...Show All