PEng1's Q&A profile

• Visual Basic Beginner: VB & SQL

  Hello, I just started to learn Visual Basic 2005.NET. I have experience with VBA in Access and SQL Server. I now want to build applications (client/server) with VB & SQL Server. Does anyone have a simple example with which I can start learning Thank you in advance! yes you can. just simply input the query you want, with the values and do an ExecuteNonQuery() The best way to do this, in terms of performance and security, is to use Stored Procedures on the SQL Server end, calling it from your client application and giving it parameters, with values, then executing the non query. Insert/Delete/Update never returns results back, the only thing it does return back is the number of rows effected by ...Show All

• Windows Live Developer Forums Messenger Hangs

  I've downloaded the new Live Messenger, and it was working perfectly. I got the free gift for testing the Beta, and now it just hangs, and won't respond. I can't get in to the programme to remove the backgrounds and animated display picture. I even tried removing and re-installing, but it still does the same thing. If anyone else has had this problem, or knows how to solve it, can they please let me know. Many thanks. Lenoire77 i found out what the problem was. It was the router that I was using, i updated the newest firmware and everything was fine after. ...Show All

• Visual Studio Express Editions generate HTML pages from VB Express

  I would like to be able to generate HTML pages from data in a database. The pages will be static. I am curious what the best approach is for this. Thanks dustinto, I have the example coding in C# and hope that can give you some help :-) public static bool WriteFile( string strText, string strContent, string strAuthor) { string path = HttpContext.Current.Server.MapPath( "/news/" ); Encoding code = Encoding.GetEncoding( "gb2312" ); string temp = HttpContext.Current.Server.MapPath( "/news/text.html" ); StreamReader sr= null ; StreamWriter sw= null ; string str= "" ; try { sr = new StreamReader(temp, code); str = ...Show All

• Windows Forms in a form i need to all the featurs of ms outlook

  in my vb.net windows application on a windows form i need to keep all the featurs of the ms outlook can any one help me how to solve this problem can you explain further please You can't just implement the outlook features into your application, to do so you would probably have to create it yourself from scratch. It would help if you can explain more :-) ...Show All

• .NET Development dataview + filter

  Hi I have a grid containing up to 100k rows. i want to perform filtering on the grid. i also have advanced filter options like match case , match whole word and regular expression. i have tried in 2 ways. 1. parsing the whole grid and checking the rows. i can use all filter options but it is very ineficient and works very slow. 2. i have tried filter on the datasource. i have done it with the method dataview.filter . this works very fine , but the filter is to simple. i cannot use the options above (only match case) . is there any other way in order to perform this filter i am stuck on this for a long time. thank you I don't have any database. data is loaded from files. also , the datatable.select method ...Show All

• Visual C++ Help with script.

  I know nothing about programming. But I need a script that once you press a F7 will use SetWindowsHookEx and count every key and mouse press every second and add them for a total of 60 seconds. After 60 seconds it will delete the amount that happened in second 1 and add the amount that happened in second 61 and continue on in this pattern. Starting out with SetWindowsHookEx and timers is not a good way to learn how to program. Start with a book or a class at your local community college... ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Collision Detection

  Ok, i know this has already been posted on but after going through that i still couldn't get it to work. So here's my code and plz tell me what's wrong. Texture2D _paddle1; Texture2D _paddle2; Texture2D _ball; Vector2 _paddle1pos; Vector2 _paddle2pos; Vector2 _ballpos; Vector3 _p1box; Vector3 _p1box2; Vector3 _p2box; Vector3 _p2box2; Vector3 _bbox; Vector3 _bbox2; BoundingBox bb1 = new BoundingBox (); BoundingBox bb2 = new BoundingBox (); BoundingBox bb3 = new BoundingBox (); SpriteBatch spriteBatch; _paddle1pos = new Vector2 (50, 300); _paddle2pos = new Vector2 (1000, 300); _ballpos = new Vector2 (400, 300); _p1box = new Vector3 (_paddle1pos.X, _paddle1pos.Y,0); _p1box2 = new V ...Show All

• SQL Server Moving new data into dimension tables automatically using Integration Services

  I have an Integration Services package that loads new data into tables that are dimension tables wi my cube. The same situation exists for my fact table. If I perform an "Analysis Services Processing Task" for the dimensions ,cube and measures, will that move the new data into my cube or do I need to perform the "Dimension Processing Destination" data flow task prior to this Is the initial processing task good enough thx, -Marilyn You only need the Analysis Services processing Task! -jamie P.S. The correct nomenclature is the "Dimension Processing Destination" data flow component, not the "Dimension Processing Destination" data flow task. Tasks a ...Show All

