Christoph Moor's Q&A profile

• Visual Basic Tableadapter.update with auto-increment on SQL column problem

  Hello, I'm using databound textboxes to display data from a database on VB.net 2005. I have an "add new" button, which does this: BindingSource.AddNew() - and then once the user has entered the details, they click a button that updates the database: Try Me.ChildrenBindingSource.EndEdit() Me.ChildrenTableAdapter.Update(Me.Main_databaseDataSet.Children) Catch ex As Exception MsgBox("Update failed") End Try I have a primary key field on the database (I'm using MS SQL express) called "ID". I've tested all the above with the user entering their own ID, and all works fine, but I want this to be auto-incremented instead. So, I set my MS SQL "ID" column up with these pr ...Show All

• SQL Server failed with error 0xc02090f3

  I migrated a SSIS pachage that has been running on a QA server for a couple of weeks onto a production server yesterday. An error message appears when running on the production server that doesn't appear on the QA server. This appears to be an internal MS format error, but I can't find much more on this error and don't know how to resolve it. The error message is: OnError Get CM000002 Transactions (Universal Trans, LLC) 2006-07-01 08:00:45.000 2006-07-01 08:00:45.000 Attempt to read message string for 0x80020918 failed with error 0xc02090f3. Make sure all message related files are registered. Has anyone seen this message and does anyone know how to resolve it Thanks in advance for any help with this one. ...Show All

• .NET Development Will assembly be functional after sending it with WCF?

  My question extends from the second part of Zhisheng Huang's reply in this post: http://forums.microsoft.com/MSDN/showpost.aspx postid=1205641&siteid=1 I am trying to create a WCF service, that should enable the user to create his own plugins, install them on the server at runtime and make them available to the clients. So basically the server loads plugins that implements an IModule interface with Assembly.LoadFrom and creates instances with Activator.CreateInterface. These instances are then returned to clients. The modules implement 4 methods that I want to execute on the clients. But when the client tries to deserialize an actual module received, I get the following FileNotFoundException: "Could not load ...Show All

• SQL Server Help with SQL Update statement

  Hi I have fields in one table I need to update from another based upon certain criteria, the fields in question are :- Table1:- AddressLine1, AddressLine2, AddressLine3, AddressLine4,ID1 Table2:- Add1, Add2, Add3, Add4,ID_1 What I need to do is update AddressLine1 with the contents of Add1, AddressLine2 with the contents of Add2, etc,etc. But, if one of the fields is empty or contains the word 'NULL' then I want to update that field with the next 'populated' field along. eg, normally it would be something like:- Update Table1 Set AddressLine1 = Add1, AddressLine2 = Add2, AddressLine3 = Add3, AddressLine4 = Add4, From Table1, Table2 Where ID1 = ID_1 but I need an 'if' statement or something in there to check whether Add2 is blank or = 'NUL ...Show All

• Windows Forms Regex and datagrids..

  I am trying to get a count of all instances of "IN" from a populated datagrid using: Private Sub Counts() Dim INCount As Integer = 0 Dim INFinder As Regex = New Regex( "IN" ) For Each row As DataGridViewRow In Me .dgResults.Rows For Each cell As DataGridViewCell In row.Cells INCount += INFinder.Matches(cell.ToString).Count Next Next tslIN.Text = INCount tslOUT.Text = Math.Abs(INCount - dgResults.RowCount) End Sub But instead " cell.ToString" is yielding "DataGridViewTextBoxCell { ColumnIndex=0, RowIndex=0 }"  Any ideas Also what would be the best way to search on a specific column TIA, Stue I did that before but being new and all d ...Show All

• Visual Studio Tools for Office MS Word And VB.NET

  Hello everyone. I want to read Images as well as text that is present in my Word document file (myfile.doc) using vb.net. In my word file i have Four Images and Description about that images. like below Image--------------- This is Image | -------------------- Description I have these type of four images and description, so I want to retrieve the images and want to display it in the label that is on my windows form. and also want to retrieve the description about the image and want to display that in another label that is present below the image label. Can anyone give me the code for the same. Please.......... Hello Prashant, Thanks for taking the time to post your question. You are more li ...Show All

• .NET Development Problem with ASP.net with p12 or pfx import

  when i do this from vb.net it work fine but same code from ASP.net fails any ideas here is ASP.net code that failed Dim fs As FileStream = File.Open(Server.MapPath( "App_Data\CISCUSTD.p12" ), FileMode.Open, FileAccess.Read) Dim buffer() As Byte = New Byte () {} ReDim buffer(fs.Length) Dim count As Integer = fs.Read(buffer, 0, buffer.Length) fs.Close() Dim myCert As X509Certificate2 = New X509Certificate2(buffer, "CISCUSTD" ) MFHTTPPost.ClientCertificates.Add(myCert) Here is vb.net code that has no problem. Dim fs As FileStream = File.Open( "C:\Inetpub\wwwroot\cctsicon\App_Data\CISCUSTD.p12" , FileMode.Open, FileAccess.Read) Dim buffer() As ...Show All

