GoDaddy's Q&A profile

• Windows Forms How to create Arrow Line Control?

  Hi, all. If you ever used visio, you have seen the arrow link. You can put arrow link between two text boxes or image boxes. I want to create the arrow as a custom control so user can select arrow on the form and can drag it/link between two picture boxes. Does any one knows about this Any info will help! Thank you. Thank you for your reply. I don't think it works on me. I'm using C#. However, I got an idea how to make it work. Just idea not programmed it yet. Anyway to make a line with event, it should be control. Mouse event should fire only when user contact the line, not the whole rectangle. Line contains all dots between two Points. When you call Graphics.DrawLine, it draws all dots(pixels). So, we cre ...Show All

• Windows Live Developer Forums System.Data.DataTable 2 GeoRSS

  Hello out there... I’m developing a VE Server Control for ASP.NET 1.1 and have a question related pretty much to ASP.NET and XML, but somehow should fit also in this forum here. I have lots of contacts (with LatLong information) stored in my database and would like to add them via a GeoRSS layer to my map. Nothing special! My question is: How to best transform a DataTable (the result of my db query) to a GeoRSS conformant XML file Right now I’m trying to use the DataSet.WriteXml() function. Is it possible to combine this with the DataSet.ReadXmlSchema() function Or is it really necessary to build the XML-tree element by element from each row of the DataTable ! Appreciate any help or suggestion!! Cheers hafi Hi Hafi23, I have ...Show All

• SQL Server Adding an image

  Hi, I have a pretty simple question. I have a table, and I need one of my columns to be an 'image' column. I've set the column type to 'image', but now I don't know how to actually add images to that column. Can someone please help me. That depends on your coding language how to upload the data to the server, for C#, see this sample which is quite simple. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=622943&SiteID=1 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server SSIS Data Flow task fails to load all text from flat file

  Hi Guys, I have a flat file which is loaded into the database on a daily basis. The file contains rows of strings which I load into a table, specifically to a column of length 8000. The string has a length of 690, but the format is like 'xxxxxx xx xx..' and so on, where 'xxxx' represents data. So there are spaces, etc present in the middle. Previously I used SQL 2000 DTS to load the files in, and it was just a Column Transformation with the Col001 from the text file loading straight to my table column. After the load, if I select len(col) it gives me 750 for all rows. Once I started to migrate this to SSIS, I allocated the Control Flow Task and specified the flat file source and the oledb destination, and gave the output column ...Show All

• Visual Studio Express Editions A Different Approach?

  Tried placing a panel on the form with a filled rectangle on it which moves down when the button is clicked, this works but is on top of the picturebox so I figured I would send the panel to the back which seems to work but now theres no filled rectangle Here's the code Dim X, Y As Integer Dim myPen As New Pen(Color.Blue, 2) Dim Rect As New Rectangle(75, 108, 79, 105) Dim WithEvents PB As New PictureBox Dim B As New Bitmap(200, 260) Dim G As Graphics = Graphics.FromImage(B) Private Sub Panel1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles Panel1.Paint e.Graphics.FillRectangle(Brushes.Red, Rect.X, Rect.Y + Y, Rect.X + Rect.Width, Rect.Y + Y) If Y = Rect.Height Then T ...Show All

• Visual Basic Ambiguous Variables in VB using Word 2000

  I have a brand new Word doc, which contains various VB items/ functions, but VB keeps naming them 11; 21; 31 etc. When I try to rename them 1;2;3 I get an error message that the variables already exist. I am assuming it is picking others up from other Word doc's on my hard drive. Is this possible Then I read about declaring the variable, and making it static and something about "Option Private Module", but I'm new to this and I don't know how to protect this document so that other word doc's don't interfere with the code. Somehow this has also now created a large document - I think, as it takes several minutes to open and forever to save anything I do. HELP!!! ...Show All

