Lisurc's Q&A profile

• .NET Development Change the background color on individual cells within the .Net 2003 datagrid

  Peoples... In VB6 you can specify a range of cells (or an idividual cell) in a datagrid and set it's background color to display whatever color you want. I haven't seen a way to do this in the .Net 2003 Datagrid. You can change it when you click on it or you can change a row or column but what I want to be able to do is change the color at the cell level. In other words, I may only want to "highlight" a few cells within a column. Does anyone know how to do this or is this a known limitation Also, has this been addressed in .Net 2005 And, lastly, if the answers are NO and NO to the last 2 question above, I can't help but wonder who worked on the .Net datagrid for MS It seems to me that this is a step backward considering that ...Show All

• SQL Server sql query to return multiple records

  Hi, I'm trying to retrieve some records from an SQL database. I've a table named CustomerOrder with three fields - custID , productname and quantity No keys in the table. it's row based approach. every custID can have multiple entries for different products. Example: CustID ProductName Quantity 1 Product1 2 1 Product2 3 2 XXX 1 2 Product1 2 1 Product3 4 I would like to write a query that gives the result as follows : CustID ProductName Quantity 1 Product3 4 2 Product1 2 Meaning that, query has to retrieve only one record per custID based on highest quantity. sel ...Show All

• Visual Studio Image to PDF

  Hi , I'm trying to develop an application which is used to convert the Image file to a PDF file using VB.NET . I'm concentrating on the ghostscript and postscript.can any one suggest any resources you know and help start coding that.any help is appreciated. -regards GRk ...Show All

• Visual Studio Express Editions about declaring parameters(using wizard)

  hi there!! i have a problem regarding declaring parameters(using  dbase wizard)... in using code what i mean is manually coding to create a connection into dbase i can easily do that by setting up a paramter ("select * from table where column = @data ",conn)... because wizard is the easiest and fastest way(to bound the dbase into textbox and combobox[ Detailed view ])...how can we declare parameters  i can create a filter but instead of paramters i used data name  e.g (Select * from table where column = 'data') i want is to change the 'data' into paramters so that the user can easily navigate or search what the user wants.... thanks in advance pinoyz, ' Build a select clause for the selected fields. Private Func ...Show All

• Smart Device Development Designer issues after CF2.0 SP1 installation

  I just installed the CF2.0 SP1 patch. Seeing other posts, I uninstalled the Beta 1 version I had used in developing some apps (because I needed more control over the datagrid), reinstalled the original CF2.0 from my DVD, and then loaded the SP1 patch. Initially, everything in my projects looked fine. However, after rebooting my machine later in the day, I now get designer errors on any form with a grid control. The main part of the message is: Could not load type 'System.Windows.Forms.DataGrid' from assembly 'System.Windows.Forms.DataGrid, Version=2.0.0.0, Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes'. Actually, I also the following message as well, but it will go away on a recompile, although it comes back the ...Show All

• SQL Server Pivot tables, Charts, Pivot chart

  Hi all, Can someone help me with some learning resources of Pivot Tables, Charts and Pivot Charts. Thanx Hello, I am having issue with Performance of the Pivot Table connecting to OLAP Cubes. I am wondering if any of you have links to how to improve Pivot Table performance Basically, I have done the backend optimization on the schema, but there should tricks on the Excel such as Connection Properties that I could use that could relate to MDX or Threshold Level that could speed up the Pivot Table performance. Below is some initial thoughts... Non Empty Threshold=1 Any help is appreciated! -Lawrence ...Show All

• Visual Basic Using a font contained in a PrivateFontCollection on a label or listbox?

  Hello, How do I use a font contained in a PrivateFontCollection on a label or listbox I posted this in the general area, maybe here is better. I have a font loaded into a PrivateFontCollection. The font is not installed on the system I am working on. I know how to use the font to 'draw' a string on the form, the font is definitely embedded. Here is the code I'm using: 'This section works - I can draw a string to the form using the embedded font. ' Imports System.Drawing.Text Imports System.Runtime.InteropServices Imports System.IO Public Class Form1 Dim pfc As New PrivateFontCollection() Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim fontStream As Stream = Me.GetType ...Show All

