Kevin Dente's Q&A profile

• SQL Server error_number() won't return error code

  hi all, i have sql statement in ExecuteSQLTask, connecting to AdventureWorks BEGIN TRY insert into person.contacts(contactid) values (1); END TRY BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber; END CATCH; i purposely put a table that does not exist in the database to catch the error. however, the error number that is 208 won't appear, instead the whole error message will be displayed. if i change the query in try block to insert into person.contact(contactid) values (1); it'll return the error number 544, which is correct. what did i do wrong thanks! thanks jaegd for your reply.. it didn't say in BOL that try/catch doesn't catch all errors or maybe i left that out. anyhow, my ...Show All

• SharePoint Products and Technologies Is it possible to run SharePoint as XHTML Strict?

  For accessibility reasons and to adapt to the current direction we are going as a goverment agency we would like to get a definative answer as to if it is possible to define SharePoint as XHTML Strict to apply our current CSS. If it is possible, is it worth the cost it might take to make it happen, considering future upgrades, changes to templates, etc. I have found some sources stating it is not possible but I can't consider them "official" sources. Thanks for the info. Terry I've never seen any indication that Microsoft was interested in adding XHTML support to Sharepoint (or any of their products, for that matter). It would be a virtually impossible task given all the 3rd party co ...Show All

