Coder25's Q&A profile

• SQL Server Selective filtering of rows

  Hi. I am using Visual Studio 2005 professional and SQL Server 2005 Express Edition. I am having a bit of an issue at the moment with my project. I have a large SQL server database (over 600,000 rows of data decoded from a text datafile and stored by my C# program) where I need to select a series of distinct rows. I have a datacolumn of varchar(10) called UID which is assigned to every row in my database. It's not a unique code so it can happen several times. By selecting a specific UID code, I can narrow down my selection to a specific range of rows (which are incremental in order). This range will contain many names. What I want to do is find a UID which will have one of two names. I have so far done this: SELECT DISTINC ...Show All

• Community Chat DirectX in Internet Explorer

  I think it would be really cool if we could use Managed DirectX on a web page. Being able to leverage our skillset in DirectX on a web page seems like a logical next step. Anyone else agree Look into the Windows Presentation Foundation. Its not quite the same as what you're looking for, but its along the same lines. It allows you to develop much richer graphical apps that can run in the browser as well as on the client. -Reza ...Show All

• Microsoft ISV Community Center Forums Map Point Control - How to add Hyperlink to a note in Map Point ?

  Hi Guys, I am working on a vb.net windows application which uses Map Point control in it. i am stuck with how to add a hyperlink to a note in the mappoint control and open a windows form and not a web form it would be of great help if somebody can give me some real code and explanation on how to do it. thanks, Mejoy ...Show All

• Visual Studio Express Editions Installation Problem

  I downloaded Visual Basic 2005 Express and when i start to install it,it goes though the setup and then i get to a screen where it's about to download but my problem is that it never connects ( it's transfer rate is 0 kb) and then after a while it says "Re-establishing connection with server" and it attempts 5 times then exits.Can somebody tell me what's wrong and how i can fix it. The best way to fix this is to download the manual install ISO Files and craete your own CD. This way you are able to install it as many times as you like, also note that you do not ae to activate or register the ISO Image install. ...Show All

• SharePoint Products and Technologies Implementing a Time Off Request Form with approval workflow in SP 07

  Hi everyone, I'm trying to design a browser based form for use on SP 2007 with some specific workflow capabilities. I would like to have the user submit it to their manager (they can manually select their manager on the form) and then have the manager approve the time off, and finally have it automatically sent to our payroll department for final approval. It would be a huge bonus if it could get recorded on a general absence calendar I've set up. In other words: 1) User fills out form (available on SP site), manually selects approving manager 2) Form is emailed to manager 3) Manager approves request 4) Form is routed to payroll department for final approval 5) Form is entered int ...Show All

• Visual J# THANK YOU!

  How can I choose which form will be appear first after compile Thanks. In a project you will find a file called "Program.jsl". Open it and locate this method: public static void main( String [] args) This is the start point in your application. Application .Run( new Form1 ()); This line tells me that the application will start with the Form1 dialog. Regards, Lars-Inge Tonnessen Microsoft VJ# MVP ...Show All

• SQL Server dbo prefix on table names in Object Explorer

  Hi there, Is there any way that I can remove the dbo prefix on the table names in the object explorer In the SQL 2K Enterprise manager, you could click on any table name, type the first few letters of the table you're looking for, and you'd be taken to the general area. With dbo on the front of the name, it makes it a bit more cumbersome. Can the dbo bit be reomved somehow No, AFAIK it can’t be removed, what for my opinion is missing in here (or I didn’t see it yet) is a grouping for schemas. SQL Server 2k didn’t know about schemas. If you would group on schemas like the fuzzy Oracle Explorer also does you could leave out the schema at the subnode of the schema. Perhaps you might raise a feature ...Show All

• SQL Server How do I update a field only if update value is not null?

  Hi. I'm not  such an expert in sql and I wanted to update a table's fields only if the value that im going to update it with is not null. How do I do that What I mean is something like: --------------------------------------------------- Update database.dbo.table set if(@newvalue !=null)      afield = @newvalue; -------------------------------------------------   Really need your help on this. Thanks. What about this by using ISNULL in the SET statement: UPDATE Crmworks . dbo . Lead SET Lead_PersonFirstName = ISNULL(@firstname, Lead_PersonFirstName), Lead_PersonLastName = ISNULL( @lastname, Lead_PersonLastName), Lead_CompanyA ...Show All