• Windows Forms Navigating through pictures on a form?

  I am programming with C# in Visual Studio 2005. I am trying to create a form that will display a single image from a set of 5 pictures. Then use previous and next buttons to navigate forwards and backwards through that set of pictures displaying each one. I have created a 2nd form which when loads up displays the first picture using the code :- pictureBox1.Image = Image .FromFile( "C:\\Documents and Settings\\My Documents\\pics\\pic1.gif" ); I know that I need to declare and initialise an array to hold all the images in and then use a for loop to display them but I am having trouble working out how to do this as I am not an experienced programmer. If anyone could help me out with this it would be much appreciated! ...Show All

• Windows Forms Looking for succesful ClickOnce deployments stories.

  Hello, We are studying the deployment strategy for a new version of an app that will be used by approx 2k end users. The app is a smart client winform portal that communicates with DataCentric objects. The DTO objects are distributed using WebServices hosted in IIS, the back end is an Oracle DB. Seeing so many concerns and issues with ClickOnce technology, my question is whether there are real, robust and reliable applications already in the field that were deployed and work fine using ClickOnce. Any comment will be greatly appreciated Thxs ...Show All

• Visual Studio Drag objects to form designer from window other than toolbox

  I have a need to drag and drop from a treeview view of a health related object model. The nodes of this object model can be turned into one or more controls on a design surface. I have this working in a separate application but want to incorporate it into VS. I can't see how to do this, however it seems possible as datasource windows do this very thing. Hi Hugh Check out this article on the DesignSurfaceExtenderLibrary. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/DSExtend.asp Carlton ...Show All

• Visual Studio Express Editions How to suppress radiobutton click or another approach?

  New user of VB 2005 Express. My application has a form that contains a few radiobutton groups. The user selects the desired buttons and eventually hits an OFF button and his selections are written to a file. The next time the application is executed, the form is opened and the file is read, setting the buttons to the values they had when the last execution terminated (this is done in the form Load event). All works well, but the click event for the radiobuttons is being executed as I set the "checked" . That causes some other program actions to occur which are undesirable at this time. Question is: how can I set the radiobuttons via the code without triggering the click event As an alternative, is there some way that I can ...Show All

• SQL Server EXECUTE AS , fatal exception

  Hi There If i add a new sysadmin login and that login is a user in a DB. If i execute the command EXECUTE AS 'LoginName': I get the following error: SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process WHats up with this If my dbo for this db is linked to a sysadmin login i have no problem with EXECUTE as 'dbo'. WHy do i get fatal errors when trying to execute as a a login name that is sysadmin On the net all referencing to the fatal error have nothing to do with EXECUTE AS Thanx Hi Raul As luck would have it i am having trouble re-creating the problem. I am running MS WInder Server 2003 ...Show All

• Visual Studio 2008 (Pre-release) Certificate Requirements for Usage in WCF

  We are trying to come up with deployment time requirements for certificates to be used in WCF. We need to check for certificates (that are present on the target machine) that have following abilities: SSL Encryption Signature In essense, how do we find out if a given certificate can perform one or more of the above Is checking for System.Security.Cryptography.X509Certificates.X509KeyUsageFlags of a certificate (through Extensions) is enough If so, how do above map to following in X509KeyUsageFlags enumerations: DataEncipherment (The key can be used for data encryption.) DecipherOnly (The key can be used for decryption only.) DigitalSignature (The key can be used as a digital signature.) EncipherOnly (The key can ...Show All

• Visual C++ Casting DataGrid to Dataset

  Hi, I'm trying to cast DataGrid to Dataset see below (C++) Dataset *mydataSet = __try_cast<DataSet*>(myDataGrid->DataSource); However,   I get the following error: "S pecified Cast is not Valid". I'm trying to loop through the rows in the datagrid therefore I need to cast the datagrid to a dataset, I populate the datagrid with a datatable. Would anyone have any suggestions on what I need to make it work Thanks       Hi Mike, thanks for yuor reply, how would I then to do it as i am new to datagrids (VS 2003 .net) Thanks in advance for your help! ...Show All