espelly's Q&A profile

• Visual Studio Express Editions A Puzzle?

  Below is the code, and you can press Button1 as fast and as often as you like to get a list of 6 random number from 1 -7 but if you change this intNumber = Int((7 * Rnd()) + 1) to this intNumber = Int((6 * Rnd()) + 1) it still works by giving a list of 6 random number from 1 -6 but it only does it once Public Class Form1 Dim intNumber As Integer Dim arrNumber(0 To 5) As Integer Dim i, x, y As Integer Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ListBox1.Items.Clear() For x = 0 To 5 Start: Randomize() intNumber = Int((7 * Rnd()) + 1) For y = 0 To 5 If intNumber = arrNumber(y) Then G ...Show All

• SQL Server Using expressions with FlatFile connections?

  This seems so obvious, but is causing me a lot of trouble: The flat files input to my SSIS packages may contain an empty line between each row of data, or may be "continuous" without any extra empty lines. Here are small examples of the data I'm working with: With the extra line: "M","SFH","Single Family Mortgage Loans","Single Fam Mtg" "M","MFH","Multifamily Mortgage Loans","Multi-Fam Mtg" "R","MIX","Mixed/Various/Unknown","Mixed/Various" Without the extra line: "M","SFH","Single Family Mortgage Loans","Single Fam Mtg" "M","MFH","Mult ...Show All

• Smart Device Development Failure loading resources

  I am currently developing an application for windows mobile 5.0. In my mainform i have listviews that get their icons from two imagelists. when i run the app, an error in the form's designer comes up and has the following stack trace: at System.Resources.ResourceReader.LoadObjectV2() at System.Resources.ResourceReader.LoadObject() at System.Resources.RuntimeResourceSet.GetObject() at System.Resources.ResourceManager.GetObject() at System.Resources.ResourceManager.GetObject() at DMS_PocketPC.Form1.InitializeComponent() at DMS_PocketPC.Form1..ctor() at DMS_PocketPC.Program.Main() the error says "NotSupportedException was unhandled". this is from the line in the designer that states: this.ilLarge32.Images.Add(((System.Drawing.Imag ...Show All

• Visual Basic diplaying bitmap from access database

  I've seen this question posted a few times but no good results. I'm simply loading a dataset from access that happens to have a bitmap stored in a field. I have a listview with a list of CD's by Album/Artist, when I click on one of the CD's I want detailed info to populate below, including a pic box with the stored bitmap. Everything works fine except the pic box. Here's the code I have: Dim bytPic() As Byte objDataSet = New DataSet objData.SQL = "usp_SelectRecording" objData.InitializeCommand() objData.AddParameter( "@RecordingID" , OleDb.OleDbType.Integer, 4, lvwRecordings.SelectedItems.Item(0).Tag) objData.FillDataSet(objDataSet, "Recording" ) bytPic = CType (objDataSet.Tabl ...Show All

• Windows Forms Update tables using stored procedures

  Hi all! I saw here similar questions but did find any proper answer. So, again... I have two tables in the DB. The master table has ID of the unique record from the details table. To retrive and store data I have two stored procedures: ALTER PROCEDURE dbo.GetAllMovies AS SELECT dbo.Movies.ID, dbo.Movies.MovieName, dbo.Genres.GenreName, dbo.Movies.Year, dbo.Movies.Description FROM dbo.Genres INNER JOIN dbo.Movies ON dbo.Genres.ID = dbo.Movies.ID ALTER PROCEDURE dbo.UpdAllMovies ( @ID int, @MovieName nvarchar(50), @GenreName nvarchar(50), @Year int, @Description nvarchar(1024) = null ) AS begin declare @GenreID int select @GenreID = id from genres where genrename = @GenreName UPDATE Movies ...Show All

• Visual Studio Express Editions Error font when bind data to Dropdownlist control?

  I store data in SQL Server, when i display it in < select id ="Select1" name ="calling" size ="25" ondblclick ="selectcall()" onkeypress ="selectcall()"> <% Response.Write( "<option style=color:" + colors + " value=" + calldetailrow.CallID + ">" + calldetailrow.CallID + "-" + calldetailrow.CusName + "-" + RecallTime + "-" + csmail + "-" + calldetailrow.CusTel2 + "-" + calldetailrow.CusCreateUser + "-" + calldetailrow.CusLastUser2 + "- Z:" + calldetailrow.ZoneID + "" + uname + "</option>" ); } %> ...Show All

• Visual Studio Express Editions Get data row from SQL Db & allocate variables to each item.

  (2005 express vb edition with sql server 2005 express edition) Hi, I have a Table: WordSurvey, with around 10 fields. Primary Key = wsID I can identify the wsID, but I now need to get all the 10 SQL data fields that relate to it and assign variables to them. I have set up a TableAdapter Query to SELECT * FROM WordSurvey WHERE wsId = @wsID. That is fine. But, I cannot work out how to: 1. Code the call to trigger the SELECT to get the fields (I cannot use SmartTags for this) 2. Allocate each field's string or value to a variable This is so that I can utilise that data to draw a graph and add specific descriptions to a templated Form. (I will also be doing this separately for two other Tables & their resp ...Show All