• Visual C# Datagridviewcomboboxcolumn error

  I always meet “System.Argumentexception…. datagridviewcomboboxcell value is not valid “ problem. The following is my code: DataTable tCompany = Database .dIResearchDataSet.Tables[ "Company" ] DataTable tEquipment = Database .dIResearchDataSet.Tables[ "Equipmment”] DataGridView dgV1 = new DataGridView (); dgV1.DataSource =tEquipment; DataGridViewComboBoxColumn col1 = new DataGridViewComboBoxColumn (); col1.DataSource =tCompany; col1.DataPropertyName = tEquipment.Columns[ "Manufacturer" ].ToString(); col1.Name = "Manufacturer" ; col1.ValueMember = tCompany.Columns[ "prefereredName" ].ToString(); col1.DisplayMember = col1.ValueM ...Show All

• .NET Development System.InvalidCastException: Unable to cast object of type 'ASP.students_payment_aspx' to type 'WMProShop.Payment'.

  I GET THE FOLLOWING PROBLEM WHEN I AM MAKING THE CHANGE IN THE APPLICATION AND REUPLOAD ON THE SERVER PLS PROVIDE ME THE SOLUTION SOON THANKS Server Error in '/' Application. here is the code of the page using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using WMProShop.Controls.Payment; /// <summary> /// Summary description for SchoolCatalog1. /// </summary> public partial class Payment : System.Web.UI. Page { prote ...Show All

• Visual Studio Express Editions New projects fail to run

  xI created a new project today, and for some reason, when I try to run it, it exits as soon as it starts running. I've created other projects with this installtion of VB Express and never had a problem. The old projects even still work and run as I'd expect. As a test ,I created a new Windows Application with nothing in it but the default Form1, and ran it. It also exits as soon as it starts. BUT... If I double-click the exe in the debug folder, the Form1 window pops-up as expected. I even tried installing SP1 for Vb Express and that hasn't helped either. Does anyone have any idea why new projects would suddenly stop working Ok I just tried the adding some code to the form load handler: Private Sub For ...Show All

• SQL Server Can anyone explain this processing schedule

  Hi, I have a fairly complicated cube which has: 74 Measure groups Each measure group contains 12 partitions = 888 partitions in my cube I have a parameterized XMLA processing script that processes 2 partitions in each measure group - i.e. 148 partitions. It does this inside a <Parallel></Parallel> element. When I executed the XMLA script I recorded the progress in Profiler. I saw that, prior to processing the 148 paritions, there was lots and lots of "Progress Report End" EventClass records with a message of: Finished processing the ' <partition name> ' partition There were actually 518 of these records so whatever it is doing, it is not doing it for every single partition. Note th ...Show All

• Visual Studio Replacing Project Name

  I have a solution developed in Visual Basic with one Class Library and one website. I have the custom template created and it works fine. However, the website always comes across as 'Site' or whatever I put in the vstemplate for the project name. I am looking to have the developer choose one and have it update it. I was looking into WizardExtensions but have been unable to get it to work. Now I am looking into GAT. Can someone point me where I should look for this since I have not seen examples that create web sites as well and being that its in VB and not C# Thanks. Kosmo Victor, Since I have gotten off topic from the original subject in this thread I have started a new one relating to ...Show All

• SQL Server an error while trying to read .sdf file from the pc application ? please help

  hi i have a problem with reading sql mobile database existed on the pc i made a sql mobile database connection with ( Add New Datasource ) and then set the datasource of dataviewgrid to display the returned dataset . at run time i have an exception said  : cann't find the library with the name sqlceme.dll as i remember , can you help me solving this problem because i very need this step , please  regards SQL Mobile did not support Windows Applications before. It was integrated only with Device Applications. However, we will be releasing SQL Server Everywhere on desktop which you can use on desktop. See the following URL for more details: http://forums.microsoft.com/M ...Show All

• SQL Server OK button doesn't Work In Report Manager RS2000

  Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1 with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2. My problem is that any page of the report manager with a "OK" button, that button doen't do nothing, it is enabled bu doesn't do any action. Can't figure this one out Need Help Thank's PS: Is did work early on this machine but stop working without notice, or any change at all. Hi, We have installed SQL Server 2005 with Reporting Service in a Windows 2003 Box. While working with the Reporting Manager through the browser we are gettting a strange problem. Whenever we are making any changes through Reporting Manager and trying to save the OK or Apply button is doing absolu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Game Services

  Hi, i have been reading a lot of documentation about XNA and i found something related to the Game Services but really i don't undertastand how i can use it somebody have any example please Google is your friend. Clicky1 Clicky2 Mitch's post is relatively old but the idea should be the same. I'm not sure how old the first link is. ...Show All

• Visual Studio Express Editions tutorial on system.net.sockets

  Is there anyone in here who knows a good tutorial to learn system.net.sockets in VB 2005 EE. I was using the winsock control, but i keeps crashing on other computers. Thanks Have you checked out the samples: http://msdn2.microsoft.com/en-us/vbasic/ms789075.aspx#bcl2 Base Class Libraries - Group 2 Samples The Base Class Library Group 2 samples show how to use the new classes and methods in the namespaces System.Net.Cache, System.Runtime.InteropServices, System.Net.Sockets.Socket, and more. Samples include: ...Show All

• Visual Studio Team System Availability and Licensing?

  Does anyone know when this edition is expected to ship Also, will you be able to upgrade from the old MSDN Universal to VSTS Databasa Professionals If you have Visual Studio Team Suite then you will continue to have access to DB Pro as it is available for Suite subscribers at no additional cost. If you only have a Team Edition then you will have the oppertunity to change from your existing Team Edition to DB Pro. To do this contact your local MSDN business Desk to perform the transfer. Hope this hlps clarify matt ...Show All

• SQL Server SQL Express from C#

  Hello I am new to .Net. I've got Visual Studio 2005, SQL Server Express and SQL Server Management Studio Express installed. Now I want to write a little C# applicaton that accesses my Test database (running on my computer). I created the Test database with Management Studio and filled it with some data. How do I connect to the database from my C# application This connection string does not work: private static DataTable GetData( string sqlCommand) { string connectionString = "Integrated Security=SSPI;" + "Persist Security Info=False;" + "Initial Catalog=test;Data Source=(local)" ; SqlConnection connection = new SqlConnection (connectionString); SqlCommand command = new SqlComman ...Show All

• SQL Server Multiple COUNTs with different qualifiers in a single query, grouped on another field?

  Hi. I was wondering if this could be done simply... I have a table of daily work shift data that contains an ID for the worker and also a status field that indicates whether the worker logged in correctly. I want to develop a query that for a given period (say, a month) counts the number of total shifts for that worker and the number of those shifts that are incorrectly logged. So, an example result set would be: worker ID total shifts incorrect shifts 90012 27 6 90036 28 2 Getting either count grouped on the worker ID is easy, getting them both in the same overall select statement is driving me crazy. I'm betting that there is some slick way to do this, but my newbie T-SQL status prevents m ...Show All

• Visual C# A problem with WebBrowser control

  Hello, I have a very strange problem with the WebBrowser control... When the WebBrowser control have the focus, all my main menu strip shortcuts stop working, and when I set the focus to another control it start working correctly. How can I solve that Your help would be greatly appreciated. Hi, I have created a sample application with webBrowserControl and WebBrowsersShortCutsEnabled property is also set to false. But it runs fine... What actuly you are doing with web borwser control as i think some thing is wrong with in you code... ...Show All