darkool's Q&A profile
Visual Basic What is wrong with the ComboBox !!
Hi all, I am writting very simple event for the ComboBox... but my msgbox displays nothing. kindly have alook at my code. Public Class Form1 Private Sub ComboBox1_SelectedIndexChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) 'Handles ComboBox1.SelectedIndexChanged If Me .ComboBox1.SelectedIndex <> -1 Then 'MsgBox(Me.ComboBox1.Text.ToString) MsgBox( Me .ComboBox1.SelectedText.ToString) End If End Sub Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim conn As New Data.OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\MaHMouD\Deskt ...Show All
Visual Studio Properties Window
Is there a reason why, when you are in source mode, and you click on a control the Properties Window is not populated I am almost positive that pre SP1 this worked. Thanks, SLTDon Very helpful Thank you !! But for the <body> tag properties, why don't the "topmargin" , "bottommargin", "leftmargin" properties show up ...Show All
SQL Server help with an expression
I need to create an expression to handle a simple calculation. Here is what I have: =Sum(Fields!MH_POS.Value, "lexis_sales_dbdata_prd")/ Sum(Fields!MH_POS_Goal.Value, "lexis_sales_dbdata_prd") What do I need to add to handle the when the MH_POS_Goal = 0 I tried isnull and nullif and kept getting errors. If I use this in a report with subtotals I get the calculation at the total level and not at the subtotal level. Any ideas how to get the calculation to perform at the subtotal level ...Show All
SQL Server SQL Query Problem
Hi, Actually I have 3 tables User (user_id, user_name....), ProjectMember (pm_id, user_id, project_id.....) & TaskAssignee (ta_id, user_id, task_id....) in which User table has its foreign key into both of the other tables. There is no relationship between ProjectMember & TaskAssignee table. Actually I want to retrieve all user's info from ProjectMember table Inner Joining User table for specific condition in TaskAssignee table. The condition is: We have to retrieve user's info from ProjectMember table (means user_id) of which user_id value should not be same with user_id value of TaskAssignee table for the perticular task_id value of TaskAssignee table. For example suppose I am providing task_id=1 to the store proc then i ...Show All
SQL Server Dual Y-Axes
Greetings, I'm wondering if it is possible to have two independent y-axes on a single chart I am wanting to plot data using a hybrid bar/line chart and have the values for the vertical bars show on the left y-axis and the values for the points on the line show on the right y-axis. I've seen this sort of thing done on other platforms before, but don't know if it is possible with SQL Reporting. We are using SQL RS 2000 by the way. Thanks -- Anthony Keep in mind that the CustomReportItem-based extensibility (such as "Dundas Charts for Reporting Services" or similar offers from other third parties) are available for SSRS 2005 only in Standard, Enterprise, or Developer Editions. It is not available for SSR ...Show All
Visual Basic Copy combobox.text to first two columns in datagridview(I got it)
I want to add the value of invoiceid combobox and customerid combobox to a datagridview column1 CustomerID and Column2 InvoiceID. I need to do this in code because the comboboxes are bound to a different table. The dgv that I am adding them to (2nd dgv) will not be updated with this info. It is only used to select rows to add to a third dgv. Currently I have to physically type the combobox values into the 2nd dgv. I want to populate those columns with the combobox selectedindexchanged. whew! I changed it to textboxes Private Sub InvoiceIDTextBox_TextChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles InvoiceIDTextBox.T ...Show All
Visual Studio Team System Checkin policy dll is blocked after the policy usage
I tried to assign new checkin policy to the project - it failed and adviced me to install the policy. I am actually compiling project tot he folder where this policy should be assigned from and now, after the error, my Visual Studio can not override the dll file. Looks like that Wizard or whatever it is didn't release the lock from dll. It happens every time when policy is touched in any way and until the Visual Studio is closed down - either memory leak or something... When I click on Team->Project Settings->Source Control - I think it does evaluation, right I think every time when policy DLL is touched in any way it's locked. When I try to recompile the policy project it complains that it can not r ...Show All
Windows Forms MouseMove Problem...
Hi everyone.. I have a strange problem in a form... I've added in the FormMouseMove event some code (MessageBox.Show("I've been moved")) to be execute... and I find that the event is fired everymoment... also whe the mouse is stoped... Maybe I'm wrong but the MouseMove event don't must be fired everytime that the mouse is moved over a control I'm trying to catch when the mouse is stoped and when is starting to move... I thought that is pretty easy but I found this kind of whatever is happen... Thanks Yes.. you are right about that the event is raised continuously as the mouse is moved within the form, but If I don't move the mouse, the event is raised too... So... How could I know when the mouse is really moved with ...Show All
Visual C# New solution name is not shown.
Hi, I have been using Visual Studio.NET 2005 IDE. Whenever i am creating solution, solution name (node) is not displayed in the solution explorer. Only project name is displayed. But solutionName.sln is created in respective location. Thereby i am not able to add new project for the same solution. Kindly suggest me some ways to enable the solution name display in solution explorer. Best Regards, kalai kalai wrote: Whenever i am creating solution, solution name (node) is not displayed in the solution explorer. Only project name is displayed. But solutionName.sln is created in respective location. You can turn that feature off. Go to Tools menu, Options, Projects ...Show All
Visual Studio Team System Validation Rule: Find Text - Regular Expression
I need to verify that a transaction id and confirmation id were actually returned. Both values appear on the page but I do not know what the exact values will be. The transaction id should be six digits long and the confirmation id should be 16 characters long (0-9,A-Z,a-z). The challenge is that I am trying to use a web test and I want to avoid writing code if at all possible. The Find Text Validation Rule has an option to set "Use Regular Expression" to True, but I am having trouble finding examples using this. Can anyone give me examples of how to use Find Text to search for transaction id = 123456 or confirmation id = 12345abcd67ef89gh when the exact ids are not known Thanks in advance... ...Show All
Visual C++ Docking Markers
Fellow application artists, Those docking windows in Visual Studio 2005 are pretty darn cool and useful. I like my screen real estate such that my main window gets as much screen as I can give it. I've seen the same feature in Visual Paradigm software but it seemed a little more sluggish to me. So my question is regarding those sliding tool windows that you can pin and have your client area resized, and you can position them so many different ways and still have them slide and adjust well, the same ones you use in Visual Studio 2005 for everything but coding. What are they called in Visual Studio speak, and do they have a pre-built Microsoft class I can use Building my world one semicolon at a time, Seth There's no specific term fo ...Show All
SQL Server Jump to Url
I use the "jump to url" in a report that links out to a page on our company intranet. Our internal users have to use http and an external user needs to be routed to the site w/ https. How can I account for this in a report You could use an expression for the URL and look at the global "UserID" Based on that UserID, you should be able to determine if the user is internal or external, and set the URL appropriately. HTH BobP ...Show All
SQL Server Topcount for a period.
I want to get the 10 best xxx in a period (i.e. this quarter, last quarter, this year, last year...) I have used topcount to get the top customers but it includes all the data from all years. For example in foodmart to get top brands by sales I have: set [TenBest] as 'TopCount( [Product].[Brand Name].Members, 10, [Unit Sales] )' I assume I somehow use the [Time] dimension in the query to get the top brands for 1997, 1998, Q1 1998, Q3 1997... Then I can use the same syntax for toppercent, bottom.... Thanks, Chris Chris, The simplest method is to just use a tuple in place of the measure: Using your example: set [TenBest] as 'TopCount( [Product].[Brand Name].Members, 10, [U ...Show All
Windows Forms Can't get ObjectDataSource Paging to work!
Hi, I am trying to use paging with a DataGrid and ObjectDataSource, but I can't get it to work properly. The problem I see while debugging is that I get startRowIndex =0 and maximumRows =0 therefore my Select returns an emptry result set. Here's the code snipet to what I've used. But when I break inside GetUnnMemberDirectory (the select method), I always get maximumRows as zero. What is the problem with this code Thanks! < asp : DataGrid ID ="DataGrid1" runat ="server" Width ="600px" AllowPaging ="True" AutoGenerateColumns ="False" DataSourceID ="unnMD_ObjectDataSource" ShowHeader ="False" GridLines ="Horizontal" ...Show All
Visual Basic VB Logic Problem, Select Case, Cannot Update Correctly
Hi, I am hoping someone can help with a tricky issue. I have a DB to be updated by data from excel files. My program looks at the data in the excel files, assigns the values to variables, compares the variables to the comperable fields in the DB, and updates as necessary. The data going into the DB is actually coming from 3 separate excel files. My logic works fine as long as all I am doing is filling in blank fields in the DB. However, sometimes a particular value is flagged by the lab that is producing the data as being "out of range". The test will be re-run at some future date and that value updated with a new value. I can't simply NOT fill in that field, because if the test does NOT get re-run we will have no data. (We want ...Show All