Wayne_Peterson's Q&A profile

• SQL Server Looking For Examples Of Stored Procedures in C# or VB.Net.

  Hi, Does anyone have any links to examples of stored procedures written in C# or VB.Net instead of T-Sql.  I'd like to see how it looks and works.  Thanks!  Ken. There are several examples available if you installed the samples and documentation.  They are located in the C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR by default. ...Show All

• Windows Forms New functionality in DateTimePicker control Please Help ??

  DateTimePicker Control Nice control but what about adding new functionality in it Like :- Adding a two more extra buttons < > like the the existings to allow the user to navigate through years like months Can any one help me, how I can implement a function like that Thanks more for every one Open a new custom control project and drag a DateTimePicker control to the design surface...now add two small buttons with the graphic arrows *<>* and use the onclick events to set the year of the DTP... HTH ...Show All

• Visual Basic Shell Method

  How can I load a folder up in the windows explorer Your first line, should be... Dim sFile As String = Me .TextBox.Text.ToString() Don't forget to add the .Text  before the .ToString(). If that doesn't help, debug the code, and check the value of sFile at the If statement. ...Show All

• SQL Server Database Mirroring : How to find the TCP port being used for mirroring?

  Hi, I am interested in finding the TCP port which has been setup on a principal/witness/mirror server. I have queried the  sys.database_mirroring_endpoints and sys.endpoints system views but nowhere does it specify the TCP port. I think the only way to find out is to go to one of the mirrored databases and to right click properties-->Mirroring. I think this is ugly way to find out the TCP port, so if anyones found a better way to find this do tell.... Cheers, Priyanga select * from sys.tcp_endpoints may be what you're looking for... -Keith. ...Show All

• SQL Server Webbrowser navigation

  HI all, I am customising the MSreporting services browser out put. While creatting my customised reports viewer i found difficulty in navigating thru pages. Can anybody help me. In the MSReport viewer when report is generated it will show the number of pages and we can go next and last etc... In my viewer i put a webbrowser control and used the navigate method of the browser to get the report. But the problem is it only shows the first page. How can i move to all pages . similar to MSReportviewr i like make navigation to back and forth , how can i do. help me ...Show All

• .NET Development IIS server accessible through local network but not the internet

  Hi, I'm using the IIS server on my windows Xp Pro at home. I can access the web server fine, and view webpages etc on my local network, when I ues the dns address. But when I try the same thing outside my network, it just says the page cannot be displayed. The thing is the J2EE server I have, could go though port 80 and it was accessible via the dns address outside the local network, and it viewed fine. I of course switched the J2EE server's port to 8080, to stop it from conflicting with the IIS server. On my router, i route the incoming connections from the net ip, to the local computer's ip on the network. Port  80 open for the s ...Show All

• Visual Studio Express Editions Locking Data in Combo Box

  How can I stop the items in my combo box list being deleted i.e when the program is run and the first item is displayed within the combo box I can delete the value that is displayed. However when I hit the drop down button the item is still there. Ideally I would like it so that if the "Del" key is hit nothing happens. Thanks in advance You can block the delete key by doing this: Private Sub ComboBox1_KeyDown( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyEventArgs) Handles ComboBox1.KeyDown If e.KeyCode = Keys.Delete Then e.Handled = True E ...Show All

• SQL Server array with sql server 2000

  hello I have created one store procedures that return a table variable 'CREATE PROCEDURE sptcondconsiglieri @immobile_id varchar(6) as DECLARE @tbl table(condomio_id Varchar(6),titlo varchar(5),nominativo varchar(256),stato int) DECLARE @colA nvarchar(50) DECLARE @MyCursor CURSOR /*declare @mycursor1 cursor*/ SET @MyCursor = CURSOR FAST_FORWARD FOR Select nome_consigliere From t_immoconsiglieri where immobile_id=@immobile_id order by posizione OPEN @MyCursor FETCH NEXT FROM @MyCursor INTO @ColA WHILE @@FETCH_STATUS = 0 BEGIN Insert @tbl SELECT dbo.T_Condomini.Condomino_id,dbo.T_Condomini.titolo,dbo.T_Condomini.Nominativo,dbo.T_UniCond.St ...Show All

