Ctp Haddock's Q&A profile

• SQL Server specify column chart colors

  hi, im wondering if it is possible to create a report template where i can specify the colors of column charts. these charts should look alike at anytime. maybe the first coloumn is always red and the second alway grey and third alway blue und so on ... thanks rhapsy One approach is to define a custom assembly which contains your custom color palette definition (similar to: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx ) and then use it in all your chart reports. There is currently however no general report template support for this. -- Robert ...Show All

• Visual C# MS Access database store at startupPath's application

  Hi all C# forum members I have a small database application using C# and MS Access.Here is my connection String "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\mydb.mdb;User Id=admin;Password=;" It works ok but I m now want to change the datasource to the folder same as folder of application. I mean that when I make a deployment , the data source is same as application folder of user. I 'v know that I need use this method in my connection string datasource =Application.StartupPath +database name but I dont know how to use it, Could you repair it for me Thank you very much. DongMT, Vietnam string connectionString = string.Format(     "Provider=Microsoft.Jet.OLEDB.4.0;Data So ...Show All

• .NET Development Accessing files over network using smart client

  Hi, I'm writing a smart client, but I can't figure out how to make it work using .net framework 2.0. For debuging purposes I've written a real simple server-app, running it on the server works fine, but running it on a client gives an errormessage. Without fileaccess the client runs with no problem. The simplified code: private void button1_Click(object sender, System. EventArgs e) { try { FileIOPermission f2 = new FileIOPermission (FileIOPermissionAccess.Read, "C:\\"); f2.AddPathList(FileIOPermissionAccess.Read, "c:\\testFile.txt"); StreamReader sr = new StreamReader ("c:\\testFile.txt"); string line; while ((line = sr.ReadLine()) != null) debug.AppendText(line + "\r\n"); } catch (Except ...Show All

• .NET Development COLUMN LEVEL RIGTHS AND C# APPLICTIAON

  Dear All. I have two tables t1 (f1 int, f2 int) and t2(f3 int, f4 int) And I have view1 as( select t1.f1, t2.f3 from t1, t2 where t1.f2 = t2.f4 ) user1 has right to select all columns from view1, but user2 can select only column "f1". In c# application, I have simply a datagrid. i want to get user right and set visibilty of datagrid's columns based on that rights. f.e: if connected user is user1, that application will show all columns of datagrid, if user2 than it must display only column f1. How can I achieve it Thanks in advance. Sincerely, Teymur You cant handle that problem through sql server  as sql server does support columns permissions on each data obje ...Show All

• Visual Studio Express Editions I want to use cascadingDroDown control with SQL Server 2000 database?

  I want to use cascadingDroDown control with SQL Server 2000 database, i have three table called province, District, Street. Province: (ProID, ProvinceName) District: (DistID, ProID, DistrictName) Street: (StreetID, DistID, StreetName) How can i use it with cascadingDroDown when i select province in Dropdown1 then all Disttrict belong this province are displayed, then when i select District, all streeet belong that district are displayed in dropdown3. Can you help me Thanks, Hi, minhnguyen Say that province table is bound to droDown1, district table displays in droDown2, street table displays in droDown3. The idea is to add param in the sql statement which ...Show All

• Visual Studio 2008 (Pre-release) How to put 2 ListBoxItem on same row?

  Since everything is possible in WPF (well almost) this should be a pieece of cake. when you have a number of ListBoxItems in a ListBox, they’re listed one item per row. But what if my ListBox.Width = 300 and my ListBoxItem.Width = 100 then there’s some waste of space. Before I dig in to it I just want to know if the way to do it (if doable) is by overriding some methods that’s placing the itmes out so I can manually place them out, animate them etc.. Well, why don’t I use like a Stackpanel I need to use a control that inherits from ItemsControl so I can use ItemsSource to databind my object in xaml. Would be grateful for some hints in the right direction Have a nice day /erik Usi ...Show All

• Visual C++ Using VC++ 8.0

  Hello, I have a project that was created/build using VC++ 6.0, the project uses a third party library iconnect.lib. I am trying to compile the project using VC++ 8.0 but I get a lot of linker errors - some of those errors are below. Note: the project compiles without errors or warnings when using VC++ 6.0. Can someone tell me what I need to do to get my project to compile/link successfully with VC++ 8.0 Thanks in advance! -Agustin ERRORS: Error 82 error LNK2001: unresolved external symbol __RTC_CheckEsp iconnect.lib Error 83 error LNK2019: unresolved external symbol __RTC_CheckEsp referenced in function "class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > ...Show All

