MarkSPA's Q&A profile

• SQL Server Agents not appearing in Replication Monitor (SQL 2000)

  During an upgrade, we had problems with PK errors on sp_MSget_repl_commands. I recreated the SP with the varbinary characteristic as we have seen in many posts and it was sucessful in starting. However, the sp now appears as a 'user' sp, not a 'system' sp, however I an not sure that is a real issue. The problem I am seeing is that none of the agents are appearing in replication monitor under their agent folders. Replication appears to be working fine and the publications are showing on the distributor in the Replication Monitor - Publication folder under the appropriate publisher. But all of the agent specific folders (i.e. Snapshot agent, distribution agent, etc) are empty. Another interesting point, is that if replication fails, t ...Show All

• Visual Studio Express Editions reading numeric data from excel sheet

  Hi All , I am trying to read data from the excel sheet but i am facing problem when there is any numeric data is cell it gets Null value. Can some one please help me how can i read the numeric value from the excel sheets. If the same cell is having some other kind of data it is reading that data. Thanls Avinash Kundal I seem to have this one resolved. From what I understand, in your case, if there is a numeric value it will not display it - correct My excel had this: somestuff 123 ---- hi --- 5678 --- blue43 46 someNumber3 After some research, I believe the problem is in the connection string. The connection string should have the extended property HDR=NO; the code I used for the conn ...Show All

• Visual Studio Express Editions concerning media player

  renee where do I post pause button code It's described here. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1049186&SiteID=1 I'm not the only one making the request. ...Show All

• Windows Forms P PlugIn

  Pls,How can i expose my application in VB.Net so that another developer can plug into my application and use my modules or my functions. For an Example,I can plug into microsoft Excel and use its in-bult functions for my application. Please I will need an Example code using VB.NET 2005 Thanks Maybe this will article by Roy Osherove or this sample from Billy Hollis . ...Show All

• SQL Server Sql Delete Question

  I don't know if this is where I should post or not. I am trying to figure out how to get this select statement which generates all of the records I need to delete. Here is the select statement. SELECT * FROM SrcComputer as c join SrcDriverEntry as d on c . DriverEntryId = d . DriverEntryId join SrcFileList as f on d . FileListId = f . FileListId where c . compid = 567721765 I tried writing the Delete statement like this, but lo luck. DELETE FROM SrcComputer as c join SrcDriverEntry as d on c . DriverEntryId = d . DriverEntryId join SrcFileList as f on d . FileListId = f . FileListId where c . compid = 567721765 How would I re-write the statement t ...Show All

