Liam .net's Q&A profile

• Visual Studio Express Editions Connect to Lotus

  Hello On our server we have a lot of Lotus databases that we get information from. Now we want to make a small easy program to collect information like product and quantity on stock so our resellers can get the information as well but still not get all the information in that database. Is this possible How do i connect to lotus database I would really appreciate all help I can get. Thanks Rikard aka Biocide I suspect you won't be able to connect to it as a 'database' - it may well be a repository for data, but probably isn't considered a database as we know it: or the format is not well known. You will need to use the Lotus notes objects, I believe. You will have to investig ...Show All

• Windows Forms Strange Drag Behaviour in MDI App

  Hi, I have an MDI host form. The user can open a number of sub-windows which drill further and further into some data, in each case resulting in a (third-party) grid containing a reasonable amount of data -- sometimes up to a couple of thousand of rows by twenty columns. However I have noticed a problem when dragging these windows around, which is that they don't redraw themselves properly! So I could end up with win1 still showing part of win2 even though I have dragged win2 to an entirely discrete space within the MDI container. Anyone any ideas where I can begin to look for a solution to this Do I need to put some code in the DragDown event of the MDI host to ensure that everything redraws itself properly ...Show All

• SQL Server Importing XML File using SSIS (DTS)

  I can use MS Access to import an XML file and it builds the columns and loads the data. I am trying to use SQL Server 2005 to do the same thing and there doesn't seen to be a way to easily accomplish the same task that works so well in Access. Has anyone tried this If so and you were successful, what were the steps to set up the package Thanks. Mark, Thanks It worked. So the impression that i get is that all XML's should be waped in a root node. Is it True ...Show All

• Windows Forms Datagrid C# question.

  Hi there, I decided to start off learning C# by doing come datagrid stuff. My problem is that I don't know how to select a few columns from a full table when I am trying to display all the data on a datagrid. The code I am running is here: namespace ECN { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load( object sender, EventArgs e) { // TODO: This line of code loads data into the 'eCNFormsDataSet.ECN_Main' table. You can move, or remove it, as needed. this .eCN_MainTableAdapter.Fill( this .eCNFormsDataSet.ECN_Main); this .MaximizeBox = false ; } private void button1_Click( object sender, EventArgs e) { ...Show All

• Visual C# Completely dynamic method invocation

  In java, I believe you can attempt to call a method even though the compiler can't find the method in the object's known class. Basically, you could do something like this - Object o; o.SomeMethod(); The java compiler doesn't look to see if SomeMethod exists in o. It simply compiles the code and tries to find the method on the object at run-time. If it's not found, something like a MethodNotFoundException is thrown, and can be handled gracefully. I want to do precisely the same thing in C# without using reflection. I think this type of behavior can be acheived in a roundabout way using the item of a foreach loop, but I want to be able to do it anywhere. Essentially, I want to be able to get this piece of code to compile - tr ...Show All

• Visual Studio Tools for Office Explorer Wrapper for C#, VSTO 2005 & Outlook 2003

  I have tried many variations for the explorer wrapper, and my last attempt was with a few bits of code taken from the Microsoft "ShortcutBar Sample". My resulting Explorer wrapper is at: http://pastebin.com/844445 But I'm facing a problem: If I open multiple Explorer windows and close them, the Outlook process is still running after all Outlook Explorers have been closed. This doesn't happen if I only have one Explorer running. To reproduce the problem, take the code pasted at the URL above, and debug it. When Outlook launches, open multiple explorer windows (right click on a mail folder and select "Open In New Window"). And then close them. You will find that your debugger doesn't stop on its own, and you ha ...Show All

• Visual Studio 2008 (Pre-release) uploading powerpoint file on the server.

  Hi, I am developing an application wherein i need to upload the powerpoint file(which is provided by the user) on my server.Can anyone please help me out to resolve this issue Hi Ashish, Access denied happens when I publish the application in VS.It is an XBAP application.When I click on Upload file button,I get an error "Access denied".it happens in local machine. ...Show All

