Yos123's Q&A profile

• SQL Server Slow execution of queries inside transaction

  I have some VB.NET code that starts a transaction and after that executes one by one a lot of queries. Somehow, when I take out the transaction part, my queries are getting executed in around 10 min. With the transaction in place it takes me more than 30 min on one query and then I get timeout. I have checked sp_lock myprocessid and I've noticed there are a lot of exclusive locks on different objects. Using sp_who I could not see any deadlocks. I even tried to set the isolation level to Read UNCOMMITED and still have the same problem. As I said, once I execute my queries without being in a transaction everything works great. Can you help ...Show All

• Visual C# I've learned C#, but... What's with the IDE?

  I know C/C++/Java/Python/Perl/Ruby/PHP/HTML/CSS etc etc... I've read over almost all the MSDN documentation for C#, I understand the language, how its OO model works with interfaces and structs (however I think it's funny how switch statements function, and that MS didn't feel precedence was important with the ++ -- postfix/prefix operators.) Ok, so I get all that. Now the hard part! Point and click. (Visual Studio .NET 2005) When you create multiple forms in the project, is there some "running instance" of them once the program is executed I.E. with Form1 and Form2, where Form1 is initially run. The ...Show All

• SQL Server Securing the MS SQL Server 2005 database on client side

  Hello! I developed database driven .NET application and I need to deploy it. I faced a problem, which is "how to protect my database against direct access". I use MS SQL Server 2005 Express Edition as a DBMS and appropriate database. I want to make possible to manipulate with data in my database only through my client application. 1. How do I define SA password and instance name in silent mode of MS SQL 2005 EE installation with Mixed type of Authentication 1.1. Can I change SA password after the installation 2. If my database be attached to my new instance... Is it possible to copy my database, attach it to another in ...Show All

• Visual C# MFC Control on c# WinForm

  Hello I've got a c++ MFC 6.0 control with is panel with tree wnd view static text fields. I've puted this colntrols on WinForm as a part of winfrom interface. Now I can use this control - and it's look like rest of interface, I can choose node from tree and write text on static text control, The problem is when I'm traing use Arrows from keyboard, when I want to use arrows on tree - whole control is loosing focus and it swicht focus to the closest c# control on this winform. Any ideas ...Show All

• .NET Development Reliable, stable and adaptable client/server solution?

  I have a multi client/server project in development (VB.NET 2005) and was looking for a stable and adaptable basis for the networked communication between the clients and server. So far, i've got a tcpclient client-side and a tcplistener server-side, with a byte-based network stream providing the actual data transfer. Other posts reccomend asyncronous reads (which I have semi-implemented at the moment) but i'm not sure if my current approach can satisfy all of the application's needs. For a start, some of the data written to the network stream requires a reply from the server before the program can continue (for example, a login reques ...Show All

• Windows Forms Bind to IDictionary

  I have name/value pair of data (like Flash AsociativeArray or java HashMap):  Hashtable row = new Hashtable();  row.Add("name", "Wilson");  row.Add("age", 22);  textBox.DataBindings.Add(new Binding("name", row, "name")); If I want to bind a this to a textBox or a control  How  Above does not work. I do not want to write get/sets for all types of&n ...Show All

• Visual Studio Team System Hello Somehow I did it

  Hello, I had problems with security Issue's and I think I solved almost all of them except my last post. Now I have a red X in the document folder, what I should check   Avi   P.S My last Post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=183455&SiteID=1 10x If you mean the STS_WPG Group in "local users and groups" I added everyone to this group with full permission + in the IIS right click on the Share point site "permission" I added everyone too. Any other Ideas   ...Show All

• Smart Device Development rotating my app

  Hi In the designer I've rotated my form 90 degrees - but when I run in on my iPaq - it's not rotated - what do I need to do thanks Bruce You will have to rotate the screen on the device.  On the device go to Settings - Screen and select landscape mode either right or left handed. ...Show All

• SQL Server Compatibility Level SQL Server 2000 (80)

  Hallo Everyone, I have an SQL database that I need to detach from an SQL2005 server and reattach to an SQL 2000 database. I tried to set the Compatibility level from SQL Server 2005 (90) to SQL Server 2000 (80). This did not work Any ideas Nigel... How are you trying to do this   Try setting the compat level to 80 when attached to SQL Server 2005, and then attach to SQL Server 2000. Peter ...Show All

• Visual Studio Team System Context across multiple web tests.

  It appears that if I create a context that it only lasts to the end of the web test. Is there a way to create a context in WebTest1.webtest, then use it in webtest2.webtest, etc. If so do I have to do an ordered test for this to work Thanks, Tom I was successful in using a web test plugin to resolve my problem. The steps I took were: 1) create a web test plugin as described in help. I updated the static variables only if they were blank (the 1st time) 2) Created an ordered test. 3) added the web test plugin to all the web tests in the ordered test. When the ordered test was run, the 1st web test 'set' ...Show All

• Visual C# Download picture to report

  I need to produce a report of company products in which the photos are on company website already.  I want to download those pictures and populate a dataset which would be used as a datasource of the report. How can I download those pictures and how to know when all pictures are completely downloaded   If some pictures have problem in the download, how should I handle it(set timeout) Any suggestion is appreciated.  Many many thanks. ...Show All

• .NET Development Using a Stored Procedure VB.net 2005

  I have a form in VB.net 2005 application that need to run a SQL stored procedure but I am having problems in getting it to work The form checks a table and depending on the result updates another table Code used is Dim cn As New System.Data.SqlClient.SqlConnection Dim cmd As New System.Data.SqlClient.SqlCommand cn.ConnectionString = "Data Source=101.0.31.51;Initial Catalog=WSM;Integrated Security=True" cmd = New SqlCommand( "usp_resulttest" ) cmd.CommandType = CommandType.StoredProcedure cn.Open() cmd.ExecuteNonQuery() Allways fails on the ExecuteNonQuery I have checked the SP and that work correctly ...Show All

• Visual Studio Tools for Office VB2005 Viewing Access Report

  Hi, beginner needs help, I am currently working on a project that connects to a MS Access 2003 Database, the problem is that I need to be able to view the pre-set reports I have created in Access via my project, everything else works great. 1. Is there a method to pulling up the Access reports through a command click event 2.  Viewing the Access report would be great but if this is not possible what are my options   3.  I know I can integrate with word and export the data in the fields to one of these but how difficult would this be to do btw, the access DB will be located at a server just in case this c ...Show All

• SQL Server List all your connection managers

  Hello, I'm building a custom task which has a property ConnectionManager which obviously allows you to select which connection manager you're goinng to use. I know how to get the list of connection managers but how do I make them appear in a combo-box in the properties pane Anyone got some code for that Hopefully this is fairly trivial for you developer types out there. Thanks Jamie Adam Tybor wrote: I don't know about dataflow components, but on a custom task I simply created a property of type ConnectionManager and it gave me a drop down list of all the connectionmanager's guid's in the package. The built in type converter has ...Show All

• Visual Basic making images with buttons

  i want to make a program where when you check a check box it shows an image.what kind of coding does the button need You need to make a form with a checkbox and and picturbox on it and use code somewhat similar to this. Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged If Me.CheckBox1.Checked Then Me.PictureBox1.Load("c:\logo1.gif") Else Me.PictureBox1.Load("c:\logo2.gif") End If End Sub ...Show All