• .NET Development Socket Exception : No connection could be made...

  I'm working on a test app to familiarize myself with sockets and msmq before implementing a real solution and I'm running into some problems. I have simple TCP server and client applications set up to send strings from client to server. Basically, i'm retrieving messages from a message queue (client end) and sending them over to the server (just output to text box for the moment). I'm not sending anything back to the client...just a one-way send from client to server. It works perfectly the first time, but if I close the client and re-open (when message queue receives more messages), when I attempt to send them over to the server I get "No connection could be made because the target machine actively refused it." I know the ...Show All

• Visual Studio 2008 (Pre-release) NetMsmqBinding across Enterprise

  Iam trying to have a NetMsmqBinding two way communicatiion across 2 of our clients. I have done it on using private queues on my local machine and now i want the same working on queues across the internet. Any useful information on how to setup such an environment and any known issues you have run into will help. ( I know using public queues needs Active Directory e.t.c) T.Ramesh. [1] is a good starting point to look into the admin aspects of MSMQ. [1] http://technet2.microsoft.com/WindowsServer/f/ en/library/040755a5-60f5-4f2c-aa1f-4dad89d747f31033.mspx ...Show All

• Visual C# Getting started with Business objects

  Hi guys, i m trying to get started with Business Objects, but i m a little bit lost here.. hope you guys can help me out. So far all the tutorials i read on the internet just show you how to make an "employee" or a "product" class, coding that is very simple, and i don’t have any problems using them and even binding them to Windows Forms using BindingLins<T>, etc... i ve been testing it out and it works fine. But right now i m trying to make something that have some relations, and i cant figure out how i am supposed to do it, what i m trying to do is a simple "Order" class that is related with a customer and some products... something like: Order Customer Products So, could you guys help me out with this ...Show All

• SQL Server SSIS in vb

  Hi How can i generate vb.net code after i create a ssis package. In vb 6 and sql2000 dts one can do that. Thank you Horea Soanca wrote: Hi How can i generate vb.net code after i create a ssis package. In vb 6 and sql2000 dts one can do that. Thank you You can't. SSIS is a different animal to DTS. Just because you could do it in DTS does not mean you can do it in SSIS. -Jamie ...Show All

• Windows Forms Leaky label on transparent form

  Hi, I created a form with a label on it and set the opacity property of the form to 20 (the form becomes a little transparent). The label has white background color and has text. If I click on the white background of the label, my form looses focus because the label is "leaky", the application behind my form becomes active. How can I make my label a little bit more "clickable" Hi, I figured it out, the problem was the wrong color I used, when I changed it to other - web style- color, my label became filled with color. I hope this will help other stuck with problem like this. ...Show All

• Visual Studio SandCastle Getting Started Help

  So I've become completely spoiled with msdn-style help and with tutorials. I've never used nDoc so this is all new to me. I have a C# console app with xml (///<summary>... etc.) comments for every method both public and otherwise. I've used the SandCastle Help File Builder to execute against my solution file. The solution has xml comments and I get no errors at all. The problem is that I also don't get any documentation. I get a chm file with "Namespace" at the top and none of my classes or the program.cs are represented in the chm. Is there a getting started, 101 tutorial out there that will help me figure out what I've done wrong and get me grooving I have a major asp.net application that I have to document for a cl ...Show All

• .NET Development Debugging mscorwks

  >What if you did stop inside the runtime >What if we did allow a debugger to stop at a native breakpoint inside the runtime, but just refused to execute the helper-thread and thus >temporarily disable managed-debugging functionality In theory, this would work. In practice, it would be a bad user experience >because: > - you couldn’t get a managed callstack since the helper-thread can’t run. Thus you wouldn’t be able to see what managed function called into the runtime. > - You’d be stranded at the native breakpoint. You could step within the native code, but without the helper running, you could never step back across the native a managed boundary. Except that there is a window in ...Show All

• .NET Development How to get return a value from WndProc()

  Hi, In a C# application, I am SendMessage () function defined in user32.dll and accepting the call in another C# application by overriding the WndProc (ref Message m) function. I need to return a value (0 or 1) from WndProc to the process where SendMessage () was called. I tired the Result member of Message to do the same but was unsuccessful. Can anybody suggest something that that could be helpful. Thanks. Deepak Hi Mattias, In the application where the windows message is handles, the following code is there: protected override void WndProc ( ref Message m ) { // process the message if (FlagsAttribute) m.Result = (IntPtr)1; else m.Result = (IntPtr)0; } The code of the a ...Show All