cbtm's Q&A profile

• Windows Forms How can I make update version for application which was signed with certificate now expired?

  If I change expired code signing certificate to new one and publish updated application, client will fail to launch. And code signing fails if I try to use expired certificate. How can I make update version for application signed with old certificate If anyone else is having this same problem, please report and comment about it at the following link as this will become a major issue for people whose code signing certificates are expiring over the next few months. If you have this issue and go to the link, hopefully, they will have a fix or a workaround by the time you go there. Nothing yet. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=207513 ...Show All

• Windows Forms Extended WebBrowser newwindow event problem

  Hi everybody, First i would like to thank everybody from the previous post on the new microsoft webbrowser navigating and newwindow event extension. but i seem to have encountered a snag. i have a new web browser that implements tabbed browsing and all is well until it encounters this kind of link " <a href='#' onclick=window.open...".It just behaves us if nothing has happenned. curiously if i create a new webbrowser it works fine.So anybody please help. thank you all here is the code for the newwindow handle private void wb_BeforeNewWindow( object sender, BrowserExtendedNavigatingEventArgs e) { if (( bool )tb.Tag) // code handling new tab and browser { newTabWindow( "" ); } ...Show All

• Visual C# A question of OO structure...

  Hello All, I'll do my best to explain what I'm trying to accomplish and look forward to any and all suggestions you have for the "proper" way to do this (realizing there is no 100% correct way, but some methods are more optimal than others). I apologize in advance for my n00bness. For this example, I'll use football (american) players. I want my Player class to have a List<Stat> collection of my Stat class. Each Stat, which is an indicator of how well a player plays a particular position, should have a base value but be able to return a "true" value which is a calculation of the base value plus a percentage of one or more other stats. For example: a Player's Halfback stat might be base value plus 50% of the Fullba ...Show All

• .NET Development Null Values

  The following code executes a Select query almost flawlessly. There are some records in qrySecurityPricesWithSymbols where VixOpn, VixHigh, Vixlow, VixClse contain null values. When this query is executed, those records are excluded. How do I get them to be included strSqlRead = "SELECT Date, Opn, High, Low, Clse, VixOpn, VixHigh, VixLow, VixClse FROM qrySecurityPricesWithSymbols WHERE (((qrySecurityPricesWithSymbols.SecuritySymbol)=" & Chr(34) & txtSymbol.Text & Chr(34) & "))" objCommandRead.CommandText = strSqlRead objReader = objCommandRead.ExecuteReader() Paul and Jan are correct...It is not your Select statement that needs altering it is the q ...Show All

• Visual Studio 2008 (Pre-release) Updated samples - June 2006 CTP

  http://www.valil.com/winfx/ ...Show All

• SQL Server Merge Join conditional split - HeadBanger

  I have a merge join that does a full outer join. I then have a conditional split that will breakout by unchanged, insert and update. The update is what I am having a problem with. The conditional split for the update is a follows: !ISNULL(HISTORICAL) && !ISNULL(TRANSFORM) Now I believe the problem is related to spaces in the key field let me explain. The join field is defined as [char](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, There was an original mismatch between the two tables of VARCHAR(14) & Char(14) but now there both Char(14). What's interesting is that the few records with Alpha characters correctly does the update but the records with starting numeric data all go down the insert ...Show All

• Visual Studio Team System Removing or redefining Refname

  Hi, I am having a situation that requires either removing a previously define refname or just being able to redefine it. E.g. I'd mistakenly defined a refname as a string and now I want to change it to an integer. Does VSTS support this And if so, what are the steps Thanks Then is there any mean to completely delete it from VSTS It is pretty drastic, but it's either that or rebuild the VSTS server. ...Show All

• SQL Server SQL Query to output formatted Excel file

  I need to create a query (SQL 2000) that renders a formatted excel (xml or xls) file for each row that is outputted. The details, I have a Campaign table that contains information for Auto and Life "Leads" and the data is submitted by telemarketers directly into the database. I need to render a file for each line, and it would be good if It were an Excel XML or XLS file, because that's what we've been using for a while. hi try this query Exec master .. xp_cmdshell 'bcp "use dbName; select * from tableName" queryout "e:\test.xls" -c -CRAW' hope this will help you ...Show All

• .NET Development wrong data displayed

  To all: I have a login page with textboxes (for email as username and for password) and LOGIN button and UPDATE DATA button. When user clicks the UPDATE DATA button the details of the user is supposedly displayed on textboxes (another page). BUT the details being displayed when the button is clicked is ALWAYS the details of the user that is on the first row of the USERS table in the database eventhough the user (that wants to update his profile) is saved on the fifth row on the USERS table. I hope somebody can help me on this. Thanks. Here is the code: (For clicking the update account button on log in page) Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Ha ...Show All

• Visual Basic How to encrypt an image file ?

  Hi All I am saving image files on web server. To secure them i want to encrypt them. How can i achieve this Please give me some solution/suggestion to solve the problem. Regards well I guess you could use the File.Encrypt/File.Decrypt methods in the System.IO namespace but the partition must be NTFS in order to make use of this. http://msdn2.microsoft.com/en-us/library/system.io.file.encrypt.aspx http://www.codeproject.com/dotnet/EncryptFile.asp ...Show All

• Visual Studio Express Editions SQL database error in VB project

  I was trying to make a database for my VB application (using VB express 2005). New Items -> SQL database. I never used the database before and I received this error. If the default settings is the problem, how do I change the settings to allow remote connections. Here is the error in the screenshot. OK.... The VBE designer doesn't support remote connections as those are features of the professional IDEs that one purchases. However you can connect by code similar to this which I prefer anyway..... Imports System Imports System.Data Imports System.Data.Sql Imports System.Data.SqlClient Imports Microsoft.SqlServer.Management.SMO Imports Microsoft.SqlServer. ...Show All

• SQL Server avoiding accidental deletes...best practises??

  Is there a way to get sql server to present a message box asking if you are you sure you want to delete all the data in a table. also are there any 'best practises' to avoid accidental deletes. For example Im making a lot of delete statements like: del from table_name where item_id = 23 but one time I executed this statement I mistakenly excuted the first line of the statment only, resulting in the loss of all the data in the table, luckily I was able to re-populate the table, but I wish to avoid that mistake in the future. Let me ask this question: would you want a script stopping half-way through a stored procedure To wait for a user dialog box to complete at 4am If you are having p ...Show All

• Visual C# String Mid in c#

  In VB we could use: b$="abcdef" a$ = mid(b$,2,1) which would pickoff the second chr for a length of 1 from b$ how do we do it in c# Substring is indeed the equivalent, but be aware that it is 0-based (like everything else in the framework), while the classic VB string functions are 1-based, so adjust accordingly. David Anton www.tangiblesoftwaresolutions.com Instant C#: VB to C# converter Instant VB: C# to VB converter Instant C++: C# to C++ converter, VB to C++ converter Instant Python: C# to Python converter, VB to Python converter ...Show All

• SQL Server Assign several different sets of paramters, to be chosen by user?

  Hi, Is there a way to put in several different sets of values for the defaults in parameters, where the user could then choose which set of defaults they want For example, I have two drop-downs for dates: Start Date and End Date. I would also like another drop-down (or button, or whatever) called, say "Interval". It would have choices such as "1 week interval" or "52 week interval", and whatever is chosen would set the Start and End Dates to whatever default values I had assigned to the parameters in "Interval". It's not quite the same as cascading parameters. Any suggestions would be greatly appreciated! Thanks. Sorry, but this is cascading parameters. One parameter which pulls of the data from the serve ...Show All

• SQL Server Tables don't show up in SS Management Studio Express

  Hi Folks, I have a strange problem where I run SQL Scripts to create tables in SS Management Studio Express. The Scripts run OK but the Table names don't appear in the left-hand Object Explorer window. I know they are created because I checked with Toad and I can also INSERT and SELECT data from them. How do I get them displayed I'd appreciate any suggestions. Thanks very much. Barry Hi Mike Thanks very much for your advice and responding so quickly. You were right - the tables were in the Master Database. The rest of your advice helped me fix the problem very quickly. Regards Barry ...Show All