• SQL Server SSIS Package runs fine except as a scheduled job

  I have an SSIS package created from a SQL 2000 DTS using the Migration Wizard. The package imports data from a MySQL database to a SQL 2005 64-bit database running on 64-bit windows server 2003. The package runs fine when executed from SQL Server Management Studio but when I schedule it as a job it fails with: Executed as user: [the domain admin account]. The package execution failed. The step failed. I've tried a lot of different ways to make this work including creating a new SSIS package. Again, the package ran fine except when it was scheduled as a job. Any ideas would be appreciated. thanks! ...Show All

• Visual Studio 2008 (Pre-release) I love DLinq. Really need n-tier support though.

  In section 7.4 of the DLinq guide it mentions that that's something you guys are looking at. Do you guys have an idea if that functionality will get in there before the product is given the green light to go-live Since most apps these days are designed as SOA, there will need to be a distributed notification mechanism. Thanks CZ The type of n-tier support we have for DLinq is simply an API that allows you to introduce objects to a new context after they have been round-tripped across the tiers. You still have to move the objects or data across the tiers yourself, and you have to figure out how to squirrel aw ...Show All

• Visual C++ 256 color (or true color) ImageLists showing up as 4-bit in CTreeCtrl?

  I have a basic CDialog and a CTreeCtrl in it. When I try to attach icons into it, I run into slight trouble. Even though the bitmap is 256-color or true color, the icons always appear in fixed-palette 4-bit (16-color) in the CTreeCtrl . The code is roughly this:   CImageList* imageList = new CImageList;   imageList->Create(IDB_ICONS, 24, 20, RGB(0xff, 0xff, 0xff));   tree->SetImageList(imageList, TVSIL_NORMAL);   tree->SetImageList(imageList, TVSIL_STATE); What might be going wrong here Both Create() and SetImageList() give S_OK . I see there's another overload of CImageList::Create() that ...Show All

• Visual Basic compiler and unexpected error (cqqueryeditquerysaveinterfaces.cpp)

  tried to build a project... and got the 'unable to comile ... error &Hxxxxxxxxx' etc. then noticed 1 warning 'unused variable' so I though I would jump in and fix that before attempting a full build... double clicked warning... went to comment out the variable line .... and I got the following message... Microsoft Visual Studio X Unexpected error encountered. It is recommended that you restart the application as soon as possible. Error: Unspecified error File: vsee\pkgs\vssproviderstub\cqueryeditquerysaveinterfaces.cpp Line number: 1060 any one shed any light on it for me Lex. ... more information ... ...Show All

• Smart Device Development Recording sound with a given volume threshold.

  Hi everyone, I am writing an app in c# that requires to record an incoming sound with a given volume threshold, say, when my voice is higher than a value, it will be recorded by PDA and when my voice is lower than the minimum value, PDA stops recording and a wav file is save in PDA. anyone has some ideas about doing that which lib, dll shall i use thanks a lot yes i tried that, i can record and play wav files but still have no idea about the volume threshold.... thanks ...Show All

• Visual C# HELP ME PLEASE!!!!!

  hi everyone when i press f4 i want to show the properties of the class how can i do this If you mean your how to popup the property view in Visual Studio, you can bind the F4 shortcut button to the View.PropertiesWindow action. You can bind this in the option screen of Visual Studio under the Environment->Keyboard section. ...Show All

• Visual Studio Team System Build FAILED: A database error occurred (SQL error 8152) ---> String or binary data would be truncated.

  Hi, I'm running Beta 3 Refresh in a single server environment. I've started moving our source code from StarTeam to TF Version Control, but have run into a problem with the build. I started out with a small sample and a simple build file and everything worked fine. Now I've checked a major part of our source code into TFVS and have set up a team build. The build have multiple solutions with multiple projects and several thousand source files. The problem now is that both the large build and the small sample build(that worked fine before I checked in all the source code) fail while checking out from version control. Everything still works fin ...Show All