• .NET Development MySQL connection problem in remote datadase access with MySQL ODBC 3.51 Driver

  Hello everyone, I am writing a program in .NET wich communicates with local or remote MySQL databases usind ODBC. i am using the follwing connection string: string ConnStr = "Driver={MySQL ODBC 3.51 Driver};"; ConnStr = ConnStr + "Server=" + textBoxServer.Text + ";PORT=3306;database=MyDatabase" + ";uid=" + userid.Text + ";pwd=" + password.Text + ";option=3"; whenever i try to get connected to the local host, it seems to work fine. But in case of a remote database it shows the following error: [System.Data.Odbc.OdbcException] = {"ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Host 'tk-pool10.ntdom.tk.informatik.tu-darmstadt.de' is not allowed to connect ...Show All

• .NET Development PropertyInfo.GetValue[need help]

  Hello firends, I m trying to create a generalized objectArray sorting function whose prototype will look like this public object[] Sort(Object[], strPropName) The reason for creating such a Function is that I call some WebMethods of a webservice. Each webmethod returns an object[] but ,whose type differs. and i need to sort those object[]. i tried this public object [] SortObjectArray( object [] objectArrayToSort, string propertyName ) { int size = objectArrayToSort.Length; Type type = objectArrayToSort[0].GetType(); Object tempObject = System. Activator .CreateInstance(type);// this will act as temp obj for swapping during sorting for (int i = 0; i < size; i++) { for (int j = i + 1; j ...Show All

• SQL Server SQL Server Agent How to detect error exit code of cmdExec batch file?

  I've got a job setup that flows as follows: 1. Run a cmdExec step that performs a transformation of a text file, if the last update in my db control table is earlier than the text file. If an update is needed goes to step 2, if not exit the job. 2. Replicate the db to subscribers 3. send an email to the admin with a message indicating the number of records in the table, and date of last update. Now, no matter what I try, I cannot get the cmdExec step to detect an exit code set in my vb.net program when the update is not needed. I don't want to replicate or send an email, unless I'm updating the db. Anybody, know how to detect a exit code other than 0. I've tried explicitly setting the error code to 1, and the sql server agen ...Show All

• Visual Studio 2008 (Pre-release) How to dispose a ServiceHost?

  I start ServiceHosts from dynamically added assemblies, but can't unload them (dll still locked) since I'm not able to dispose closed service hosts. Here's some code (simplified) AppDomain appDomain = AppDomain.CreateDomain("AppDomainName"); Assembly contractAssembly = appDomain.Load("NamespaceOfContract"); Type ImplementedContract = contractAssembly.GetType(ContractImplementationNamespace + "." + ContractImplementation); Type ContractInterface = contractAssembly.GetType(ContractInterfaceNamespace + "." + ContractInterface); Uri[] baseAddress = new Uri[] { new Uri("http://localhost/test") }; ServiceHost serviceHost = new ServiceHost(ImplementedContract, baseAddress); serviceHo ...Show All

• SQL Server Avoiding Empty Tags using XML Explicit..

  Hey all, a nice little challenge for you as I've searched all over.. Here is some very simple XML Explicit code: SELECT 1 AS TAG,     NULL AS Parent,      product AS [ParentTag!1!AProduct!Element]     FROM tblTable WHERE X = Y FOR XML EXPLICIT When there is no results, I get an empty tag. <ParentTag/> This I do not want. Insted I would like nothing. Is there a simple way to achieve this Using SQL Server 2000 Looking forward to your responses! Roqs Dunno if its just my SQL Server but mine is working fine. I get a blank when no data is returned (Not the <ParentTag/> ) Tried this with northwind. ...Show All

• Visual Studio Express Editions Timer won't fire

  I have a timer on form1 with the timer_tick set up like this:     Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick         teaTime = False         MessageBox.Show("End timer")     End Sub In a module I have:     Public Sub Transition1()         Form1.Timer1.Enabled = True         teaTime = True         Dim st As Integer = 0         Do While teaTime             ...Show All

• SQL Server Can anyone explain what the pre-execute phase is doing for OLE DB data sources using sql commands?

  I have a project which spans multiple servers and aggregates literally billions of rows of data into a much smaller and manageable result set which I store on another server. There are two stored procedures which take up 99.9% of the processing time. Each one of these SPs are estimated to run over 3 hours a piece (gives you an indication of how much data there really is). With in this SSIS package, I have two control flows, one for each SP. When I run the SSIS package from VS2005, I can see that there is a pre-execute phase which takes about an hour abnd a half to complete, and then move on to executing. My question is, what the heck is this, and what is it doing I know it validates the sql in the procedure, but does it actually run the S ...Show All

• Visual C# What is the purpose of all these generated files ??

  I wrote a simple program in c# to display an image and Built it.(file name was Image) In the Project Folder these are some of the files that were generated.                   Image.sln (Solution File)                   Form1(Dot net managed resource file)                   Form1.cs                   Image.cs             &nbs ...Show All

• Visual C# & symbol not displaying on a label

  I have a label that displays a description from a field in database. Noticed if the description has a & symbol it does not display in on the windows label control. How do I get & symbol to display on the label Thanks ...Show All