Shawn Wildermuth - MVP (C#)'s Q&A profile

• Visual Basic ADO.NET Database

  Below is a code I cannot get to work, it is actually from a how to book. The Error I always get is: Too many arguments to 'Public Overridable Overloads Function FillByLastName(dataTable As addressBookDataSet.AddressesDataTable) As Integer'. The error occurs at the end on this line: AddressesTableAdapter.FillByLastName(AddressBookDataSet.Addresses, symfind.Text) Public Class FrmAddressBook Private Sub AddressesBindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddressesBindingNavigatorSaveItem.Click Me .Validate() Me .AddressesBindingSource.EndEdit() Me .AddressesTableAdapter.Update( Me .AddressBookDataSet.Addresses) End Sub Private ...Show All

• SQL Server T-SQL Badly needed

  To one of our sql server database Table A , we need to migrate data from another sql server database Table B . Assume there are two columns in a table namely OrderID and Comments . Here OrderID is a foreign key. And therefore, I can have any number of comments for a Particular OrderID. Thru a TSQL query, I wish to have all the Comments data beside the OrderID seperated by comma like Ord1 Comm1, Comm2, Comm3 Ord2 Comm5, Comm6. Comm7, Comm8, etc., This is just the thing we used to do for numeric columns using GROUP BY statement as SELECT ORDERID, SUM(ORDER_TOTAL) AS AMT FROM B GROUP BY ORDERID Want to know how to achieve similar effect with Varchar type of data. I'm currently using Cursor to concat, but it is taking long l ...Show All

• Visual Basic Help with Implementing IInternetSecurityManager in Web Browser control

  Hi I am currently designing my own web browser based on Microsofts Web Browser control I am using Visual Basic.net 2003 with the .Net Framework 1.1 My problem is i can't get it to work, and i am getting errors in code for reasons i just cna't figure out as my code seems logical, maybe i just need someone else to look at it, maybe someone else can see an error i can't see. Neways here is what my code for it looks like: Public Class Form1 Inherits System.Windows.Forms.Form Implements WebBrowserAPI.IServiceProvider Implements WebBrowserAPI.IInternetSecurityManager I also get errors trying to implement these statements as well Public Sub New() MyBase.New() ' InitializeComponent() ' InitializeComponent() ' Microsoft Web Bro ...Show All

• Visual Studio There is no source code available for the current location. (Why???) - More Information

  I have a VC++ solution configured as follows: a.exe b.dll c.dll All 3 projects are part of the solution, with a being the startup project, and running in debug configuration. All 3 projects output their .pdb files as expected. a is dependent upon b, and b is dependent upon c. I set a breakpoint in b at a point where the code is in c. When I do that, VS complains that "There is no source code available for the current location." There is source code, and current .pdb. Any ideas why this happens Thanks, -HS When I run a.exe, I then look in the modules window. It shows that c.dll is loaded, BUT it has a red flag on it which says "The module did not load at the default address". Thi ...Show All

• Visual FoxPro Hot key question

  I know that we can assign a hotkey 'S' for a button like : thisform.button1.caption="\<Start" The question is: how to assign a hot key "Page Up" or "F2" key for the button in a form You can'nt make it using a "Hot Key" assignament, instead, you need enable the KeyPreview property in your form, and to provide custom code into the KeyPress Method with the handlement of your keys. A Example: ** More at **** http://fox.wikis.com/wc.dll Wiki~KeyPress~VFP **** http://msdn2.microsoft.com/en-us/library/6wd37f7s(VS.80).aspx Procedure KeyPress (nKeyCode, nShiftAltCtrl) ** nKeycode returns a inkey value. http://msdn2.microsoft.com/en-us/library/aa977875(VS.80).aspx Do Case Case ...Show All

• Visual Basic NET SEND GUI

  Hi all. I am working on a net send/recieve utility. I can get the sending protion of the program to work, but cannot get the receive portion to display the received message in a textbox in my application. It always pops up like the standard windows message screen. How can I get it to display it my received textbox. Another question. Is there a way to stop the command box from flashing when I click to send a message Ok, I have made a simple gui useing the shell("net send") option. Is there a way to return the "Message Sent Successfully" message like is received from the command prompt when using net send there ...Show All

• Windows Forms Loading Image (Visual C# 2005)

  Hey, I after these lines of code what should I put to make it load the image into a PictureBox openFileDialog1.DefaultExt = "*.gif" ; openFileDialog1.Filter = "Gif Images (*.gif)|*.gif|JPG Images (*.jpg)|*.jpg|TIF Images (*.tif), (*.tiff)|*.tif|PNG Images (*.png)|*.png|BMP Images (*.bmp)|*.bmp" ; openFileDialog1.InitialDirectory = "MyDocuments" ; openFileDialog1.CheckFileExists = true ; openFileDialog1.CheckPathExists = true ; Thanks :) PictureBox1.Image.Save(<filename> , System.Drawing.Imaging.ImageFormat.Jpeg) ...Show All

• SQL Server Count Item Number

  Hello; Which is the easy way to do this: I have 2 tables:Work_Order_Header and Work_Order_Detail. I need to generate the Item Number from 1 to "qty of items" when I make the JOIN on WorkOrderNumber. Example: WorkOrderNumber WorkOrderItem WorkOrderAmt 122 1 10.00 122 2 15.25 122 3 24.37 How I generate the WorkOrderItem using a select with a JOIN on the 2 tables A sample you be something like: SELECT ( SELECT COUNT (*) FROM [Order details] OD2 WHERE OD2 . orderID = O . OrderID AND OD2 . ProductID >= OD . ProductID ) AS Number , O .*, OD .* FROm Ord ...Show All

• Visual Basic wininet API - date and time not correct

  Using functions available in the wininet API, I get the files in a directory from a remote unix server with their timestamps. I use FileTimetoLocalTime first to convert the UTC time to local time and then use FileTimeToSystemTime to get the system time - as suggested by the article in MSDN. But the lastwritetime obtained thus is always 8 hours off of the real time and the creationtime and lastaccesstime are always 12:00:00. Also for very old files, the date also is off by 1 day. Why is this Am I missing something or is the code to get the system time is wrong Please let me know. Thanks! Here is the code snippet Private Function ConvertToDate(dtGivenDate As FILETIME) As Date Dim dtDateinSYSTIME As SYSTEMTIME Dim dtDateLocal As FILE ...Show All

• Windows Forms detailed listview questions

  1) how can i write in a multiline way in a row in a detailed list view 2) how can i export a data listed in a detailed listview to: .pdf .doc .html thanks but what i want is that a column width will be fixed and the string entered is not known until run time , so the text will not be written in one line but in many lines restricted by the width of the column ...Show All

