Nikkon's Q&A profile
SQL Server Arithmetic operator
I'm using Sql Server reporting tools and creating a report. How can I display the difference of two fields on a report you have 3 text boxes on a form.. say you have two fields... textbox1.value = fields!myfield1.value textbox2.value = fields!myfield2.value then in the value for textbox3 put = fields!myfield1.value - fields!myfield2.value QED Daryl ...Show All
SQL Server Reading in an XML file from a URL
Hi I have a problem with SSIS in that I need to read an XML file in from a URL,which brings me back the below XML. What I need to be able to do is essentially create a single record, including the nested XML <image> into the same record. This information then needs to be entered into a database table. What I found is that if I use a data flow component, and have an XML source pointing to this URL, it essentially creates a different output for every level of nesting. This causes me serious issues because I would then have to somehow get to the information in the <image> tag, and then get everything below that, etc, to be able to get the images related to each <stock> record. This is a pain. I also looked at using ...Show All
Visual Studio Change of File/Project open Dialog in VS2005 compared to 2003
Hi everybody I often work with favorites. VS2003 had the Favorites folder on the left side in the file open dialog. In VS2005 there's no favorites folder icon anymore. How do I add the fav folder in VS2005 ...Show All
Visual Studio Team System Static Data Tables - Solution?
Hi all, OK, I think I've come up with a good way to manage data in 'Static Data' tables through source control and through which changes can be managed through source control and published to both blank and live databases using DBPro. I've also created a free tool to create the management scripts for you. Have a look at: http://leon.mvps.org/StaticData/ and let me know what you think. Note that the script generator tool is in its first public release, and therefore not yet suitable for live environments, but with some feedback hopefully we can get something working! Hi, Leon! This solution will work. Although we generate just IF EXISTS (SELECT WHERE (id)) UPDATE WHERE (id)] ELSE INSERT () Not ...Show All
.NET Development mouseUp event of vertical scroll bar
Hi all, Plz tell me hos get MouseUp event of vertical scroll bar of browser in javascript. the onscroll doesnt fire until the user stops scrolling, effectively the same as mouseup. It also works for the middle mouse wheel that many users use to scroll, which a specific mouseup event on the scrollbar wouldn't detect. I found a little html on the net that illustrates this point. If you still think you need the mouseup event please elaborate on why you feel you need to do it that way. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <head> <title></title> <script language="JavaScript" type="text/javascript"> <!-- var zxcTO; function Scroll(){ clearTimeout(zxcTO); z ...Show All
Visual C++ 'DisplayMat' : cannot convert parameter 1 from 'int [6][6]' to 'int *[]'
Hi. this is a sample of my problem. what should I do thanks. #include "stdio.h" #include "stdlib.h" #define _Row 6 #define _Col 6 void DisplayMat(int *Mat[]); void main() { int Matrix[_Row][_Col] = { { 11,0 ,13,0 ,0 ,0 }, { 21,22,0 ,24,0 ,0 }, { 0 ,32,33,0 ,35,0 }, { 0 ,0 ,43,44,0 ,46}, { 51,0 ,0 ,54,55,0 }, { 61,62,0 ,0 ,65,66} }; DisplayMat(Matrix); } void DisplayMat(int *Mat[]) { int k,j; for ( k = 0; k < _Row;k++) { for( j = 0;j < _Col;j++) printf("%d\t",Mat[k][j]); printf("\n"); } } You need to change the signature of DisplayMat function to this: void ...Show All
Smart Device Development Null reference Exception : Use the "new" keyword to create an object instance
Hi, While I am setting image as background I am getting the following excpetion. While I am running it in VS 2003 it is working normally with out any problem. but when I take the same code and try in VS 2005 I am getting the following exception. Null reference Exception : Use the "new" keyword to create an object instance code is : private void Form1_Load(object sender, EventArgs e) { m_backgroundImage = LoadImage("background.png"); } static public Bitmap LoadImage(string imagename) { return new Bitmap(System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(imagename)); } plzz can any one tell how can I run this code in VS2005 with out any error. ...Show All
Visual Basic How to mass insert data into DB(MS Access) in Window application
Using VB 2005 Can anyone help me with the above problem.... Pls send a sample links/codes asap~ THX ...Show All
Windows Forms User control-Design time support
i have created a user control and for this control one property is an object of a class named ControlProperties i have designed a form to accept certain values( essentily the controlproperty class object ) which are added to an hash list for design time support..my problem is i dont know how to assign perssist this object...i am getting this object during design time..but once i run this the object becomes null..i figured out that the object properties is not being included in the intialize compnent method.. here is what id did..to open the form during design time public class DesignSupport : UITypeEditor { public DesignSupport() { // // TODO: Add constructor logic here // } public o ...Show All
.NET Development Any way to display images in gridview?
the image is stored in a column as binary data. Set the content type with Response.ContentType and Stream binary data with Response.BinaryWrite Eg. <asp:imagefield dataimageurlfield="ImageID" dataimageurlformatstring='ViewImage.aspx id={0}'> </asp:imagefield> In viewImage.aspx // Get the record from database and .... Response.ContentType = "image/gif" Response.BinaryWrite( (byte[]) dr["Image"] ); // dr = DataReader Object. HTH Regards Jignesh Desai ...Show All
SQL Server INFORMIX ODBC PROTOCOL
hi all, Happy new year! is anybody here familiar with the different informix ODBC protocol such as Sesoctcp and onsoctcp and the rest of the protocols I think my SSIS design is affected by this protocols i'm having problems with the unicode and non unicode conversion. many many thanks Joey hi Phil, thanks for that - OLEDB But that's beyond my control. honestly, i was thinking the same. i'll keep that in my wish list anyway i don't have access to our informix db and the way to connect to it is to use the stored ODBC system DSN created by other DBA by which password is protected by the box. Using OLEDB i can have it saved using the UDL (universal ...Show All
SQL Server Getting a reference to a Script task in VB.net
I am trying to get a reference to a script task so I can manipulate it's properties. However I can't seem to figure it out I have a reference to Microsoft.SqlServer.ManagedDTS and Microsoft.SqlServer.Dts.Design and based on BOL they show Imports System Imports System.Collections.Generic Imports System.Text Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Tasks.BulkInsertTask Imports Microsoft.SqlServer.Dts.Tasks.FileSystemTask Imports Microsoft.SqlServer.Dts.Runtime But I get errors saying Imports Microsoft.SqlServer.Dts.Tasks.BulkInsertTask Imports Microsoft.SqlServer.Dts.Tasks.FileSystemTask can't be found What do I need to reference or Import to be able to see the ...Show All
Visual Studio Express Editions Save a picturebox image as jpg
Microsoft help says in order to save the image in a picturebox, you must assign a button to the image, so I don't know if this is correct, but I am using: Private Sub SetMyButtonProperties() Button2.Image = PictureBox1.Image() End Sub I have read on the forum that the easist way to save a picturebox image is to use: Me.PictureBox1.Image.Save(FileName) So I am using: Me.PictureBox1.Image.Save("C:\MyImage.jpg") My goal is to click Button1, then open an image in PictureBox1 (So far, so good.) Then click Button2 and save the image as a jpg. But this is where I click Button2 and receive an error message for this line of code: Me.PictureBox1.Image.Save("C:\MyImage.jpg") The error is: NullReferenceException was unh ...Show All
SQL Server How can I connect to a remote sql server using windows authentication?
It is simple 1- I open the Sql Server 2005 Management Studio 2- I select Windows Authentication from the drop down. 3- I cannot write the user name and password, it chooses the default once, the one I am logged in with! But I am in a virtual machine outside the domain controller, I can access shares on machines that are on the domain controller, thanks to the file sharing of windows, but I cannot login to sql server, thanks to a meaningless restriction on that dialog :-) Now, how can I still use the Windows Authentication and login, how can I avoid the sql server authentication Ok, then why the text boxes for the user name and password are ...Show All
Smart Device Development Compact Framework 1.0 MD5 hash
Is there any way to get an MD5 File hash using C# or C++ on a device that has compact framework 1.0 OpenNETCF is unfortunately not a possibility, Joshua Take a look at this article and the downloadable code related to it. ...Show All