avi_india's Q&A profile

• SQL Server Converting a date with a derived column

  I'm having trouble converting a date in the format of: Jan 11 2006 12:00:00:000AM to a smalldatetime in my new SSIS package.  I'm trying the derived column transformation, but I'm at a wall now, especially with the conversion of 'Jan' string to integer/month/value of 1.  Anyone have experience/advice on this transformation What happened to the DateTime String transformation in SQL 2000   Was that too unpopular to move to integration services   That transformation saved my butt many times - every banks' data feed we import uses a different date format. Thanks in advance for any advice/help! -Erik ...Show All

• SQL Server If statement

  Hi All, I have the following parameters in a subreport: Frequency, EndDate and StartDate Frequency, and EndDate have been populated using values from the main report. I need to set the StartDate possibly using an expression or the code builder. This is the psuedocode: If Frequency = 'Monthly' startdate = dateadd("m",-(12), Parameters!EndDate.Value if Frequency ='Weekly' startdate = dateadd("w",-(12), Parameters!EndDate.Value if Frequency='Daily' startdate = dateadd("d",-(30), Parameters!EndDate.Value In English If frequency='Monthly' the start date should be set to 1 year before the enddate if frequ ...Show All

• Visual Studio Express Editions Computernames

  Hi How can i see the names of all the computers in a network, which are connected to my computer or which my computer is connected to. Regards Thomas Are you still with me here is a .NET object picker from Mr Igor Kissil that was posted on the gotdotnet.ru forum, that I have updated to from 1.1 to 2.0. It works as expected. the picker is in C#, but can be referenced in VB. includes a VB example project (PickerTest) with a reference to the C# library IMPORTANT : compile before opening the form1 in the PickerTest as the form has the component on it. . . will fail if not compiled ...Show All

• Windows Forms the value of datagridviewcomboboxcell is invalid error

  I get the above error whenever I use a comboboxcolumn in a datagridview. I set up the datasource, displaymember and valuemember properties properly. But, when I run the app, I get this error... what is the reason of it  anyone who knows the fix of this problem... Or is this bug in VS.NET 2005 Beta.. I have a variation on this problem. I had filled my dataset with the ...Show All

• .NET Development ConfigurationSection Question

  I am in the mist of learning about the new configuration classes in the 2.0 framework. Here is what I am trying to do: Define my own custom section in the app.config Have the application read this custom section from the app.config Have the application be able to modify the values from this section Save these changes as a user config file From what I understand with the new configuration classes the flexibility is there to save values to the application config file or a user config file, but I can't quite figure out how to accomplish this. Thanks Kevin If you need to have a cust ...Show All

• Windows Forms Problems getting the handle to a PictureBox as a HWND

  Hi, I have some code which casts a handle to a Picture Box to HWND. Sometimes it works fine, and at other times it generates undefined value, and I can't see why. What I am doing is: At startup, before the GUI is displayed, I get the address of a Forms.PictureBox control using the Handle method, which returns a System::IntPtr. According to the docs, this should be valid at this stage, and a number is always returned. I pass this in to a method, which casts it into an HWND for passing in to an unmanaged C++ library (which generates an image to put up in the PictureBox), as follows: System::ntPtr hwnd; HWND phwnd; phwnd=(H ...Show All

• Windows Forms giving a panel focus

  I am sure its simple, but I have searched about and can't seem to et something working. Simple window, i created a panel in. Here is what I have and have tried: The commented portions are what I have tried. [code]  private : System::Void IrrlichtPanel_Paint_1(System::Object^ sender, System::Windows::Forms::PaintEventArgs^ e) { ObjDisplay->init((s32) this ->MyPanel->Handle.ToPointer()); //this ->MyPanel->BringToFront(); //MyPanel->BringToFront(); //this ->MyPanel->Focus(); MyPanel->Focus(); }  [/code] The object I am loading into the panel is displaying corr ...Show All

• Visual Studio Visual Studio 2005 Beta 2 setup fails immediately

  Hi, I'm installing Visual Studio 2005 Team Suite from the Beta 2 DVD handed out at one of the recent MEDC events. I have: Windows XP Pro + SP2, 1.6Ghz, 256MB RAM, 4Gb disk space free. No problem with the DVD drive that I am aware of. No previous betas installed. I have VS 2003, eVC++4.0, Embedded Visual Tools 3.0 installed. Following error appears: AppName: setup.exe AppVer: 8.0.50215.44 ModName: setup.exe ModVer: 8.0.50215.44 Offset: 00029002 Any ideas I can send the full error log if you give me an address. Regards, Ade W You could try running FileMon or RegMon and see if they throw up any erro ...Show All

• Visual Studio How to let ReportViewer in ASP.net 2.0 local mode to change Report definition

  If reportviewer is used in Form application, ReportPath can be set. But in asp.net the same method does not work.     protected void Button1_Click(object sender, EventArgs e)     {                 if (this.strOrderBy == "Customer")                 {                     this.rvPrice.LocalReport.ReportPath = @"Report\PriceCustomer.rdlc";     &nb ...Show All

• Visual Studio Team System "My Queries" using object model

  Hi all, I hope this is the right place for this. I can't find how to get the queries in "My Queries" using the object model. Anyone know how the get it   Nir Nir, This forum is mainly for the tools specific to VSTS for developers (Static Analysis, Profiler and Unit Testing). However, I can bump this over to the TFS forum where they may be able to better answer it. Thanks, Ian ...Show All

• SQL Server Versioning Stored Procedures with VSS and Sql Server 2005

  I am wanting to put my stored procs in vss. The configuration that I am looking at is Sql Server 2005 Sql Server Management Studio VSS I have not been able to find anything that gets me going, so if someone has a link or some links, please just redirect me and I will continue digging. What I don't know is what is the best approach for doing this. Do I need to create a new project in management studio for all of my stored procedures Is there a solution that I can add to VS.NET that would do this What I am ultimately looking to do if this is possible, is have my developers use Management studio to work on their procs and have it interact di ...Show All

• Windows Forms ToolboxBitmapAttribute doesn't work

  Could anybody explain me what happens Code is below: C#: [ System.Drawing.ToolboxBitmapAttribute(typeof(MyClass), "myicon.ico") ] public class MyClass: Component {...} VB <System.Drawing.ToolboxBitmapAttribute(GetType(MyClass), "myicon.ico")> _ Public Class MyClass Inherits Component ... End Class I have place the above component into Toolbox, but its icon remains "sprocket". No rebuilding and no replacing help. I have  ...Show All

• SQL Server Breakpoint doesn't work

  I've got a breakpoint in a script task. The script task executes successfully but doesn't break. Short and sweet this one. Anyone any idea why it might not -Jamie   JAson_scoobyjw wrote: Hey Jamie, I believe I read somewhere in the pipe that breakpoints weren't going to work until the prod release... Nah, I know this has worked in the past and I've read posts today from people that have had it working. -Jamie ...Show All

• Visual Studio Express Editions BalloonTipText on NotifyIcon1 Hover over?

  I've been looking at how to use BalloonTipText, and I found this small section of code: NotifyIcon1.BalloonTipTitle = "Balloon Tip Title" NotifyIcon1.BalloonTipText = "Balloon Tip Text." NotifyIcon1.BalloonTipIcon = ToolTipIcon.Error That isn't working for me though, in the test app I made to try it out. I put it in the NotifyIcon1_Click event and nothing showed up. I'd really like to be able to display something when the user hovers over the notify icon too, and I couldn't find a hover over event. Also, can I use a variable for the text in the balloon tip Any help would be appreciated. ...Show All

• Visual C++ TypeLoadException

  Hello - I recently added code I adapted from C# to C++ based on an articale on CodeProject.com that is used to provide runtime Properties to a PropertyGrid. The link is: http://www.codeproject.com/cs/miscctrl/bending_property.asp #xxxx It now compiles fine, but I get the runtime error TypeLoadException with the message: "Body referenced in a method implementation must be defined in the same type" along with the name of the assmebly and other assmebly info. I'm baffled as to what this could mean. Any help would be appreciated. I will paste in the code for the class at the end of this post. Thanks in advance - ...Show All