Chetan Chudasama - MSFT's Q&A profile

• SQL Server Outline from database

  This is probably a newbie question, and I'm just missing something. Please forgive my ignorance. I would like to display data from a SQL database in an outline format. For instance:     Date    Event    Event    Event   Date    Event I can't figure out how to accomplish this. If someone can explain the procedure or point me to a code snippet for this function, I would be most grateful. Thanks in advance. Steve ...Show All

• Windows Forms Reference to assembly not working

  Hi, I have a project with a reference to a dll file.  However the project is not able to access anything within the dll file.  I am basing my code on a similar application that uses the same dll file, and it works fine.   Please help!! I don't think it's a COM dll as the other application does not use Interop for&n ...Show All

• .NET Development How do I send mail using C#?

  Does anyone have a code snippet that shows how to send mail from c# Dear Mohamed,   I was very interested to try the code snippet using authentificated SMTP you gave us, but I cannot find and member Fields in the System.Web.Mail.MailMessage object. How come I am the only one Did I do something wrong Thanks,     ...Show All

• SQL Server How to identify which all SPs are accessing a given table ?

  I don't know if I am in the right section of the forum. Please help me with this : Is there any system stored procedure or any other method to identify the list of all stored procedures that are using a particular table in my database. Thanks Prasad P No, there's nothing built in.  A quick and dirty way of figuring it out is:   SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TEXT LIKE '%YourTableName%'   This does have some issues due to especially large routines and routines that make use of dynamic SQL and concatenate names, bu ...Show All

• Windows Forms cycling through, and removing, listbox items dynamically

  Is there a way to dynamically cycle through a listbox to erase the current elements I won't know how many elements are in the listbox either. This is what I tried so far, but doesn't seem to work: For Each index As Integer In myListbox.Items         myListbox.Items.RemoveAt(index) Next index Thanks for any help! Sorry guys...yeah that works&n ...Show All

• .NET Development MySql and SqlDataAdapter

  I'm tring to use a SqlDataAdapter to access some data in a MySql database. The problem is that the SqlDataAdapter.SelectCommand.Connection.Open() does not like my connection String which is: " DRIVER={MySQL ODBC 3.51 driver};Server=10.10.0.229;port=3306;Database=dbName;Uid=myUserID;Pwd=myPassword; " If you take out DRIVER={MySQL ODBC 3.51 driver}; and port=3306; it runs but then it doesn't find the database. The error reports that it's looking for and SQL Server 2005 which makes sense assuming it's the default type of server. I have no problem with that same exact connectionString connecting my SqlDataSource Objects be ...Show All

• Visual C# Move textbox around on my form in run-time

  Hey howzit I would like to beable to move a textbox that is on my form with my cursor to anywhere on the form in run-time Is this possible, could you perhaps give me a code snippet I am very new to C#! Thanks! You can use the MouseMove event, in your form override the OnMouseMove method and set the textbox position to the mouse x and y axis. protected override void OnMouseMove(MouseEventArgs e) { txtFilepath.Left = e.X; txtFilepath.Top = e.Y; base .OnMouseMove (e); } ...Show All

• Visual Studio Team System Can work items be tie to share point?

  Hello, Is it possible to tie work item to share point   What I would like to do is update work items from share point.   Thanks i working  on win98 and vb6 i made  app with it  but when i try to make it  to exe file the windows 98 give me  an error (this program has prformed an illegal operation and will be shiut down) ...Show All

• Smart Device Development WM5 deployment error

  Hi. Just recieved this morning the first WM5 device that exists in the UK I believe. I love it! (trying to make the wifi work is tough...but anyway) I have VS.NET 2005 I have also installed the WM5 smartphone SDK. Problem I am having is this: When I create a New smart device project for WM5, I get a huge form on the screen, rather than the expected small compact form. Is this correct The form looks like the Pocket PC project. Other issue I have is that if I try to deploy the project using this project, It gives me this error: Error 1 The device security configuration disallowed the connection. Ensure that you have the appropriate c ...Show All

• Windows Forms application... "surroundings?"

  Hi, Look at Outlook 2003 (if you can't: http://pwp.netcabo.pt/otlk.jpg)... See that blue border surrounding the application  hows that done Thanks... My apologies -- I misread the image.  If you're talking about the dark blue border around the controls, you would need to override the Paint event for your control, draw the border, then draw the rest of&n ...Show All

• .NET Development .Net Technology to replace DCOM

  Hi, I'm new to .Net, and I'd like to know what's the closest technology to do remoting that close to DCOM. And it will be very helpful if you could provide me hte link for interesting article that comparing that with the DCOM. Thanks a lot Enterprise Services "System.EnterpriseServices is the closest as it is DCOM."    Actually...   "An Enterprise Service is a COM+ service provided through the System.EnterpriseServices  namespace.  A serviced component is a .NET class designed to use Enterprise Services, and a serviced assembly is a .NET assembly that contains at least o ...Show All

• .NET Development ado.net, connection pooling, and leaked connections

  Hi, I have been looking at some legacy code with performance issues: I ran perfmon on the problematic use case, with a counter on .NET CLR Data / Current # Pooled connections (amongst others) I noticed that while performing a set of tasks in the use case, pooled connections increased systematically peaking at 9. I think this is because of the workload governor which MSDE uses, but I think that this would simply carry on increasing on a full instance of SQL Server. I am unsure why this is happening: my question is this: given a non-threaded single-user  environment, why would the current pooled connections increase in this wa ...Show All

• .NET Development GC.Collect() freezes for several seconds on gen 2 collection

  I have a server application which manages a few hundred thousand objects in a Hashtable. Each object has to be in memory for fast lookup and access. The keys are not changed so the Hashtable itself is fairly static, but the objects are constantly updated via incoming data and read to serve user requests. The problem is that every 5 minutes or so the GC kicks in and freezes the entire process for up to 4 seconds. This is regardless of whether other threads are running, e.g. even if I do no updates or queries, it takes this long just to create all object graphs for collection, even when nothing is collected (i.e. GC.GetTotalMemory returns ...Show All

• SQL Server Problem Installing SQL Server 2005 Express

  When I attempt to install the standalone SQL Server 2005 Express, the install hangs at "Detecting Installed IIS".  I have reboot the PC. I have sucessfully installed the other parts of Visual Studio Team Developers Edition. I am running XP Pro SP2. Previously I had Beta 2 and the Release candidate installed on my PC and I carefully followed the recommended uninstall procedure. Please Help. Steve I have fixed the problem.  I saw a post on the general VS 2005 setup forum that status that Norton/Symantec Anti-Virus and Firewall products may cause the hang-up on "Detecting Installed IIS".  After d ...Show All

• Visual C++ Runtime error: Unhandled exception at 0x004cd752 in quikcomp.exe: 0xC0000005: Access violation reading location 0xffffffff

  Hi all, I am experiencing a runtime error that I am having trouble solving. I am extending a current application to include SSE intrinsics. During runtime, I receive the following error: Unhandled exception at 0x004cd752 in quikcomp.exe: 0xC0000005: Access violation reading location 0xffffffff Here is a code snippet: __m128 *mPre = NULL; __m128 *mDst = NULL; __m128 *mPost = NULL; curK = kHalf; do { curKChan = curK * chans; mPre = ( __m128 *)(imgBuf - curKChan); mDst = ( __m128 *)rowBuf; mPost = ( __m128 *)(imgBuf + curKChan); i = imageSize; do { *mDst = _mm_add_ ...Show All