Sianspheric's Q&A profile

• SQL Server Why can you not create a Query Notification subscription in TSQL?

  The title says it all. You can do it from a ADO.Net client so why not from TSQL. It all uses the service broker stuff so why not You can not do it from an internal CLR assembly. This is explcitly block. Secondly the comments in the article don't answer the question how you get the Engine to start monitoring for changes to a query via TSQL ...Show All

• Windows Forms Searching for specific text data in the datagridview control

  I have been tearing my hair out looking for a way to search all the rows in a selected column of a databound datagridview control for specific text (like a combo box lookup) without success. I am beginning to think that it is not supported and I will have to buy something like vsflexgrid.net. Is there a way to do this without buying a third party control You can do an exhaustive search over all the cells of the datagrid view for the key like this For counter = 0 To (DataGridView1.Rows.Count - 1) For counter2 = 0 To (DataGridView1.Columns.Count - 1) If (DataGridView1.Rows(counter).Cells(counter2).Value.ToString.Contains(key)) Then MessageBox.Show("found") ...Show All

• Visual C++ Divide without using operators

  I need a code for Dividing two integers but ... without using any operators ie (+,-,*,/) to get the Quotient and Remainder One can use math.h . plz help me thanks..... You know, google won't bite you. http://www.bearcave.com/software/divide.htm ...Show All

• Visual Studio Express Editions how can i draw lines or tables in my form?can any one give me code for saving files in .rtf format?

  how can i draw lines or tables in my form can any one give me code for saving files in .rtf format Very Very soon - a couple of new shape controls will be made available by Microsoft to allow you to draw shapes on the form at design time. Was there in VB6 but got lost in VB.Net and now its going to make a reappearance as a free download - keep eyes on MSDN site. ...Show All

• Silverlight (formerly WPF/E) "WPF/E" Feb 2007 CTP refuses to load

    Earlier today, you may have noticed your “WPF/E” December Community Technology Preview (CTP) control expired.  No worries though- we’ve just posted the February CTP for Windows and Mac  to Microsoft's download center and updated the samples on the Channel 9 Playground to work with the new CTP.  Note that to get your samples working with the February CTP, you’ll need to change out the agHost.js file with the new one found here . Tomorrow we’ll update the website with details on what’s new in this release, and an updated SDK and samples will be available soon too. Thanks, "WPF/E" Marketing Hi Mr. Cohen, Just as an FYI, I selected the link to the agHost.js file in your post above and I ...Show All

• Visual C# video frame extraction&turn still pictures into animated GIFs

  Hi, 1.Can anyone kindly tell me how to extract video frames to (.bmp,.jpg) from video(.mepg,.avi) 2. And how to turn still pictures into animated GIFs using C# thanks Frank It doesn't sound like the whole application to me, just like a major function in the application. First results on Google for "c# extract video frame" (no quotes) are: http://www.codeproject.com/useritems/ExtractVideoFrames.asp and http://www.codeproject.com/cs/media/avifilewrapper.asp For the animated gif, try http://www.codeproject.com/dotnet/NGif.asp , and make the correction in the comments if needed. ...Show All

• Visual Basic Weird DataGridView Adding Data Error. You can't have an index = -1

  I'm having a weird problem while using a DataGridView. I'm using a DataGridView to display some information in an list of something called a Flag. Most of the information are String, one column per Data Property. In my program, I've got a button I press to add an element to this list. So it adds a new flag and refreshes the DataGrid and the new Flag appears. Now, here's the problem. If a Flag is added to the list before the DataGrid is first shown, it works fine. BUT, if the list is empty when the DataGrid is shown and I then press the button to add a new flag, I get an IndexOutOfBoundsError when I click on any cell in the DataGrid. It's the most bizarre thing; if I start with a flag in the list before showing the Grid, I can a ...Show All

• Visual Studio Express Editions Publishing to install on offline computer

  I need to install my program on a computer that doesn't have the internet. When I went to publish it I changed the Install Mode to "The application is available offline as well" but when I went to install it, it tried to connect to the internet to install .NET Framework 2.0. So I checked the prerequisites and .NET Framework 2.0 was checked. I unchecked it but then when I went to install it, I got a message asking me which program to use to open the setup file. Anyone know what I can do No, I'm sure if it did then I could deselect it as a prerequisite and it would probably still install but I want to know if there is a way to add the .NET Framework as a part of the setup. ...Show All

