Angelo_f's Q&A profile

• Visual Basic select on dataTable

  i have a dataSet with dataTable how can i select 2 fields from dataTable i tried something like- ds.Tables(0).select(String.Format("Field={0}",columnName)) but it didnt work thanks the Select property/method (or filter in the datatable object) will only query the dataset/datatable (like you do in a SQL Select statement) you can get the value for the column on the specific row:   Dim theColumnOfData as Object() = theDataSet.Tables(0).Rows( RowIndex ).ItemArray( ColumnIndex)   I guess if only want to show 2 fields, you should base your SELECT statement selecting the 2 fields only     ...Show All

• SQL Server Change the WHERE conditions dynamically

  Is there a way I can build a case statment or similar to handle different where conditions I know I can do it dynamic sql but it would be nice to have a method where I can create the querries directly in a normal statement Someting like: Select c1, c2, c3 From Table WHERE Case @Condition WHEN '>' @SelColumn > @Limit WHEN '=' @SelColumn = @Limit WHEN '<' @SelColumn < @Limit END I know this doesn't work so an example that do work would be nice. MortenBE wrote: Is there a way I can build a case statment or similar to handle different where conditions I know I can do it dynamic sql but it would be nice to have a method where I can create the querries directly ...Show All

• Visual Basic system.directoryservices encryption parameter

  Hi, I know that this might be a wrong place to ask this question in the forum, but I could not find another place to ask this question, anyways here it is: The application that I am working on would require the authentication of users using LDAP over Active directory, the actual line of code doing the authentication looks something like this: Dim authDir As System.DirectoryServices.DirectoryEntry Try authDir = New System.DirectoryServices.DirectoryEntry( LDAP://DC=xxx.xxx.xxx , UserNameTextBox.Text, PasswordTextBox.Text) MessageBox.Show( "authenticated" ) Catch ex As Exception MessageBox.Show(ex.Message) Finally authDir.Close() End Try the code authenticates the user, but the security ...Show All

• Visual C# Monitoring Suspicious System Time Change

  I'm at a lot as what to search for but heres my problem. The current application I am writing depends heavily on specified dates. The program will compensate for any computations it may have missed since it was last ran. So the program doesn't have to run continuously. Each time the main loop executes I store a LastTick DateTime into a database. So if the System Date is set back I can catch this. But is there a way to tell if the system clock was purposely pushed forward w/out quering a web service The problem arises if a user pushes his clock forward by accident or on purpose and runs the application (or if the application is already running). The app will think that it just hasn't ran in X days since lasttick and compute and store vario ...Show All

• Visual Basic How to change the culture in a thread or application or program.

  my VB.net 2005 Application is My .Application.ChangeCulture( "en-GB" ) the problem is, my OS dateformat may be will not be matching my application culture. e.g. 7 april 2007 at my application = 2 July at my OS my prblem is: when I send 07-02-2007 to my database it will save depends on my OS format then when I retrieve the value it will be 02-07-2007, it changed from april to july Sorry Dear, My column datatype is datetime, the problem is my Access database datetime format is same of OS, but My application is fixed format My .Application.ChangeCulture( "en-GB" ) I hope to try to change your OS datetime format from ControlPanel and make your application fixed culture as me, and try to ceck the ...Show All

• SQL Server Viewing DTS package Logs in 2005 Server Management studio

  We still have some Legacy 2000 DTS packages running on our 2005 Server. The DTS packages have been configed to save the logs on the 2005 SQL server. We can manually look at the logs in 'msdb.dbo.sysdtspackagelog' and 'msdb.dbo.sysdtssteplog' table but I am looking for some GUI tools so our tech support can view the package logs without writting a query. In 2000 Enterprise Manager, you can right click on a DTS package and select 'Package Log...' and then a nice GUI window will show up for you to browse through all the dts logs. I just can't find this tool in 2005 Server Management Studio for Legacy DTS packages. If I right click on a Legacy DTS package, all the option I get are 'Open, Migrate, Export, Delete, Rename, Refresh'... Si ...Show All

• Smart Device Development Compress data on GPRS connection

  hi all! i have a smart-phone with CF 2.0 but it haven't umts/wi-fi connection. i have read that the CF 2 support the gzip compression, right so...is possible to compress all the data on gprs, send them to a server (with public ip) that decompress and send them to the final destination and the same for the answer, the server compress the answer and send it to my smart-phone that decompress the data. so to have a faster connection and to pay less (i pay for kilobytes) ok...now i have configured my smartphone! all the connection are redirected to a specific port of the phone. but now i have an other problem: how can i skip the proxy and connect with the gprs in order to send the data to int ...Show All

• Visual Studio 2008 (Pre-release) WPF and Directshow

  I have previously asked this question in a Directshow forum, but got no answer. I have made my own movieplayer control (Directshow library with .NET 2.0 wrapper) and now I am trying to get it to work with WPF. However whenever a WPF control is placed upon the video, the overlapped region starts flickering :( both with and without translucency. Any idea how to solve this I can see that Microsoft do not have this problem with their MediaElement control, but have not been able of figuring out how they do it. Using MediaElement is not an option, since I have some features which are not available to MediaElement. Regarding the TV tuner part. Would it be possible to make a source filter which is basically ...Show All

• Microsoft ISV Community Center Forums Live Communications Server tab does not show up

  I have just installed Live Communications Server 2005 Standard in my test enviroment. I have a seperate server as a Domain Controller (all servers are Virtual Servers on one physical machine). When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I open the User Properties window on my DC, there is no Live Communications Server tab. It should show up there, but it isn't. Also, when I open the Live Communications Server Management Console, I only see an empty screen and no 'tree-view' of possibilities. When I manually add the snap in after running mmc, it works and I can see the Forest, Domain, etc. Nothing, except the Management Console, di ...Show All

• Windows Forms DateTime format problem in SQL query...

  Hi! I have a DataGridView connected to a dataset and I 've already created a query which searches the entire database in order to extract rows with a certain date. The user enters the desirable date in a textbox. But there is a problem with the date format: I've found that when i enter the date in the following format: MM/dd/yyyy it works fine.But wherever i am using this format: dd/MM/yyyy Visual Studio generates the following error: ''An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Additional information: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.'' Any help how to overcome this problem ...Show All

• SQL Server Migrating Access XP database to SQL Server 2005 Express

  I want to migrate my Access XP database to SQL Server 2005 Express Edition. The Start Menu does not display any migration assistant in SQL Server 2005 Express menu list. How to migrate it hi, never tried it my self, but have a look at http://www.microsoft.com/downloads/details.aspx familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en regards ...Show All

• Visual Studio Team System no red cross mark.

  I decreased my response time goal to 0.01sec and when i ran the load test the value of avg response time was 0.10(min) 0.20(max),however it still didnot give me any Red cross on avg response time when it is not meeting the goal set.Instead it gave a red cross on avg. connection time .Kindly tell why Thanks i appreciate your help however ,the first question still remains unanswered why did it not gave a red cross on the LHS column that is under COUNTERS for Avg Response Time as it is not meeting the goal.Kindly explain. ...Show All

• Windows Forms Capturing MouseWheel Event - Different mouse, different behavior

  Hi, I'm actually using Managed C++ within VC++ 2005. I tried to add handling of mousewheel. I've put following code: 1. EventHandler: this->WA_TbPgDrw->MouseWheel += new System::Windows::Forms::MouseEventHandler(this, &Form1::Analyse_MouseWheel); 2. Routine for Handling event: private: System::Void Analyse_MouseWheel(System::Object* sender, System::Windows::Forms::MouseEventArgs* e) { if(WA_TabCntrl->SelectedIndex == 0) // Onglet Design { if(e->Delta > 0) { if(ZoomAffVal < 100) ZoomValue = ZoomAffVal + 1; } else { if(ZoomAffVal > 50) ZoomValue = ZoomAffVal - 1; } if(Modules_Hors_Limites(S"Screen")) { ZoomValue = ZoomAffVal; // Restaurer la valeur precedente... th ...Show All

• Visual Studio Team System Is there a way to pass session between webtests in an orderedtest?

  Is there a way to pass application session info between webtests in an orderedtest webtest1, for example in an ordered test, logs in. webtest2 needs to be logged in to work... webtest2 does not itself log in because I'm trying to write webtests modularly. webtest2 was hoping the ordered test it's in would still be logged in to the app from the successful execution of webtest1... But this does not seem to be the case, unless I'm missing something I need to set of specify... Is this supported Thanks! :-) Hi Bill! Good to hear from you again! We met in April at WOPR6. I was there for the 3 SWOPRs. Yes this does help, at least it confirms that passing app session between webtests in an ordered tes ...Show All

• Smart Device Development error 0x00000716

  I have made an application in windows mobile 5.0 pocket pc.I have put the error logging in my application.I am getting followinf error GetLastError returned : 0x00000716: The specified resource name cannot be found in the image file.  ) Can some body please help me out about what is this error and how can i overcome it   ...Show All