WinDeveloper's Q&A profile

• SQL Server How to schedule package Continuoulsly?

  Hi, I have requirement that i need to Schedule package continuously(every 10 Seconds). Any solution on this it would be great! H there, I'm afraid that 2005 doesn't give you the possibility to launch processes on seconds-basis, so you could do a little vb application where inside a loop and using a Timer..: Dim pkg As New Microsoft.SqlServer.Dts.Runtime.Package Dim EventsSSIS As Eventos Dim app As New Microsoft.SqlServer.Dts.Runtime.Application while true.. pkg = app.LoadFromSqlServer("msdb\yourpackage", Nothing , Nothing , Nothing ) sResultDts = pkg.Execute( Nothing , Nothing , EventsSSIS, Nothing , Nothing ) stuff.. Pub ...Show All

• SQL Server Cannot create diagram in SQL 2005

  i get the following message Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. I am the db owner but still wouldnt let me install and create diagrams. help! cheers hey i found the answer you gotta set the owner to sa and then go to the database properties, then options, then change compatibility fromn sql 2000 (80) to sql 2005 (90) too easy.. thanks buddy ...Show All

• .NET Development Bug in List<T> and MemberwiseClone ???

  MemberwiseClone is supposed to create a shallow copy of the object, right But this little experiment shows that that is not the case when subclassing List<T>, I must be missing something here... Calling Test() will throw, adding "3" to the third list will also change the second list! public void Test() { StringList first = new StringList (); first.Add( "1" ); StringList second = first.Clone(); second.Add( "2" ); StringList third = first.Clone(); third.Add( "3" ); if (second.ToString() != third.ToString()) throw new Exception("Bug!"); } public class StringList : List < String > { public StringList Clone() ...Show All

• Architecture Database application class separation to tier/layer

  Here's what I am doing, I am doing database application with C#. And so, I have class signifying some major tables, and separate DAO for them, as well as another set of classes that would populate the table class properties with the resultset returned from DAO. I am thinking of separating them into separate dll, layers; with DAO at one dll, and the table class at another. Is this advisable Now I have a problem with circular reference, whereby VS would not allow me. My table class would have .Update() and .Delete() methods, where inside it would declare a DAO object and calls the corresponding methods in DAO. But on the DAO dll, it would have to reference the table class as well, during object creation. Is it that these should be ...Show All

• Visual C# Referencing .Net 2.0 dll in .Net 1.1 application !?

  Hi , I want to refer a dll created in .Net 2.0 in a .Net 1.1 Windows application. How do I do that Thanks in advance Aseem Chiplonkar Software engineer. Well .... My problem is that I have a third party dll which is created in VS 2005. I also have the source code. I want to use that dll in my VS 2003 application. Do you have any suggestions how do i do that Thanks in advance, Aseem Chiplonkar software engineer. ...Show All

• SQL Server installing sql server 2005 alongside analysis server 2000

  analysis services 2000 work fine on my machine so i dont want to go near them ,but i do want to upgrade sql server 2000 to 2005. can i have sql server 2005 and analysis services 2000 work side by side on a server Yes - you can do it. The AS2005 will have to be installed as a named instance, because you cannot have two default instances on the same machine and AS2000 didn't support multiinstancing. ...Show All

• SQL Server Execute As error

  I have a stored procedure that needs to run with elevated privliges, so I tried setting it to run as one of the db owners. When a regular user tries to execute the SP, I get the error Cannot execute as the database principal because the principal "joejoe" does not exist, this type of principal cannot be impersonated, or you do not have permission. What do I need to set up so a user can be impersonated Did you try as SELF It should work like you want. mpswaim is a user, who is the db_owner group, right You really shouldn't need impersonation for this procedure to work anyhow, since all users have rights to sysprocesses. Here is the script I used to reproduce the situation. I created the users without login for e ...Show All

• Windows Forms Membership and Personalisation in Windows Forms

  Hi, Can I use the Membership and personalisation feature of ASP.Net 2.0 in Windows Form based applications or is there a different way to achieve the same Thanks Sai Yes, I do for an application the simpliest method is to setup a webservice and do your authentication against the webservice. i.e Webservice expose function public bool Login(string username,string password) So you would call you webservice app instead of calling a bus layer class. The cool thing about this for me is that I can then keep on username and login for extranet services and internal windows app. You should use SSL on the webservice though to keep things secure. The other way I believe is that you could use the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Price?

  does anyone know how much XNA will cost i mean it can't be free... Q: Can I use the XNA Game Studio Express or XNA Framework to build a commercial Xbox 360 game A: XNA Game Studio Express will enable you to create Windows and now Xbox 360 console games much more easily. These games are limited to non-commercial scenarios for 360 titles created with XNA Game Studio Express. However, XNA Game Studio Express may be used to create commercial games which target Windows. We will be releasing XNA Game Studio Professional next spring which will allow developers to create commercial games for Xbox addition to Windows. The licensing is similar to old Academic Visual Studio licensing models. Obviously by the t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Help What do I need to download so I can connect to my 360 for XNA?

  What do I need to download so I can connect to my 360 for XNA Do I need to download windows media connect You need to go to your 360, go on XBLMarketplace, go to Games, New Downloads, and find XNA Creators Club. There you'll find both the Download you need (8MB) and the Memberships, prices vary depending on where you live. ...Show All

• SQL Server Repeate group values in Matrix

  Hi, I am using matrix to make a report. I have company name in the row group and user name in the details field. When I run the report I only see the company name once and each user of that company is displayed in a separate row. Then next company name and its users... I wanted to know if there is a way to display company name next to the user name I know it can be done by using "table" but I can't use table because in this report there are other fields can only be done in a matrix. So, please let me know if there are any settings in matrix which I can use to display my company name next to each user of that company. Please ask me any thing if the question is not clear. Thanks a lot for the help. -Rohit ...Show All

• Visual Studio Express Editions HELP: Transparent TextBox

  Hi, I am making a program where you enter a string into a textbox, but I want the textbox to be transparent. When I try to change the BackColor to "Transparent" I get an error message saying: "Property value is not valid: Control does not support transparent background colors." I have a picture in the backround, but nothing will be 'moving' aound the screen. Is there a way to take a screenshot, edit the picture to just the part behind the textbox, then sett the textbox BackColor to the picture that I just made -Josh Thanks, That worked (after a bit of a hassle) I just used the DLL Library he made in my toolbox so I didn't have to use all that code. I still have a few things to ...Show All

• .NET Development Interop Thread Leak?

  Hi, I'm hoping for a few pointers for tracking down a resource leak. I developed a VB 2.0 indexing application which is using FileNet's Capture COM objects and we're occasionally seeing a fairly serious leak. It doesn't appear to happen consistently (one user has never had one and I can't seem to reproduce it in my test environment), but it does occur regularly in production. I've been using various tools to poke around in a mini-dump (w/ full memory) and I've seen a few potential problem areas, but I can't seem narrow it down any further. Using PerfMon I found that the leak appears to be in private unmanaged memory. When I open the dump in WinDbg, I get this message: This dump file has an exception of interest stored in it ...Show All

• Smart Device Development How to peek at the CF IL

  I'm opening CF assemblies with ILDASM/Reflector in an attempt to learn more about the internals and/or undocumented behavior of some classes, but all I get are empty method signatures. I'm opening for example c:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\CompactFramework\2.0\v2.0\WindowsCE\System.dll. Should I be looking somewhere else (i.e. the GAC ) Please look inside Debugger\BCL folder instead of WindowsCE folder. ...Show All

• Smart Device Development SerialPort.BytesToRead max's out at 2047

  hi, currently i'm doing a program for pocket PC connected to RFID reader using Serial Port. I'm very new with the program with window CE. I had done the same program in Window Form and it running well. But, when i transfered the program to Smar t Device Application, the program not running well. I had try 2 ways. First is using timer, and second is using serial_portData_Received. Below is the codes: Using Timer: program stuck on sp.Write( new byte [] { 0xC0, 0x02, 0x01, 0xFF }, 0, 4); =inside timer private SerialPort sp; private void Form1_Load( object sender, EventArgs e) { #region Serial Port Init sp= new SerialPort (); sp = new SerialPort (); sp.PortName = "COM1" ; sp.BaudRate = 11520 ...Show All