• Windows Forms Drawing multiple circles

  Hi, I want to draw more than one circle say for example 8 I know i can draw circles with the use of the following code Graphics g = this .CreateGraphics(); int x = 100; int y = 100; int r = 10; g.DrawEllipse( new Pen ( Color .Lime, 5), x - r, y - r, r, r); g.Flush(); g.Dispose(); but what i want is more than one circle. Also after i have drawn them how can i make say 7 hide and one visible with the timer set. would i have to use another interger or a string and assing it to graphics g=this.CreateGraphics() function and then on form load say that the interger has to be hidden. Could someone please help. Also please bear in mind i am a begginer so could you direct me step by step please Th ...Show All

• Visual Studio C#/Crystal Reports Application Deployment

  Setup program with merge files (created exactly as it is described in MSDN and many aricles) successfully installes my program on my development computer and on two other computers but failed to install on any other computer Setup process is interrupted with the message: Unable to get installer types in the C:\Program Files\...\MyAplication.exe assembly. --> Unable to load one or more of the requested types. Retrieve the LoaderException property for more information. All steps I do are have carefully checked against tens of articles. There is a difference between three computers which allow installation and all other which do not allow. Before to start develop the application I used those three computers for ...Show All

• Windows Forms Datagridview and wrong ID

  Hi all, I've developed a quite complex application using VB 2005. I'm using an Access database. I noticed a strange problem with a datagridview. After deleting a record, closing my application, reopening it and adding a new record using the datagridview, the system gives to "ID column" a wrong value (for example, a value already used by another record). After saving the new record, and "refilling" the datagridview, the correct ID for the new record is displayed. How could I solve this problem Thanks in advance for your help. Yes, if I fill again the correct ID is shown but I would like to understand the problem... I need to read the correct ID after adding a new record from another form ...Show All

• SQL Server How Can I retrieve Sql 2000 Encrypted Column Data From SQL 2005 Stored Proc?????

  Hi... I want to retrieve SQL 2000 Encrypted Column Data From SQL 2005 strored proc. My Stored Procedure was on SQL 2000 and it works fine....Then I restore Database From SQL 2000 to SQL 2005. The Following Statement is on my store proce. select user_id , Encrypt ( user_pass ) from OpenRowset ( 'SQLOLEDB' , 'myserver' ; 'sa' ; 'mypass' , databasename . dbo . users ) as a The Following Error I get When I execute the above statement. Msg 195, Level 15, State 10, Line 1 'Encrypt' is not a recognized built-in function name. Thank you. Bal. Hi Adam, Thank you very much for your response...I know this is the last alternative i have, but is there any feature in S ...Show All

• Smart Device Development Management of phone calls

  Hi, I would want to be able to control incoming and outgoing calls. I know I can detect them with an object of SystemState. Now, there are several problems: - Can I detect them if the events occurs out from my application - Can I finish a phone call If it it possible: - I don't know if I can close an incoming phone call or if only the OS is able to do it. - I don't also know if it is possible to finish an outgoing phone call that I haven't initialized into my programme. Anyone can help me Thanks a lot. Alvaro Penarrubia You can be sure this helps. Thank you very much. But, a couple of question more... this API is programed in C (or C++) not in C#, it isn't I think there's no equivalent in C#. ...Show All

• .NET Development after publish the program, if i wanna change the data from Access database, where i can edit it?

  hi i have a program with MS access database after i publish and install the program at the other PC where i can edit the database without re-publishing the program thx for your attention hunb Review - http://msdn2.microsoft.com/en-us/library/system.windows.forms.application.startuppath.aspx Eg. Where db is published to sub directory data. Dim MyDBPath As String = Application.StartupPath & "\data\mydb.mdb" rgds, Martin. ...Show All

• Visual C++ MSJAVA.dll not found

  First the msvcr80.dll was not found. I copied this dll into my application directory. But now msjava.dll is not being found and I cannot find it anywhere on my harddisk. Anybody got a clue how to fix this Peter How do you know it is missing Are you using depends.exe If so then it is error you can ignore - see here . ...Show All

• SQL Server csv export without headings

  Hi, is it possible to export a report to a csv file without the headings at best i have been able to hide the headings in the report, but when exported to csv file it includes a row at the top of commas, then the data follows. I need the file to be just the data. thank. To eliminate column title row that you see before the data, use NoHeader option: http://msdn2.microsoft.com/en-us/library/ms155365.aspx You can use it with URL access (add &rc:NoHeader=true to report url), or, for RS 2005, you can configure your CSV rendering extension to always ommit the header row. CSV renderer doesn't stack data from 2 different data regions, so your trick with table above matrix won't get you the result y ...Show All