• Visual Studio 2008 (Pre-release) uploading powerpoint file on the server.

  Hi, I am developing an application wherein i need to upload the powerpoint file(which is provided by the user) on my server.Can anyone please help me out to resolve this issue Hi Ashish, Access denied happens when I publish the application in VS.It is an XBAP application.When I click on Upload file button,I get an error "Access denied".it happens in local machine. ...Show All

• Gadgets HTML form in gadget submits to new window. How can I stop this?

  Hi all, I'm new to sidebar gadgets as well as Windows Vista. I'm a web developer, coming from Windows 2000 Pro, where I had a small php-based form that kept track of my hours. In Windows 2000 I was able to add it to my desktop fairly easily with "Active Desktop". It is proving to be somewhat more difficult with Vista Sidebar Gadgets. I was able to create the gadget, and the php form now displays. To do this, I created the .gadget folder in my User directory, then in the html file in that folder, I created an iframe with a source pointing to the php file in my localhost webserver directory. So that's my background... Anyway, when I try to submit the form, instead of reloading the gadget, it opens the form in a new window. This occurs even w ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Collision of Rotated Sprites

  Ok. I realise collision detection has been discussed quite alot, but after doing a fair bit of searching through the forums and the web, I still can't find a solution to my problem. I am working on a arial view car game (remember GTA 1 and 2 ) and I am at the point where I need to handle collisions. Most people seem to be using BoundingBoxes, which would work fine in a few situations, but in my case, drawing an axis aligned box around my rotating car would be far too inacurate. I realise that the boundingbox class does not allow rotation as mentioned in this forum, so I am wondering if anyone is aware of an alternative solution. I could solve the problem by creating a series of rotated square alpha images for my car to use when rotating, ...Show All

• Visual FoxPro visual foxpro query

  Hai, i have a table with the following records. month,dealercode,branch,netqty can anybody kindly give me SQL Command which will sum netqty group by dlrcod and month but for each dealer monthqty should appear vertically. select dlrcod,branch,sum(netqty) from <table name> group by dlrcod,month with this query i get month totals horizontally but i want months to appear vertically. if any body can kindly give me a query, i would be greatful eg. mnth delaer code branch netqty january a0001 blr 1000 april a0001 blr 500 feb a0001 blr 300 may b0001 blr 400 june b0001 blr 300 january a0001 b ...Show All

• Visual Basic SMTP Authentication Windows Application

  I have a VB.Net application that I wrote that is NOT web based. This application is used to send our customers monthly updates and other information. We recently changed our T1 and our server requires Authentication. I have been able to get a web based version to authenticate, but am unable to do so with Windows. Any help would be appreciated. I need to get this working within the next few days. Dim SMTPMail As New SmtpClient Dim MailMsg As New MailMessage, I As Integer MailMsg.From = New MailAddress( Me .txtFrom.Text) MailMsg.Subject = Me .txtSubject.Text MailMsg.IsBodyHtml = False MailMsg.Priority = MailPriority.Normal MailMsg.Body = Me .txtMessage.Text SMTPMail.Host = Me .txtServer.Text SMTPMail.Port = 587 ...Show All