Jsilver's Q&A profile

• Windows Forms How to Show Image in Datagridview cells

    HI, I am stuck with a problem that how to display an image in the datagridviewimagecolumn As when i m trying it shows a X mark. Not the Image My Code is: Dim ArrowIcon As New Icon( "..\Images\Icon1.ico" ) Dim IconColumn1 As New DataGridViewImageColumn Dim IconColumn2 As New DataGridViewImageColumn IconColumn1.ImageLayout = DataGridViewImageCellLayout.Normal IconColumn1.Image = ArrowIcon.ToBitmap IconColumn2.ImageLayout = DataGridViewImageCellLayout.Normal IconColumn2.Image = ArrowIcon.ToBitmap Me .DataGridView1.Columns.Insert(0, IconColumn1) Me .DataGridView1.Columns.Insert(1, IconColumn2) I don't know why it is not showing the image Plz help me Thanks a lot in advanc ...Show All

• SQL Server Monitor network resources used by single database

  Hi, Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000. Please help Regards Mohd Sufian The tools are Profiler, accessable from the Tools menu in SSMS or Start/Programs/SQL Server/Performance Tools or perfmon accessable from Start/Programs/Administrative Tools/Performance. The tool to use depends on the meaning of "network utilization". Profiler will allow you to run a trace you can use to aggregate reads, writes and duration by database. Perfmon has many counters that can be used by database. See SQL Server 2005 Books Online topics: SQL Server, Databases Object http://msdn2.microsoft.com/en- ...Show All

• SQL Server Where can I check Edition Information?

  Dear all, Do you know which file or command I can use to check what is the Edition of Reporting service that we have installed We install it on a separate server from the Database. Thanks in advance. Regards, Terry Just a simple way to find the edition is to go to the following folder where reporting services is installed: usually it is C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles and open any of the log file in .txt extension and search for the word "edition". You may find the text "INFO: Catalog SQL Server Edition = Enterprise" if the edition is Enterprise. ...Show All

• Software Development for Windows Vista Windows work flow VS extensions - install error message

  During the install of WWF RTM I get this message: The installer has insufficient privileges to access this directory: C:\Config.Msi. The installation cannot continue. Log on as administrator or contact your system administrator. When installing the WWF I am logged in as Administrator, also there is no Config.msi fileu nder the C:\ root on my PC. I clicked re-try and the installation continued and gave a sussessful message at the end. I checked the log file and the error was recorded. I am able to open VS2005 and can see the WWF templates Also able to create Workflow projects! Has anyone else seen this error. I also got this error during the Windows SDK install Any ideas -javahar E ...Show All

• Visual Basic Running a DOS command from within a VB application

  Hi all. I am a newbie, and I am trying to develop a graphical interface to automate a task that I usually execute through a batch program. I have to execute an external command-line program that is not capable of accepting parameters. In my batch files I always solved the problem redirecting the input: my_command < input_file So I tried something like this (which works perfectly when the external program accepts parameters): procId = Process.Start("my_command", " < input_file") This doesn't work, and this is the reason why I am here to beg you help..... Can someone help this sad newbie ! Regards ___ Max To Spotty: I think this cannot work, ...Show All

• Visual FoxPro How to fix grid headings?

  Can we do that It does not help if I set: AllowHeaderSing=.f.   I think you meant AllowHeaderSizing. If you set it to .F. header height is not allowed to change. It doesn't have anything to do with column positions (I think you meant it). To do that: thisform.myGrid.Setall('Movable',.F.) ...Show All

• Visual Studio Express Editions My Tool Controls Disapeared

  I down loaded several Visual Studion Programing Languages and Then The sql express program. I tried installing some controls by clicking .sln file a list came up I clicked on Visual Basic It started up with an error message. After that my toolbox says no usable controls. I tried the right click Choose Items I see a list but chcking them doesn't help. clicking reset toolbox doesn't help. Clicking show all, showes a bunch of grayed out controlls. Reinstalling, Uninstalling and Reinstalling, renaming the visual studio 8 directory and downloading and installing doesn't help. I noticed the directory in Choose Items Says "global assembly cashe" This has happened to all of my express applications HELP!!!! HELP!!!!! ...Show All

