JoseBarrientos's Q&A profile

• Visual Basic Error connecting to SQL Server 2005 local instance using VB 2005 app

  I am trying to create a Visual Basic 2005 app and connecting it to SQL Server 2005 Express Edition (bundled with VB 2005) but i am getting errors I just want to know if there is any configuration that i need to perform on SQL server before attempting to connect VB 2005 App with SQL Server 2005 My sql server 2005 configuration is default.. that is i am only listening to local connection (remote connections, piped and tcp/ip connections are disabled). I am running 512 MB ram, 160 GB hard drive, Windows XP SP2 with all the updates Please help.. Asim Zeeshan This is the exect error msg i get... When I try creating a new connettion, I select SQL server, I select Windows Authentication (bcoz its a local sql server ...Show All

• .NET Development .Net 1.1 Windows control vs .NET 2.0

  Hello everyone, I need help. I have a Windows Forms Control developed for the 1.1 Framework that is deployed to all employees workstations in my company. This control interacts with a Scanner device. Then we have a ASP (vbscript) page has some Script that calls its methods locally. Documents are scaned on the web page and then uploaded to a server. Everithing worked fine until the 2.0 Framework was installed on the wrokstations for another application. Now on the script I get the "object doesn't support this property or method" error. If the .NET 2.0 is removed everything goes back to normal. Any clue ...Show All

• Visual C# Refresh Property Grid Values

  Sorry, but I had to repost this in the C# forum because no one answered me in the Windows Forms forum. Say I have an object, "oFoo", and I assigned oFoo to a PropertyGrid on my form. oFoo also has a .CurrentValue property. If I have a TrackBar (tBar) on my form, and when the user scrolls the TrackBar, oFoo's .CurrentValue is updated respectively. How do I refresh the CurrentValue so that it shows up correctly in the PropertyGrid Right now, the only way I can do that is by refreshing the entire PropertyGrid, but I would think there would be a better, more standard way of doing this. I've tried using RefreshProperties(RefreshProperties.All), but it doesn't even refresh the value in the property grid, so I'm pretty stuck ...Show All

• SQL Server update with sum

  i want to sum up the values during the update process but error raises You need a SELECT befor the SUM(...). UPDATE T1 SET ParentBandStd = (SELECT SUM ( T3 . NettStd ) FROM STAGING . DBO . CUSTOMERBANDINGLOAD T1 INNER JOIN PRESENTATIONEUROPE . DBO . CUSTOMER T2 ON T1 . LOCALPARENT = T2 . LOCALPARENT INNER JOIN PRESENTATIONEUROPE . DBO . SALESANDORDERS T3 ON T2 . CUSTOMER = T3 . SHIPCUSTOMER WHERE T3 . INVOICEDATE >= @STARTDATE AND T3 . INVOICEDATE <= @CURRENTDATE AND T3 . TRANSTYPE = 'L') ...Show All

• .NET Development Connect to Access DataBase with ADO .NET

  I need help, or an example, of how connect and work with a Data Base with ADO .NET. I've seen de sqlclient, but i don't need to connect at a sql server, i've my own database in my computer. is everything in the same way that in old ADO or is a special change thanks a lot! Ok, then the diference between ADO and ADO.NET is that the first uses RecordSet, and the second DataReader, or Datatable.. now i have a thing like this: Cadena = "SELECT * FROM EstRem" Set Conn = New ADODB.Connection Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & RutaBBDD Conn.Open Set Cmd = New ADODB.Command Cmd.CommandText = Cadena ...Show All

• Community Chat My creation: Color based object tracker

  Hey guys, I've created a program which uses a webcam to track things based on color. I'll use this as a vision system for some of my robots! Check it out on my blog: http://ashishrd.blogspot.com/2007/01/real-time-color-based-object-tracking.html Ashish Hello Ashish My name is bernardo and I'm very impressed with you software. We have a startup robotics company ( www.roboticsgroup.com ) I wanted to know if you are available for some small projects, and in the future maybe we can work on a larger one. You can reply to bernardo@roboticsgroup.com . Thank you. ...Show All

• Windows Forms Change Content

  Ok. I have been searching for many hours now, could someone please help me. I need to know how to change the current content so that when I click the Next button the content changes.  This would allow me to make more options available.   I really need to know how to do this in VB, please help. ...Show All

• Visual Basic Cannot update / insert to access table

  All. I have an access database containing one table stored in my resource file. I can select from this table using the OLEDBCommand and an sql statament etc which works fine. However when I try and do an update or insert to the table no changes actually take place even though when debugging the code it says its been successfully. Can any one help Code Below Cheers Dim PPSConn As OleDb.OleDbConnection, PPSCmd As OleDb.OleDbCommand, strSQL As String, RowCount As Integer = 0 PPSConn = New OleDbConnection(csGlobal.PPSLocalConnString) strSQL = "update tblLocalApp set LocalVersion ='" & "9.9.9" & "' WHERE AppID=" & ApplicationID PPSConn.Open() PPSCmd = New OleDb.OleDbCommand( ...Show All

• Visual Studio Express Editions remote computer

  Is possibble to connect to a remote computer in Visual basic express edition If yes, write me a code Thanks Ah! I see. Now this is the tricky one. Where is the computer located if its locally, on the same network for example, then depending on the permissions, you can create a directory without really requiring all that TCP/IP Classes. To do this:   System.IO.Directory.CreateDirectory(" path\folderName")   so if I had a computer on my local network then I would create it like so: System.IO.Directory.CreateDirectory("\\ computerName\shareName\NewFolder ") or if you have mapped the drive already within Windows, then specify the drive letter followed by the name of th ...Show All

• .NET Development saving xpath document

  public void EditAnnouncement( int intAnnID, string strAnnTitle, string strAnnBody) { XPathDocument annDoc = new XPathDocument ( "Announcement.xml" ); XPathNavigator annNavigator = annDoc.CreateNavigator(); XPathNodeIterator nodes = annNavigator.SelectDescendants( "ann" , "" , false ); XPathExpression expression = annNavigator.Compile( "//annPanel/ann/annID=intAnnID" ); if (annNavigator.Matches( "expression" )) { //////////////////////// in here is code true for my editing issue nodes.Current.MoveToChild( "annTitle" , "" ); (is this annTitle which id is same user sent; for example user sent to id= 1 is this child in sam ...Show All

• Visual Studio 2008 (Pre-release) How does WPF Handle simple control focus?

  I don't know if I am missing something, but WPF seems to be having trouble handling focus changes. If I make 2 textboxes and a button to switch the focus between them, something strange happens. WPF thinks it changed the focus upon the button.Click event, but it actually takes another mouse click (actually anywhere on the window, even the titlebar!) to make the cursor actually move from one textbox to the other. using System; using System.Collections.Generic; using System.Text; using System.Windows; using System.Windows.Controls; namespace Project3 { class Starter { [STAThread] public static void Main() { Application application = new Application(); Window1 window = new Window1(); application.Run(window); ...Show All

• Visual Studio Express Editions dynamic array of objects question

  In attempting to learn more about objects and arrays in C#, I have a little app that reads rows from a database, loads a list box with one of the column values and then creates a object to hold the data.  The code looks like this:   private Project [] Projects = null ; int iCounter = 0; if (reader.HasRows) { // We have projects - Populate the list while (reader.Read()) { this .lstProjects.Items.Add(reader.GetSqlString(0)); Array .Resize< Project >( ref Projects, iCounter+1); Projects[iCounter] = new Project (); // ProjectName=0, ProjectComment=1,ProjectUser=2,ProjectPath=3,ProjectID=4 Projects[iCounter].Name = reader.GetSqlString(0).ToString(); Projects[iCounter ...Show All

• .NET Development WSE 3.0 MTOM + Web service call that returns an array of a custom made class = HTTP 415 Error: Unsupported media type

  Hello, I'm currently having problems incorporating WSE 3.0 MTOM to an existing web service. With it turned off, everything's OK (But why turn it off when this is one major reason for having WSE 3.0). But when turned on, I get an HTTP 415 Error whenever the web service call returns an array of a custom "entity" class. I've done some web surfing and all I'm getting are variants of the fix found here http://tim.mackey.ie/MTOMErrorTheRequestFailedWithHTTPStatus415UnsupportedMediaType.aspx . I'm pretty sure this isn't it. Any suggestions/answers would be much appreciated.  Thanks! Using Service (I'm assuming this is a proxy derived from System.Web.Services.So ...Show All

• Visual Studio Team System XML Schema definition

  I have tried to access the XML schema definiton so I can make changes to my template and I am getting a "not found" error for http://schemas.microsoft.com/VisualStudio/2005/workitemtracking/typedef What's up Kathir is correct. You can also go to this help topic and download all the process template schema files: http://msdn2.microsoft.com/en-us/library/ms194967(VS.80).aspx Thanks, Allison [MSFT] ...Show All

• Visual C++ Can i make VS play a sound when build is done?

  Is this possible i know there are post build events and such but even when i try to print an ascii bell char to make it beep, it does not work. it would just be good to know when the build is finished. For why Visual Studio doesn't have build sounds and what to do about it, see this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=189939&SiteID=1 ...Show All