xchiaroni's Q&A profile

• SQL Server Unable to connect to SQL Server after activating Remote Connections

  I also experience the same error 40. I've also followed the suggested solution to activate the remote connection. But, I still see the same error. Is is possible that I've restarted SQL Engine wrongly The following is what I received from the error message. Please guide me. Thanks Server Error in '/WebSite5' Application. Hi,    I have the same problem as brokenrulz.  Is there a solution  for this ...Show All

• SQL Server Queries returning Multiple instances of the same record

  I am running SQL 2005 and have created a simple database for interfacing with Visual Web Dev 2005 and Visual Studio 2005. I noticed that my applications where returning multiple instances of the same records in the queries. I went back to the SQL server and created a query, and sure enough, I'm getting each record returned 3 times. Where do I start to resolve this issue DOH! You were right. The records were duplicated. Apparently using the ...Show All

• Windows Forms TabControl: Custom TabPageCollection?

  I'd like to hook the TabPageCollection of the TabControl in order to fire events when pages are added and removed, is there any way to have the TabControl construct my TabPageCollection object rather than it's own I'd like to have functionality similar to overriding the ControlCollection of the Control object using CreateControlsInstance. Thanks, Ray Controls is inherited from the TabControl's base class, P ...Show All

• Visual Basic Updating Data from a table Adapter

  Honestly I do not understand why I need to write code to update a databse and why it stores it localy. I'd simply rather the system update the individual row after it is scrolled off of. In either case since I guess I can't do that. Here is some code in a button on a form Try ItemsTableAdapter.Update( NewCreationsDataSet1.Items) LineCodeTableAdapter.Update( NewCreationsDataSet1.LineCode) Catch ex As Exception MsgBox(e ...Show All

• Visual FoxPro Microsoft treeview: Newbie Question

  I'm using VFP6 with Microsoft Treeview. I have a little newbie doubt: Can I programatically collapse and/or expand a tree node What command do I use in order to do it Thanks in advance. It's simple. For example: ThisForm.TV.Nodes.Clear ThisForm.TV.Nodes.Add(, 0, "ListRoot", "Lists") ThisForm.TV.Nodes.Add("ListRoot", 4, "Lists", "Printable lists") ThisForm.TV.Nodes.Add("ListRoot", 4, "Exportabl ...Show All

• Windows Forms datagridview Button Column

  Hi, I got this issue. I have a datagridview with one column of type DataGridViewButtonColumn. I want to put a text on the button. I've tried in the Edit Column options to put the text in the Text properties and even set the UseColumnTextForButtonValue to true. Doesn't seem to work. I can't find a way. Please help, Thanks, Found the answer in the forum ... http://forums.microsoft.com/MSDN/ShowPost.aspx PostI ...Show All

• .NET Development RAS

  Hi, I am writting application that uses the funcion RasDial ... from some reason i am allways getting error in the return value it is always 87... the prototype is like this [DllImport("rasapi32.dll",CharSet=CharSet.Auto)] public extern static uint RasDial(IntPtr lpRasDialExtentoins, string phoneBook,RasDialParams lpRasDialParams, int dwNotifierType,RasCallBack lpNotifier,RASCONN lpRasConn); the delegate is defined like this: pub ...Show All

• Windows Forms open a web page

  Hello, I have a project where I have to create an exe to access a webpage every 5 minutes or so.  Is this possible to do this in Windows form   Thanks. You can add a timer to your form and add this code to  ...Show All

• Visual C++ errors while executing vc++ code

  Hi I have one opensource of vc++. While executing this code it is giving the following errors. 1)error C2433: 'HWND' : 'inline' not permitted on data declarations 2)error C2143: syntax error : missing ';' before '{' 3)error C2447: '{' : missing function header (old-style formal list ) 4)error C4430: missing type specifier - int assumed. Note: C++ does not support default-int 5)error C2086: 'int CALLBACK' : redefinition If any one got these erro ...Show All

• SQL Server HELP - Cannot connect to SQL Server 2005 Express

  I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express But when i load the latter and try to connect to my database I get the below error message. TITLE: Connect to Server ------------------------------ Cannot connect to DEVCOMP\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 20 ...Show All

• Software Development for Windows Vista DependentUpon missing in VS2K5 Extensions beta 2

  Hi, I've installed Visual Studio 2005 Extensions for Windows Workflow Foundation (beta 2) and I have a problem when I add "Sequential Workflow (with code separation)" to a "Sequential Workflow Console Application" project. After adding the item to the project two files appear in the VS Solution Explorer: Workflow.xoml as Workflow.xoml.cs. But the problem is that they aren't related. The .xoml.cs isn’t under the .xoml. ...Show All

• SQL Server Backup of databases within SQL Server 2005 Express

  Hi there! Is there any replacement for the missing SQL Server Agent which could be configured to backup "all databases" and fix minor errors in databases, rebuild indexes, etc. Or let's better ask: is there any solution/tool out there to create and execute maintenance plans without the need of SQL Server Agent (It might be a simple tool that enumerates the DBs and executes some T-SQL statements on them) Thanks Jochen ...Show All

• Visual C# How to Send mail -help please-

  iam a new C# asp.net developer and i want a code to send mail to mysite users . i want a code and instruction to get my framwork ready tahnks for help This question has been asked many times on the forums. Please do a search and you will find the code and instructions you are looking for. Here are a few to get you started: v1.1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=717&SiteID=1 v2.0 http://forums.microsof ...Show All

• .NET Development Sudden DB connection failures & session expiry problems - How to find the cause

  I've been tearing my hair out over this one and I can't seem to find a solution :( Here is the error message in question: ExecuteScalar requires an open and available Connection. The connection's current state is closed. at System.Data.OleDb.OleDbConnection.CheckS tateOpen(S tring method) at System.Data.OleDb.OleDbCommand.ValidateC onnection( String method) at System.Data.OleDb.OleDbCommand.ValidateC onnectionA ndTransact ion(String method) at ...Show All

• SQL Server DataSet and Insert method

  hi, i created a query to insert a row in DataSet in Visual Studio 2005. i gave the method name to the query i created. as i understood it returns '1' if successful or '0' if not. is it possible to get the ID or the row instead Hi, ok then go the OUTPUT way (described in the BOL) INSERT INTO Sometable (Columnlisthere....) OUTPUT INSERTED.* VALUES ...Values here... HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All