• SQL Server VS2005/SSR2005 Report Controlling field visibility by code

  VS2005/SSR2005 Reporting: How can one control an individual report fields visibility (toggle on/off) at run time, based on data values (of the same field or another field) in the report. Without user having to sit there and "Click". Thanks Zulu5255 If the Hidden expression evaluates to true, the item is hidden, otherwise it will be visible. Once the report is rendered, the visibility of the item is set until you re-render the report or you have a toggle item controlling the item's visibility. A toggle item allows you to control the visibility of another item after the report is rendered using a textbox. When you say that you set the expression, and then set it to be hidden, do mean that ...Show All

• Visual Basic Superconstructors?

  What's the general syntax for using inheritance in VB Say I've got ClassSuper and ClassSub, ClassSub inherits ClassSuper. How do you access the super constructor How do you access values in the super class Thank ya, exactly what I needed. And just to make sure, MyBase always goes up one level, right So if I had SuperClass, SubClass and SubSubClass, to access SuperClass's constructor you'd use MyBase.MyBase.New() ...Show All

• SQL Server Localization of Report Manager to Portuguese

  Hello to all! I want to translate de interface of the Report Manager to Portuguese. I'm develop a class that implements Microsoft.Reporting.WebForms. IReportViewerMessages The class is in a file called "ReportViewerMessages.cs". The structure is like this, the project is called "PortugueseReportManager", there is a namespace named "PortugueseReportManager" and the name of the class is "ReportViewerMessages". So far so good, but when I change de web.config file in the report manager folder I'm getting over and over this error message when I try to see a report: The type PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken= ...Show All

• SQL Server error in ssis package!

  Hi, [OLE DB Destination [1146]] Error: An OLE DB error has occurred. Error code: 0x80040E23. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E23 Description: "Cursor operation conflict". [DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (1146) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009. have any of u encountered this error package is wo ...Show All

• SQL Server Trying to CONCAT a TEXT field with 2 VARCHAR fields - brick wall.

  Hi all. I have been going round and round for the past 2 days on this and would appreciate any help. In a view select statement, I need to concat 2 varchar fields with a text field. If I CONVERT the TEXT field to VARCHAR, only the first 30 characters of the field appear in the result set. If I convert the VARCHAR fields to TEXT, I get an error that I cannot CONCAT TEXT fields. I'm not sure what to do. Can someone please offer some assistance Thanks in advance! Steve I tried this and it works fine (SQL Server 2005 as VARCHAR(MAX) does not work in 2000): SELECT CAST ( TextCol AS VARCHAR ( MAX )) + VarCol1 + VarCol2 FROM Table ...Show All

• SQL Server Viewing reports designed on SQL 2005 Reporting Server

  I have built the reports that I need using Visual Studio and the SQL 2005 Reporting Server, but now I need a way to view the reports via a web browser. I am not much of a web/programming expert, so any help that could walk me through the process of publishing the .rdl files that I have created via a web browser would be much, much appreciated. Again, I am a novice in the the web arena, so the more straight forward the steps the better. Thanks! Thanks so much for the help. Is there also a way to create reports that are dynamic and regenerate based on new data ...Show All

• SQL Server SQL Server Express, Simultaneous ,Multiple Application Access?

  Hi Everyone, I have a software solution that consists of two separate applications that share a SQL Server Express database on a single computer. Everything is working great, except when both of the applications want to access the database at the same time. All I can find is information on configuring multi-user access in a distributed system. I'd appreciate any information on configuring multi-application access on a single computer. Thanks, Mike For what it's worth, in the connection string I had to include the ".mdf" extension for the AttachDbFilename attribute. E.g., ...AttachDbFilename=C:\src\LocalDataCache\DB\MyLocalCache.mdf; ...Show All

• SQL Server Problems with Roles and sp_helpRoleMember

  I have a database role named gc_stationAdmin. I have a user x who has this role granted him when via Mgmt Studio under Logins. In fact I have 50+ users who have this role. 1) when I execute sp_helpRoleMember I see only 20 users who have this role when I'm expecting to see 50 and user X is not amongst the 20 2) when sp_helpRoleMember is executed AS user X, they only see 1 user with this role (and it's not himself) 3) when I drop user X from Role using sp_dropRoleMember OR using Mgmt Studio under Login Properties, it never drops him according to Mgmt Studio. When I pull up the login properties, that role is still always checked no matter what I do...although he doesn't appear in the sp_helpRoleMember result ever. What is goi ...Show All