• SQL Server insert statement problem

  Hi all, I'm trying to calculate the data from one table and insert the results into another table. The queries are the following: 1. select top 5 userId, count(photoId) numOfPhoto from photo group by userId order by count(photoId) desc 2. select top 5 userId, count(photoId) numOfPhoto from photo where datesubmitted > DATEADD(dd,-30,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) and datesubmitted < DATEADD(dd,-8,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0))group by userId order by count(photoId) desc 3. select top 5 userId, count(photoId) numOfPhoto from photo where datesubmitted > DATEADD(dd,-7,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) and datesubmitted < DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) group by userId order by coun ...Show All

• Visual C# String format

  Hi i need to read from a TextBox in a float the problem is the format : if i use "," like : 12,5 it works but it dosn't work for "." like 12.5 the code i use is : float x; x = float.Parse(textBox2.Text); You can parse with a specific culture if you want, use the code like this: CultureInfo cultureInfo = CultureInfo.CreateSpecificCulture("nl-NL"); float x = float .Parse(textBox2.Text, NumberStyles.Any, cultureInfo); ...Show All

• Visual Basic Delete all selected items in listbox?

  How can I delete all the selected items in a multi-select listbox in VB.NET Thanks, James Wow I hadn't thought of doing it in reverse Thanks! P.S. Whew I've lost count of how many of my problems you've fixed, ahmedilyas! ...Show All

• Windows Forms Editing tables without Primary Key

  Hello everyone. I am trying to work with a database in C# 2005 Express. One of the tables in that database doesn't have a Primary Key. However, it has a unique Foreign Key associated with each row. How can I select any particular row for editing on that table Its easy to select and edit tables which have a Primary Key by writing something like: dataset.TableNameRow row = dataset.TableName.FindBy(PrimaryKey); row.BeginEdit(); . . . row.EndEdit(); But how can I select and edit a row from a table which doesn't have a Primary Key Thanks in advance, Ashish i dont think you can actually access a row with no pk if u can't reference it.. if it is in a dgv maybe then but i havent tried it is good practice to keep an index or sum ...Show All

• Visual C# how do i "select" on the code an item in a ListView

  i need to set the index of a selectedItem in a listView. when the user wants to change the selection on a single selection listview i want to check if the user want to perform an operation with a MessageBox, if the user cancels, i need to reset the selecteditem to the previoulsy item (before the click) I know the index, but i don't know how to select it to show it as normal selected on the treeview if ( listView1.SelectedIndices.Count == 0 || listView1.SelectedIndices[0] != <index of the item to select>) { listView1.SelectedIndices.Clear(); listView1.SelectedIndices.Add(<index of the item to select>); } This will not change the selected item anymore once it's been changed to t ...Show All

• Visual Studio Express Editions Rename project

  How do I rename a project I'm unsure about the Express editions however you would go to your solution explorer, then right click the project and go to rename. Perhaps go to View > Solution explorer to show the solution explorer. Then continue on as above. ...Show All

• Visual C# Are there excellent steps for a new learner to launch on c#?

  as a new learner, to set about c# will with much mood.So many class and meths will enlarge my head. HI, ahmedilyas : An example of a Messenger toast is the message that appears on a user's desktop when one of the user's contacts signs in. Another example of Messenger toasts is the messages displayed when a user receives an alert from the .NET Alerts service. Could you please tell me how to catch the screens If i clcik the links in the screen and how to respond this event. Thanks in advance. Are there class files can be find in the Visual stadio ...Show All

• .NET Development Comparing 2 XmlDocuments

  Is there a way to compare 2 XmlDocuments by code Thanks Avi Thanks   This tool is great The only thing I can't find is how to ignore empty nodes. Like if I have a date property and it is null in one doc I have <date/> and in the second I don't have it at all and it is the same when I deserialize(the way it should be). is there a flag to ignore empty    Avi ...Show All