Idanle's Q&A profile

• SQL Server Package attempts to query source db constantly when editing

  Trying to set up a tranform task between a mysql db using and ADO.NET connection and sql server. My query to pull from the mysql db is something like "select x,y,z from table where last_updated" > @User::LastUpdated. This command is set up as an expression for the Data Flow Task and is the value for the [DataReader Source].[SqlCommand] I have two questions. Why does the package attempt a query against the mysql database all the time And Why is the query attempting to pull the entire table instead of having any regards for my where clause I've even added where last_updated > greatest('2006-08-15', '" + @User::LastUpdated to attempt to get it a where clause even when the parameter isn't set yet. What is the trick Th ...Show All

• .NET Development Server Admin

  Hi I am creating a simple client/server application using the remoting library. What I want is if the server admin types a message into the server console, the message will be delivered to all clients (Example: say the admin needs to bring down server for a few minutes, he can type a message into the console, which will then send a message to all clients saying the server is coming down) I was wondering what the easiest way to do this would be I was thinking about setting it up so that when the admin enters the message, the server sends it off to the service, and then then have a timer control on the client that checks the service every 30 seconds for new messages and then displays a Message Box with the message. But I was thinkin ...Show All

• Visual Basic PNG Backgrounded Form

  I have a form with a PNG image as its background image. How can I make the form's opacity match the opacity at different parts of the image (for example, I have a drop shadow that fades from black to transparent. How do I acheive this effect on a form ) If you put a transparant control (= reduced opacity, not seethrough with transparencykey-color) over another control, then you'll see the control underneath, but you can't click it. But maybe if you capture where the user clicks on the transparent control, and then transfer the .click and other events' handling to the control underneath, you can get what you want. Edit: I don't think you can match the alpha values, though. Edit2: I got it sortof working with 2 forms: -- Form1: trans ...Show All

• Internet Explorer Development IE 7 opening to Run Once page with error on it.

  I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. The error appears to be a web page error I copied what was displayed for the error Line 56 Char:2 Error 'windows.external' is null or notan object Code O URL:http://runonce.msn.com/runonce2aspx ...Show All

• Visual Basic create sql table in vb.net code

  Hi, create a table in vb.net connect with sql server. i know create a sql table in sql server 2000. but i don't know vb.net using runtime create a table. pleasew help me. thanks Hi Do you want the TSQL ddl statement for creating a table (temp or perm) or are you looking for the code to create a connection and issue a command Richard ...Show All

• Visual Studio Express Editions Publish V C# 2005 with SQL Server Express 2005 Database

  Hi @ll I published a simple program using visual c# 2005 express beta 2 with database type sql server express edition 2005. Everything work fine inside my PC But nothing work in my friend PC ! I can run the GUI but when I trying to enter data error message coming to me say's "Timeout Expired" I tried to install framework 2.0 beta 2 in my friend PC then I Installed the full version of sql version express ! My Q here Do I need to special file to include the program when I publishing it ( and How ) or I should do something more Or I need third party program to help me Installing the program Or Microsoft made this option only in professional version of c# Pleaseeeeeeeeeeee Help me , please I'm alone here AS SOON AS POSSIBLE and I will be than ...Show All

• Visual Studio Team System System.ServiceModel.EndpointNotFoundException:

  I am getting the following error when I try to run a webtest on a webapplication System.ServiceModel.EndpointNotFoundException: Could not connect to http://10.10.23.890/weblogin.aspx TCP error code 10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. It showed no error while recording but throws this error when i playback the same. please help Thanks, Sooraj ...Show All