• Windows Forms VS2005 Designer Question

  Hello, When you use the VS2005 Windows Forms designer to edit any control, it has '(DataBindings)' section under the 'Data' category in the Properties browser. I'm developing a custom control and would like to add design-time support for a property. I'd like my property to have the same design-time editor that the (DataBindings) properties use (ie. SelectedValue and SelectedItem for a ComboBox). I want the developer to be able to select (for example) a DataTable AND also a DataColumn at the same time. I am aware of how to add design-time support such as: [ AttributeProvider ( typeof ( IListSource ))] public object DataSource... [ Editor ( "System.Windows.Forms.Design.DataMemberListEditor" , typeof ( UITypeEditor ))] ...Show All

• .NET Development Error 26 Caused by one specific table

  I have a VB .Net 2005 app conected to an sql server express database. Most of the forms open without a problem and show the data they should without a problem on both my development machine and at the clients site. I have now added a new table to the database with a new form and I made a change to an existing form to use this new table. On my development machine I am having no problems retrieving or updating the data from the new table. Unfortunately at the client site I am having probelms with both the new form and the modified one (all other forms open and show data quickly and without any problems). When I open either form it takes a long time and then I get the following message: System.Data.SqlClient.SqlException: An error has oc ...Show All

• SharePoint Products and Technologies Nested Master Pages Example

  Has anyone gotten nested master pages working within MOSS I'm looking for a working example of parent & nested master page code. I've found little more than statements that they work just like ASP 2.0 master pages and this: http://msdn2.microsoft.com/en-us/library/ms476046.aspx There is says: For example, you can reference one master page from another master page using the following directive: <%@ Master master=MyParent.master %> Which isn't exactly right, because the tag needs to be "<%@ Master MasterPageFile ="~sitecollection/_catalogs/masterpage/parent.master" %> Is there a minimum set of other stuff that needs to be in a nested master page (similar to the minimum master page) to make it w ...Show All

• Visual Basic Is it Recursion (or is it Memorex)

  I have a function called from a paint event that writes (DrawImage) on the control. It works ... so I thought nothing more about it ... U N T I L ... I went back a put a breakpoint into the code to Debug a problem, and then I noticed something strange. Instead of just working and exiting, it keep re-entering the function. I put a counter in it and it re-entered at least 14 time. I image it has to do with the 'Paint" event, but it certainly worried me. Here is the really strange part: When I took the breakpoint out, the counter now says the function is only entered once. Here is a simplified version of the code: <Code> Private Sub Panel1_Paint( ByVal sender As Object , ByVal e As System ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Questionable Design?

  Granted, I'm only a hobbiest, but it seems that many of the samples in this beta just have some very poor design regarding encapsulation. Is it no longer one of the pillars of good OO that an objects data is private and exposed through accessors Jim Perry wrote: ThwartedEfforts wrote: I'm glad someone else had the balls to mention this. Not only is the Spacewar demo a sloppy example of what Game Studio Express can do, you also need prior knowledge of C# to add keyboard or mouse support—something every gamer takes for granted. IIRC, it's a matter of uncommenting one #define to get keyboard support. Really tough. I'm not trying to start a flame war h ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA will changes?

  Beta 1 and Beta 2 is very different to verision 1.0 The question is. XNA will changes in version 2.0, this version will be different to version 1.0 The games developed in version 1.0 have any problem with the version 2.0 or with the version for Vista I worry that my game not run in future version of XNA Sorry my English suck! ;( changes to the API are expected between beta versions. However, they try to avoid changes after an API has shipped. I wouldn't say never, but I'm sure that if there are breaking changes, there will be a migration guide. Honestly, I wouldn't worry about v2.0 ... ...Show All

• Visual Studio Tools for Office VSTO 2003 basics

  Hi, I am new to this and I need to know some very basic info about developing Excel application using .net. I am using VS 2003 and framework 1.1 and VSTO 2003. I developed a hello world excel application. In that I added some value in a cell of a worksheet and some basic stuff. The application I am trying to develop loads data from the database and populate excel sheet. After that I want to be able to get values from socket and keep on updating values in excel sheet. I also want end user to be able to use usual excel features such as adding new calculated cells to the worksheets, adding worksheets, changing cell color, sorting, Saving As e.t.c Is this possible if yes, then what would I have to deploy on user machine I ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Could C# be the future of gaming?

  Since XNA is using C#, and is is a more intuitive language than C++, is it possible that in the future that C# will dominate, espessially in AAA titles. Could XNA be ushering a new way of programming in the main stream Although I’m a huge C++ fan but.. XNA will be using C#, DirectX is now shipped with many samples tutorials for managed frame work, and the bench mark between C++VS C# graphic applications isn’t noticeable even sometimes its better on C# with all that I guess its time to migrate from C++ to C#... ...Show All