bharathirajaa's Q&A profile

• Visual Studio Express Editions How to connect vb2005 express and SqlServer Express through a network

  Dear all, I installed Visual Basic 2005 Express and SqlServer Express. I tried some features of both of them but I'm not able to connect a databse through a network. To explain, I have two computer in the same work group. In one of them I have installed SqlServer Express and the other one works as client, i mean, i want to develop a software able to connect to the first one and make operation with the database. Using the "DataSource Configuration Wizard" I have to indicate the "database file name" which is not visible through the network. With the VB6 and MSDE2000, using a connection string, it was easy to connect to a server through a netw ...Show All

• SQL Server Why can't query analyzer be made to work for SQL 2005?

  I know my investigation is pretty light but it appears that DMO works fine against SQL 2005 (we use the same code to generate script against a SQL 2005 server that we do for a sql 2000 server). Why prevent query analyzer from being able to use the same DMO so that it works on SQL 2005. I really miss the simple ways of using query analyzer that I have become accustomed to and would love to be able to keep it in my toolbox foruse with both databases. Also why (when using query analyzer search, one of the best features that I miss) does it prompt you to install the stored procedure and then not work anyway sp_msobjectsearch . ...Show All

• .NET Development user name and password to IIS

  I all, I'm trying to connect to a webservice located on my PC. So, I typed the http://(MY IP...)/WebService/Service1.asmx Then the browser give my authentication window. how can I add a user name and password to be authenticated. Is my way right. I want to attach the web service from anoter computer . Please help me... You must add a local user on your machine. You can do that in the User Accounts control panel. You should also check that the user has permission to access the files, from Windows Explorer. Right click on the folder containing the files and choose properties and then you can look under Securit ...Show All

• Windows Forms want a button be focused always !

  hi i have a windows form , with some text boxes. after enter sth. in them, user should press the button, but if user want to press it by the "enter" button on keyboard, it doesn't work. i mean it isn't focused automatically , would u please give some idea thank u Forms can automatically react to ENTER and ESC by default.  You just need to set the AcceptButton and CancelButton to the appropriate button on your control and whenever the user hits either of these keys the appropriate button will be clicked.  Note that this might not work for all controls but most (including multi-line textboxes ...Show All

• Visual Basic Use string value as variable name

  How do I use a value of a string as a public variable name/object that I can then change.... dim var1 as integer dim var2 as integer dim var3 as integer...ect... Dim vroot as string = "var" Dim i as integer = 1 Do var + i.tostring 'this returns "var1" 'now how do i use this var1 returned value to act like a variable i=i+1 loop until i = 15 Also how would i do this with objects....say i had a series of labels named label1, labe2, label3...ect... to call these through a "label + i.tostring + .text" script also...... Catch my drift....is this possible Thanks! Hi, I don't think that this is possible. B ...Show All

• Windows Forms ListView column autosize

  hi all, is there a way of making a ListView control autosize based on the data inside it i.e. the column adjusts to the size of the longest string inside it regards hi Frederik, thanks for your help it works, but now it makes the column smaller than the column heading. is there a way of ensuring that the column is bigger or equal to the length of the column heading ...Show All

• Visual Studio 2008 (Pre-release) Is there a sample that uses ResourceDictionaryLocation.ExternalAssembly?

  The sample that specified ResourceDictionaryLocation.ExternalAssembly for ThemeInfoAttribute was not able to be found. I made MyControls.dll and MyControls.Luna.dll. The resource of MyControls.Luna.dll was not used though ExternalAssembly was specified. What is the name/location of the ResourceDictionary XAML file in your MyControls.Luna.dll System expects that the file will be in the "themes" folder and named according to theme and color scheme... Giving: themes/luna.normalcolor.xaml (default color scheme) themes/luna.metallic.xaml (silver color scheme) themes/luna.homestead.xaml (olive green scheme) ...Show All

• .NET Development inherit from XmlElement

  To create/manipulate an XmlDocument I created some classes inherited from XmlElement. Those have some attributes and functions which makes it easy to work with the XmlDocument in the context. Creation works perfectly, so something like this: MyXmlElement element = new MyXmlElement(prefix, localName, namespaceURI, doc); ... rootNode.AppendChild(element); But if I save and load the XmlDocument again, how do I get my special elements back The cast does not work: XmlNode node = xmlDoc.SelectSingleNode(queryString, xmlns); MyXmlElement element = (MyXmlElement)node; leads to: "Unable to casr object of type 'System.Xml.XmlElement' to type ...Show All

• SQL Server Cursor count

  Hi! How can I get the size of a cursor variable (the number of rows in it) Thank you! Hi, use @@CURSOR_ROWS HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio How to Change Null Value Parameter Prompt Checkbox

  How can I change the Null value parameter prompt checkbox When my users select the Null checkbox for a parameter, the report returns everything, which is what I want to happen. But my users would prefer that the checkbox say "All" instead of "Null". They feel that Null is confusing. You need to implement the interface on one of your own classes. Take a look at this article: http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportviewermessages.aspx ...Show All

• Visual Studio Setting a breakpoint that only stops one thread?

  I have a helper thread in a C# application, and some code in the application that it runs and I know for sure will never be reached by what I will call my "critical threads." Is there a way to set a breakpoint that, when hit, will only halt the thread that hit the breakpoint Yes. Place the mouse over the breakpoint glyph and select Filter... from the context menu (right mouse click) and then specify the threadid(usage information provided in that dialog). You can also get to the Filter... option by placing cursor on line with the breakpoint and selecting Breakpoint from the context menu. Azeem Khan ...Show All

• Microsoft ISV Community Center Forums VS2005: Any more CTP or RC builds to come?

  VS Release Team, I've searched these forums and have even researched a number of blogs, but I haven't been able to find out when the next VS2005 drops will be. I'm currently using the July CTP for VS2005 Pro, and am tracking a number of issues with my current development project that I'm hoping will be resolved in future RTM builds, either within Visual Studio itself (e.g., Forms designer), or as a result to fixes in the Framework. Could somebody comment on the availability (to MSDN Universal and/or other subscribers) of additional VS2005 drops, including August CTPs and/or Release Candidate (RC) builds Also useful would be to hear whether o ...Show All

• SQL Server Password Protected Excel File

  Hi I'm in need of a bit of assitance here.  Basically I am currently creating a SSIS package which works in principle with the exception of my data flow.   On my data flow I am reading an excel file using the excel source, this works fine for a number of my examples but one of the excel files is password protected.  This is throwing an error when I try to run the package. Does anyone know how to read a password protected excel file Thanks Kismet123 You cannot access a password-protected Excel file using the Jet OLE DB Provider, period. I probably shouldn't mention this, but as an int ...Show All

• Windows Forms My latest pet peeve

  Erm, just  a thought...but PLEASE...*PLEASE* add a .Tag or .Name property to MenuItem ..i'd be in love then :( I've done this before, but then I sacrifice being able to use the designer to modify the menu.  Does anyone know if the Menu designer can be forced to use a custom MenuItem instead of the normal framework MenuItem Thanks, Ro ...Show All

• Windows Forms Getting BindingContext to save current edits.

  I have a form that uses BindingContext and CurrencyManager. It works fine, but when I click save, the current TextBox does not save its information (maybe it's not marked as dirty until moving to a different Position ). What's the simple, standard way of coding a statement that basically says "save the current record's updates too" Hi Silona, It&n ...Show All