• Visual Studio Express Editions getting around Administrator Rights

  how do i set up my program to run under a normal user and not require them to be administrator Thanks well this depends on the user themselves, they would have to do a "runas" command (or right click the program and go to Run as..." - you can't handle this in your application AFAIK if you are talking about launching an external application within your application using Process.Start(), then yes it can be done by giving the Process the user credentials/account details to run under. Is this what you are after ...Show All

• Visual Studio Team System Team Project Creation Failed

  I am having problem in creating team project, getting the following error. To resolve the error I looked into some of the posts and tried resolving this, but could not find a result. steps followed 1. I have installed SQL server 2005 2. Windows Share point portal "Web Farm" 3. TFS Single Server installation recently tried 4 . NTML Authentication 5. Full Control permission to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET but still the problem is not solved. My sharepoint and reporting services are running perfectly alright kindly help me in resolving this error. regards Suganthi Error Insufficient permissions on the Windows SharePoint Services at mango to ...Show All

• SQL Server Customising Date Picker

  O Great Beings of MSDN, After much fruitless search I am requesting help on whether there's any way to disable some of the dates in SSRS date picker control. I have a date parameter in which I want users only be able to select the Fridays. I could show a drop down list of Fridays but that doesn't look too flash, especially when the list has about 2K Fridays. Any help would be appreciated. Thanks Teo, I think I will have to give up on this one as we already have a custom report protal on which all the RS reports and other reports are displayed. Having another application fire up to collect parameters is not an option for me so that's a bit of bugger. Hope microsoft can utilise the dataset section in order to provide thi ...Show All

• Windows Forms Displaying a textbox over a picturebox

  I am putting several pictureboxs on a form then use the mouse hover to bring up a textbox. All works ok BUT the pictureboxs overlap the textbox. So what can I do so the textbox shows in front of the picturebox THANKS When I try that and hover the mouse over the picturebox it just flashs on and off. If there is not a picture box in the way it will display. Here is the code that I am using to display the textbox (mytext) Private Sub InitializetextBox() MyText.Location = New Point(x, y - 16) BindingNavigatorPositionItem.Equals(i) MyText.Text = OutputTextBox.Text MyText.Visible = True 'Repeater_IDTextBox.Text = MyText.Tag MyText.ReadOnly = True MyText.BackColor = Color.White Me.Controls.Add(MyTex ...Show All

• Community Chat Microsoft and its 'new' Halo: Wars RTS Game, and Derelict Studios

  Well, as most have probably heard, Microsoft has come out with a 'new' Real Time Strategy game called Halo: Wars, a game to be made for the X-Box 360. I quote 'new', because it is not a new idea, nor shall all the credit go to those people who work in Microsoft. A Modification for the game C&C Generals, called Halogen, was a mod in the works for approximatly 3 years, where people from the community pitched in numerous hours of work and labour for the good of the  community, and a playable release was soon to come for those of us desperate to download it. Microsoft came in close to before the release and forced the memebers of Derelict Studios to close down Halogen and halt all progress on the game, and close down the ...Show All

• Visual C# My DataSet Doesn't Work :S

  Hi, In my project I have one DataSet ('Step') from this I have two tables ('Students' and 'PostCode'). I have set them up in both the same way. I can successfully call Step.Students.FindBy(PK) and the function will return either null or not null depending on the results it finds, which is what it should do. However my second table I call Step.PostCode.FindBy(PK) and it always returns null no matter what is in the database. It actually returns null for everything, select, count etc. It looks to me like the dataset isn't actually connecting, even though my GridView successfully shows the content of the table I originally thought the changes weren't being committed but even when I use AcceptChanges() it still doesn't work. One thought I have ...Show All

• Windows Forms Windows Forms userControl Communication Interface?

  Hi, I have a very simple windows app that contains one windows form that contains a splitter control. This form loads two userControls into each panel of the splitter: Control cLeft = new LeftSpine (); cLeft.Dock = DockStyle .Fill; splitContainer1.Panel1.Controls.Add(cLeft); Control cRight = new RightSpine (); cRight.Dock = DockStyle .Fill; splitContainer1.Panel2.Controls.Add(cRight); My Question is what is the best way for me to pass a string (etc) from the usercontrol: LeftSpine to the other usercontrol RightSpine() I've read a lot about interfaces, would I create an interface that would be used by the two usercontrols Can anyone point me in the right direction thanks ...Show All

• Visual Basic VB GUI client inserting into db but where?

  I have a VB GUI client application, no source code or anything, and when I use the GUI to delete a record, is there a tool or something that can tell me where/what the client app is doing in the db (which tables are being accessed, what operation (delete/update/add etc..) The reason I ask this is as follow. I have a client with an access control server. the server stores cards that employees use to enter the building and present to a reader to gain access. this is first time I see this specific type of server. I am integrating some 3rd party app. the db is completely open, I can see all tables etc.. the GUI is closed, the manufacturer will not discuss anything about how it works. ...Show All