• SQL Server Service Pack 1 Question

  Is there a way to check and see if SQL Server 2005 Developer is already up-to-date with Service Pack 1 I don't want to try and install on top of it if it has already been done. Thanks! Go to Add/Remove Programs and click on show updates. If SP1 is installed, it will show up under your main SQL 2005 entry. You could also check the version of a file (say sqlservr.exe) and check which SP level the file is. (version 1399 is RTM, 2047 is SP1). Thanks, Sam Lester (MSFT) ...Show All

• Visual Studio Team System Where's the log?

  We just installed Team Foundation Server Suite. I can access it from the same machine but when I try from other machines, I get a failure notice, TF31002: Unable to connect to this Team Foundation Server. Possible reasons for failure are - The Team Foundation Server name, port or protocol - The Team Foundation server is offline - Password is expired or incorrect. For more information, contact the Team Foundation Server Administrator. Well, the server name, port and protocol are correct, the server is online and the password is not expired and I am the Administrator. Where are the logs that tell me what the real problem is, so I can fix it -rwg Hi, We have ...Show All

• Visual Studio MissingReportSourceException NullReferenceException

  "MissingReportSourceException means that you have not yet supplied a definition for the report, so the report viewer can't validate parameters. Make sure you have set ReportViewer.ServerReport.ReportPath before calling SetParameters(). " How do you set the path or set the definition tried " reportViewer1.LocalReport.ReportPath.Equals new ( "TicketPrintLayout.rdlc" ); " and it gave me a null reference exception, so what do I do ...Show All

• Visual Studio Express Editions Serial Port, Data Received does not work

  Hello there... For my diploma thesis I am developing a program that controls a measuring instrument via rs232. I am quite new in VB and programming but I am trying hard:) I was quite successfull in writing on the rs232 port, reading i working, too. My problem is the data_receved handle. this code works: Public Function Read() sRead = SerialPort.ReadByte() sRead = SerialPort.ReadExisting LB_Kom.Items.Add("RX: " + sRead) End Function But, I have to initiate this function manually. Ths is not exactly what my program should do, it should run automaticlly:) Thus I tried this: Public Sub SerialPort1_DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles SerialPort1.DataRece ...Show All

• Visual Basic Convert Color Image to a Gray Shade Image

  Hi all, I'm creating a custom button control. I need to show a color image when the button control is enabled and a gray shade of the same image when the button control is disabled. How can i convert a color image to a gray image in VB 2005. Thanks, I know, there are many methods to do that, I wrote two classes, the first one uses the average method, and the another uses YIQ method. Here is the result : http://www.instructurez.com/posts_images/post_712.jpg Here is the code for average method : Public Class Colorful_To_Gray_Pics Public Function Colorful_To_Gray_Pic( ByVal InputPic As Image) As Image Dim TempBitmap As New Bitmap(InputPic) Dim XIndex As Integer , YIndex As Integer , Average As Integer For XIn ...Show All

• SQL Server MDX Filter Problem

  Hi, I am using AS 2000 FoodMart 2000 DB . My problem is when I run the below query I am getting an error. Query 01 SELECT {[Measures].[Unit Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales] WHERE [Product].[All Products].[Drink] “ Duplicate dimension across (independent) axes when calculating a query axis ” But it is understood that I can use any other slicing dimension with WHERE clause to filter instead of the Product dimension, just like the below query: SELECT {[Measures].[Unit Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales] WHERE [Customers].[All Customers].[USA].[CA] This query works fine. My point is that I know AS 2000 does not use the same dimension in two ...Show All

• Visual Studio Tools for Office connecting excel file to C++ program

  Hi every body I am a new programmer and I have been studying C++ for one semester. I know how to link and use files with these extinsions (.dat , . txt). However, I need to know how to connect excel spreadsheet with my C++ program "win 32 console application" and then I need to read my input from this spreadsheet and produce my output on it. I searched a lot but I did not find any thing. Actually, I do not know what is the solution for my problem, is it a code or a tool or something else If there is any one who can help me, I will be thankful. Moreover, If there is a refrence or a book that helps me ,please tell me and I will be glad to study it. I use MS Office 2003, Visual Studio 2005. Sorry if my question seems sill ...Show All