• Visual C# Getting information OUT of Excel

  Hi, I have an excel file with 1000 rows in it and 5 columns. I have a windows form where I select the excel file. I need to be able to open this file and retrieve all the rows from it. I then need to split the rows into cells and insert the data into an SQL database. Any pointers in the right direction would be really useful, so would some code examples. Cheers Jon You can query Excel files with OleDB. This has on great advantage, you don't have to have Excel installed on the machine and you will get an DataTable as result. You can put the data in this datatable in you database very easy with a SqlDataAdapter. Here is the code to read from the Excel file: public DataTable GetDataTableFr ...Show All

• SQL Server SQL Reporting Services..

  Hey guys, Is it possible that a report viewer on VS2005 to send an email manually w/o using the subscription services Also, is it possible to preview a reporting services(2000 Version) to a VS2005 report viewer Thanks in advance.. Hi, thank you for your prompt reply. I appreciate it. Just wanna know how you were able to render it to the appropriate format. Can you provide some code Sorry for the newbie question. Thanks in advance. :) ...Show All

• SQL Server Missing Sql Server node

  I have just installed Visual Studio 2005 team system beta 2 on an XP machine which had a sql server 2000 previously installed. However I do not see the Sql Servers node in Solution explorer. I do have the data connections node and can make conenctions to the server. Does anyone know what I can do to make the Sql Servers node available Hi Asim Shah, You should register again almost one SQL Server there. Good Coding! Javier Luna http://guydotnetxmlwebservices.blogspot.com/ ...Show All

• Visual C++ Bug in Windows 2003 winsocks or MFC CAsyncSockets implementation?

  Download this http webserver example from msdn. http://msdn.microsoft.com/library/default.asp url=/library/en-us/vcsample/html/_sample_mfc_httpsvr.asp Compile and run the software on any Windows 2000 box, with Visual C++ 6.0 or Visual Studio 2003. (I have not installed 2005 to try it with it.) Now inside c:\Webpages (the root dir) put a really large file, say 300k. Download it from another machine. If you had installed the server on Windows 2000 - the download goes very fast. I get (150kb/s). I use wget to time the download speed, and download from a unix box at a different location. You can also use Internet explorer to time the results, but wget is more accurate. Now copy the same server program into a windows 2003 machine an ...Show All

• Software Development for Windows Vista Problem Integrating WF with Visual Studio

  I have just set up a clean installation of Vista Beta 2 64 bit ()build 5384) with the intension of testing out WorkFlow I have followed the instructions to install Visual Studio, the SDK and Orcas. Starting up visual studio I get no WF option in the project types And when I try and install Visual Studio 2005 extensions I get the follwoing error message: Platfor Prerequisites Missing -- Windows Workglow Foundation version 3.0.4125.0 I have checked the WF components are turned on in control panel and it is. "Interestingly" if I create one of the new Windows(winfx) project types I get a load of new WinFX items I can add but they all display as a black window without any tools that can be dragged on... which is m ...Show All

• Visual Studio Express Editions How to SUM column data

  Hello, The result of a query in TableGridView looks like this: Location Number1 Number2 Thanks again, Inserted your line (it would not take without " Me .Database1DataSet" ---------------------------------------------------------------------------------------------- Private Sub Find_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Find.Click Try Me .Table1TableAdapter.FillBy( Me .Database1DataSet.Table1, LocationComboBox2.Text) Catch ex As System.Exception System.Windows.Forms.MessageBox.Show(ex.Message) End Try Dim result As Integer = 0 result = Table1BindingSource.Count If result > 1 Then Me .DataEntry.SelectedTab = TabPage4 ...Show All

• SQL Server WQL Query - Where Cluase

  Hi, I am trying to collect windows event log in a raw format. I need to collect this data everyday for the past day but somehow I can't use the date criteria. Please Guide. The following query also brings data for 20061104 too. Is there a date function or Left function which I apply to get data only for specified date. SELECT ComputerName, Logfile, RecordNumber, Category, CategoryString, EventCode, EventIdentifier, EventType, Message, SourceName, TimeGenerated, TimeWritten, Type, User FROM Win32_NTLogEvent Where LogFile = 'System' and TimeGenerated >= '20061105' and TimeGenerated < '20061106' I did post my question to SQL Server Integration forum as SQL Server Integration has WMI Task. Someone move this to SQL Server D ...Show All