• Visual Basic Change BackColor

  Why does this not work The form changes to color.Aqua, but the picturebox, pbBlackout stays Black. Me .BackColor = Color.Aqua pbBlackout.BackColor = Color.Aqua At Last!! Figured out what was going wrong, for some reason, can't think why I had imported a plain black image !! Once removed all works fine! Thanks for all the help. ...Show All

• Software Development for Windows Vista Why is the Activity ContextGuid not public???

  The execution context of an activity is an important piece of the workflow. So why is this important piece of information hidden Currently, there is no way for me to correctly obtain a specific instance of an activity. The main issue I am running into is with tracking. I need to track additional information that is supplied by custom activities. Also, can see the need for a workflow to be able to access other activities in a specific context in order to complete. Here's some code (based on Joel's explanation) that found the non-zero ContextGuid following the chain of parent activities: private void codeActivity1_ExecuteCode( object sender, EventArgs e) { Guid contextGuid = Guid .Empt ...Show All

• Visual C++ how to create object from LPDISPATCH

  Dear all, I have an ocx. There are 2 methods: long CVsTelComSECtrl::GetType() { return 1; } LPDISPATCH CTelCtrl::Fax() { m_pcFax = new CFax; m_lpFax = m_pcFax->GetIDispatch(NULL); m_lpFax->AddRef(); return m_lpFax; } When I create an application, insert this ocx into application. I could use the method GetType() from this ocx CTelCtrl m_cTel; long lType = m_cTel.GetType(); //Works OK But I cannot use Fax(). How can I create a object with CFax type from this LPDISPATCH. Please help me, Tuan Thank you very much. In the last sentence, you mean I should add one more method which returns CFax* in OCX I do that. Compile is ok but link is not ok. pFax = (CFax*)m_cTel.Fax(); long lRetVal = ...Show All

• Windows Forms Exe file size is large!

  I have a WinForm application. The size of the exe was about 200 KB and after I added the .ico file that I created, it's size has changed to 980 KB. I don't know if adding the .ico file has caused this or something else. The application has not changed much and the only significant change that I made was adding the .ico file. The size of the .ico file is only 85 KB. Can anybody tell me what may have caused this Thanks Basani Basani, My best guess is that ico is probably stored differently than the file format icon with probably less compression, but that is just a guess. Why are you worried though James ...Show All

• Internet Explorer Development XSLT generated JavaScript not executed

  My problem is the following: I generate JavaScript Code in XSLT that should be excecuted in the IE (V. 6.0). I create a <select> box with some <option> in it. Instead of using <xsl:choose><xsl:when> repeatly I thought I just create a Function that get's called afterwards and sets the right option. The XML: <root> <element>2</element> <element>1</element> </root> The XSLT: <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output version="1.0" encoding="utf-8" omit-xml-declaration="yes" media-type="text/html" /> <!-- main template --> <xsl:template match="/"> <h2>This is the transformation</h2> & ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Tutorials Thread

  If it's not too much trouble, could this topic be stickied I am just wondering if we could have a main thread that carries links to all the tutorials. In other words, someone makes a thread with a new tutorial, and then, they post the link to it here with a description of the tutorial. That way, others don't have to search through a whole forum for just one topic. Just an idea to make it easier on everyone.   On a side note, I plan on linking this thread to another thread titled: First XNA Program Development Team (FXPDT). Take a look at it. Thanks for your time. Also, I've added some tutorials for you all for now.   P.S. Since the tutorials are publicly viewed and linked to, I don't think you need permission to ...Show All

• Windows Forms DataGridViewCheckBoxCell problem

  Hello I am using DataGridViewCheckBoxCell in datagridview. When i check and uncheck the particular column, the column is marked as checked. The code used is as foreach ( DataGridViewRow row in dgOrders.Rows) { DataGridViewCheckBoxCell include = ( DataGridViewCheckBoxCell )row.Cells[ "Select" ]; if (include != null && include.Value != null ) //if checked { Do processing } } what will be the problem I am sorry to say that the problem still persists. I have set the truevalue of the checkboxcell to true before binding to gridview as DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn (); chk.HeaderText = "S ...Show All

• Visual Studio Tools for Office Remove borders from Excel charts using C#

  I am building an excel file from scratch. this includes charts of data. In this particular case I need to remove the borders from the chart, but it doesn't appear to work correctly. // The next three lines are an attempt to remove the border, the fourth shows that I am controlling the chart ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).Border.LineStyle = Excel.XlLineStyle.xlLineStyleNone; ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).Interior.ColorIndex = 2; ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).Border.ColorIndex = 2; // After attempting above I use the following code which works to round the corners ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).RoundedCorners = true; I don't want to round the co ...Show All