• Windows Forms Force property grid to completely refresh.

  I've implemented dynamic type information for a control class using ICustomTypeDescriptor. Specifically, setting one property to a certain value causes some other properties to become irrelevant so I omit them from the properties collection in ICustomTypeDescriptor.GetProperties(). The problem is that the PropertyGrid control that is displaying the properties for the object does not update to show these changes, even after calling Refresh() on it. I've also tried doing stuff like clearing the selected object from the property grid and re-setting it but it still shows the old set of properties. One strange thing is that resizing the control by dragging one of the resize handles causes the grid to update properly (setting the size via ...Show All

• Visual Studio 2008 (Pre-release) GUI of DLINQ

  When will be the DLINQ integration into VS is available The DLinq Designer is integrated into VS, check out the following link DLinq Designer Walkthrough for VB and C# . ...Show All

• .NET Development Simple Update from a VS 2005 vb project to an mdb?

  Hi all, New to Visual Studio, and only have experience with asp and access. The problem I have is this. I can call nearly anything out of my database that I want, but for the life of me, I can't update even a single field. Now the worst part is this. The little program I'm working on to do the data access is just a simple console app, which passes the data on to clients. All is well except, how do I code an update to a field. For example, to update the field Email in the Clients table with a variable passed through dimmed as a simple string This is an example of the code I am using for my general select querries: Dim conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Delirium.mdb" Dim cmd A ...Show All

• Visual Studio Express Editions How do you convert an array into a stream to make a bitmap?

  I am trying to make a bitmap from an array without setting each pixel and I all I could find for a bitmap is a stream and I thought I could serialize it somehow into a stream like this Dim memStream As New MemoryStream(size) 'memStream.Read(numb, 0, nums.Length - 1) 'LiveBitmap = New Bitmap(memStream) or Dim s As Stream = New Str Dim formatter As New BinaryFormatter Try formatter.Serialize(s, numb) or formatter.Serialize(memoryStream, numb) Catch e As SerializationException Console.WriteLine( "Failed to serialize. Reason: " & e.Message) Throw Finally End Try LiveBitmap = New Bitmap(s) or LiveBitmap = New Bitmap(memoryStream) ...Show All

• Visual C# IRecordInfo::RecordCreate(), IRecordInfo::RecordDestroy(), and Reference Counts

  When using a variant is used to pass a structure using COM Interop Services, a question comes to mind on the use of reference counts for the IRecordInfo interface when calls to RecordCreate() and RecordDestroy() are used to create a record or destroy a record managed with these specific calls. In other words, you cannot use malloc() and then RecordDestroy() on a record pointer, or vise-versa RecordCreate() with free(). Variants exist in the following forms: VARIANT , see #include <afxwin.h> _variant_t , see #include <comutil.h> CComVariant , see #include <atlbase.h> COleVariant , see #include <afxdisp.h> When a record is created with RecordCreate(), is it a mandatory practice or just a good practic ...Show All

• SQL Server storedproc return

  for some reason i keep getting a exception heres the code for the app int returnvalue = 0; DateTime dateCreated = DateTime.Now; // All users are added to Guests role upon registration. Roles.AddUserToRole(username, "Users"); String connectionString = ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); SqlCommand command = null; try { conn.Open(); command = new SqlCommand("InsertMember", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@AspNetUsername", username)); command.Parameters.Add(new S ...Show All

• Visual C# this.close() confusion - I may be doing something wrong?

  I've been doing this for awhile now and it has occurred to me that I should not be In my try/catch statements, if the exception is serious, I've been displaying the message to the user then the catch issues "this.close();" to shut the app down. Is there another (safer ) way of stopping the app if a severe exception occurs for example: try { sw_dohDeathWriter = new StreamWriter ( m_strOutputPath , true ); } catch ( IOException iox ) { MessageBox . Show ( "End Of File reached. " + "\nRecords Processed...: \n\n" + iox . Message , "File Conversion Error" , MessageBoxButtons . OK , MessageBoxIcon . ...Show All

• Visual Studio Custom Add File and Linking File

  Hi All, When you right-click on Debugging in Solution Explorer in Debugging window, you can add a new item with your own DSL template. Can I perform this with just clicking a button I made by myself Second one, let's say I add two new DSL files; test1.mydsl and test2.mydsl. How can I link these two files For instance, in test1.mydsl I make the relation between System1, System2, and System3. And in test2.mydsl the full diagram of System1 is specified. Can anyone please help me, or point me to links that are related Thanks in advance. Herru Thanks, Edward! Your answers sound interesting. I've heard about GAT/GAX before, but I didn't know what is exactly the purpose of that and the relation to DSL. I thought my application w ...Show All

• Windows Forms Can c# perform a CTRL+V

  Hi all How can i get my program to perform a CTRL+V. (paste from clipboard) Thanks. Lars The following code gets the name if the active control is a text box.By comparing the name we can determeine which text box Control cnt = this .ActiveControl; if (cnt is TextBox ) { string name = cnt.Name; } ...Show All

• .NET Development Strange XmlSerializer error

  Dear all, I am programming in VB.NET , using the .NET Framework 2.0 on a Windows Vista machine running VS 2005 with the SP1 beta applied. I have a VB class which was derived from an .XSD schema using the XSD.exe tool. I am able to instantiate objects from this class and build by "XML" object up using it, without too much difficulty. However, when I come to serialize the output to an XML stream, it fails, with a FileNotFoundException on the serialize line, e.g.: Dim serializer As New XmlSerializer( GetType (eGov.IRenvelope)) Where eGov is my class namespace, and the IRenvelope is the class within the namespace that corresponds to my object which I am attempting to serialize. The interesting thing is, tha ...Show All